After an installation of SQL Server 2005 a Software-Setup didn’t run because it demanded a case-insensitive collation. We had Latin1_General_CS_AI and wanted to change to Latin1_General_CI_AI.

This is not a trivial task and can make you a lot of pain, so maybe this helps. Many thanks to Tom Wisnowski.
This is his blog entry from http://geekswithblogs.net/mskoolaid/archive/2005/12/17/63413.aspx :

Step 1. Put SQL Server into Single User Mode

The first thing you will want to do is stop the SQL Sever Sevicer (sqlservr.exe) and the associated services (Agent, Full Text, Etc). There are a few ways to do this, but the easiest way would be to use the SQL Configuration Manager (Start->All Programs->Microsoft Sql Server 2005->Configuration Tools->Sql Server Configuration Manager). From this console you can manage the various SQL server services running on the machine. Right Click on each service listed and stop the service. The services are stopped, you can proceed to Step 2.

Step 2. Start the SQL server in Single User Mode

Open a command window and navigate to the folder where Sqlservr.exe resides (generally :\Program Files\Microsoft Sql Server\MSSQL.1\MSSQL\Binn). Run “sqlserver.exe -m” to start the sql server from single user mode.

Step 3. Rebuild the system databases

In SQL 2005, the rebuildm.exe program is nto supported. To rebuild the master database you need to use the setup.exe found on the SQL 2005 installation media. To rebuild, use the following command “start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=”. Please refere to Books on Line for compelete details on how to use Setup.exe.

Step 4. Restart the SQL Server Services in regular mode

End the command shell you started earlier. Ctrl-C to stop SQL server in single user mode, then close the command window. Go back to the Sql Server Configuration Manager and restart the SQL services.

Setup /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=InstanceName
/SQLSYSADMINACCOUNTS=accounts /[ SAPWD= StrongPassword ]
/SQLCOLLATION=CollationName

Use /SQLCOLLATION= with the name you need.
For a List of collations use: SELECT * FROM fn_helpcollations()

Latin1_General_
CI = Case Insenstive
CS = Case Senstive
AI = accent-senstive
AS = accent-insensitive and so forth.

Thanks to Jeff

declare @y int;
declare @m int;
declare @d int;

– the date we wish to create is Nov 6, 2003:
set @y = 2003
set @m = 11
set @d = 6

select dateadd(mm,(@y-1900)* 12 + @m – 1,0) + (@d-1)

For my site-search: Convert Date, ConvertDate, DateConvert,Int,Integer,IntToDate,IntegerToDate,Datum

Error “File format not supported” when you import VOB files

Issue

When you try to import VOB files into Adobe Premiere Elements 1.0 or Premiere Pro 1.x, the application returns the error message, “File format not supported.”

Solutions

Premiere Elements 1.0 and Premiere Pro 1.x do not support importing and editing the VOB file format. If you must work with the contents of a DVD, the following suggestions may provide you with possible workflows for using this material in Premiere.

Solution 1: Change the .vob file extension to .mpg, and then import into Premiere.

Note: Premiere Elements and Premiere Pro do not import encrypted DVD MPEG files . The technique described below only works when used with VOB files that have not been encrypted.

1. Open My Computer, right-click the DVD drive, and choose Explore.
2. Navigate to the Video_TS folder.
3. Copy the VOB files to your hard drive.
4. Change the VOB file extensions (.vob) to the MPEG file extension (.mpg).
5. Import the MPEG files into Premiere Elements 1.0 or Premiere Pro 1.x.
6. Render the footage on the time line.

Solution 2: Convert the MPEG files to DV AVI

Use a third-party application (such as VirtualDub, DVD2AVI, or Mpeg2AVI) to convert the MPEG files from Solution 1 to Microsoft DV AVI, and then import the DV AVI files into Premiere.

Background information

For additional information on converting VOB files to DV AVI files as well as other format conversion, visit www.videohelp.com .

I thought I was all alone with this Problem. My font in Outlook was so big, even if I hat it in Arial 9!
A co-worker was able to help me out quick. Today I have seen the same problem at another’s co-worker screen and he told me: “I don’t know how to change it back!” … Damn the Mouse-Wheel.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TKC Supercheatpack 1.21 Final

This cheat is brought to you by TKC

