Viewing 15 posts - 1,036 through 1,050 (of 4,745 total)
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...
May 6, 2012 at 1:38 pm
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...
May 5, 2012 at 1:12 pm
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...
May 4, 2012 at 6:08 am
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
May 3, 2012 at 4:14 pm
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...
May 2, 2012 at 1:17 pm
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.
May 2, 2012 at 9:28 am
presuming you haven't already you should apply SP1, rolling out through dev and test first.
May 2, 2012 at 8:50 am
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...
May 2, 2012 at 8:40 am
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
April 25, 2012 at 2:50 pm
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...
April 24, 2012 at 4:53 am
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...
April 23, 2012 at 8:35 am
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...
April 19, 2012 at 9:29 am
no thanks. despite your moral high tone you are just looking for confrontation. It would be a waste of time.
April 18, 2012 at 10:55 am
good stuff, always good to have verification. cheers
April 18, 2012 at 10:25 am
How about the thread? 🙂
opc, you are still insulting me, I resent and refute your last post.
'nuff said.
April 18, 2012 at 10:00 am
Viewing 15 posts - 1,036 through 1,050 (of 4,745 total)