If the service account used by the Agent is already SA in the SQL Server then check the owner of the job. This login should be an SA account within...

To the author:

If you don't mind, it might be worth to rewrite the article to remove this implication so folks new to SQL Server won't read it the wrong way...

This is a nice demonstration of the fact that a clustered index is essentially the same as a "clustered table" but in several places in the article it was clearly...

Looks like you are on SQL 2005 but might you be seeing this documented bug in SQL 2000 that allows statements after a RAISERROR to be executed:

http://support.microsoft.com/kb/309802

Another workaround to do this with just public level access (and without using an undocumented command) is to use this code:

SELECT

File_id FileID, type_desc as FileType,

size/8*64/1024 as TotalSpaceMB,

fileproperty(name,'SpaceUsed')/8*64/1024 as...

Looks like bunch of XML tags are getting exposed. I see them in the edit mode too. I took them out and resubmitted the article but I will also get...

For a minute I really did believe the prank and was going "Kudos to SSC for pulling off such a coup of PASS!" but again it was just a prank....

Ruth,

I sent you a private message last week about this error. Just posting a message here in case you didn't receive it.

The code taken from the website does parse...

I have figured out the reason behind the false syntax issue: TAB spaces! The code editor on the site doesn't seem to format tabbed spaces well and must be inserting...

Hello,

Thank you for bringing this to my attention.

The original code I submitted parses fine. But you are right there is something going on when you copy it off from...

In our production envirionment we have 3 catalogs taking nearly 20GB space. We did not experiment with performance in terms of it's location but keeping them on the same drive...