See http://technet.microsoft.com/en-us/library/ms177564.aspx

or you can set it permanently in SSMS by going to

Tools >> Options >> Query Execution >> SQL...

Did you switch to CMD mode?

From menu: Query -> SQLCMD Mode

I also thought that !DIR is just a typo and answered correctly.

But why 2008? It works fine in 2005 as well.

SELECT CONVERT(CHAR(10), CONVERT(DATETIME, 'Sep 27 1957 12:00AM', 109), 101)

I wonder if EXCEPT or INTERSECT can be used here.

Just an idea...

I use SSMS Tools Pack for this.

http://www.ssmstoolspack.com/

I use Mike Tutor's script. If someone interested it's here:

http://www.sqlservercentral.com/scripts/users/69523/

My SQL Server 2005 BOL dated April 2006 doesn't mention the [count] argument for the GO command. I guess it was added later, in one of the service packs perhabs.

iqtedar,

Here is another article you may want to check:

http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/

--Vadim.

Here is...

Nice and fast - Thank you.

Suggestions:

1. Option to create DROP INDEX statemens.

2. Option to skip clustered indexes.

--Vadim.

There is a typo in PasswordFieldSymetricKey. 'm' is missing from word Symmetric.

--Vadim.

Good question.

For some reason I thought it could be True because of some weird implicit conversion, so I came up with this code to get my correct answer:

DECLARE

Here is an article about linking to previous row. See if this can help.

http://www.sqlservercentral.com/articles/T-SQL/62159/

--Vadim.