If you use Enterprise manager to make the changes, you have the option to click the script button to see the script that it would use to make the change,...

The table would be a better design if you put the "T code" and user name as separate columns, ideally integer foreign keys to lookup tables for T Code and...

select replace('THIS IS SOMEONE''S EXAMPLE','''','''''')

This is the query you are executing:

select Y02P02  from second_sales where store = K12390

You have to enclose literal strings in quotes like below, or it will assume you are giving it...

And one more way to do it:

select
dateadd(year,[Last Sale Date]/1000-1900,[Last Sale Date]%1000-1)
from
(select [Last Sale Date] = 2006014 union all
 select [Last Sale Date] = 2006018 ) a 

You can exclude any columns you want in BCP if you use a query as input data source.  You can also do it using a view.

I thought the United Kingdom was an honorary US state, like Puerto Rico, Guam, or Canada.

If the applications are truely unrelated and have no need to share data, create separate databases for each application.

It makes them easier to manage.  For example, in the future you...

This will return a random value that is not in your table.

Your scheme can have 10 to the 20th power combinations, so as long as the value is randomly generated...

As I said the first time, Microsoft will only be producing patches for XP, Vista, and 2003 Server.

There will be no patches for Windows 2000, and I did not list...

It kicks everyone out of the database and sets the database offline so that no one can connect to it.  You can read about it in SQL Server Books Online.

When...

You can use the free PSINFO utility from http://www.sysinternals.com.  It gives you the numbers you wan directly, including the % of free space.  You can run it from XP_CMDSHELL.  Here...

They can return different results.

Statement 1 can return multiple rows for each row in MP2BATF if there are multiple matching rows in WOE.

Statement 2 will return only one row for each row in MP2BATF...

Microsoft will only be producing patches for XP, Vista, and 2003 Server.  There will be no patches for Windows 2000.

Preparing for daylight saving time changes in 2007

http://www.microsoft.com/windows/timezone/dst2007.mspx

How to configure...

If you just want to kick everyone out of the database before detaching it, use this command (in SQL 2000)

alter database Sostenutotest 
set offline with rollback immediate