Viewing 15 posts - 32,401 through 32,415 (of 39,818 total)
You probably need to install the client tools. IF you have a copy of SQL Server personal, you can install jsut the client tools.
April 2, 2007 at 8:41 am
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?
April 2, 2007 at 8:40 am
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...
April 2, 2007 at 8:14 am
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...
April 2, 2007 at 7:58 am
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...
April 2, 2007 at 7:57 am
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.
April 2, 2007 at 7:52 am
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...
April 2, 2007 at 7:43 am
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...
April 2, 2007 at 7:11 am
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....
April 1, 2007 at 9:50 am
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....
April 1, 2007 at 9:48 am
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...
April 1, 2007 at 9:43 am
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...
April 1, 2007 at 9:42 am
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...
April 1, 2007 at 9:39 am
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...
April 1, 2007 at 9:30 am
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...
April 1, 2007 at 9:29 am
Viewing 15 posts - 32,401 through 32,415 (of 39,818 total)