Showing posts with label sql2000. Show all posts
Showing posts with label sql2000. Show all posts

Monday, March 12, 2012

How long on Hilary's Merge book? :=)

Reading this pretty incredible book on SQL2000 Transactional and Snapshot
replication and wondering when Volume 2 is coming out?
I can't give you an answer on that. Right now we are looking at March/05.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%23sOYjNd0EHA.2040@.tk2msftngp13.phx.gbl...
> Reading this pretty incredible book on SQL2000 Transactional and Snapshot
> replication and wondering when Volume 2 is coming out?
>

Friday, March 9, 2012

How Is The SQL2000 Desktop Licensed?

Could the SQL2000 Desktop Engine be bought individually or they one
have to buy the Enerprise version in order to get the Desktop Engine?
All we need right now is the Desktop Engine.
Thank you very much
mike
MSDE is free!
http://www.microsoft.com/sql/msde/howtobuy/default.asp
David Portas
SQL Server MVP
|||Mike wrote:
> Could the SQL2000 Desktop Engine be bought individually or they one
> have to buy the Enerprise version in order to get the Desktop Engine?
> All we need right now is the Desktop Engine.
> Thank you very much
> mike
Do you mean "Personal Edition" or MSDE 2000? MSDE 2000 is a free
download from MS: http://www.microsoft.com/sql/msde/default.asp
Personal Edition is included as a part of Standard and Enterprise for
use with workstations and cannot be purchased separately.
David Gugick
Imceda Software
www.imceda.com

How Is The SQL2000 Desktop Licensed?

Could the SQL2000 Desktop Engine be bought individually or they one
have to buy the Enerprise version in order to get the Desktop Engine?

All we need right now is the Desktop Engine.

Thank you very much

mikeMSDE is free!
http://www.microsoft.com/sql/msde/howtobuy/default.asp

--
David Portas
SQL Server MVP
--|||Mike wrote:
> Could the SQL2000 Desktop Engine be bought individually or they one
> have to buy the Enerprise version in order to get the Desktop Engine?
> All we need right now is the Desktop Engine.
> Thank you very much
> mike

Do you mean "Personal Edition" or MSDE 2000? MSDE 2000 is a free
download from MS: http://www.microsoft.com/sql/msde/default.asp

Personal Edition is included as a part of Standard and Enterprise for
use with workstations and cannot be purchased separately.

--
David Gugick
Imceda Software
www.imceda.com

Friday, February 24, 2012

How I can transfer login and password between SQL7 and SQL2000 Ser

Hi Good Day to everyone
In SQL7 Server have created some users ID with the passwords. I would like
to know how I can transfer those login IDs and Passwords into the SQL2000
server without re-create.
Besides, I would like to how to change the db ownership after I transfer the
ID and password?
Please advise.
Polar Bear.
* Polar Bear is new to SQL DB
Here are some articles you may be interested in:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/featu...le.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Polar Bear" <PolarBear@.discussions.microsoft.com> wrote in message
news:D76B2259-BEA3-4239-9BBB-2E24A2395DBC@.microsoft.com...
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer
> the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB
|||Check out http://www.support.microsoft.com/?id=246133 for transferring
logins.
With regards changing the database ownership, check out SQL Books On
Line for the sproc sp_changedbowner.
Regards
ALI
Polar Bear wrote:
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB

How I can transfer login and password between SQL7 and SQL2000 Ser

Hi Good Day to everyone
In SQL7 Server have created some users ID with the passwords. I would like
to know how I can transfer those login IDs and Passwords into the SQL2000
server without re-create.
Besides, I would like to how to change the db ownership after I transfer the
ID and password?
Please advise.
Polar Bear.
* Polar Bear is new to SQL DBHere are some articles you may be interested in:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/feat...cle.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Polar Bear" <PolarBear@.discussions.microsoft.com> wrote in message
news:D76B2259-BEA3-4239-9BBB-2E24A2395DBC@.microsoft.com...
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer
> the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB|||Check out http://www.support.microsoft.com/?id=246133 for transferring
logins.
With regards changing the database ownership, check out SQL Books On
Line for the sproc sp_changedbowner.
Regards
ALI
Polar Bear wrote:
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer t
he
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB

How I can transfer login and password between SQL7 and SQL2000 Ser

