Here is the problem, the previous solution uses too much resources for a simple task and your solution is using Microsoft property the System tables which changes with service packs...

The first thing I have to say is a Sequence is an object while Identity is a property, so here is a Microsoft Provided solution.  I think the Sequence is...

Try the link below for almost everything you need to do with CASE statement.  Hope this helps.

http://www.craigsmullins.com/ssu_0899.htm

Kind regards,

Gift Peddie

Quick and easy open the database in Enterprise manager and open Query Analyzer make sure the Object browser is open then right click on the table and click on create...

That is because few things are faster than INNER JOIN using the FROM and ON clause, most SQL Server users still use the WHERE clause but the query processor ignores...

The question is why are you restoring with code when you can just put your .bak file in the backup sub folder in Microsoft SQL Server folder in programs and...

Try  an INSERT INTO with Column List statement it gives you control of how the table is moved into the new database.  If you are in SQL Server 2005 try...

First of all Windows 2003 installs neutered you have to enable a lot of components and my point of reference is that of a developer who always install IIS by...

There is no reason to run a Cursor to backup a SQL Server  database because the backup and restore wizard is one of the best things in SQL Server.  All you...

DDL is not data description language, DDL is data definition language and the last query is better because per ANSI SQL when the query processor see the FROM and ON...

Great article, I have saved it thanks.

Kind regards,

Gift Peddie

I am both MCSE and MCDBA certified  and I am SQL Server expert so your comment about me not using SQL Server is not relevant.  Richard is of Chinese decent...

Perry,

No that is not my way of telling you I don't know because I know sorting require applying the equality operator to types and SQL Server 2000 BOL (books online)...

Perry,

Those codes are straight out of SQL Server 2000 BOL and I was interacting with someone who is Chinese and it helped resolve his problems, I cannot go in detail with...

You can set up a proxy account for SQL Server Agent, try the links below for how.  I know it works I have helped a lot of developers with it. ...