Hi all,
I'm trying to get the database name from connection string. It only works some of the time. Just wonder if I miss anything in my SQL script:
declare @dbconn varchar (500)
set @dbconn = 'Data Source=test-sql01d\NEW_NIDEV01;Initial Catalog=Restricted;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=false;'
select substring(@dbconn,(CHARINDEX('g=',@dbconn) + 2),CHARINDEX('T',right(@dbconn,79)))
if my database name is 'tested' then it worked but if my database name is something else like 'Restricted' then it came back with just Restr