Very Computer

by **simo** » Wed, 31 Oct 2001 23:59:17

Hi,
I am looking for a sql script that will check what version
of sql server is installed and then perform an action
depending on what the version is.
Can anybody help with this?

by **Dejan Sark** » Thu, 01 Nov 2001 00:09:40

introduced in SQL 2000, IIRC.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.

Quote:> Hi,
> I am looking for a sql script that will check what version
> of sql server is installed and then perform an action
> depending on what the version is.
> Can anybody help with this?

by Al » Thu, 01 Nov 2001 00:12:05

Hi,

Al

Quote:
>Hi,
>I am looking for a sql script that will check what version
>of sql server is installed and then perform an action
>depending on what the version is.
>Can anybody help with this?

by **OBM System** » Thu, 01 Nov 2001 00:22:19

Hi

A simple question for all those budding DBADMIN people. I would like to copy
my DB on to a CDROM or HDD then take it else where and read the entire
database (Including, tables, indexes, constraints and SPs etc).

What is the most simple and effective way of doing this ?

Hey guys I am very new to MS SQL2000.

Thanks

Yamin

by **Ron LeVa** » Thu, 01 Nov 2001 00:50:55

Yamin,
Use the backup function in enterprise manager to back up the database onto
the media then use the restore function to place it on the target server.

HTH
Ron LeVau,
Database Consultant

Quote:> Hi

> A simple question for all those budding DBADMIN people. I would like to
copy
> my DB on to a CDROM or HDD then take it else where and read the entire
> database (Including, tables, indexes, constraints and SPs etc).

> What is the most simple and effective way of doing this ?

> Hey guys I am very new to MS SQL2000.

> Thanks

> Yamin

by **Rand Bo** » Thu, 01 Nov 2001 01:57:20

Yamin,

A simpler procedure is to stop SQL Server, copy the mdf, ndf and ldf files
that make up the database, take them to the new machine and run
sp_attach_db in Query Analyzer. This will attach the database. However any
users in the database will basically be orphaned. You will need to account
for these users. Look at sp_change_users_login in Books on Line to deal
with these.

Rand Boyd
Microsoft SQL Server Support

Please reply only to the newsgroups.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.

I've been "encouraged" to share this helpful information from our lawyers.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
? 2001 Microsoft Corporation. All rights reserved.

by **Prasad Koukuntl** » Thu, 01 Nov 2001 02:38:49

Rand,
sp_change_users_login does not create the original passwords for the logins
that will be created. Is there any other procedure to regenerate these
passwords other than restoring the backup of the master database from the
source (original) server.
Thank you.
Prasad.

Quote:> Yamin,

> A simpler procedure is to stop SQL Server, copy the mdf, ndf and ldf files
> that make up the database, take them to the new machine and run
> sp_attach_db in Query Analyzer. This will attach the database. However any
> users in the database will basically be orphaned. You will need to account
> for these users. Look at sp_change_users_login in Books on Line to deal
> with these.

> Rand Boyd
> Microsoft SQL Server Support

> Please reply only to the newsgroups.
> When posting, please state the version of SQL Server being used and the
> error number/exact error message text received, if any.

> I've been "encouraged" to share this helpful information from our lawyers.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use.
> ? 2001 Microsoft Corporation. All rights reserved.

by **simo** » Thu, 01 Nov 2001 03:10:48

I found what I needed.
Thanks.

>-----Original Message-----

Serverproperty function was

>introduced in SQL 2000, IIRC.

>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.

>> Hi,
>> I am looking for a sql script that will check what
version
>> of sql server is installed and then perform an action
>> depending on what the version is.
>> Can anybody help with this?

>.

by **Rand Bo** » Thu, 01 Nov 2001 04:44:39

The only definite way to get the passwords is to restore the master
database.

Rand Boyd
Microsoft SQL Server Support

Please reply only to the newsgroups.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.

I've been "encouraged" to share this helpful information from our lawyers.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
? 2001 Microsoft Corporation. All rights reserved.

by **Keith Kratochvi** » Thu, 01 Nov 2001 09:09:44

Here is a method to transfer logins *without* transferring the master
database:
http://support.microsoft.com/support/kb/articles/Q246/1/33.ASP

--
Keith, SQL Server MVP

Quote:> Rand,
> sp_change_users_login does not create the original passwords for the
logins
> that will be created. Is there any other procedure to regenerate these
> passwords other than restoring the backup of the master database from the
> source (original) server.
> Thank you.
> Prasad.

Very Computer

sql version

sql version

sql version

sql version

sql version

sql version

sql version

sql version

sql version

sql version

sql version