Hi

I think u can script logins,users and user permissions and run the script on the new server.

hi

to supress the messages use the "WITH NO_INFOMSGS" option with the command.

Hi

Not a very convincing post. A project is successfull only when all the people associated with it feel its useful to them. The post talks about real situations that we...

hi

this should be the design for this purpose

hi

is the new installation on the same server on which sql 2000 is running.since u logged in as sa we can assume that privileges wont be a issue.

r u trying...

hi

yes trigger might be the cause of the problem.

hi

how are u trying the restore? i did not get this "If I restore a data of one Database 'A' to another Database 'B'".

Are u using Restore the backup of...

Hi

is ur sql database on a local server or network server. check the credentials you ar using to connect to the database

Chirag

hi

i got it the same way...in the setup files folder and also registry.

regards

chirag

Hi

Thanks Duncan & Colin.

Duncan -

I want this information for connecting and restoreing a db at a clients place remotely and person who has installed it has already left the...

hi

i did not understand fully what u meant by your statement

"yes iam trying to insert same record once again because, one new record will be added to that table thats...

hi

r u inserting the same record once again. that might be causing the unique constraint violation.

Hi

If Exists (SELECT name from sysdatabases where name = 'MyDataBase')

BEGIN

USE MyDataBase

select * from MyDataBase..MyTable

END

hi

try this......

select u.userid from users u left outer join userroles ur on u.userid = ur.userid

where ur.roleid is null.

hi

does the REQUEST_DATE_TIME column contain date as well as time. if so you will have to format this column in your query.