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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 dynamically retrieve the server name

Author  Topic 

pug2694328
Posting Yak Master

166 Posts

Posted - 2006-05-23 : 14:00:30
Is there a query that will pull the servername?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-05-23 : 14:09:20
SELECT @@SERVERNAME
Go to Top of Page

pug2694328
Posting Yak Master

166 Posts

Posted - 2006-05-23 : 14:19:02
thanks!
Go to Top of Page

pug2694328
Posting Yak Master

166 Posts

Posted - 2006-05-23 : 14:47:47
Is there an analog to this for Pervasive SQL?
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-05-23 : 19:43:30
Ugh, you got me, I've never used Pervasive.
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2006-05-23 : 21:47:31
Look up system functions in the Pervasive Programming manual. They have quite a few you can use. I'm sure one of them will give you server name.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -