Viewing 15 posts - 1 through 15 (of 30 total)
Many thanks Stan for posting this.
March 6, 2016 at 11:02 am
In you article you state that:
"If is a requirement for point-in-time recovery and minimal or no data loss in the case of a disaster, then the database should be in...
November 2, 2008 at 4:04 am
But perhaps you should also ponder ... should all local admins( of your server) be or have the same rights as the DBA given that by default local admins are...
February 12, 2008 at 2:39 am
BOL indicates that SQL Server Reporting Services itself is not Microsoft cluster aware, so you cant install it as a cluster resource.
So what you have to do is create...
January 10, 2008 at 5:28 am
Hammad khan (1/7/2008)
Temp DB data file is huge on one of our Production Server.I try to shrink the database
as well as Shrinkfile .But no lock.There is no open transaction...
January 9, 2008 at 4:29 am
KevinBrenn (1/8/2008)
Sean (1/8/2008)
Kevin, Could you please please copy the link again, one in previous post is not working. Thanks. Sean
Now how did that happen in any case here it is...
January 8, 2008 at 3:09 pm
Sean (1/8/2008)
Kevin, Could you please please copy the link again, one in previuos post is not working. Thanks. Sean
Now how did that happen in any case here it is again
January 8, 2008 at 2:58 pm
Try following the steps in this article
http://www.microsoft.com/technet/pro.../tkerberr.mspx
It has instructions on how to identify the problem and how to fix it.
January 8, 2008 at 12:21 pm
Hi it may be that the account used by you sql server agent is a local account rather than a domain account and/or does not have enough privilages to connect...
January 7, 2008 at 2:55 am
Kishore.P (1/4/2008)
use DBCC Updateusage, DBCC PROCCACHE, DBCC SHRINKDATABASE command along with DBCC Shrinkfile get better performance as well as good for backup also. Just try it.
Unless you plan to...
January 4, 2008 at 6:21 am
According to tecnet you would have to include the full path in order for it to open this script see.
http://technet.microsoft.com/en-us/library/ms162825.aspx
e.g
sqlwb "C:\Documents and Settings\username\My Documents\SQL Server Management Studio Projects\FinanceScripts\FinanceScripts\MonthEndQuery.sql"
January 4, 2008 at 5:56 am
SRB (1/3/2008)
SP4? He's running SQL 2005.
Yes this feature was introduced with SQL 2000 Sp4 refer to
http://support.microsoft.com/kb/897284
I expect that they have not disabled this feature on 2005...:D
Kevin...
January 3, 2008 at 5:44 am
Dean Jones (1/3/2008)
Thanks for the replies.
Below is the detail of the dump log file you asked for
•2007-12-23 10:37:13.02 spid2s SQL Server has encountered 1...
January 3, 2008 at 4:57 am
Hi if you visit the following
http://support.microsoft.com/kb/913089
you can read all about obtaining the latest service packs for sql server 2005 (including express)
however if you are in a hurry you...
January 2, 2008 at 9:39 am
Here is a link that will explain the use of both the inserted and deleted tables
http://msdn2.microsoft.com/en-us/library/ms191300.aspx
If you need more help let me know
Kevin Brennan M.Sc MCDBA, MCSE, MCP+I
January 2, 2008 at 4:54 am
Viewing 15 posts - 1 through 15 (of 30 total)