The Teamkilling and Cheating community

Visit us at:   http://www.tkc-community.net

Programmers: [YENG]Hubertus & [TKC]Anothercheater

Thanks to all who helped beta-testing and giving new ideas
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~v1.21~

-DISCLAIMER-

This software is provided ‘as-is’, without any express or implied warranty.
You are not allowed to continue the  setup-process if it would result in
breaking legal laws, legal license agreements or patents of any government.
The files included in this release are meant for educational purposes only.
Neither the authors of this file nor the TKC-Community can be held
responsible for any damages this release may cause to you, your grandma
and/or your computer. In fact neither the authors of this file nor the TKC-
Community can be held responsible for anything you  do with the files
contributed in this release, like illegal activities.
USE AT YOUR OWN RISK ONLY! And remember to have fun

-INSTALL-
0. Do NOT copy the setup.exe to your OFP folder.
1. Doubleclick the Setup.exe and follow the instructions.
2. Select your existing Operation Flashpoint folder which MUST
contain the FlashpointResistance.exe.
3. Press Continue and your ofp is patched and ready for use.

-FEATURES-

+ Undetectable from any server through a smart patch engine
+ ESP Hack – See where your enemies are
+ Fog Hack – Remove fog and increase the viewdistance
+ Godmode – The easiest way to get unkillable
+ Manipulate Objects & Players (Move, Destroy, Repair, Put in Air, Copy,
Hide, Delete, …)
+ Spawn any Vehicles you want on any map – Choppers, Planes, Tanks,
Papercars, LST…
+ Special Effects – Spaceworld, Delete ALL Objects, Boats, Logos, Bombs,
Parachutes, Crazy CTF Flags, Walk on Water…
+ CTI Tools – Delete the MHQs, Teleport yourself to the enemie MHQ, Switch
the MHQs, Send out drones to the enemy MHQ…
+ SUPERWEAPONS – Get the big ass guns ready and kill the cornercamper
with a Maverick, Sabot, MG, 30mm, Bombs, etc.
+ Free Camera Scripts, Restore Fog, Anonymouse Killing, Flying Trucks,
Guba & Angelina, AI Flooding, Wallstreets, Churches, Towers, …
+ And many more, checkout www.tkc-community.net for more

-STARTUP-

1. Start a multiplayer game
2. After the game started you need to die once so you respawn, after that
you can access the === SUPERCHEATMENU ===.

-ADDITIONAL-

If you got problems running this cheat or for additional cheats (1.96 ID-
Changer, 1.96 Ammotrainer, etc) goto www.tkc-community.net/Forums
and read the existing topics in the OFP section.

Have fun and good luck!

Copyright © 2003-2005 by TKC-Community.net

Download

– Drop all Views, Functions and Stored Procedures in SQL

– See also http://www.duelec.de/blog/?p=430

declare @procName sysname

declare someCursor cursor FOR

SELECT name FROM sysobjects WHERE type = ‘P’ AND objectproperty(id, ‘IsMSShipped’) = 0

open someCursor

fetch next FROM someCursor INTO @procName

while @@FETCH_STATUS = 0

begin

exec(‘drop proc ‘ + @procName)

fetch next FROM someCursor INTO @procName

end

close someCursor

deallocate someCursor

go

declare @funcName sysname

declare someCursor cursor FOR

SELECT name FROM sysobjects WHERE (type = ‘FN‘ OR type = ‘TF’) AND objectproperty(id, ‘IsMSShipped’) = 0

open someCursor

fetch next FROM someCursor INTO @funcName

while @@FETCH_STATUS = 0

begin

exec(‘drop function ‘ + @funcName)

fetch next FROM someCursor INTO @funcName

end

close someCursor

deallocate someCursor

go

declare @viewName sysname

declare someCursor cursor FOR

SELECT name FROM sysobjects WHERE type = ‘V’ AND objectproperty(id, ‘IsMSShipped’) = 0

open someCursor

fetch next FROM someCursor INTO @viewName

while @@FETCH_STATUS = 0

begin

exec(‘drop View ‘ + @viewName)

fetch next FROM someCursor INTO @viewName

end

close someCursor

deallocate someCursor

go

PROBLEM:

How to compare to dates in t-sql without considering the time?

