Nice question. This hasn't burned my yet and this type of question may mean it never does! Thanks.

Have mulitple answers always been allowed? I must be asleep at the wheel.

Correct Answer...The query would fail in code review and the developer's continued employment would be in jeapordy.

Burned again. For the reasons already stated

You are correct. My setting was for SQL Server 2000. Duh!

No way! A resume is designed to get you the interview, nothing more or less.

Nice article thanks.

One thing I found interesting in 05 is that when you use the UI to script an existing login, it still uses the old syntax!

/****** Object: Login...

Thanks for the puzzle. Great fun!

Thank you Eric and Amar.

I'm not sure you noticed, but my original post was from 08/06. We deployed with the FT indexes on the data drive, and for our...

Thanks Amar

Bring back code of the day.

Terry

If possible, I would reccommend you move into a 64 bit OS with 64 bit SQL Server. Unless your OS is currently 64 bit, this would make an in place...

"What file groups " does not includes anything except file groups. And really, can't any file be placed on a compressed drive with the consequences of that action.

I should have...

Where in the question is it stated that the "script" is using xp_cmdshell, or even TSQL?

Terry

Though I don't really like it, all our initial backups are first native and over the network and they do not fail.

Terry