Viewing 15 posts - 946 through 960 (of 964 total)
Not sure, it looks okay. What happens if you run the same command, but specify -E before the -S parameter?
November 4, 2009 at 3:13 pm
I agree. It looks like someone stopped the service manually. Is there an event in the system log that states when the log was turned off? You may be able...
November 4, 2009 at 3:03 pm
You are correct that you should usually go for the Principle of Least Priviledge. However, there are different requirements for different scenarios. If you feel though that you should be...
November 4, 2009 at 1:43 pm
...
DENY EXECUTE ON [dbo].[sp_start_job]
TO TargetServersRole
DENY EXECUTE ON [dbo].[sp_stop_job]
TO TargetServersRole
...
You say that the users are trying to start and stop jobs, but according to the permission set you just posted about...
November 4, 2009 at 1:28 pm
Does the Dell SAN have any software the server uses to connect to it? For instance I know that NetApp tends to have Windows servers use SnapDrive to connect to...
November 3, 2009 at 2:42 pm
Is your instance in mixed mode for security? Because if not, you will be able to add SQL logins all day long and still not be able to connect.
November 3, 2009 at 10:18 am
I know that you said that port 1433 is not being blocked on the 2008 machine, but have you tried taking the firewall out of the equation altogether? Can you...
November 2, 2009 at 5:26 pm
Try running sqlcmd with the -w 40 paramater. That should wrap your text for you. You could also send the sqlcmd output to a text file. For more information, take...
November 2, 2009 at 4:45 pm
Is there any issue with the location the model db log file was moved to? Drive ran out of free space? Permissions set to where the SQL service account does...
November 2, 2009 at 4:31 pm
How many VMs are on the physical machine? I remember one thing I read a while back was that Microsoft does not recomment setting CPU affinity on a VM because...
November 2, 2009 at 4:14 pm
I think each scenario is different, but as long as the servers in the cluster have the same physical elements, i.e. they have the same amount of CPUs I do...
November 2, 2009 at 3:17 pm
thanks for the script
those error messages are very long
any way to break it out into say 40 charter lines so that it wraps and i can read it ?
You can...
November 2, 2009 at 3:00 pm
I think the uninstall that you may be thinking of is when OS patches, hotfixes and service packs get installed, not SQL service packs. I agree with others here, you...
November 2, 2009 at 2:42 pm
What happens when you try connecting using one of the management tools like SSMS or sqlcmd?
November 1, 2009 at 2:34 pm
Viewing 15 posts - 946 through 960 (of 964 total)