Hi,
Using SQL 2k SP3
I want to know if there's a way to retrieve the name of the database a
stored proc is run in.
For example:
CREATE PROCEDURE HelloWorld
AS
PRINT 'Hello world, this proc is run in: ' + CAST(GetDatabaseName AS
nvarchar)
GO
GetDatabaseName here is fictitious ofcourse , what would be the right
command? I can't seem to find it.
Regards,
Bas
----
Okay, okay, i'll explay what I really want with it, I want something like
below (yes it's quick 'n' dirty), but without having to pass the db name:
CREATE PROCEDURE CheckDBProperties
@DBName nvarchar(1000),
@Error nvarchar(1000) OUTPUT
AS
DECLARE @Result sql_variant
SELECT @Result = DATABASEPROPERTYEX(@DBName, 'IsAnsiNullDefault')
IF @Result <> 1
SET @Error = @Error + 'IsAnsiNullDefault has a wrong setting: ' +
CAST(@Result AS nvarchar(1)) + CHAR(13) + CHAR(10)
SELECT @Result = DATABASEPROPERTYEX(@DBName, 'IsAnsiNullsEnabled')
IF @Result <> 1
SET @Error = @Error + 'IsAnsiNullsEnabled has a wrong setting: ' +
CAST(@Result AS nvarchar(1)) + CHAR(13) + CHAR(10)
SELECT @Result = DATABASEPROPERTYEX(@DBName, 'IsAnsiPaddingEnabled')
IF @Result <> 1
SET @Error = @Error + 'IsAnsiPaddingEnabled has a wrong setting: ' +
CAST(@Result AS nvarchar(1)) + CHAR(13) + CHAR(10)
GO
DECLARE @FLEP nvarchar(1000)
SET @FLEP = ''
EXEC CheckDBProperties 'MyDB', @FLEP OUTPUT
PRINT @FLEP