Viewing 15 posts - 541 through 555 (of 966 total)
I am running SQL Server 2005 SP4 Standard and have sysadmin right. I have created a maintenance plan but it is not visible under the Maintenance Plans folder under Management....
November 28, 2012 at 6:03 am
SQL does not need to be restarted for memory changes to take effect. Once you set it you should see it show up under running values.
Are you on a 64-bit...
November 28, 2012 at 5:57 am
Can you see the table from a linked server within SSMS?
November 28, 2012 at 5:24 am
Also, if you could post the error from the SQL error log that would be helpful.
November 28, 2012 at 4:09 am
If automatic failover is required, then you must have a witness. Otherwise no, it is not required.
November 23, 2012 at 4:19 am
It is possible that your backup is corrupt and if that is the case then like others have pointed out you will not be able to restore from the corrupt...
November 21, 2012 at 4:33 am
What about using perfmon to check CPU utilization and send an e-mail alert if it is over a set threshold? You could even instead of having perfmon send an e-mail...
November 21, 2012 at 4:22 am
Not that I have seen, but then again I do not see it THAT often. Curious, is the version of SSMS the same version/service pack as the SQL instance you...
November 19, 2012 at 4:58 am
DCEXEC is used for the Management Data Warehouse as a part of the collector sets that actually grabs performance metrics and pumps it to a management data warehouse for reporting.
Unfortunately...
November 19, 2012 at 3:47 am
Has this always happened or just recently started? I have seem COM errors popup in SSMS before and the only work-around I have found is to close and reopen SSMS...
November 19, 2012 at 3:28 am
Yeah, exactly what Gail said. You should have a backup strategy for all your databases in production. How far back your backups should be based on your requirements for how...
November 18, 2012 at 12:17 pm
Instead of creating your own function to send e-mails, have you checked out the send-mailmessage cmdlet? You can send out your message body as html.
November 18, 2012 at 3:27 am
What connection does sp_who2 show is connecting to the SSRS database?
November 18, 2012 at 3:18 am
First and foremost before even considering any changes to the current schema if it were me I would work to identify the current environment a little more. Specifically the potential...
November 18, 2012 at 2:59 am
You can try enabling trace flag 1222 to capture the deadlock information. Then you can analyze the deadlock further to see what is causing it.
November 14, 2012 at 3:59 am
Viewing 15 posts - 541 through 555 (of 966 total)