Viewing 15 posts - 331 through 345 (of 1,655 total)
dkhattar (5/21/2009)
Hi,I want to know what gurus of replication think wrt having Single Distribution DB or multiple distribution dbs for a single instance of sql server.
Deepak
Each publication can only have...
May 25, 2009 at 3:36 am
Did you configure RS after the setup ?
If not run "Reporting Services Configuration" from the start menu or RSConfigTool.exe through explorer. TYhe configuration tool will then create the virtual directories...
May 25, 2009 at 2:04 am
As Florian already said, I don't think the code you posted is causing the problem.
The procedure as posted works fine on my system.
But just a thought, could it be...
May 20, 2009 at 6:14 am
Are you sure the datatype is varchar and not nvarchar? A nvarchar in SQL 2000 is limited to about 4000 characters.
What's the datatype for the parameter in the stored procedure?
May 20, 2009 at 3:25 am
There are a lot of things SQL2005 logs to the errorlog which you won't find in SQL 2000. I don't really understand what you want. 2005 is a different product...
May 20, 2009 at 2:09 am
About how to find out which queries cause the High CPU usage have a look at this post from last week:
http://www.sqlservercentral.com/Forums/Topic716821-360-1.aspx#bm716925
May 20, 2009 at 1:07 am
jason (5/19/2009)
So what method you suggested ?? and is the best for my situation
My first thought would be merge replication, but to be honest you didn't provide a lot of...
May 19, 2009 at 10:24 am
ppcx (5/18/2009)
May 19, 2009 at 8:22 am
Not sure if I understand you correctly but this is what I make of it.
You have a backup job which reports a status of failed even though the .bak file...
May 19, 2009 at 7:23 am
In case you don't wanna learn C# or like me, just don't find the time to do it, there are two very good articles about reading from and writing...
May 19, 2009 at 6:54 am
The problem with setting up replication is that it often requires you to make changes to your database design. Transactional replication requires a primary key on all tables. Also peer-to-peer...
May 19, 2009 at 6:35 am
Check this article:
http://support.microsoft.com/kb/891984
It's not directly related to replication it it should help you to fix the problems.
May 19, 2009 at 6:27 am
There is a very good reason they every subscriber has it's own identity range. In most cases the Identity column is also a primary key, which must be unique.
If...
May 19, 2009 at 3:36 am
Rem (5/18/2009)
Now my version is:
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) ...
May 18, 2009 at 12:35 pm
shanila_minnu (5/15/2009)
configuring SQl Agent means.??????i didnt get you
Did you look at the link I added????
May 15, 2009 at 7:49 am
Viewing 15 posts - 331 through 345 (of 1,655 total)