How would you turn on C2-Level auditing?

RE: Scripting databases

Parker77, I suspect you want to automate the process rather than relying on the interactive wizard. Is that right? I don't have a "script the lot" example, but a starting point may be Umachandar Jayachandran's example at http://www.umachandar.com/technical/SQL70Scripts/UtilitySPs/Main17.htm

RE: Locking problem

Could you not just rsTemp.Close after reading the max value? Yes - I have seen the ADO objects keep information locked beyond the original intent. We had several lockups similar to this one. In our situation, we could use the NOLOCK because we were not updating that information. Guarddata-

RE: General Network Errors

All the clients are set to TCP. Its also very intermittent. For the vast majority of the time the connections are fine. Rolf

RE: Renaming a Server on SQL 2000

Yes that should work fine. There is a bug with this, if you are using multi protocol you must remove them and add it back.

RE: Deleting a subscriber

Do you need to have all the changes made at the subscriber to be replicated to your publisher? With merge replication, you will have the same db in both servers, even when both are making changes to the db. But if you need to have the same db, and the subscriber to start only, then […]

RE: Killing users before restore

Make sure you are not in that database in the QA

RE: Who should manage/support Analysis Services?

THANK YOU....I actually am the DBA but have not had any hands on the Analysis Services and I welcome any information. Thanks again. BABs

RE: Who should manage/support Analysis Services?

Hey BABs, As far as migrating from DEV to PROD, there's a few options. You could archive the database on the dev server, and then restore it to the Prod server. This works well, but something that really annoys me is that you can't rename your data source after doing this, so if your machines […]

RE: Query scheduling!!!

I was thinking more along the lines of using triggers to fire off the queries after an INSERT. Would this work?