Viewing 15 posts - 616 through 630 (of 769 total)
Hi George Sibbald,
In the SQL Server Failover Cluster Admin, under 'Services and Applications' section I can see the SQL Instance - 'SQL01' available and also under nodes section I can...
April 29, 2011 at 4:04 am
Sorry, couldn't get the hyperlink. Could you please suggest where you can see the interlink?
April 18, 2011 at 2:09 pm
master
April 5, 2011 at 3:16 am
no, refresh of the database is being performed using a SQL JOB. I dont use the SSMS generally for this kind of tasks, it is prone to hang for large...
April 5, 2011 at 3:05 am
Ambiguity in the question..!
Answer should be both..
(1) divide by zero/ (2) remainder.
March 1, 2011 at 2:17 pm
There is ambiguity in the question...!
Copy job/other jobs can be in Monitoring server.
March 1, 2011 at 2:07 pm
Hi Grant/Brandie,
exec @rc = sp_trace_create @TraceID output, 2,
N'\\system-namet\E$\Trace\Trace_1', @maxfilesize, NULL,@filecount;
if (@rc != 0) goto error
Getting the below error msg:
Msg 19069, Level 16, State 1, Procedure sp_trace_create, Line 1
The...
February 16, 2011 at 12:09 pm
Temp tables are used for interim calculations, where we actually can't make logical calculation using the actual tables.
February 16, 2011 at 11:53 am
The last posted comment was indeed too funny!!! Hehehe.
February 16, 2011 at 11:50 am
The Resource database (mssqlsystemresource)depends on the location of the master database. If we move the master database, can't the resource database also would follow the master database?
February 13, 2011 at 10:13 pm
how to create 10 files using xp_cmdshell?
February 10, 2011 at 1:17 pm
I found this question to be too tricky to answer.
February 10, 2011 at 12:51 pm
Viewing 15 posts - 616 through 630 (of 769 total)