Booksonline has some basic information. The best place I've seen on the web is http://www.google.com/microsoft

Not that I'm aware of. AFAIK, a restore should put everything back as expected. If it was a different server default, perhaps it changed. An interesting thing to look at.

I don't think there is any way to change this. You could have them script changes and then run them through someone who does own the table.

You can do what I do. I have a script that checks the flat files as well as the jobs and generates an HTML file that is stored on the...

A few things to consider. Allocations are in extents, so you will always use space according in extent lengths. Similar for pages.

Indexes are separate (nonclustered) and have some small overhead,...

Haven't seen it, but have you tried the patch in the article? When you say you couldn't get MS support, what does that mean? did you call the PSS hotline?...

Have you tried using the "WITH MOVE" option to set the log file to a different name?

I'm sure there is, but I'm not sure what it is? What type of step is this and how many lines? If it's T-SQL, perhaps you should create a stored...

It can be slightly flaky, especially if SQL is not running as a user account (as local system). Did you click and set a breakpoint and see the red dot?

sysmessages

Sorry, too busy to do much in the forums yesterday.

Glad you came up with the answer.

Have you recompiled anything? Perhaps reindex? Is this sp performance or query or both?

You can also get this from VBScript using the FileSystemObject.

Wow, that's a tough one. How many people will use this? Larger numbers of users should mean more calls. Of which, some more should be escalataed to the DBAs.

How stable...

There are any number of solutions. I do the backups with TSQL and the file deletions with VBScript in an ActiveX task. Both are contained in a DTS package which...