SOLUTION:
Compare if my variable @MyDateToCompare is equal or less to the current date (GetDate())

IF

CAST(CONVERT( CHAR(8), @MyDateToCompare, 112) AS SMALLDATETIME)

<=

CAST(CONVERT( CHAR(8), GetDate(), 112) AS SMALLDATETIME)

…

Youtube-Video an bestimmten Zeitpunkt starten – Stimmt, sollte ich auch mal bloggen, da ich jedes mal vergesse, wie es funktioniert.

Man kann bei Youtube-Videos via URL-Parameter einen Startzeitpunkt manuell festlegen. Dutzende Male habe ich diesen Parameter und vor allem seine Syntax schon gegoogelt und immer wieder vergessen. Damit ich das in Zukunft nicht mehr tun muss und weil es vielleicht der Eine oder die Andere noch nicht wusste bzw. sich auch nicht merken kann, hier die Syntax für diese Funktionalität:

URL des Videos + #t=(x)m(y)s

Wobei (x) für eine Zahl für die Minute und für (y) eine Zahl für die Sekunde steht.

Beispiel:

http://www.youtube.com/watch?v=3nwwKbM_vJc#t=4m12s

Here is a simple solution…

If you have locked yourself out your Mambo installation, (i.e.) lost your admin password, you should be able to reset it without issue as long as you have access to your database via phpMyAdmin, the MySQL command line utility, SQLYog or some other similar program.

Simply login to your database and run the following statement:

Replace ‘newpassword’ with the new password you would like and replace ‘admin’ with whatever your admin username is. The admin username is ‘admin’ by default so unless you changed it this is probably still the same. Replace mos_users with the name of your user table. The ‘_users’ part will always be the same, but if you selected a different database prefix during installation then ‘mos’ may differ. If you left the database prefix alone during installation then the table will in fact be ‘mos_users’.

PROBLEM:

Unable to rename [DatabaseName]. (ObjectExplorer)

Rename failed for Database[DatabaseName].  (Microsoft.SqlServer.Smo)

The database could not be exclusively locked to perform the operation. (Microsoft SQL Server, Error: 5030)

SOLUTION:

ALTER DATABASE <DBNAME>  SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
SP_RENAMEDB <oldname>,<Newname>
Go
ALTER DATABASE <NEWDBNAME>  SET MULTI_USER — set back to multi user
GO

Shortcuts for Notepad++

http://notepad-plus.sourceforge.net/uk/shortcuts.php

ALTER DATABASE [DBNAME]  SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE [DBNAME] COLLATE  Latin1_General_CI_AS_KS_WS
ALTER DATABASE [DBNAME] SET MULTI_USER

Keep in mind that changing the collation of the database will NOT change the
collation of the columns that are already in the database, only the default
collation of any new columns you will create.

You can change your database collation from enterprise manager. But your columns in table did not change accordingly.

Here is show how to change all collation columns in database.

I updated the SQL 2000 Version from vbnetsample.blogspot.com

Note: The EXEC-Statment ist commented for protection. Uncomment to Execute the Printed Alter-Statemnts.

SQL 2000 Version:

Sample Script
DECLARE @@TableName Nvarchar(100)
DECLARE @@ColumnName Nvarchar(100)
DECLARE @@ColumnType NvarChar(100)
DECLARE @@ColumnLengh FLOAT
DECLARE @@SQL NvarChar(1000)
DECLARE @@IsNullAble NvarChar(50)

DECLARE my_cursor CURSOR FOR
Select sysobjects.name From sysobjects Where xtype=’u’ OPEN my_cursor

FETCH NEXT FROM my_cursor INTO @@TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE my_column CURSOR FOR
select syscolumns.name,systypes.name as Type, syscolumns.length ,syscolumns.isnullable
From syscolumns inner join sysobjects on sysobjects.id=syscolumns.id
left outer join sysproperties on sysproperties.smallid=syscolumns.colid and sysproperties.id = syscolumns.id
inner join systypes on syscolumns.xtype = systypes.xtype
where sysobjects.xtype=’u’ And sysobjects.name=@@TableName And (systypes.name=’nvarchar’ or systypes.name=’varchar’)

OPEN my_column
FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble

