yea, I tried that as well so that I could get clean stats. I believe I mentioned that in the first post.

I still can't figure out why it's doing a...

I don't believe you can do it the way you are thinking but I could be wrong.

Are you going to mixed-mode authentication?

It might also be a good time to utilize...

What are you seeing in the Add/Remove Programs?

Are you in the position to completely reinstall everything from scratch for a good clean system?

Do you show an Integration Services Service running?

I'm...

I tried that and it still took a long time.

I didn't run profiler at the time to see if it still chose to do the cursor fetch but I will...

*bump*

Surely someone has dealt with this sort of thing.

I've found a few places that talk about OPENQUERY but they are mainly dealing with SQL 2000.

A profile on the remote server...

I believe it is best to do them separately if it's possible with your resources.

As long as it isn't one disc partitioned into two.

Normally, we do:

C: OS

D: SQL

SAN: data...

Where were you running profiler from?

If you store it in a trc file running from a remote box you and only capture TSQL_SPs you should be ok.

Get it into...

Have you considered upgrading your SQL installation to 64-bit? AWE is a half measure really, and it would make sense for you to take advantage of the capabilities of the...

How does this apply to a 64-bit OS with 32-bit SQL Server 2000?

We have 16GB of RAM and I currently have AWE enabled with Max and Min Memory set leaving...

I apologize for not being more specific. I've just found what seems to be a fix for it but I hope there's a global change.

I'll be a little more specific...

Thanks, I tried this way and it works:

SELECT 'GRANT EXECUTE ON [dbo].['+ ROUTINE_NAME + '] to ApllicationUser'

FROM INFORMATION_SCHEMA.ROUTINES

WHERE SPECIFIC_SCHEMA = N'dbo'

and ROUTINE_TYPE = 'PROCEDURE'

and ROUTINE_NAME LIKE '%usp_%'

Saves me a...

not all of them.

I've gotten them to standardize and use usp_ instead of sp_. I would say probably all of the user stored procedures (I hope there all usp_) and...

I had to do this myself and it was a beast because I had not properly researched it.

Here's my post from that night about one of the issues.

I wish I...

If you want to monitor it on multiple servers I would highly suggest going through this series of articles (here[/url]) and adding a step in there for this specific need....

I know of one gotcha that I've experienced on both 2000 and 2005. Most of it wasn't my fault, but I've found a case where the computer name and SQL...