Viewing 15 posts - 211 through 225 (of 279 total)
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...
July 2, 2009 at 1:12 pm
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.
July 2, 2009 at 10:12 am
... or, besides what Lynn mentions, you can go granular adding the NOLOCK hint to your queries, if that is possible that is.
July 1, 2009 at 2:30 pm
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
July 1, 2009 at 11:42 am
... 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....
June 18, 2009 at 2:37 pm
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...
June 18, 2009 at 1:49 pm
You can start by reading here[/url]. Don't forget to read the Join the Discussion part
June 18, 2009 at 12:24 pm
sarvesh singh (6/16/2009)
...I have a weekly Back up Job...
and then you state
...It's a 24 hour system where it's receiving transactions every minute...
I hope you:
1) have the database in...
June 16, 2009 at 11:19 am
RBarryYoung (6/16/2009)
Lowell (6/16/2009)
wow i could make an article on SSC over this...lots of questions below got my thoughts flowing.Sounds like a good idea, Lowell. 🙂
I second that.... this...
June 16, 2009 at 8:17 am
Right, we ended up doing it that way as well, as our documents were longer than 8000 chars as well....
June 15, 2009 at 4:27 pm
Alvin Ramard (6/5/2009)
Have fun loading Unicode characters in your char(1) column!
... well, that's part of the problem, the question did not properly specify the rules of the game..... In my...
June 5, 2009 at 7:48 am
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...
June 5, 2009 at 7:19 am
... in this case server refers to the machine that hosts the SQL Server instance....
May 28, 2009 at 12:41 pm
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...
May 28, 2009 at 11:38 am
Viewing 15 posts - 211 through 225 (of 279 total)