My answer was based on the logical understanding of instance configurations. And yes I got it correct. Good QoTD. Thanks.

Yes Auto Close and Auto Shrink are not good options.

Also please update us with your findings. I guess Trace thingy must helped you.

Best Regards,

Sudhir

Or you may also try these:

select * from sys.sysprocesses

EXEC sp_who

EXEC sp_who2

Please see there are ProgramName, HostName columns to help you up to some extents.

Interesting Question, revising about the issue. Thanks.

Please refer these URLs.

http://msdn.microsoft.com/en-us/magazine/cc163854.aspx

http://msdn.microsoft.com/en-us/library/ff647813.aspx

Also I would suggest you for following things if something has changed last week at application level:

1. See how many connection strings are being created in your...

Why would one like to do so?? I can't understand.:unsure:

For logging you can write your...

Please read your question again by yourself. TableName should be written as @TableName. Also your procedure name is different in definition.

An Interesting Question!

I am part of development of an erp application.I need to capture the history of data which is mandatory for capturing history..details.

Can anyone give solution-how to handle this scenario by...

You may use code like this:

ALTER TABLE [TableName] WITH NOCHECK

ADD CONSTRAINT [PrimaryKeyName] PRIMARY KEY CLUSTERED ([ExistingColumn])

WITH (FILLFACTOR = 75, ONLINE = ON, PAD_INDEX = ON);

Pls refer this link:

http://msdn.microsoft.com/en-us/library/ms190273.aspx

Yes, I do agree...

This time I tried logically and thought that after Truncate command the distribution statistics must be deleted. But I got wrong. Anyways learnt something from this.

But still I think...

Interesting question!!

Thanks.

Open or type a Transact-SQL script that contains the queries you want to analyze into the Management Studio query editor. After the script has been loaded into the Management Studio...