Which version of SQL Server do you run, which Service Pack. I've seen my share of replication problems but never experienced orphaned agents. Do you allow anonymous subscriptions? What is...

I'm a member of PASS, although not very active during the last couple of months. What I found really worth the money are the annnual conferences (PASS Summit). No better...

DTS always looks for files on the local machine where it is initiated. So when runnning through a schedule it will look on the server. If you run it through...

HI Steve, I haven't done any benchmarking myself but I remember an article telling that hyperthreading gives you about 1.2 times the performance of a single CPU. Unfortunately I can't...

It's in the recistry under

HKey_Local_Machine>Software>Microsoft>Microsoft SQL Server>80>Registration

Sorry no answer yet, but cold you post your function and the way you want to run it. I assume with

quote:

---

I...

Sorry no answer yet, but cold you post your function and the way you want to runit. I assume with

quote:

---

I again...

For a start check out this thread:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=1635&FORUM_ID=61&CAT_ID=5&Topic_Title=SQL+Server+VS%2E+Oracle&Forum_Title=Anything+that+is+NOT+about+SQL%21

From what you tell it sounds very much like the server accepts Windows authentication only. The sa account is no Windows NT account and therefore can't log on if you...

As far as I remember you're not allowed to create triggers on system tables. So are you sure the trigger is created succesfully on sysdatabases?

Just wanna add one more link

http://www.nextgenss.com

Sorry mate, editing the t-log is not possible (thanks god). My usual way of fixing such a situation would be make a t-log backup and do restore with stopat just...

First of all if you have a recent backup of your msdb which does not contain the error it might be the best to restore that backup.

In the case that...