Viewing 15 posts - 1,546 through 1,560 (of 1,654 total)
sp_repladdcolumn and sp_repldropcolumn only work on SQL 2000, plus all subscribers must be SQL 200 as well.
July 30, 2003 at 6:06 am
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....
July 29, 2003 at 3:08 am
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...
July 29, 2003 at 3:06 am
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...
July 28, 2003 at 7:47 am
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...
July 28, 2003 at 7:24 am
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...
July 28, 2003 at 1:31 am
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...
July 25, 2003 at 2:10 am
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.
July 24, 2003 at 3:03 am
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...
July 24, 2003 at 2:56 am
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
July 22, 2003 at 5:34 am
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:
July 22, 2003 at 3:55 am
All you need to do is edit the log reader agent profile in Replication Monitor, See also BOL under "Log Reader Agent Profile"
July 22, 2003 at 3:45 am
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...
July 22, 2003 at 3:35 am
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...
July 15, 2003 at 12:06 am
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....
July 4, 2003 at 10:30 am
Viewing 15 posts - 1,546 through 1,560 (of 1,654 total)