No you cannot backup from the Transaction Log in that manner except with a LogExplorer which has this built into the tool. Never tried it so not sure how well...

Nope the only way I know is to use ALT-PRINT SCREEN if small enough and past into MSPAINT then print. MS Did not port coloring to the print process itself,...

No, but you can have multiple problems. If the database came from 2000 then it cannot be attached to 7. Also, if the database was made up of multiple mdf/ndf...

No but that is how I test questionable software.

You can use trigger_nestlevel() in your UPDATE trigger to test if another trigger fired causing it to fire.

Really lame example

create table testme (

[col1] int not null,

col2 int not null,

col3 int...

Opps, it ends up under system or system32 directory depedning on the OS. This shoudl be better.

exec sp_msforeachtable 'EXEC master..xp_cmdshell ''bcp yourdbname.? out yourdrive:\yourpath\?.dat -S(local) -c -E'''

Of course it can vary for many reasons. However, if it encounters a problem it will stop and explain the problem. Then on top of this is the diff and...

Never said it was easy, just that it could be done.

Or you can use VBS script file to do the work. You may have to make a few code change but in vbscript you can write to the stdout quite...

Apparently, this has always been the case so I am sure will get treated as a bug. I tried SQL 2000, SP1 and SP2 all did same, as did SQL...

Simon that is right and not right. VB can write to stdout but it will not process in a Command Prompt window by the way the handles work. However, there...

Keep in mind "Reserve physical memory..." is supposed to keep at least that much available to SQL, so SQL should not drop below that point. 500 MB means it needed...

They still have a lot of commands like DBCC and others that work the same, but the overall query engine is different and 7 was a complete buildup from scratch....

This is what I use to clean out all old versions, however I do suggest even thou I trust it, always make a backup of the msdb database before you...

Sorry, I misread your earlier post too, was not thinking in the lines of Master as where the sp_ item is stored.

As for the later, my guess is it doesn't...