No. What would be the purpose? Query Analyzer is so you can run commands against the database.

One solution. Change your permissions on the database to allow you...

You can input parameters two ways, one allows you to skip parameters and one doesn't.

CREATE PROCEDURE usp_myproc

@param1 CHAR(1) = 'a',

@param2 CHAR(1) = 'b',

@param3 CHAR(1)...

But that shouldn't give the error you got...if that is indeed the problem, you should have gotten an error stating something similar to "items in the select must be in...

Post the new script you created and we may be able to help you.

-SQLBill

Mark has a good point. In fact the RESTORE DATABASE command uses the WITH RECOVERY or WITH NORECOVERY option (default is WITH RECOVERY). So, it is possible to RESTORE...

One other thing to try...relooking at your first post, you indicate you are trying to set up an ODBC connection. You shouldn't have to do this on the server itself,...

Do you have another account to use?

Does anyone else have an account that has sysadmin priviliges in SQL Server?

It really sounds like BUILTIN/Administrator account was deleted. If so, you...

My first thought is that you want only one unique Customer name. But if so, how do you determine which ItemDescription they should have?

While you respond to that, this might...

but only return one entry for each - for each what? Customer or ItemDescription?

How do you determine which result you should get? Can you provide us what the result...

Yes, that is the TOP reason you will see that error.

-SQLBill

Just for your records...here are good resources/directions for moving your system databases:

By Steve Jones

Moving TEMPDB:

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

Moving MASTER:

http://www.sqlservercentral.com/columnists/sjones/moveyourmaster.asp

Moving MSDB:

http://www.sqlservercentral.com/columnists/sjones/movingmsdb.asp

By Chris Hedgate

http://www.sqlservercentral.com/columnists/chedgate/movingsystemdatabasesachecklist.asp

-SQLBill

Which database do you want to move? Moving system databases (especially MASTER) is not like moving user databases.

-SQLBill

Does Administrator have an account in SQL Server?

Has the SQL Server login BUILTIN/Administrators been deleted or set to deny or anything like that?

-SQLBill

The problem usually isn't that the log CAN'T grow. The problem, instead, is that the log can't grow FAST or LARGE enough.

You set the growth to be 500MB. But...

And you are trying to connect from a remote computer, correct?

Is your computer on the same domain as the SQL Server computer?

-SQLbill