Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. iamtechuser

    OSQL & SQL Server 2005

    Help Is OSQL compatible with 2005?? I am getting very messed up output in my file when I run OSQL on 2005... lots of blank lines and dashed lines. If I run on 2000, it's fine... what's the problem? Thanks
  2. iamtechuser

    Temp table weirdness, pls help

    Hi, I am running the following stmts. insert into #tmp EXEC @result = master..xp_cmdshell @cmd SELECT @output = IsNull(@output + char(10) + result, result) FROM #tmp PRINT @output -- this is NULL!! SELECT * from #tmp -- this returns ROWS!! END I don't understand this... I believe it...
  3. iamtechuser

    select into a variable

    Hi I need to select into a variable: insert into #tmp EXEC @result = master..xp_cmdshell @cmd IF (@result <> 0) -- return value from xp_cmdshell, 0 = success, 1 = failure BEGIN SELECT @output = result FROM #tmp But @output is empty... but #tmp is not. Help, how can I capture row data...
  4. iamtechuser

    scripting maintenance plans

    Is it possible to script maintenance plans?? thanks
  5. iamtechuser

    Operator doesn't send

    Hi, I set up an Operator as my email address. I tested that I can mail to this email address by sending a test email. That worked ok. However, if I use this operator in a job notification, and set it up to notify on job failure, it doesn't send to the operator from the job... when the job...
  6. iamtechuser

    Translog backup question

    Hi, Are translog backups "tied to" the last FULL backup? That is let's say I take: FULL BACKUP 6/18/08 12:01 AM TRANS BACKUP 6/18/08 12:15 AM FULL BACKUP 6/18/08 7:00 AM TRANS BACKUP 6/18/08 7:15 AM Can I apply the TRANS BACKUP @ 12:15 AM to the FULL BACKUP @ 7:00 AM? My understanding is...

Part and Inventory Search

Back
Top