Since you are using 2005 what i suggest that you can do is add the user to have dbo as his default schema. so that whatever objects he creates will...

IS TADLR your domain nmae or th machine name?

OS error 5 is for permissios. have you checked whether you have permissions to read the file. and also the restore path. do a restore verifyonly or header only to...

You have 2 data files one with extn ,mdf and other with .ndf. If so then you can combine them into one by doing the following

1. attach the database

2....

Check if your id has permissions. since you say that you are a sysadmin i would see that this should execute successfully. check the rights.

If it is SQL 2005 then full text catalogs are stored in backups.

I have no probs with the servername that i have already handled internally the issue is i have hundreds of scripts and now using a batch file to call them...

You can copy the content of sysdtspackages table to the destination server. But you will have to redo the connection settings in the new server.

Filter have not worked most time for me to i trace the data and manipulate with tables and sql statements.

If the databases reside in single same server you can use the three part naming convention to call the other database from a databaselike

dbname.ownername.objectname

else if they reside in diff servers...

For you req look for log shipping or replication. Log shipping will transfer the database fully and can be only in read only mode. Replication can be made to transfer...

Forgot to say microsoft's MSDN too.

When you set min memory you have to set the max memory option too. THere is no alternative with 4GB in the server and if there are few databases being...

Detach/attache method will work fine. Also the backup and restore methids. Then you can move the logins and jobs and other things by scripting out and executing in the other...

Create 4 new files move the data from the tables to the new files with a backup name and drop the tables and other objects in the database then create...