Forum Replies Created

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

  • RE: WWBOD

    I would buy a new cruising sailboat, outfit it with the best satellite communication software money could buy, and then sail off into the sunset.

    While over the...

  • RE: iPads for Christmas

    Steve,

    Merry Christmas, and I would like to thank you and Red-Gate for an opportunity to tell you how SQL monitor would be a great asset to my DBA toolkit,...

  • RE: Put Your Thinking Caps On

    I heard Santa was an recoverying alcoholic, has a stomach ulcer and I heard if he gained any more weight he wouldn't be able to get into his Santa suit....

  • RE: Put Your Thinking Caps On

    Dear Santa,

    I've been a good boy this year and I want "SQL Monitor" for Christmas. Oh, and by the way having an iPad to run it on would...

  • RE: The Top Ten Reasons to Attend the PASS Summit 2008

    As for using the SSC6 registration code. I'm one of those that will not be able to use the code. It would be nice if we could get...

  • RE: Auditing "sysadmin" access to SQL Server 2005

    All excellent suggestions. Hopefully a few more of you will post your auditing requirements and methods. Keep the suggestions coming, I'm compiling all the options suggested so I...

  • RE: Query Analyzer and TSQL

    select * from information_schema.columns where table_name = 'your table'

  • RE: Query Analyzer

    select * from information_schema.columns where table name = 'your table'

  • RE: controling script

    Of course the only drawback to this would be you could run sp_1 again, until both the sql agent jobs finished.

  • RE: controling script

    Build two SQL Server Agent jobs. One that executes SP_2, and the other executes SP_3. Then have SP_1 start the SQL Server Agent jobs by using the sp_start_job...

  • RE: sorry about this

    You might try something like this:

    declare @line varchar(1000)

    set @line = 'line 1' + char(13) + 'line 2' + char(13) +

    ...

  • RE: Maximum number of Prefixes

    Your table name "uszhoit25794.dbspace..dbaSpaceDist.dbaSpaceDist" contains to many qualifiers. Looks like you are trying to reference a linked server "uszhoit25794", and on that server you are trying to insert records...

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