Thanks! That was what I was looking for!

I don't exactly understand. Perhaps I was not clear.

Windows XP on client machines comes with SQL Server ODBC Driver for 2000.

Soon clients will have to connect to...

I was using the same account for the SQL Server Agent and the SQL Server services. I granted them Local Admin privileges and this did not resolve the issue.

I figured it out.

I needed to include RPC:completed as an event.

exec sp_trace_setevent @TraceID, 10, 1, @on --TextData

exec sp_trace_setevent @TraceID, 10, 3, @on -- DatabaseID

exec sp_trace_setevent @TraceID, 10, 6, @on-- NTUserName

exec...

Actually, I am not having problems capturing the inserts/updates/deletes when performed in Query Analyzer. I am not able to capture them when performed within SQL Server Enterprise Manager. ...

Whenever I have made a connection to Oracle through SQL Server I have installed the Oracle client on the SQL server box.

I'm not sure you can connect to Oracle...

Are you able to connect to the SQL Server instance through Query Analyzer or are you not able to connect to it at all?

You may want to ask the DBA...

We've been suggesting that we increase the use of telecommuting -but its not going to happen. We can telecommute when we need to stay home for something (repairman, etc)...

Funny, I thought I had tried disabling it and it hadn't working. It work this time!

Event Logs just said:

User : NT AUTHORITY\SYSTEM

The SQL Server (MSSQLSERVER) service was successfully sent...

My blocking issue was actually expected by the application. Because they were trying to update the database with almost a days worth of data and communications channels hadn't properly...

There are a bunch of CXPacket waittypes and then the waittypes that are blocked are LATCH_EX and PAGEIOLATCH_UP. I found some postings that it may have to do with...

Thanks. I tried dropping and recreating the maintenance plan and now the integrity checks job works. But optimizations job rebooted the server. 🙁 Off to microsoft.

Never...

Thanks for sharing this with us. I had developed something pretty complicated to monitor my database instances. Not only have I now gotten more experience with SSIS, but...

Tony Mungor (1/7/2008)

---

If you have not, try setting the default value for the SVR_Conn variable to (local) or to your server name \ instance name . That worked for...

I am getting a similar error as the previous poster. It "Previews" under the QASRV.SQL_Overview connection manager, but not under MultiServer. When I look back at the MultiServer...