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.
| Author |
Topic |
|
tahir
Starting Member
3 Posts |
 Posted - 2007-07-20 : 08:10:33
|
| hi,how can i get a unique identifier for a database or a sql server instance.thankstahir |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 10:59:42
|
| You can get db id from sys.sysdatabases, but don't know if there is sql instance guid. |
 |
|
|
tahir
Starting Member
3 Posts |
Posted - 2007-07-20 : 11:12:48
|
| hi again,thanks for your reply butsysdatabases.dbid is not a universal unique identifier for that database.i want to get a theoretically unique string like "AD3fDJD82NDE29..." which identifies the database or server instance. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-20 : 11:13:56
|
| there is no such id.why do you need this?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
tahir
Starting Member
3 Posts |
Posted - 2007-07-20 : 11:19:51
|
| i am developing a software and i don't want my customers to move their database to another sql server instance.this is because of licencing purposes.thanks |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-20 : 12:52:31
|
| that is simply ridicolous.you can't really deny access to your database in this way._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-20 : 13:37:10
|
| Plus customers can move databases from one server to the next and transfer the license with it.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
getting database or sql server instance guid