Viewing 15 posts - 556 through 570 (of 575 total)
Try this.
DECLARE @KeyWords VARCHAR(1000)
DECLARE @NewKeyWOrds VARCHAR(1000)
DECLARE @Name VARCHAR(100)
SELECT @KeyWords = (SELECT KeyWords FROM Table WHERE Name = @Name)
UPDATE TABLE SET KeyWords = @KeyWords + @NewKeyWords
WHERE Name = @Name
February 10, 2004 at 5:31 pm
Also known as UNICODE DataType!
Look in BOL for more info!
February 10, 2004 at 5:25 pm
You will have to test it for yourself!
I have up to 10 joins in some stored procedures with no performance problems or concurrency issues! However, I would not recommend 10...
February 10, 2004 at 5:24 pm
Looks like you will have to do what the Readme file sais! There is no alternative other than moving the Ditsribution Database to the local server!
February 10, 2004 at 5:17 pm
Your question doesn't make sense!
What exactly are you trying to achieve?
Do you want the ORACLE Database to Replicated to SQL Server? OR Vice Versa?
February 10, 2004 at 5:14 pm
Don't of any built in SP's however, you could write one yourself!
February 10, 2004 at 5:11 pm
Ok.....You are learning a bit more about SQL Server Replication! In future you should study up on it before installing, configuring and removing SQL Server Replication as it is a...
February 10, 2004 at 5:06 pm
You need to disable that Database as been Published!
February 9, 2004 at 11:04 pm
You can also place the query in a DTS Package and export it to Excel.
February 9, 2004 at 11:00 pm
The correct process to remove Replication is....
(A) Drop Subscriptions
(B) Drop Publications
(C) Disable the Publishing Database
Did you do it in this order?
February 9, 2004 at 6:11 pm
What makes you thnk that this has anyting to do with Replication?
Can you tell me how you dropped replication?
February 9, 2004 at 4:21 pm
Are you talking about the SQLServerAgent Service?
Then try NET STOP SQLSERVERAGENT in a Command Prompt window or a batch file!
February 8, 2004 at 8:22 pm
If rows do not match between Publisher and Subscriber then the Subscribers are most likely out of sync!
Lets start from the beginning.
(A) Did this error occur immediately after installing and...
February 8, 2004 at 6:21 pm
No problem. Thanks.
Do you know any good books where I can improve my SUBQUERY skills?
February 5, 2004 at 5:46 pm
Viewing 15 posts - 556 through 570 (of 575 total)