In our shop everyone gets their own individual windows login to connect to the domain and that login ( and the groups it belongs to) is used to control their...

a possibility is to create a SQL authenticated login (it has to be SQL authenticated) and instruct the BI developers to use that account when working with their Agent jobs...

the alert will continue to fire until something is done to reduce the amount of data, thats the expected behaviour, I don't believe that can be changed.

you can reset the...

its simply a count of the number of times the event that fires the alert has occurred. As you have a response delay not every occurrence fires the alert

If your log file is increasing in size despite taking log backups, perhaps you need to increase the frequency of the log backups.

Reindex jobs are also a frequent cause of...

sorry, SP1 for SQL, 10.50.1600 is RTM, applying SP1 will bring you up to 10.50.2500

the service pack 1 referred to in your post is for the windows OS.

presuming you haven't already you should apply SP1, rolling out through dev and test first.

this is a bug, if you are in fact using SQL2008R2 it was fixed in I think CU4 else it is definitely fixed in SP1. there must also be a...

If what you want to do is monitor SQL issued against the databases and by whom you can use SQL profiler, but run it as a server side trace

mysteryjimbo,

unfortunately having the passive node paused did not work for me. It caused SP1 to fail the 'is node clustered' check as it complained that either the cluster resource was...

This is probably the link Jeff is thinking of.

Check the URLs it links to as well.

With logs the important thing to be aware of the size and number of VLFS...

the transfer login task disables the login and assigns a random password on the destination, so unless you know all the passwords its pretty useless.

You can tell it to keep...

no thanks. despite your moral high tone you are just looking for confrontation. It would be a waste of time.

good stuff, always good to have verification. cheers

How about the thread? 🙂

opc, you are still insulting me, I resent and refute your last post.

'nuff said.