Viewing 15 posts - 166 through 180 (of 297 total)
Use the SQL Server Configuration Manager to add / modify any of the SQL service accounts. That will setup the appropriate permissions for the service accounts.
March 30, 2009 at 9:48 am
You need to grant View Server State for Activity Monitor.
March 27, 2009 at 7:24 am
You will need some sort of entitlement scripts for pulling out all those permissions.
March 27, 2009 at 6:52 am
This list is definitely NOT a one size fits all solution. This may work in my environment but may not in yours. Neither is this a comprehensive list.
As you...
March 27, 2009 at 5:38 am
Confidence is paramount, however being truthful about your skillset will help. A smart interviewer can immediately spot when someone is making things up.
March 26, 2009 at 6:57 pm
You need to give them Alter Trace permissions
GRANT ALTER TRACE TO
March 26, 2009 at 6:52 pm
I agree with the need to get senior management buy-in. I recently took over an environment with some of the issues you mentioned and more. I did a detailed analysis...
March 26, 2009 at 6:48 pm
SQL Server creates local groups on the SQL box during installation (Under Computer Management --> Users and Groups --> Groups) as below
Default instance: SQLServerMSSQLUser$ComputerName$MSSQLSERVER
Named instance: SQLServerMSSQLUser$ComputerName$InstanceName
There are groups for Agent,...
March 26, 2009 at 12:23 pm
Isn't your SQL service account part of the default local groups that SQL Server creates during install? If so, it should've had system administrator access to the instance.
March 26, 2009 at 11:53 am
No, the primary database can be mirrored to only one destination database. For the configuration you refer to you will need to use Replication
March 26, 2009 at 10:09 am
The default trace should be able to help you find out if there are file growths (event class 92 and 93) during the data loads.
March 26, 2009 at 8:43 am
Have you tried restarting the SQL services? Before that I would go in to the Agent properties and simply select database mail profile. I've noticed this as an issue when...
March 26, 2009 at 6:53 am
that way would be intrusive and take a while to do, and leave you with one much bigger file, then you have to recreate the files you just deleted.
IMO,...
March 26, 2009 at 6:44 am
One way would be to move all the data to one file remove all the empty data files. Add the new files to the database with the sizes you need...
March 25, 2009 at 2:26 pm
Viewing 15 posts - 166 through 180 (of 297 total)