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
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.