Forum Replies Created

Viewing 10 posts - 1 through 10 (of 10 total)

  • RE: REPORTSERVER DB GROWING TOO LARGE

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

  • RE: Sync All Logins on a Server in a single click using SP_MSForEachDB

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

  • RE: Sync All Logins on a Server in a single click using SP_MSForEachDB

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

  • RE: Import Excel to MS Access Problem

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

  • RE: Software is Like Building a House

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

  • RE: Disk Space

    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

  • RE: Starting Query Analyzer

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

  • RE: QOD 10-30

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

  • RE: Finding and Deleting Duplicate Data

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

  • RE: Print statement in Stored Proc

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

Viewing 10 posts - 1 through 10 (of 10 total)