Forum Replies Created

Viewing 15 posts - 2,491 through 2,505 (of 2,840 total)

  • RE: Replicating a Database Overseas

    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...

  • RE: SQL Server Schemas

    My Bad..It is actually termed a Role.

    Not group... Stupid me.

  • RE: SQL Server Schemas

    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.

  • RE: Issue in Transactional replication

    Do a CheckDb on your Subscriber. See if everything is Ok with your Subscriber DB.

  • RE: SQL Injection

    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...

  • RE: how can deny user who has full rights to prevent some tasks.

    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...

  • RE: MOM access to SQL Servers

    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...

  • RE: Replication from SQL 7 to SQL 2005

    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....

  • RE: A stored Proc inside a cursor inside a trigger

    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...

  • RE: Manual or auto - growth of datafiles

    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...

  • RE: Space is not reclaimed in distrubution database

    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...

  • RE: How to replicate the data of table level triggers

    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...

  • RE: Big TransactionLog and File-growth

    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...

  • RE: Capacity planning

    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...

  • RE: Not Connected

    You need to be more specific than Jast say Not connected.

    Please be more specific. Any errors??

Viewing 15 posts - 2,491 through 2,505 (of 2,840 total)