In this case I'll have to disagree that the current version is the only good version. Lots of times we'd have a couple people testing v.05 that used sp_test1 (even...

Trigger should always fire unless it has been disabled. I guess if you need to see it you could add a line that logged an entry to a table.

Andy

Just load in general. In any but the smallest of operations you want to give SQL exclusive use of a server, that way it can use basically all the memory,...

Agreed that you suffer an increase in network traffic. But for an internal link its easy to add more, a 1g card or two tends to eliminate the bottleneck. If...

The cutoff point is whatever you set it. If you don't set it, then all only the pointer is stored in the table. If you look at sp_tableoption, you'll see...

Better answer than mine!

Andy

Another point is that you if you use an ADO stream to retrieve it, you can push it directly to the response object without having to write it to disk...

Sorry for the lack of clarity, its Books Online, the standard SQL help file.

Andy

Nope, its about as simple as that.

Andy

I think probably makes sense to do this in VB (or your choice of language), for each record, loop through to grab x bytes at a time to build the...

BOL has some info, search for Data Types, then pick described under it in the index.

Andy

I like storing them in the db. If you do a search on the site you'll find several threads that cover the pros/cons in detail.

Andy

Thats a possibility.

How the transactions get sent across depends on how you configured the pub, the default is using the proc methodology I posted earlier. Search for "Using Custom Stored...

Not silly. That makes sense. Sort of...wouldnt they have to have removed TCPIP as an available protocol? I dont have access to the Server Network Utility yet, waiting on userid/password...

The row has already been deleted, or the delete failed, say due to a foreign key or something? Do users have delete access to the subscriber? Just looked at how...