Viewing 15 posts - 46 through 60 (of 74 total)
February 16, 2012 at 2:07 am
for creating a new snapshot you have to drop the existing snapshot. there is no other way.
February 15, 2012 at 12:15 pm
Also you can find server start time in SQL server Error log.
February 15, 2012 at 12:11 pm
You can simply check it by tempdb creation date time. 🙂
February 15, 2012 at 12:06 pm
Column names are same for all thirty table which you want to drop?
February 15, 2012 at 8:14 am
Check this article.
February 15, 2012 at 5:55 am
Use try-catch block in your stored procedure to capture the error message.
February 15, 2012 at 5:51 am
Here is a example to send a mail with table formate.
DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<H1>Work Order Report</H1>' +
N'<table border="1">' +
...
February 15, 2012 at 3:41 am
soulchyld21 (2/9/2012)
February 9, 2012 at 4:49 am
Use try - catch block for error handling.
Syntax:
BEGIN TRY
{ sql_statement |
statement_block }
END TRY
BEGIN CATCH
{ sql_statement |
statement_block }
END CATCH
February 9, 2012 at 2:49 am
February 9, 2012 at 2:45 am
DSquared (2/8/2012)
February 8, 2012 at 7:38 pm
Viewing 15 posts - 46 through 60 (of 74 total)