Not directly. You could parse them out in your app I guess, but that will only work for that app, not all of them. Or use a COM piece to...

I think we need more info. VB? ASP? what language? Is there a SQL issue involved?

Andy

Log shipping is supported using a set of sp's in the BORK. The theory is pretty simple. Every x minutes run a log backup, copy to the other server, restore...

I'd recommend transactional for this type set up, though you may want to look at log shipping as an alternative. I like this book, although there is not a huge...

As long as it is not defaulting to a table scan because the index is poor, or there isnt enough data to make it worth using the index.

Andy

Hello Wizzy,

As I posted earlier in reply to Richard, I cant argue that you can solve this other ways, probably more efficient as well. It was posted as one way...

Depends on the hierarchy you want too. If you try using explicit, it gets to be ugly in a hurry. Raw and auto are quick and easy. If you need...

If you leave out the DTS part its easier to think about - you just need to a join between the two tables. For doing things like this you might...

If you do it with a stored procedure you're still sending it over the wire unencrypted. Depends on how much risk you can handle.

Andy

I havent seen any - Leon and I have talked about this but never came up with a really good test methodology. It's certainly going to take some cpu time...

I think probably the easiest way would be use the file system object in your job, that would let you determine if there were files (that match your criteria), then...

I dont think of us here at SQLServerCentral.com have much C++ experience. My suggestion if you can't find sample code on MSDN would be to look for a C++ centric...

Take a look at the bit column. SQL represents false as 0 and true as 1 (where VB uses -1 for true).

Chris has some fair points about booleans. One common...

You can let users other than SA have access to xp_cmdshell. Not a good idea, but it is an option. Bulk insert has it's own role in SQL2K, doesnt have...

Hey Marvin,

Could you post the code as you have it now. Used correctly checking for BOF and EOF will work - in fact, doing it ANY other way is bad!...