If I remember it right you have to configure your SQL2000 Server as Distributor. Also when you upgrade your servers or install SP's the distributor has to be done first....

As stated before, the agent and the sqlservice use a domain user account. Built-in Administrators have been removed, but the account in question is added with sysadmin rights (otherwise the...

I am sysadmin (as well in NT as in SQL)and A certificate authority isn't involved either, after all it's just a test server.

As I wrote before I'm able to...

Jpipes, thanks for your reaction, but I don't think that's the issue here. I tried it remotely and logged on locally. At least after restarting the machine I would expect...

Did you check if there is a system created index on the computed column. Query sysindexes for any indexes with a name like "_WA_sys_". You won't see them...

I suppose you're table is pretty big. What happens is that while EM retrieves all your records it puts the table in so-called firehose mode. This means that you already...

Though I'm sure there are plenty of other scripts out there check out this article

http://www.sqlservercentral.com/columnists/achigrik/udfexamples.asp

It contains several datetime related functions incl. one to calculate workdays.

I don't think it's possible to make a snapshot of just the new table unless you create a separate publication.

What I usually do is copy the new table manually to...

This should work:

CREATE PROCEDURE dbo.spRef_GetCertifications

(

@activesOnly bit

)

AS

SELECT ID, Name, IsActive, SubmittedOnGMT

FROM Certification

WHERE IsActive = @activesOnly

ORDER BY Name ASC

Basically what the function does is running a programm refiner and the returns the output as a string value. If you wanna know more about Refiner check this site:

http://www.afd.co.uk/pcpman/Refiner/

...

All you need to do is edit the log reader agent profile in Replication Monitor, See also BOL under "Log Reader Agent Profile"

In your case it I would say yes, set up a mail profile which corresponds to an Exchange mailbox. The reason why the MS article doesn't say so explicitly is...

I once found this extended procedure which might be usefull for you. It's called xp_dialup or so and opens and closes a dial up connection if needed. I must admit...

The proble is that SQL Server does a Integer division. Rewrite it as SET @test-2 = 1 - (((2302 - 2000)/2302.0) * 100) and you get 12.119....

quote:

---

The process could not query row metadata at the 'Subscriber'.

---

First of all I...