Viewing 15 posts - 886 through 900 (of 964 total)
By default the agent job runs under the account that created the job, not the agent account. If you go into the properties of the job, does it show the...
November 23, 2009 at 1:34 pm
Sure. Run this to set the security to mixed mode:
USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO
You can then run this to verify what mode the security is set at:
EXEC...
November 23, 2009 at 1:32 pm
Sorry, I hit a button on accident and my first post went early.
Open up Enterprise Manager
Navigate to the instance that you are troubleshooting
Right-click the instance name and go to Properties
Click...
November 22, 2009 at 10:42 pm
Open up Enterprise Manager
Navigate to the instance that you are troubleshooting
Right-click the instance name and go to Properties
Click the Security tab
In the Authentication section, ensure that "SQL"
November 22, 2009 at 10:39 pm
Another option is if the application is using SSRS to display the reports, then you should be able to see the query used in the rdl file. There will be...
November 20, 2009 at 4:53 pm
Is this merge replication? I have seen a similar error in SQL 2000 and we are usually able to restart the replication agent and it comes up and the transactions...
November 20, 2009 at 4:37 pm
There is not a built-in Windows command that will allow you to send an e-mail. Not automatically anyway. What you could do though is if you are running a command...
November 20, 2009 at 4:23 pm
In the Jobs tab of Enterprise Manager or the Job Activity Monitor of SSMS, what jobs does it show actively running at the time you were experiencing the high CPU...
November 20, 2009 at 4:17 pm
Does your machine host any scripts that could have been running at that time? If it happens again can you check in Activity Monitor the user logged against that activity?...
November 18, 2009 at 3:26 pm
I do not believe their is a way in SQL 2005/2008 to turn it off, but I could be wrong. Is having the object owner causing a problem?
November 18, 2009 at 3:15 pm
Are you sure it is the database server acting slowly and not the application or OS hosting the app itself? You can run a profile trace to find out what's...
November 18, 2009 at 2:20 pm
The installer for the sp tells you what files need to be closed in order to prevent a reboot from being needed. However, from what I remember, SQL services do...
November 18, 2009 at 2:16 pm
I have not heard of a set limit for the number of jobs that an instance can have or run. I would imagine the any limit you hit will more...
November 18, 2009 at 2:10 pm
That sounds strange. Can you manually type in the path to the location on the SAN where you want to backup the databases to?
Does the account you're creating the maint...
November 18, 2009 at 1:57 pm
Just remember that if you are adding a SQL login instead of a Windows login, the database instance needs to be in Mixed Mode security.
November 18, 2009 at 1:53 pm
Viewing 15 posts - 886 through 900 (of 964 total)