I would suggest getting a seperate server or at least creating a new instance where you can copy your data to nightly for reporting purposes....

Hmmm...well if it works cool!

Thanks for the tip Greg...Looking @ this data (from DBCC log()) I don't really see anything useful that tells me whats going on.

Is there some way to translate the...

Sanjeev,

Only you can solve your problem by learning SQL. This isn't a place to get others to do your work for you. There are tons of great resources on this...

Thanks guys...we do fall under SOX regulation but do not have any auditing or monitoring software in place. Any suggestions on a good solution for this?

Greg,

I tried updating my sp_SearchText with your query above but am getting some interesting errors. Any idea's?

declare

@search nvarchar(50)

set @search = 'insert'

drop table #results

create table #results (

[Database] nvarchar(128),

[Schema] nvarchar(128),

[Name] nvarchar(128),

[Type] nvarchar(20),

[Created]...

Haven't tested it but it looks like you may have some issues trying to run this in a 2005 environment. I know xp_cmdshell is turned off by default and would...

I don't think this is possible, has something to do w/ how EM stores the connections I believe. Sorry...

Here's the code for the sp_SearchText

if object_id('sp_SearchText') is not null

drop proc sp_SearchText

GO

-- exec sp_SearchText 'EIS'

create proc sp_SearchText

@search nvarchar(1000)

as

create table #results (

[Database] nvarchar(128),

[Schema] nvarchar(128),

[Name] nvarchar(128),

[Type] nvarchar(20),

[Created] datetime,

[Modified] datetime

)

declare @db...

Ooops...forgot the schema!

I was joking B-)

why?

If the nightly extract contains all the information you need in the table rather then writing proc's for applying all the changes (Insert, Update, Delete) just wipe out the table...

Sure...you need to make sure you have a linked server setup and permissions but that should work, just fix the syntax:

insert into [DMO1\DMO].Employees.Employee

select * from Employee where empid='729'

Some of my favorite ones are the ones that say "5+ years SQL 2005 experience"...gotta love that.

I agree w/ your point about the hybrid roles, in almost every company I...