Also the event log has the following. The temdb database is in F:\sql\database folder. How to I go about resolving this now.The server has no g:\ drive associated with it.

CREATE...

it stops immediately with the message.

The error message is very clear. the table is having a constraint named PKPS and when you are again creating the table then it is also building the constraint and...

I want to know how you mapped the nt logins manually. I'm not able to do that.

When I'm trying to dd the windows login and making the default db...

it is not mapping the nt user.

I tried to map it to sql login also but it also failed with the error that the user does not exists.

What is the error you are getting when you are adding new sql agent jobs?

Also check if autogrowth is checked or not.

I'm able to increase the size without any fail...

Will this work for a windows login also.

thanks a lot Greg.

Is there any way to decrypt the password in Sql server 2000.

Run the following and see howmany connections u get

select spid from master..sysprocesses where db_name(dbid) = 'Ur database name'

Just kill the pocesses shown in this and then do the restore.

Shekar,

the data would have got saved.Its just that the maximum charaters that you can view in result is set to 356. increase it to 8000 and then probably you will...

Is your MSSQl service running properly. Also this is the only instance running on this. Try to connect in the EM using the servername instaed of local.

Are you able to...

how do I properly arrange or order the dependancies.

thanks Mohammed.the article http://msdn2.microsoft.com/en-US/library/ms190730.aspx solved the problem.Adding the sqlgroup to the lock pages memory and a reboot solved the problem.

Colin I had set the account while the installation only.

Thanks all...

First of all you need to tell us the exact error which you are getting.

Secondly you will have to check as to what all objects are owned by this login and...

"execute master..usp_diskspace" is not working???