jryan_pun (6/1/2008)

---

thanks for you reply.. i appreciate all.. more than a month i edit this code but i cannot solve.. can you help if i need your help.. because im...

Please post your question so that we can try to help you.

Please don't cross post. It just fragments replies and wastes people's time. Many of the regulars read all the forums.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic509190-19-1.aspx

Please don't cross post. It just fragments replies and wastes people's time. Many of the regulars read all the forums.

No replies to this thread please. Direct replies to:

http://www.sqlservercentral.com/Forums/Topic509190-19-1.aspx

Now this is interesting. Same question from a different person. hmmm. Homework?

http://www.sqlservercentral.com/Forums/Topic509017-360-1.aspx

Interesting. How come another member has posted the exact same procedure (but different name) with virtually the same question?

See here: http://www.sqlservercentral.com/Forums/Topic509053-146-1.aspx

There is no where near enough information...

Please post the following:

The table structures

The index structures

Some idea of the volumne of data in these tables.

The current execution plan (saves as a .sqlplan...

Help you with what? There is no where near enough information to give you any suggestions.

Please post the following:

The table structures

The index structures

Some idea of the volumne...

Shrinking database = really bad idea. The DB will just grow again and you will probably have messed the performance up doing the shrink.

Do you have transaction log backups running?

In...

You did notice that the post you replied to is over a year old?

The transaction log is not optional. It's used by SQL to keep a permanent log (for recovery purposes) or all data modifications that occur. It's what allows SQL to always...

Shouldn't be a problem, providing you don't create unique indexes that don't exist in the publisher.

If the subscription is reinitialised, you'll have to recreate the indexes.

What recovery mode is your database in?

Are you running regular log backups?

You don't want to physically shrink the transaction log. It'll just have to grow again.

Since you're in simple recovery, run a checkpoint at regular intervals between your inserts. In simple,...

Copying by cmd uses your account. Copying through QA uses the SQL...