I'm not sure there's a size limit, but with a file that size you might have issues if there's any network hiccup. Your best bet might be to send it...

Microsoft has been a little sloppy with SP2. I wonder if they put too much of a testing burden on Beta and CTP testing and getting feedback.

I got this from...

I agree with that. I can't believe that these companies get the benefit for the millions they spend. Personally I'm a Yankee Stadium, Texas Statium, The Forum in Englewood, Candlestick,...

Actually it's Andy's fault! He wanted these forums and coded to them

I was happy with plain ol' ASP. Much simpler.

Hopefully this will be...

I agree with the above. Looks like .NET problems.

You probably need to install the client tools. IF you have a copy of SQL Server personal, you can install jsut the client tools.

you just execute a "CHECKPOINT" command. But these execute every minute or so, so I'm not sure you need to. Is there something you are concerned about?

I think the problem is that the Srvr A is using its service account to jump to srvrB. Should be a setting in the linked server properties to use the...

This might be similar to what I've seen in the past with AS/400 drivers. There's a limited amount of space for driver code and sometimes these things leak memory and...

All changes (insert, update, delete) acquire an exclusive lock. Granularity depends on a number of factors, but they all have an exclusive lock. Now, read operations can ignore the lock...

I don't think there's a dispatch type either. You can add an ActiveX task and a msgbox(globalvar) in the package and get the result interactively.

If you just want to update all rows, it's a simple update statement. A computed column will work, but if you have exceptions or things change, then it's harder to...

Markus,

It's worth it. It's one of the few games the Rockies sell out and while it's a zoo, it's neat to be in that atmosphere where everyone is excited, there's...

Coming out this week: http://www.sqlservercentral.com/columnists/mBalasundram/2925.asp

I'd use separate DTS packages for each client as an easy way to implement things for your team and train others on how to maintain them....

Jason,

Take a deep breath. It can be frustrating, but let me try and explain a couple things. First you don't connect a SQL instance to another. At least not easy....