Hi Jens,

about the "orphaned" agent you can try running the "distribution clean up" agent under Miscelleanous agents. This might solve the issue but personally I think the you have to manually...

Hmmm, I hope I get this right. The reason why you got the message the subscription is invalid I suppose has something to do that you replced the server. Even...

I'm not sure if I understand your question correct but this might help:

Select o.name as tablename, i.name as Indexname from sysobjects o join sysindexes i

ON o.id =i.id

M

What do you mean that your SQLMail is running slow. Do you run a query in xp_sendmail which is slow or does the delivery of the mail takes a log...

Hello Jack,

I've done it in the past and I will attach a script which shows the basic techniques. Anyhow be aware of a couple of drawbacks.

First of all most...

I and several others experienced the same. Although I couldn't find any official statement from Microsoft, it seems that SQL2K can not work together with Outlook 2003. Try Outlook 2002...

Solved the problem, It must be "sp_grantlogin 'NT Authority\system' "

Markus

You need to create a custom snapshot agent profile. Right click on the snapshot agent, select profile and when create your own.

Hope this helps

M

You might have a look at this: http://www.sqlservercentral.com/columnists/jgama/sqlserverpasswordauditing.asp

M

First of all I have to agree, schema changes in a replicated table can be very unpleasant and under SQL 7.0 dropping all subscriptions, remove the publication and when change...

In fact, the "correct" answer isn't even possible without first taking another Tlog backup.

First of all you have to change your service account from "local system"to a user account. The reason is that the local system account cannot access any resources outside the...

I don't agree with the whitepaper. Mike Hotek used to have an article on his site http://www.mssqlserver.com which described exactly this case. Unfortunately it seems the article is...

Not sure if I can be of any help, but I experienced about the same problem about a year ago. Suddenly, out of the blue the merge agent only updated...

Have a look at mssqlxpress. It's a bit like QA with some additional features like VSS integration.

http://www.xpressapps.com/