Hi Good Day to everyone
In SQL7 Server have created some users ID with the passwords. I would like
to know how I can transfer those login IDs and Passwords into the SQL2000
server without re-create.
Besides, I would like to how to change the db ownership after I transfer the
ID and password?
Please advise.
Polar Bear.
* Polar Bear is new to SQL DBHere are some articles you may be interested in:
http://vyaskn.tripod.com/moving_sql_server.htm Moving DBs
http://www.databasejournal.com/features/mssql/article.php/3379901 Moving
system DB's
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
Andrew J. Kelly SQL MVP
"Polar Bear" <PolarBear@.discussions.microsoft.com> wrote in message
news:D76B2259-BEA3-4239-9BBB-2E24A2395DBC@.microsoft.com...
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer
> the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB|||Check out http://www.support.microsoft.com/?id=246133 for transferring
logins.
With regards changing the database ownership, check out SQL Books On
Line for the sproc sp_changedbowner.
Regards
ALI
Polar Bear wrote:
> Hi Good Day to everyone
> In SQL7 Server have created some users ID with the passwords. I would like
> to know how I can transfer those login IDs and Passwords into the SQL2000
> server without re-create.
> Besides, I would like to how to change the db ownership after I transfer the
> ID and password?
> Please advise.
> Polar Bear.
> * Polar Bear is new to SQL DB

how i can make script Database with Data?

hi
i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise +
SP4.
i have database contains Tables, and i want make script to build Tables on
other Database,
but i need this script include Data in Tables too, i can make that ? and
how?
thanks
--
Tarek M. Sialahi,
Tark Siala wrote:
> hi
> i am working on Windows 2000 Advanced Server + SP4 and SQL2000
> Enterprise + SP4.
> i have database contains Tables, and i want make script to build
> Tables on other Database,
> but i need this script include Data in Tables too, i can make that ?
> and how?
> thanks
you can have a look at a free prj of mine, at the link following my sign.,
DbaMgr2k, which include an "INSERT INTO" script generation feature at table
level...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply|||Try www.sqlscripter.com to generate data scripts. It's free.
"Tark Siala" wrote:

> hi
> i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise
+
> SP4.
> i have database contains Tables, and i want make script to build Tables on
> other Database,
> but i need this script include Data in Tables too, i can make that ? and
> how?
> thanks
> --
> Tarek M. Siala
>
>

how i can make script Database with Data?

hi
i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise +
SP4.
i have database contains Tables, and i want make script to build Tables on
other Database,
but i need this script include Data in Tables too, i can make that ? and
how?
thanks
--
Tarek M. Sialahi,
Tark Siala wrote:
> hi
> i am working on Windows 2000 Advanced Server + SP4 and SQL2000
> Enterprise + SP4.
> i have database contains Tables, and i want make script to build
> Tables on other Database,
> but i need this script include Data in Tables too, i can make that ?
> and how?
> thanks
you can have a look at a free prj of mine, at the link following my sign.,
DbaMgr2k, which include an "INSERT INTO" script generation feature at table
level...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply

how i can make script Database with Data?

hi
i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise +
SP4.
i have database contains Tables, and i want make script to build Tables on
other Database,
but i need this script include Data in Tables too, i can make that ? and
how?
thanks
--
Tarek M. Sialahi,
Tark Siala wrote:
> hi
> i am working on Windows 2000 Advanced Server + SP4 and SQL2000
> Enterprise + SP4.
> i have database contains Tables, and i want make script to build
> Tables on other Database,
> but i need this script include Data in Tables too, i can make that ?
> and how?
> thanks
you can have a look at a free prj of mine, at the link following my sign.,
DbaMgr2k, which include an "INSERT INTO" script generation feature at table
level...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply

how i can make script Database with Data?

hi
i am working on Windows 2000 Advanced Server + SP4 and SQL2000 Enterprise +
SP4.
i have database contains Tables, and i want make script to build Tables on
other Database,
but i need this script include Data in Tables too, i can make that ? and
how?
thanks
--
Tarek M. Sialahi,
Tark Siala wrote:
> hi
> i am working on Windows 2000 Advanced Server + SP4 and SQL2000
> Enterprise + SP4.
> i have database contains Tables, and i want make script to build
> Tables on other Database,
> but i need this script include Data in Tables too, i can make that ?
> and how?
> thanks
you can have a look at a free prj of mine, at the link following my sign.,
DbaMgr2k, which include an "INSERT INTO" script generation feature at table
level...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
-- remove DMO to reply