Copy Logins from Server1 to Server2

Hello,
I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
there a way that I can export the logins acount info to the other sqlServer?
Thanks
Jose.DTS let you copy logins.
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:%23aETDE52DHA.3416@.tk2msftngp13.phx.gbl...

quote:

---

> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other

---

sqlServer?

quote:

---

> Thanks
> Jose.
>

---

|||There is a really good doc under Books On line, search for Log shipping...
Moving logins from one server to another is part of the failover process for
log shipping so the process is really documented well...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:#aETDE52DHA.3416@.tk2msftngp13.phx.gbl...

quote:

---

> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other

---

sqlServer?

quote:

---

> Thanks
> Jose.
>

---

Copy Logins from Server1 to Server2

Hello,
I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
there a way that I can export the logins acount info to the other sqlServer?
Thanks
Jose.DTS let you copy logins.
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:%23aETDE52DHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other
sqlServer?
> Thanks
> Jose.
>|||There is a really good doc under Books On line, search for Log shipping...
Moving logins from one server to another is part of the failover process for
log shipping so the process is really documented well...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jose Ines Cantu Arrambide" <nospam@.nospam> wrote in message
news:#aETDE52DHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> I have 2 SqlServers, one has a lot of Login/Users/Permissions data. Is
> there a way that I can export the logins acount info to the other
sqlServer?
> Thanks
> Jose.
>

Copy database to same server but with a different name

I have a production database named "PRODUCTION_DATABASE" on "SERVER1". I would like to copy this database (and all its views, stored procedures, etc.) to the same server but under a different database name (i.e., "TEST_DATABASE" on "SERVER1"). This copy will be used for software development testing purposes.

What is the best way to do this?

P.S. I have SQL Server 2000 Enterprise Edition.You can use DTS to copy the database, or you can use a backup file from the production database and restore it to the test database. to use DTS, right click on the database, select Export, then when given the chance, Export Objects. When selecting a destination database, select New and you will be able to create the new database.|||douglas.reilly,

Your DTS suggestion worked perfectly! Thanks :)

Converting MS Access to SQL Server 2K

Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regards
Using the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards
|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?

Converting MS Access to SQL Server 2K

Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||>2) Also the recordset does not return any record
what is your query, and what is the dB structure?

Converting MS Access to SQL Server 2K

Hi,
I am fairly new to SQL Server and would appreciate if anyone could solve my
problem.
I have SQL server 2k installed on the server, say server1. My website is
also hosted on the same server. I have another instance installed on my
client machine.
Now I am connecting to the remote SQL server instance and
migrating/importing data from MS Access DB. The database migrated
successfully. I changed the ADO connection properties in my ASP code to
access data from SQL server.
Now the problem...
1) I am connecting to the DB but have to prefix all my table names with the
DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
2) Also the recordset does not return any record
please help
regardsUsing the 2-part name is optional... When you select * from mytable. SQL
first looks to see if YOU own a table with that name. ( ie wayne.mytable).
If such a table does NOT exist, then it searches for and returns a table
like this owned by the dbo... ( ie dbo.mytable)...
So you shouldn't have to use the 2-part name...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fuzail" <Fuzail@.discussions.microsoft.com> wrote in message
news:AB8DC0C4-29A8-48A1-99AC-B89F9668DBDA@.microsoft.com...
> Hi,
> I am fairly new to SQL Server and would appreciate if anyone could solve
my
> problem.
> I have SQL server 2k installed on the server, say server1. My website is
> also hosted on the same server. I have another instance installed on my
> client machine.
> Now I am connecting to the remote SQL server instance and
> migrating/importing data from MS Access DB. The database migrated
> successfully. I changed the ADO connection properties in my ASP code to
> access data from SQL server.
> Now the problem...
> 1) I am connecting to the DB but have to prefix all my table names with
the
> DBO, eg.. [DBO].tablename. Is there any way I can avoid this?
> 2) Also the recordset does not return any record
> please help
> regards|||
>2) Also the recordset does not return any record
what is your query, and what is the dB structure?