These are Certificate-based SQL Server Logins

Server principals with names enclosed by double hash marks (##) are for internal system use only. The following principals are created from certificates when...

Note:

Stop the SQL Server Agent service before connecting to an instance of SQL Server in single-user mode; otherwise, the SQL Server Agent service uses the connection, thereby blocking...

Opening Event Viewer and viewing events related to failover clustering

To open Event Viewer and view events related to failover clustering:

If Server Manager is not already open, click Start, click Administrative...

--Crude way

Try running below mentioned query and try to output only the latest execution of plan and you will get your data in columns named 'command' and 'line4'.

select * from...

Check sql server error log for tht message and once u get the correct 'State' in error message refer to http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

MJ

You can specify any name. If there is any format that you follow for mdf file names thn specify it in that format(under EM--Restore Database-->Options-->Restore As) while restoring.

http://articles.techrepublic.com.com/5100-10878_11-1041267.html

HTH!

Moin,

It is because its maintenance plan log table which logs every execution information. Would be better if you just order by end_time desc and check the first few rows(in ur...

SELECT [task_detail_id]

,[line1]

,[line2]

,[line3]

,[line4]--Displays Age: Older than 4...

Hope it works for you!

Manu

Thanks for sharing your experience Jeff.

Many thanks!

MJ

Try the attached one(zipped format).

http://www.martinfiala.net/Archive/2006/10/08/Zasilani-emailu-z-SQL-Serveru-bez-nutnosti-instalace-MAPI-klienta.aspx

MJ

Run exec sp_spaceused @updateusage = ‘true’

to get exact figures and then decide accordingly.

http://www.mssqltips.com/tip.asp?tip=1358

MJ

Thanks Lowell. That will surely help. Needless to say I find your scripts(posted on this forum) too useful.

Thanks again.

Manu

Yes, you can. Go to New Agent Job-->New Job Step-->Under Type-->choose Active X Script. In down window select VBScript as lanaguage and paste your script.

MJ

That 66.4 is available for use by other applications.

MJ