Viewing 10 posts - 1 through 10 (of 10 total)
Can't give you any definitive answers I'm afraid but we are having a similar issue with the ServerParametersInstance table. Ours is keeping 180 days worth of info (based on...
March 29, 2011 at 2:38 am
If any one is having troubkle with this (on SQL 2005) make sure that the INSERT statement reads as follows...
INSERT into ##TempSync EXEC sp_msforeachdb @SQL
For some reason the ##TempSync &...
June 3, 2008 at 7:53 am
Tried this against a couple of our dev servers + it picked up a couple of rogue logins on the SQL 2005 box but it failed with "Line 7:...
June 3, 2008 at 2:30 am
I recall having a similar problem quite some time ago and according to the notes I took at the time the way I got round it was to amend the...
December 14, 2007 at 2:24 am
Unashamedly pinched from I can't remember where...
If Architects Had To Work Like Software Designers...
Dear Mr. Architect:
Please design and build me a house. I am not quite sure of what I...
October 5, 2007 at 2:21 am
I don't know about net send but you can use the extended stored procedure xp_fixeddrives to tell you how much disk space you have left...
April 25, 2007 at 2:44 am
Like you said, there are several ways to get in to QA. One other method of starting QA that you didn't mention, and the one I tend to use the...
October 12, 2005 at 1:51 am
Just last week I found myself in the situation of trying to use DTS Dynamic Properties Task to set Server / Database.
To me, using a query was not...
October 30, 2003 at 2:26 am
Useful topic to cover but isn't the final solution over-complex?
Couldn't you just use an inequality of PaymentID's on a self-join as follows..?
WHERE PaymentID IN
July 25, 2003 at 3:45 am
brianr - just type CHECKPOINT into QA
I had a similar issue recently so I ended up writing milestone messages to a dummy table rather than using PRINT. I could then...
July 24, 2003 at 2:46 am