Loner,

Is this the same job you've posted about in other threads?  If so, I recommend you polish up your resume and hunt for another one because it seems this job...

Don't worry, Steve.  I'm not blaming anyone whose name isn't on the cover. @=)

Actually, your last statement makes a lot of sense.  That explains why this book has got me...

And don't forget, in SQL Server 2005, xp_cmdshell is disabled by default.  If you haven't configured it to be active, check your SQL Server Surface Configuration.  BOL also has a...

Hmm.  I've just realized why I'm being so petty about this.  When I read books like this I tend to evaluate them for later recommendation.  And here's what I've found:

This...

Lynn, I've tried multiple snapshots before, but always gotten an error.  I tried it again this morning and, of course, it worked this time.  Which is confusing, especially since every...

Oh, Hush!!! @=)

I'll admit I didn't even look before I made that suggestion...

Maybe not.  After all, it isn't an "essential to keep the server running" system process.  It's just a backup process.  You should be able to kill that.

Juan,

Do you have any SQL Server experience at all?  SQL 2000 or SQL 2005?

Just curious.

Steve,

Maybe the site should have an area with a newsletter archive.  That way people who don't get their newsletter delivered for some odd reason can go out and download or...

Was there a newsletter on 8/1?

If there wasn't, I haven't had any problems regarding newsletter delivery.  If there was, this is the only instance I've encountered.  I get my delivery...

Loner,

In the situation where your boss says something is easy and you don't think it is, try sitting down with him and asking about it.  Tell him something like, "Okay,...

Juan,

I wouldn't wait for the 2008 certs to come out.  It'll at least be a year (probably two) before any decent study materials come out.  Besides, you get your MCITP...

You should not try and stop / restart the services until you've tried to kill that particular SPID.

"Kill <spid>" is the command.  It may take a while, so be patient. ...

If you look up "Convert Function" in Books Online, it will give you all the codes for converting a datetime to your proper format.  For the Italian format version, the...

So essentially anything saved to the system that uses a table variable could potentially be listed in sys.indexes as a type "Heap" then.

Hmmm.  I suppose that makes sense.  Would be...