Viewing 15 posts - 706 through 720 (of 1,098 total)
Ok, when I have time, I will try creating the views. I don't know if it is the best solution, so I will have to test it. Is has some...
April 7, 2003 at 6:46 am
You should have any problems in the upgrade. But it is always more secure to backup your SQL Server 7 system and user databases before upgrading.
After upgrading to may need...
April 4, 2003 at 2:46 pm
We have 4 processor and most of the time the first one is giving top pics while the others are still low.
But the overall cpu usage remains low. It don't...
April 4, 2003 at 2:36 pm
To rebuild an index you can execute DBCC DBREINDEX from QA. Check BOL for more info.
April 4, 2003 at 2:25 pm
With EM, Right Click over Replication, Publications and Generate SQL Script.
This will ask for a .txt file to save the script. Then open the file and you will see...
April 4, 2003 at 11:49 am
If your users can't ping your SQL server and can ping the IP adress, then maybe you should add an alias from the client network utility of SQL on every...
April 4, 2003 at 11:00 am
Restoring the distribution DB is not so complicated if you keep the backups in syncro with the publisher db. I use the sync with backup option.
I have to do it...
April 4, 2003 at 8:57 am
Are you getting any errors? It looks good to my. You can also try:
select a.cid,b.name
from taba a
inner join tabb b
on a.cid=b.cid
LEFT OUTER JOIN tabc c
ON a.cid =...
April 4, 2003 at 8:36 am
You can change in the jobs of the merge agent the values for DistributorPassword, PublisherPassword and SubscriberPassword.
Or you can create a new login and change the login info and also...
April 4, 2003 at 8:30 am
OK, maybe I din't tell my situation. The subcribers pull the subscription that I need to filter. So I subscribe them to my central publication and every subscriber manage the...
April 4, 2003 at 8:10 am
Remember that everything that EM does, you can do it with T-SQL statements. The best way to know how to programatically enable a subscription is create the subscription with EM,...
April 4, 2003 at 7:48 am
Maybe you don't have permissions to access the network adress.
you can also execute:
master.dbo.cmdshell 'DIR \\NetPath\C$'
to check that is available.
Check the login account you use to run SQL Server. That account...
April 4, 2003 at 7:33 am
Yes, unless SQL Server displays a message that you have exceeded the number of available locks, I wouldn't change it. Maybe SQL manages to replicate to the distribution the conflicting...
April 4, 2003 at 7:16 am
Yes I know. Like it is now it is working fine. But in fact the articles that would need to filter are almost 10, and now I have 74 subscribers,...
April 4, 2003 at 7:03 am
This is a new installed instance? Or is old and the problem started to show now? If so, did you make any changes to the server?
April 4, 2003 at 5:49 am
Viewing 15 posts - 706 through 720 (of 1,098 total)