Many thanks Stan for posting this.

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...

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...

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...

Hammad khan (1/7/2008)

---

Hi All,

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...

KevinBrenn (1/8/2008)

---

Now how did that happen in any case here it is...

Now how did that happen in any case here it is again

http://www.microsoft.com/technet/prodtechnol/windowsserver2003/technologies/security/tkerberr.mspx

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.

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...

Unless you plan to...

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"

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 Brennan M.Sc,...

Dean Jones (1/3/2008)

---

Hi All,

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...

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 can use...

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