You might also want to check here[/url]

Instead of the easy way, using Notifications, you might want to use a call to an SP passing as parameters for example the server name (although that can be pulled...

Version 9.00.3042 is Sp2, see here

SQL Server 2005 Build List[/url].

I think there was another dll that also might needed registration, but can't find the link now.

... or, besides what Lynn mentions, you can go granular adding the NOLOCK hint to your queries, if that is possible that is.

I had a similar issue this morning... couldn't save a new or existing maintenance plan.

Open a DOS prompt and type:

regsvr32 msxml6.dll

... right, but in the discussion there's a method using an OLE Object to obtain the total disk space. That, together with the Free/Available gives you both pieces of info....

Did you check the DBMail queue? It might give a hint on why it's not sent?

Also, if not mistaken, when you execute your SP, besides the "4 rows effected" it...

You can start by reading here[/url]. Don't forget to read the Join the Discussion part

and then you state

I hope you:

1) have the database in...

I second that.... this...

Right, we ended up doing it that way as well, as our documents were longer than 8000 chars as well....

... well, that's part of the problem, the question did not properly specify the rules of the game..... In my...

This is just one more of these questions that have been put out there without checking/thinking about the possible correct answer.

As we have seen from previous posters, either char(1) or...

... in this case server refers to the machine that hosts the SQL Server instance....

Taken from BOL:

The local definition takes effect only after the server is shut down and restarted. Only one local server can be defined in

each server.

And, not sure if the...