Mike Levan (1/27/2009)

---

Here is the exact error mesg.

Executed as user: StatePA\PZarah. Cannot find the object "dbo.Rev2001" because it does not exist or you do not have permissions. [SQLSTATE 42000] (Error...

Hi everyone I am trying to obtain some extra information from my ssis packages but I am not getting anywhere. I am using two tables to obtain some information from...

Thanks guys for the quick replies. What I wanted is a value of length 16 and the options you gave are great.

Thank you very much for your help.

If you are configuring this from...

yeah that's what I've done and it works, but I wanted to know if anyone knew for sure that Latin1_General_BIN was the equivalent for the one in sql server 7.0.

Thank...

have you tried executing the replication job from t-sql?

hey, what kind of replication are you using? and an important question that you should ask yourself, how important is the data you have in your subscriber??? because if it's...

have you tried using in the precreation cmd 'none'?????

but you should have in mind that, you would have first to synchronize your metadata on both servers and then you wouldn't...

Anyone please??? : (

I want to confirm that the collation Latin1_General_BIN is the equivalent for sql server 7.0 collation "binary sort order for the iso 8859-1 (Latin 1) character set". Or which would...

DavidB (10/22/2008)

---

You didn't mention the drive configuration on the first server other than SAN. How many disks in the volume, what is the RAID configuration for that drive? On the...

Ninja's_RGR'us (10/21/2008)

---

Check the autoshrink, autogrow settings on sql 2k5.

If the files need to grow during the process, that'll hurt a lot (as much as 40-50% slower). Autoshrink could add...

I am not clearing the cache before doing this, is...

Steve Jones - Editor (10/21/2008)

---

could be a lot of things, hardware, load on either server, disks, etc. check the plans, be sure they're running efficiently, look at load on the...

Sorry SqlGuru :hehe: I think I couldn't explain to you my question. I do understand your point, BUT how do I implement what you are talking about?More indexes?new transactions?I know...