Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQl Server Replication and database creation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-19 : 19:05:55
Gaurav writes "we are building a SQl Server Centric web application, and requires replication as we do lots of offline data entry which is to be replicated to the web server. thus to emulate the same environment in the testing phase, i have changed the sa login password from security options and created a new user and databse with SETUPADMIN( as required for replication) and DBCREATOR Gaurav writes "we are building a SQl Server Centric web application, and requires replication as we do lots of offline data entry which is to be replicated to the web server. thus to emulate the same environment in the testing phase, i have changed the sa login password from security options and created a new user and databse with SETUPADMIN( as required for replication) and DBCREATOR Fixed Server Roles and DB_OWNER fixed database role. Now after creating a blank database when i connect from some other machine from network and after successful connection tries to IMPORT OR EXPORT pre fed data into t
   

- Advertisement -