You will need to roll your own.

You can do something like

select convert(char (9),getdate(),6)

where you would replace getdate() with your datetime variable. And then if needed assign the...

Do you have any files like SQL00001.dmp on your server? The datestamp should match the time you ran the queries. The first couple of sections of those dumps...

Is the database set to 65? sh_page errors are thing from SQL 6.5. Upon conversion it is easy to forget to change modes.

sp_dbcmptlevel 'yourDBname'

Thx. That explains why, while in Grid mode, when you stop a query a partial result set is returned. I do still use text mode once in a...

We have seen SQL's performance impacted by sp's a number of times. We run web front ends from one IIS box and a sql from a different server. ...

8.00.608 is the latest publicly available security rollup for SQL 2000 SP2.

Neil,

It depends on your support relationship with Microsoft on whom you contact.

I read the Q and it states apply the SP to clients running EM. I have installed this...

What about when the email name you are retrieving from a table is no longer valid? Any ideas on error processing?

Can't quite get this part to work properly, or...

Thanks that was this what I was looking for! Now to figure out if sp_recompile is a better option in my case then DBCC FREEPROCCACHE since the DBCC here...

It will be next week, at least, before I get to the bottom of it. We do have a high end tape system $$$,$$$.

Just keep in mind that with EM most actions go through your local system. It can really make a difference over a slow link! So when EM appears...

Great definitions!

I would like to add just a few things:

Administrative/Operational DBAs are SAs in Development, Test, and Production. They spend some amount of time trouble shooting production system SQL...

I have seen this before and it could be due to mail client weirdness. And those errors do show up in the SQL Agent log. Take a look...

...

Tape backups when properly managed work great--much faster than backups to disk. We have our servers on switched 100M ethernet and tape backs are really fast. Also it...

Depends on the complexity of the project. For my simple projects that are non-critical, I generally set up the logins on the new server, backup the database on test,...