Hi there,

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...

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 &...

Hi Ken,

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:...

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...

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...

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...

 EXEC master..xp_fixeddrives

Mark

Yakov,

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...

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...

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..?

DELETE Payment

WHERE PaymentID IN

(SELECT...

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...