You can also try using a Server sizing tool. You can find the Compaq one here

http://activeanswers.compaq.com/ActiveAnswers/Render/1,1027,5-6-100-225-1,00.htm

You'll need to register to download it though.

You put in the number of...

How about a read-only Application Role?

Check out "How to create an application role" and "Establishing Application Security and Application Roles" in BOL.

"HUNT 'N' PECKER"

Did learn touch-typing way back when. Got up to about 60 WPM. Then I started working in mainframe environment. Those programmable function keys where...

Firstly you should remove the linked server via sp_dropserver. As the databases are on the same server you don't need to worry about linking servers.

I think your problem is...

Good series of articles so far. Awaiting the final article on rolling back changes. Have had a few nightmares to sort out in that department.

Have you heard/used...

All

Thanks for your comments and suggestions.

This task has been placed the too-hard basket. The "Server Support Technichians" are "not too sure a contract DBA should have...

Ok, I've put quotes around the whole path, but I still get the same error.

Unfortunately, due the usual political guff, I am not allowed to access the command prompt or...

I also would like to know why you advise against using Visual Interdev. I've implemented and used it successfully in a couple of jobs.