It sounds 'simple' to add the proc parameter, but it will be pretty hard to combine the trace with the text, since I could not find it from any dm...

Hi Jason:

It works very well for me. It is in prod now, after running on QA.

It almost covers everything I need to know, just one more:

Is it possible to...

Well Done.

I get better understanding with your examples plus your calculations.

One question:

Does it mean that index for C105_CompanyCode, and index for C105_Statement_Acct might be 'dropped', when a composite index of...

After using ERwin for many years, I shifted to ERStudio at beginning of this year. And I am happy with the shifting. (SQL only, it is cheap)

one of the common mistakes of the application side is:

Create / Alter / Drop SQL objects on the fly.

With the implementation of DDL of SQL2005, I had so many confrontations...

Very useful discussion on this partial data recovery.

question:

1. Is there any method in recovering partial, ex 2 tables out of 400 tables 20 gb db?

I still miss the old...

Glad to see someone like me, also play badminton twice a week!

If there is some conflict in the schedule, I will swim or running to compensate to myself.

After all those...

100% agree. Event after using sql 2005 for around 8 months, still missing those 'lost features'.

Probably, some R&D people in MS decided to take them off since they are just from...

Hello Janet Wong:

This is my first time to read your articles. However, after reading it, I begin to read all your previous publishings. They are full...

Reverse to our justice system, a database person is supposed to be "guilty first", then has to approve he/she is "innocent"...

Current is 45 hours + 8-10 hours via VNC during the out-of-office time.

Hi Andy:

Do you happen to have the info about "Los Angeles Area SQL Server User Group" or "Orange County Area SQL Server User Group"?

thanks

-David

According to the while paper, 32767 is the max for SQL2000.

But the limitation was around 1100 to 1200 in my working environment. We have failed 2-3 times when the #...

On our SQL2005 64bit, sp1 server, I just experienced the same error of "[LOG] Unable to read local eventlog (reason: The parameter is incorrect)" with every 5 seconds dumpping to...

Basically, I agree Yelena's suggestion to put Appl/DB on the same server; this might be better under the condition of only one default instance.

This way, the memory and storage utilization...