WHILE @@FETCH_STATUS = 0
BEGIN
IF (@@IsNullAble=1)
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ + @@ColumnType + ‘(’ + CAST(@@ColumnLengh as
NVARCHAR) + ‘) COLLATE ‘ + ‘ Thai_CI_AS NULL’)
END
ELSE
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ +
@@ColumnType + ‘(’ + CAST(@@ColumnLengh as NVARCHAR) + ‘) COLLATE ‘ + ‘ Thai_CI_AS NOT NULL’)
END

PRIN(@@SQL)
–EXEC(@@SQL)

FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble
END
CLOSE my_column
DEALLOCATE my_column

FETCH NEXT FROM my_cursor INTO @@TableName
END
CLOSE my_cursor
DEALLOCATE my_cursor
GO

SQL 2005 Version:

DECLARE @@TableName Nvarchar(100)
DECLARE @@ColumnName Nvarchar(100)
DECLARE @@ColumnType NvarChar(100)
DECLARE @@ColumnLengh FLOAT
DECLARE @@SQL NvarChar(1000)
DECLARE @@IsNullAble NvarChar(50)

DECLARE my_cursor CURSOR FOR
Select sys.objects.name From sys.objects Where [type]=’u’ OPEN my_cursor

Select object_id FROM sys.objects
Select *  FROM sys.syscolumns
Select * FROM sys.extended_properties

FETCH NEXT FROM my_cursor INTO @@TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE my_column CURSOR FOR
select sys.syscolumns.name,systypes.name as Type, sys.syscolumns.length ,sys.syscolumns.isnullable
From sys.syscolumns inner join sys.objects on sys.objects.object_id=sys.syscolumns.id
left outer join sys.extended_properties on sys.extended_properties.minor_id=sys.syscolumns.colid
and sys.extended_properties.minor_id = sys.syscolumns.id
inner join systypes on sys.syscolumns.xtype = systypes.xtype
where sys.objects.type=’u’ And sys.objects.name=@@TableName And (systypes.name=’nvarchar’ or systypes.name=’varchar’)

OPEN my_column
FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble

WHILE @@FETCH_STATUS = 0
BEGIN
IF (@@IsNullAble=1)
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ + @@ColumnType + ‘(’ + CAST(@@ColumnLengh as
NVARCHAR) + ‘) COLLATE ‘ + ‘ Latin1_General_CI_AS_KS_WS NULL’)
END
ELSE
BEGIN
Select @@SQL =( ‘ALTER TABLE ‘ + @@TableName + ‘ ALTER COLUMN ‘ + @@ColumnName + ‘ ‘ +
@@ColumnType + ‘(’ + CAST(@@ColumnLengh as NVARCHAR) + ‘) COLLATE ‘ + ‘ Latin1_General_CI_AS_KS_WS NOT NULL’)
END

PRINT(@@SQL)
–EXEC(@@SQL)

FETCH NEXT FROM my_column INTO @@ColumnName,@@ColumnType,@@ColumnLengh,@@IsNullAble
END
CLOSE my_column
DEALLOCATE my_column

FETCH NEXT FROM my_cursor INTO @@TableName
END
CLOSE my_cursor
DEALLOCATE my_cursor

PROBLEM:

You want to visit a Website but you cannot reach it and you are not sure if it is a problem with the  provider or if it is down!

SOLUTION:

Go to http://www.downornot.com and check.

Example:

http://www.downornot.com/duelec.de

PROBLEM:

When dropping/deleting a Data Soure View from a SSAS-Database you geht this Error:

“Fehler im Metadaten-Manager. Das Objekt (dimension) mit der ID ‘Identifier’ und dem Namen ‘Identifier’ wurde durchVorgänge in der Transaktion für ungültig erklärt.”

Translates to something like: Error in Metadata-Manager. Object (Dimenions) with ID XY … are invalid / not valid!

SOLUTION:

You can only drop/delete the DataSourceView if no Cubes and Dimensions exist that references the View!

So delete all Cubes and Dimensions first and then get rid of the DSV (Data Source View)

http://www.sqlteam.com/article/sql-server-versions

SQL Server Version

By Bill Graziano on 29 January 2009 | 22 Comments | Tags: Administration

The versions of SQL Server are list in the following table. Below the table are instructions to determine what build you are running.

