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....

How do you know an index is missing? What are you looking to do?

The question doesn't make sense by itself. There are not any "missing" indexes without some reason...

The U creates an alias, so you say

from MyTable a

and then you can use "a" in other parts of the statement. So

select a.col1, b.col2

from mytable a

inner join...

I think you want to convert rows to columns, so something like this:

select a.shape, a.value, b.header as length1, c.headers as length2

from a (first file)

left outer join...

Can you run it in some batches? I like David's thoughts above, but I wonder if 1000, or 10,000, or 100,000 rows seem to complete in reasonable times.

Has the data...

I have a Mac Dual Core for the kids, but haven't gotten around to putting Boot Camp or Parallels on it. NEed to try it and see. I just saw...