Steve Jones - SSC Editor (5/8/2013)

---

You can query sys.databases to see if the database exists.

If so, then you'd have to query sys.database_files in that database to get the file location....

Neeraj Dwivedi (5/7/2013)

---

So, if already exists, it will not return anything from the second sql. Because you are checking for not exists?

I thought that you want the path for Master...

thanks guys for the response...

my requirement has changed a bit...

i'm looking for something like this...

check if destination database exists, if it exists select physical location path ( data and log...

yes its already in instance

Thanks Neeraj..

i'm executing like this

IF NOT EXISTS (select d.name, f.physical_name from sys.master_files f, sys.sysdatabases d where f.database_id = d.dbid and

d.name = 'Test_Restore')

select f.physical_name from sys.master_files f, sys.databases d where...

That is the problem here....we have that limitation....so trying to automate....

and also forgot to mention....we need to get source and destination database names, source logical data and log file names...

yeah Stored proc is causing it i guess...because we got the high CPU alerts from 11.08 to 11.38 Pm yesterday and this stored proc is in suspended mode from 11:00...

Hey thanks for the response...i tried that its isnt working....can you please be more specific....

Yes, thank you very much ..

Hey Tom,

Here what i'm getting....

for insert...new records are logged - with this requester can know what record is inserted

for update....old records are logged - with this Requester will know what...

Thanks Steve,Lowell,L'eomot for your help and patience ....script is working fine now....i'm posting the entire script for people who might need it in future....

--/****** Object: Table [dbo].[logger] ...

Thanks a lot Lowell and E'Loment....it worked like a charm....but i have some problems here....

the output what we are getting is the updated items....but the requester is looking for old...

Thanks Steve, i have updated the code as per your suggestion....please see below

create table logger

( Body varchar(500)

, ConfigSetID_Ins varchar(100)

, Subject varchar(104)

, Name varchar(200)

, Version varchar(100)

, [Timestamp] varchar(100)

)

ALTER TRIGGER [dbo].[ConfigTrigger]

ON [dbo].[ConfigSet]

AFTER...

Lowell, tried your suggestion...added convert but still it isnt working.....

Steve, i will create the table for security, but first i need to get this thing work....then i can create table...

Hi Steve, i like your idea....i will do that...please see new code...its working partially only if i put column ConfigSetID in @body...but if i add Name,Version and Timestamp in @body......