Viewing 15 posts - 2,491 through 2,505 (of 2,840 total)
Theoretically its possible and it all depends on how big your DB is. You need to have a pretty stable network connection. Preferably on a VPN. It all depends on...
February 2, 2009 at 12:30 pm
My Bad..It is actually termed a Role.
Not group... Stupid me.
February 2, 2009 at 10:49 am
You can create a Group and give Select Permission to the appropriate Tables to that group. After that add the Users to that group. Simple and sweet.
February 2, 2009 at 10:42 am
Do a CheckDb on your Subscriber. See if everything is Ok with your Subscriber DB.
January 30, 2009 at 8:50 am
I will add couple of more steps to prevent...
1. Make Sure all DB access are through Stored procs. Then you do not have to give any rights on the table...
January 30, 2009 at 6:53 am
Create a user and then carefully study what rights that user needs. Then Give the rights accordingly. If you want the user to have Select rights for one DB, Grant...
January 30, 2009 at 6:49 am
I think these are the rights that is needed. Please dont quote me on it. I could be wrong
On Windows Server 2003, the Action Account must have the following minimum...
January 30, 2009 at 6:26 am
There is no difference between how you set up replication between 7 to 7 and 7 to 2005. Configure the Distributor first and then set up the Publisher and distributor....
January 28, 2009 at 8:36 am
That is scary.
Really, I think you should try to figure out some other logic to what ever you are doing. Using a Cursor is a cardinal sin. On top...
January 28, 2009 at 7:42 am
One advantage of growing the file manually is that we can do it when the DB is not soo busy. AutoFile if it kicks in when the server is really...
January 28, 2009 at 7:39 am
Let us say that you did an update on a big table row by row. All these commands are written to the distribution DB. Just because the Commands have been...
January 27, 2009 at 7:05 am
This does not have anything to do with Replication. Replication does not care if there is a trigger in Publisher. The trigger might write to another table or what ever...
January 27, 2009 at 7:03 am
Do you make transaction log back ups? If you dont , then the log file is going to grow.
Once you have the Transaction log back up done, you shouldnt have...
January 26, 2009 at 9:54 am
There are lots of tools out there that can be used to Monitor these details. You can configure them to send emails as well.
You can also write your monitors as...
January 26, 2009 at 8:42 am
You need to be more specific than Jast say Not connected.
Please be more specific. Any errors??
January 23, 2009 at 8:56 am
Viewing 15 posts - 2,491 through 2,505 (of 2,840 total)