You can determine what version SQL Server is running by running

Select @@version

@@Version is a system level variable that holds the current version. On my computer this returns

Microsoft SQL Server  2000 - 8.00.384 (Intel X86)
	May 23 2001 00:02:52
	Copyright (c) 1988-2000 Microsoft Corporation
	Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

The main version number is 8.00.384 which corresponds to SQL Server 2000 SP1. See below for a complete list of versions. It will also tell us the version of the operating system we’re running. In this case I’m running Windows 2000 (aka NT 5.0) Service Pack 2. You can find this same information in Enterprise Manager by right clicking on a server and choosing Properties. The version information is displayed in the General tab.

This information is pulled from the system extended procedure xp_msver. You can call this stored procedure like

exec master..xp_msver

and it returns

Index  Name                             Internal_Value Character_Value
------ -------------------------------- -------------- ------------------------------
1      ProductName                      NULL           Microsoft SQL Server
2      ProductVersion                   524288         8.00.384
3      Language                         1033           English (United States)
4      Platform                         NULL           NT INTEL X86
5      Comments                         NULL           NT INTEL X86
6      CompanyName                      NULL           Microsoft Corporation
7      FileDescription                  NULL           SQL Server Windows NT
8      FileVersion                      NULL           2000.080.0384.00
9      InternalName                     NULL           SQLSERVR
10     LegalCopyright                   NULL           © 1988-2000 Microsoft ...
11     LegalTrademarks                  NULL           Microsoft® is a registered ...
12     OriginalFilename                 NULL           SQLSERVR.EXE
13     PrivateBuild                     NULL           NULL
14     SpecialBuild                     25165824       NULL
15     WindowsVersion                   143851525      5.0 (2195)
16     ProcessorCount                   1              1
17     ProcessorActiveMask              1              00000001
18     ProcessorType                    586            PROCESSOR_INTEL_PENTIUM
19     PhysicalMemory                   255            255 (267902976)
20     Product ID                       NULL           NULL

This is quite a bit of additional information. There really isn’t anything exciting in here that I can find but it’s there if you need it.

Moving my memory hook from the file-system to my blog you find in this post examples how to Format Numbers in the Reporting Services (SSRS). Thanks to Adam Tappis for his post in the MSDN-Forum.

Here is how 1000000.41 would be formatted with a few format strings

N0 = 1,000,000

N1 = 1,000,000.4

N2 = 1,000,000.41

0.00 = 1000000.41

0.0# = 1000000.41

0.0 = 1000000.4

0 = 1000000

#,###.## = 1,000,000.41

#,###.0 = 1,000,000.4

#,##0 = 1,000,000

Now for 0.670

#,###.000 = .670

#,##0.00 = 0.67

#.### = .67

Percent-Values
0.6322441

P2 = 60.32%

PROBLEM:

Google has hidden the link to delete the mail account very well. Not knowingly of course…

Like in Germany it should be the law that the cancellation of an account must be found easily on the webpage!

SOLUTION:

Your Browser knows your account by cookie. So log in to your GMail-Account.

Then call this Link:

https://www.google.com/accounts/DeleteAccount

PROBLEM:

In a SSRS 2005 RDL-File you get this message in the Design-Preview:

The table ‘xyz’ is in a list that has no group expressions defined for it.
To use a data region in a list, the list must have group expressions.

SOLUTION:

Go to the properties of the table xyz. Look at the Parent property and you are going to see that the parent is a list.
Select the list and go to the properties. Look at the “Grouping”-Entry and edit the expression in the general tab.

PROBLEM:

Parser Error Message: Type ‘ISNet.WebUI.WebGrid.WebGridColumn’ does not have a public property named ‘WebGridColumn’.

Line 97:<ISWebGrid:WebGridColumn Caption="LastReportDate" DataMember="PreviousCreatedOn"
Line 98:Name="PreviousCreatedOn" Width="100px">
Line 99:<ISWebGrid:WebGridColumn DataMember="ReportStatus" Name="ReportStatus" Width="150px" Visible="false">
Line 100:</ISWebGrid:WebGridColumn>
Line 101:<ISWebGrid:WebGridColumn DataMember="TrafficLight" Name="TrafficLight" Width="150px">

SOLUTION:

Read the comment of Brandt Beal