You could probably specify all 8 in a single Exec SQL task.

CEWII

What do they have already? What are they looking for? there are MANY things to trace, but only so much hardware to spare..

We don't usually have PerfMon running...

I think the having the rights discussion is often silly. I was a developer that had rights to very nearly every prod server, and rarely ever used them, and...

Lynn,

You don't happen to have the Priority Boost set to ON do you? I have seen that when a server is busy enough and especially when that is set...

You are part of a publically traded company right? Or a wholly-owned subsidiary of one? Otherwise SOX is an optional.. Some companies have chosen to act like...

Also, in reference to that KB article, you might just want to do it anyway..

CEWII

Do any of the ones that fail happen to be restored from somewhere else? Are you having any other securiy problems on those databases? Can you setup proxy...

I'm in favor of a single table with a check constraint. I don't see any reason to muddy the waters with any additional tables. And you can get...

You can build out a connection string using OPENROWSET but I would shy away from that before I asked other questions. Does the data that you need required to...

Irfan-358189 (10/6/2009)

---

Hi,

Is there any body who can give me simple nice scripts or any good tips for Proactively monitoring and maintaining production databases.

I know i can use sp_who2,sysprocesses,profiler,performance monitor but...

Mark_Pratt (10/6/2009)

---

Animal Magic (10/6/2009)

Thats what i used to think, but it isnt true. i read an interesting article a while back which said that for server with less than...

Jack Corbett (10/6/2009)

---

Cool, I haven't had time to try it so I didn't know and it didn't sound like you had tried it in a Logon Trigger either. It...

It does show up.. I have a loggin infrastructure I am going to be releasing soon that uses it..

CEWII

Since your question is unclear I am going to offer a solution that may or may not answer it..

Here is the code for an activeX script that will extract out...

You might try

SELECT APP_NAME()

But do keep in mind the app sets that so it is possible to masquerade as another app..

CEWII