Viewing 15 posts - 1 through 15 (of 123 total)
You may need to run DBCC UPDATEUSAGE
See http://msdn.microsoft.com/en-us/library/aa258283(SQL.80).aspx
March 28, 2009 at 1:14 am
They are not the same.
SET ROWCOUNT is deprecated so it doesn't even matter if they were the same - you should stop designing any code with it, and revise any...
March 28, 2009 at 1:05 am
Thanks but that will not work. That table is just showing backup history. If the recovery model were changed from full to simple and then back again to...
December 7, 2008 at 8:58 am
I figured it out. So scenario is I don't want a T-Log backup to be performed if a backup has not yet been performed. Example using database named...
December 4, 2008 at 4:15 pm
That will only verify whether a backup has ever been taken.
Suppose a backup has been taken on a db in Full recovery mode. Then I change it to simple....
December 3, 2008 at 3:45 pm
Looking to expand on this issue rater thean creating a new post. Yes, the issue was that a Full backup neded to be performed before a log can be...
December 3, 2008 at 3:12 pm
I recommend not using @query. Do your query first. Then simply assign the results to a variable and then assign that variable to @body.
July 21, 2008 at 10:59 pm
Do your query normal query. Assign your result set to the appropriate variable, perhaps @msg varchar(2000).
Send results
EXEC master.. sp_send_dbmail
...
...
@body = @msg
July 21, 2008 at 9:36 pm
Use MOVE to change location, not name.
You probably have different drive mappings.
April 25, 2008 at 4:28 pm
Script out the job from Enterprise Manager and post here.
April 25, 2008 at 4:24 pm
Viewing 15 posts - 1 through 15 (of 123 total)