Well none of the files show the blocked processes. how about giving the output of a sp_who2 when the problem is occurring.

From looking at the other files a couple...

Write a SSIS package that imports the excel file in daily or hourly. Hopefully the excel file is on a reachable file share.

Are you sure the instance is running on port 1433? Verify in the sql server logs.

Did you try servername, port# or ip, port# ? ie. apollo1, 1433.

What...

Looking at a profile trace today, I did notice under Security Audit is an object called Audit Dbcc event .. Make sure you select show all columns and...

I would just filter by the app account you are wanting to look at, make sure dbname is one of the columns.

Maybe add:

SQl: StmtCompleted and SQL: StmtStarting

SP: StmtCompleted and SQL:...

Good points and explanation. Thanks for clearing that up for me.

GilaMonster (3/2/2010)

SQL won't run checkDB automatically. It's a very CPU and...

Yep Server side trace.. my main concern was the profiler running the C drive out of space. I have not checked lately in the 2008 tools but in the previous...

I would setup a profiler trace.. add additional columns such as hostname,ip,login and then the standard stuff and filter the trace to only pickup that domain admin account and if...

I have seen on occasion where a third party app does something like access the master DB to pull sysinfo out of system tables and the app account required permissions...

You cannot lock out a system admin from the other databases. Your better off solving the root problem which is figuring out what access those 2 application accounts really need...

Ah yes understand what you mean now. sounds like a good solution though some food for thought..

In my example we are using the same table names on...

I am thinking you are saying that you are moving tableAto a history table and then replicating both tables to the subscriber? The only problem I forsee with that is...

Ram,

You are right we are not able to regenerate the snapshot, it would blow away the archived data. I guess your question is have they gotten out of sync? Yes,This...

Here is how we created a reporting environment , right ,wrong or indifferent 🙂

We had a requirement to keep the production db as small as possible for performance reasons as...