Have you Enabled C2 audit tracing?

I think C2 audit tracing is enabled and SQL Server is not able to write to it due to lack of disk space or other...

Glad to know that it works well.

But, I have concerns 🙁

Is it a production server? One should be carefull while issuing KILL command on a production server.

Do you have...

Best Practice, Books Online, In My Openion.

I think same as /console

>>Do I have to Deattach or take offline the DB to copy the .mdf and .ldf files to other machine.

Yes. Without detach/offline files cannot be copied.

>> I can't do a...

Tim Walker (7/21/2009)

Suresh B. (7/21/2009)

Page density is very low at 19%, which seems to be tie up with the issue, so any ideas why this would occur on a table...

Page density is very low at 19%, which seems to be tie up with the issue, so any ideas why this would occur on a table that is only ever...

As per my knowledge, after adding a new article to a publication, it is mandatory to sync it with snapshot. And it does bulk insert, not single row insert.

BTW, is...

CREATE NONCLUSTERED INDEX [ws_pda_ack_i01] ON [dbo].[ws_pda_ack]

([job_number] ASC)WITH FILLFACTOR = 85 ON [PRIMARY]

It is 85% unused, but rows are only ever inserted into it (or later updated). There are...

Install the Client Tools.

Run the following script before generating new snapshot.

EXEC sp_changepublication

@publication = 'MainPub',

@property = N'allow_anonymous',

@value = 'false'

GO

EXEC sp_changepublication

@publication = 'MainPub',

@property =...

Right click on the subscription. Select properties. Under Security you can set Account name and password.

Glad to know that you found it.:-)

Thanks for posting it.

I was about to say that hundres of database triggers cannot be created on single database.

Hi Viji,

No need to enable any option. It appears automatically just like Functions and stored procedures.

For SQL Server 2000 it will not appear.

Regards,

Suresh

Programmability -> Database Triggers.

Under Programmability, first item is Stored Procedures, second item is Functions, third item is Database Triggers.