Viewing 15 posts - 31 through 45 (of 48 total)
You can either do it through the services console in windows or under the SQL Agent properties in Enterprise Mangager. Also you might have already done this but you will...
November 13, 2006 at 9:25 pm
Have you set the SQL Agent to run under the same domain account that your mail profile belongs to?
November 11, 2006 at 7:25 pm
I also am using Red-Gate SQL Backup and have been very happy with it. I currently have over 50 SQL2000 and SQL2005 instances using it and it has been a great asset. ...
November 11, 2006 at 6:44 pm
This is one of many reasons why I remove group Builtin Administrators group. If you have a DBA you don't need your Sys Admin with that level of access.
November 9, 2006 at 5:37 am
I have an enterprise application that I battle a lot of deadlocking with. I have always seen that when I enable the trace flags for deadlock info that they disable...
November 9, 2006 at 5:24 am
Have you attempted to attach that database only using the data file and letting sql server recreate the log file?
November 6, 2006 at 8:46 am
The only way I could see you being able to do this is if you create a linked server to this Non-MSSQL database. As John stated before this is not...
October 18, 2006 at 8:10 am
Also, I don't remember for sure but you might have to restart the instance to make the change take affect. You will just have to try and see.
June 15, 2006 at 2:32 pm
I am positive that you can. I have done it many times. Below is the content from BOL:
ALTER DATABASE database
{ ADD FILE < filespec > [ ,...n ] [...
June 15, 2006 at 2:30 pm
When restoring though the GUI it will not allow you to change the logical file name. However, you can change this after the fact by issuing an ALTER DATABASE command. ...
June 15, 2006 at 6:43 am
Check to see if that DB server has rights to relay to the exchange server.
January 26, 2006 at 1:07 pm
I noticed that enterprise edition was specified for the O/S but not for SQL Server. Was this just left out or is it only running standard edition?
November 9, 2005 at 9:50 am
I want to thank everyone who responded. The microsoft article referenced in one of today's posts was exactly what I was looking for. It is plain to see that my...
August 26, 2005 at 8:29 am
It must be used to manage some kind of overhead. Thanks for you input.
August 19, 2005 at 10:59 am
This is a dedicated server. There are no other applications running. The memory settings are set for dynamic control with no maximum limitation. I really appreciate your input. Do you...
August 19, 2005 at 8:30 am
Viewing 15 posts - 31 through 45 (of 48 total)