| Groups | Blog | Home |
sql server replication : Urgent Help for replication
I am student and i need some help from you. I got one task and i need guide line and hints to solve this problem 1: From old SQL server 2000 must delet replication scripts and users 2: Check at Jobs, DTS and Security on the SQL server is OK 3: synchronize DataBase users in SQLDBA_NEW 4: Delete logins under logings under data base 5: Run script for db. 6: Setup new replication I want to ask where can i find replication scripts in the SQL server? and how can i start to complete this task? How can i creat same replication setup on the new server as old server has now? Best Regards,
Hello!
I am student and i need some help from you. I got one task and i need guide line and hints to solve this problem 1: From old SQL server 2000 must delet replication scripts and users and take test for database run sp_addlog, sp_addroleme, sp_ addserverolememeber 2: Check at Jobs, DTS and Security on the SQL server is OK 3: synchronize DataBase users in SQLDBA_NEW 4: Delete logins under logings under data base 5: Run script for db. rights over public (sp_addlog, sp_addroleme, sp_ addserverolememeber) and test users can login. 6: Setup new replication I want to ask where can i find replication scripts in the SQL server? and how can i start to complete this task? How can i creat same replication setup on the new server as old server has now? Best Regards, Mike
Thanks for ur kind reply
My task to transfer SQL server 2000 from OLD server Win 2000 to Win 2003 so i need to this. Where can i find these scripts sp_addlog, sp_addroleme, sp_ addserverolememeber? Best regards, Mike Petter [quoted text, click to view] "Hilary Cotter" wrote:
> right click on your publication and select Generate SQL Script. This should > be all you need. Where can i find sp_addlog, sp_addroleme, sp_> addserverolememeber > > I don't understand why you need to delete the users. You don't need to do > this for replication. > > -- > Hilary Cotter > Looking for a SQL Server replication book? > http://www.nwsu.com/0974973602.html > > Looking for a FAQ on Indexing Services/SQL FTS > http://www.indexserverfaq.com > > "Mike Petter" <MikePetter@discussions.microsoft.com> wrote in message > news:BB59F503-D76C-4039-A931-6FC7AEDA3A87@microsoft.com... > > Hello! > > I am student and i need some help from you. I got one task and i need > guide > > line and hints to solve this problem > > > > 1: From old SQL server 2000 must delet replication scripts and users and > > take test for database run sp_addlog, sp_addroleme, sp_ > addserverolememeber > > 2: Check at Jobs, DTS and Security on the SQL server is OK > > 3: synchronize DataBase users in SQLDBA_NEW > > 4: Delete logins under logings under data base > > 5: Run script for db. rights over public (sp_addlog, sp_addroleme, sp_ > > addserverolememeber) and test users can login. > > 6: Setup new replication > > > > I want to ask where can i find replication scripts in the SQL server? and > > how can i start to complete this task? How can i creat same replication > setup > > on the new server as old server has now? > > > > Best Regards, > > > > Mike > > > >
right click on your publication and select Generate SQL Script. This should
be all you need. I don't understand why you need to delete the users. You don't need to do this for replication. -- Hilary Cotter Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com [quoted text, click to view] "Mike Petter" <MikePetter@discussions.microsoft.com> wrote in message news:BB59F503-D76C-4039-A931-6FC7AEDA3A87@microsoft.com... > Hello! > I am student and i need some help from you. I got one task and i need guide > line and hints to solve this problem > > 1: From old SQL server 2000 must delet replication scripts and users and > take test for database run sp_addlog, sp_addroleme, sp_ addserverolememeber > 2: Check at Jobs, DTS and Security on the SQL server is OK > 3: synchronize DataBase users in SQLDBA_NEW > 4: Delete logins under logings under data base > 5: Run script for db. rights over public (sp_addlog, sp_addroleme, sp_ > addserverolememeber) and test users can login. > 6: Setup new replication > > I want to ask where can i find replication scripts in the SQL server? and > how can i start to complete this task? How can i creat same replication setup > on the new server as old server has now? > > Best Regards, > > Mike >
As Hillary mention these things dont really have much to do with
replication... but they can be fiund in SQL Server Books Online. [quoted text, click to view] "Mike Petter" <MikePetter@discussions.microsoft.com> wrote in message news:C4AB79D8-6D44-4592-A62C-1E952410EB2E@microsoft.com... > Thanks for ur kind reply > My task to transfer SQL server 2000 from OLD server Win 2000 to Win 2003 > so > i need to this. Where can i find these scripts sp_addlog, sp_addroleme, > sp_ > addserverolememeber? > > Best regards, > > Mike Petter > > > "Hilary Cotter" wrote: > >> right click on your publication and select Generate SQL Script. This >> should >> be all you need. Where can i find sp_addlog, sp_addroleme, sp_> >> addserverolememeber > >> >> I don't understand why you need to delete the users. You don't need to do >> this for replication. >> >> -- >> Hilary Cotter >> Looking for a SQL Server replication book? >> http://www.nwsu.com/0974973602.html >> >> Looking for a FAQ on Indexing Services/SQL FTS >> http://www.indexserverfaq.com >> >> "Mike Petter" <MikePetter@discussions.microsoft.com> wrote in message >> news:BB59F503-D76C-4039-A931-6FC7AEDA3A87@microsoft.com... >> > Hello! >> > I am student and i need some help from you. I got one task and i need >> guide >> > line and hints to solve this problem >> > >> > 1: From old SQL server 2000 must delet replication scripts and users >> > and >> > take test for database run sp_addlog, sp_addroleme, sp_ >> addserverolememeber >> > 2: Check at Jobs, DTS and Security on the SQL server is OK >> > 3: synchronize DataBase users in SQLDBA_NEW >> > 4: Delete logins under logings under data base >> > 5: Run script for db. rights over public (sp_addlog, sp_addroleme, sp_ >> > addserverolememeber) and test users can login. >> > 6: Setup new replication >> > >> > I want to ask where can i find replication scripts in the SQL server? >> > and >> > how can i start to complete this task? How can i creat same replication >> setup >> > on the new server as old server has now? >> > >> > Best Regards, >> > >> > Mike >> > >> >> >>
Thanks for ur reply but i have same question where can i find the procedure
or online books to start my work. Please help me today is last day for me to submit my work i know it is work of 2 or 3 hours but i havent any idea to complete this:( i totaly new with SQL server. Thanks for all of yours for ur kind time and tips. Mike [quoted text, click to view] "ChrisR" wrote:
> As Hillary mention these things dont really have much to do with > replication... but they can be fiund in SQL Server Books Online. > > > "Mike Petter" <MikePetter@discussions.microsoft.com> wrote in message > news:C4AB79D8-6D44-4592-A62C-1E952410EB2E@microsoft.com... > > Thanks for ur kind reply > > My task to transfer SQL server 2000 from OLD server Win 2000 to Win 2003 > > so > > i need to this. Where can i find these scripts sp_addlog, sp_addroleme, > > sp_ > > addserverolememeber? > > > > Best regards, > > > > Mike Petter > > > > > > "Hilary Cotter" wrote: > > > >> right click on your publication and select Generate SQL Script. This > >> should > >> be all you need. Where can i find sp_addlog, sp_addroleme, sp_> > >> addserverolememeber > > > >> > >> I don't understand why you need to delete the users. You don't need to do > >> this for replication. > >> > >> -- > >> Hilary Cotter > >> Looking for a SQL Server replication book? > >> http://www.nwsu.com/0974973602.html > >> > >> Looking for a FAQ on Indexing Services/SQL FTS > >> http://www.indexserverfaq.com > >> > >> "Mike Petter" <MikePetter@discussions.microsoft.com> wrote in message > >> news:BB59F503-D76C-4039-A931-6FC7AEDA3A87@microsoft.com... > >> > Hello! > >> > I am student and i need some help from you. I got one task and i need > >> guide > >> > line and hints to solve this problem > >> > > >> > 1: From old SQL server 2000 must delet replication scripts and users > >> > and > >> > take test for database run sp_addlog, sp_addroleme, sp_ > >> addserverolememeber > >> > 2: Check at Jobs, DTS and Security on the SQL server is OK > >> > 3: synchronize DataBase users in SQLDBA_NEW > >> > 4: Delete logins under logings under data base > >> > 5: Run script for db. rights over public (sp_addlog, sp_addroleme, sp_ > >> > addserverolememeber) and test users can login. > >> > 6: Setup new replication > >> > > >> > I want to ask where can i find replication scripts in the SQL server? > >> > and > >> > how can i start to complete this task? How can i creat same replication > >> setup > >> > on the new server as old server has now? > >> > > >> > Best Regards, > >> > > >> > Mike > >> > > >> > >> > >> > >
Mike,
if you right-click the database in question, and select to generate sql, you'll see the options available on the Options tab. These will deal with database roles but not server roles. For the rest (sp_addlog??), you'll have to code them yourself using the examples in BOL. If you post back with exactly what you want to achieve, tell us or the server newsgroup and someone will probably post back a script. Rgds, Paul Ibison SQL Server MVP, www.replicationanswers.com (recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html)
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |