Are we sure it takes longer for new applications? I know we're in a mode of enhancing applications in small ways on a regular basis, but it seems that we...

Your account must not have a login in SQL Server. What does the SSMS registered server settings say?

Good idea on the delay.

Even without it, I've seen better performance and some queries still slipping into the system as each transaction completes, but you're right, it does still slam...

Yikes!

Thanks for the update. My guess is there was some flakiness somewhere or you weren't querying what you thought you were, but glad it's working for you.

When you connect, you'll also need to drop the server and then add it back as the new server name.

And you restarted SQL?

Did you change the name in sysservers?

For a clustered index, the row count should be stored in a system table, so that should be quick.

For the first, if you had an index on the GROUP BY...

And do you just have one instance?

We do not condone or allow dumps for the exams. It is a violation of the NDA.

You must get the requirements from Microsoft and study the material. Asking someone give...

Please, please do not set a blank password. What requirement could you have to ensure that you have a security vulnerability like that?

And please don't use sa for development or...

Is this a local install of SQL Server?

You are passing along a local credential if you have computername/username and not a domain credential. Check the registration properties from SSMS and...

May the Force be with you...always

[highlight]Test[/highlight]

I added a highlight there. I'm not sure that it covers colors.

It's something that we have talked about. I'll raise the issue. It definitely is something I'd like.