is this problem is going on with every body or just u, if so it might be some thing wrong with the installaion files on ur PC.

have u alterd or droped these objects and u dont have a backup file to script them out of it?

have u changed any thing in the sql server configuration.

is it 2000 or 2005.

sory.

and u only apply NORECOVERY if there is more backups u want to apply to the database like log backups.

u have to consider the following:

1- write the database name u wnat to restore on.

2- if the file exsits on the path u choose then u have to use overwrite.

3-...

if u want u can choose the most accessed tables then rebuild the indexes manually,

then update thier statistics with full scan.

thats only if u want to gain some time to...

u could do from SQL 2000 Enterprise to SQL 2005 Standard, but when thinking off in place upgrade its a risk u shouldnt take when u can, if u cant...

if u stop the sql server, change the port, start the service, then go to the event log u then can make sure if the sql server is listening to...

i tryed to start the sevice from the command line and uesd -f parameter.

the service started, then dropped the procedure and every thing went good, am still going to try...

could u tell me were the default directory for Xp_CmdShell?

my goal is to try create this case and try to get out of it cos if any one did it to the server u have to know what to...

yes if the problem only when using windows loggins then u might have SPN problem and u have to u fix the SPN ur self from the command line "setspn.exe".

u can try every thing from encryption, procedures to alias objects, but when using sa there is not much u can do.

if i was using cluster dose this command will work?

cos we r going to change the port soon, and i dont wont to face unexpected problems.

yes i know, but what can i do, they gave me the script and i have to make it work, i did tried to use left outer join but the...