Thank You Jason,

i'll check the link and revert back if any queries.

Hi Jason,

there is no Loop and cursors, it is a simple select query, is there any other way (without using 3rd party tools) to get the full query which is...

hi,

Using DBCC INPUTBUFFER(<spid>)

but am not getting the full query.

Thank you Hanshi and Lowell,

Your Suggestions help me a lot.

Thank u once again.

🙂

Thank You:-) Sean Pearce 🙂

I got what i Want.

Thanks Once again.:-):-):-):-)

Thank You:-) Sean Pearce 🙂

I got what i Want.

Thanks Once again.:-):-):-):-)

Hi Team,

am writing in-detail,

Step 1: opening sql server > Start > Programs > Micro soft sql server > SSMS

Step 2 : Connecting to Database engine by Login and Password.

Step 3:...

On re-reading, I'm not sure that's what he's asking, anyway. Does he want to know how to have the folders automatically expanded when SSMS opens?

John

Yes John Exactly,

I've all the...

Thank You 🙂

Thank u,

It's working.

No, simple t-sql backup commmand only.

No Sir,

Hi,

there are no locks on table, selecting data by specefying NOLOCK only, still gettting the same problem.

Please suggest...!

Hi,

Below are the settings in specified path....

Set Rowcount = 0

Set Textsize = 2147483647

execution time-out=0

Batch seperator=GO

am having a table 'Stud' with index 'ix_std_to' and statistics 'ix_std_to', now i want to delete the existing statistics and check the performance of my query, and also i want...