No constraint.  No trigger.  Why not?

Okay, I was kidding.

There is a completely naughty way to do that.

Create table WTF (

c1 varchar(10) NULL,

c2 varchar(10) NULL)

GO

Alter table WTF

add  FOO as 1/((CASE when c1 IS NULL then 1 else 0...

I think that you've already found the "workaround".  Just use a nonclustered PK, or create the clustered PK inline.

Can you verify that both servers are on the same build? I would check the MDAC as well.

You can also try to copy them directly using T-SQL like so:

-------8<---------

Insert targetlocalserver.msdb.dbo.sysdtspackages

Select...

Have you come up with any physical disk IO statistics? 

Aw geez.  Now I read a little more carefully and I can see what the problem might be....

You've got a two-drive mirror for your log files!  That's not so good....

I use a similar set-up.  I have no problems at all.  I do envy your cpu count

Did you perform any IO testing before...

I remember seeing this a very long time ago.  It was fixed by one of these two things:

I turned off "fiber" mode.

or

I turned off the "priority boost" option.

I don't...

Sorry, but I do not know how to move the log file.

Is that trace level 0 thing working out for you/

thanks,

jg

AJ:  You must have a different version of Profiler.  Mine reports milliseconds of CPU utilization.

Yuri: Now, in 4 minutes, you get 775 seconds of reported utilization.  This would seem impossible,...

This happened to me.  All of a sudden, the LogFiles directory was filled up with many files that added up to "all my free space".

The solution that I found from...

There is an interesting and fact-filled discussion of what might be going on from our friends at Cisco.  This has to do with PMTUD. (Path MTU Discovery)  The MTU adjustments should be...

You can try to lower the MTU on the RDA server's network interface.  I'm not sure how to convince RDA to use smaller packets.  If I uncover anything, I will let...

Hello,

I can't think of any particular company that you could hire.  It probably depends on where you're located.  If you are close enough to Milwaukee, Wisconsin for me to know...

I'll juist add mine because if you are going to user cursors AND dynamic SQL, you might as well do them both at the same time.

Declare @TabName  sysname,

 @SQL   nvarchar(4000)

Create Table...