Thanks Gail,

Can you please help me in understanding the difference? or docs or link is highly appreciated.

Thanks OPC

It is recommended to leave the system drive ,so in your case place your .mdf & .ldf files in D drive.

Thanks alot Anthony..

Those details really helps in understanding exactly what happens..

Thanks Again

Thanks Antony for the quick reply.

Is that the only advantage?

Try DBCC MEMORYSTATUS

Thanks everyone for the reply

Above script is for database User.

Below script will give you create script of all Logins

use master

DECLARE @login_name sysname

SET @login_name = null

DECLARE @name sysname

DECLARE @type varchar (1)

DECLARE @hasaccess int

DECLARE @denylogin...

Please try the below script. This will script for object access and roles,downside is u need to specify individual user name each time.

DECLARE @DatabaseUserName [sysname]

SET @DatabaseUserName = 'dbo'

SET NOCOUNT ON

DECLARE

@errStatement...

deleted

Where and which file you are trying to open??

try below tsql

SELECT * FROM fn_get_audit_file('D:\Microsoft SQL Server\*.sqlaudit',DEFAULT,default)

Yes Gail I have go through the link you provided.

Mine is SQL Server 2008 R2 SP1 & CU3 and in that post its mentioned like fix for this issue was...

SNAPSHOT CREATION FAILED WITH BELOW ERROR

--------------------------------------------------------

Msg 2601, Level 14, State 1, Procedure sp_flush_commit_table, Line 15

Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'. The duplicate key value...

Thanks SQL Gurus Paul and Gail for the response.

Thanks for the quick reply,

Can you please provide the contact details?