Re: Determining Defaut catalog
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 01/11/05
- Next message: Rob: "export SQL diagrams"
- Previous message: bairda: "Newbie question on meaning of icon..."
- In reply to: passo71: "Re: Determining Defaut catalog"
- Next in thread: passo71: "Re: Determining Defaut catalog"
- Reply: passo71: "Re: Determining Defaut catalog"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 11 Jan 2005 20:14:11 +0100
> Db_NAME()
That is your current database (catalog).
If you want the default catalog for a certain login, look in syslogins or use sp_helplogins, as
suggested by Jacco.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ http://www.sqlug.se/ "passo71" <passo71@discussions.microsoft.com> wrote in message news:20D8C8D5-D210-4B74-BC8E-B1B8DCFB341B@microsoft.com... > Its OK. I've found it out. > > Db_NAME() > > Thanks a lot anyway > > > "Jacco Schalkwijk" wrote: > >> See sp_helplogins in Books Online. >> >> -- >> Jacco Schalkwijk >> SQL Server MVP >> >> >> "passo71" <passo71@discussions.microsoft.com> wrote in message >> news:61B2E174-AE2F-4355-BE71-5006410BE74F@microsoft.com... >> > When you using T-Sql commands, how is it possible to determine the defaut >> > CATALOG ?? >> > >> > Thanks a lot >> >> >>
- Next message: Rob: "export SQL diagrams"
- Previous message: bairda: "Newbie question on meaning of icon..."
- In reply to: passo71: "Re: Determining Defaut catalog"
- Next in thread: passo71: "Re: Determining Defaut catalog"
- Reply: passo71: "Re: Determining Defaut catalog"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
