You'll have to load the file outside of the proc and pass it in using a text variable.

Andy

http://www.sqlservercentral.com/columnists/awarren/

You're running the query from QA? As a job?

Andy

http://www.sqlservercentral.com/columnists/awarren/

If it is SQL2K, you can add the columns using either sp_repladdcolumn, or via EM (its in the filter column tab of the publication properties). EM by default adds it...

I think you're going to have to trap the error and decide what to do. Maybe tell the user, maybe just keep going, depends on the task I guess. I...

When I run the code I get a trappable error (from .Net that is), do you get the error?

Andy

http://www.sqlservercentral.com/columnists/awarren/

So just the objects are copied? No errors raised?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Hey Paul,

Sorr for the slow reply, another busy time for me. I don't have Win98 to test with (and would rather forget what it looked like!), so I can't help...

Non intuitive I'd agree. Must be generating a bad query plan for the single table case. You might have to use an index hint to get it to match the...

I don't remember seeing anything written that targets specific industries. As far as your solution, it doesn't seem bad to me at all. Merge is perfect for disconnected users and...

You're going to use TSQL or DMO to do it? If TSQL, you should repost in a different forum to get more replies. If DMO, just off the cuff I...

Nice thread. I like the comments about dynamic vs stored proc. There could well be times when a specifically built dynamcic statement might have a better query plan than a...

Using SET CONTEXT_INFO is a nice way to do this, just have to be careful that you don't break anything else that might be using it too. A different way...

Racosta is right on the distributor, but I'd add that I run the distributor on the publisher with good success. Really just depends on the volume plus the hardware plus...

Replication doesn't care. I don't see anything wrong with doing so, it's way better than not having a good copy ready to go.

Andy

http://www.sqlservercentral.com/columnists/awarren/

Interesting. Not sure what kind of volume we'd get, but something that had notes about various apps would be very useful, especially if you were just thinking of buying but...