you can't do that. 2 solutions:

1: create procedure myproc @pd int

as

declare @cmd varchar(80)

select @cmd = 'select act' + cast(@pd as varchar) + ' from mytable'

return

2: (preferred)

create procedure myproc @pd int

as

if...

See the other post and please don't cross post. We check all forums as a group for new posts.

Is there a db server in each office? When you say you have 6 inspectors, do they all need a complete copy of the db or just a slice that...

So the fix is reset to blank?

Is this an SP3 box? Possibly something in the config I'm not aware of that resets this. If you can't get confirmation on Technet...

If you can split tempdb data and log that's ok, but I don't think it will be a huge impact since this is in simple recovery and only large sorts...

I don't think anyone except the DBA and potentially Sys Admins should have sa access and sys admins only for remote hands/emergencies. This group should be tightly controlled.

On the Unix...

DTS will work. I'm sure there are other ways. Perhaps you can clarify by what you mean with "synchronize", what data, how it should work, schedule, etc.

If this isn't a dev/text db, turn it off. The benfits are far outweighed by the headaches.

2nd vote for Allen's suggestion. you might also run sqldiag and send that as well.

To see the matching values:

select a.pk

    , a.valuetobereplaced

    , b.somevalue

    , b.pk

 from tableA a

     inner join db2.dbo.tableB b

         on a.pk = b.pk

To perform the update:

update a

    set a.valuetobereplaced = b.somevalue

 from tableA a

    ...

The short answer is: It's broke

Actually the article voting is part of the new asp.net stuff and the scripts/faqs are the old ASP...

If this is very large, I tend to delete in batches of 100, 1000, whatever works.

DTS is probably the simplest if it's a few tables and you are doing it rarely. Be sure you check the "keep identity" box.

IE 5? Mozilla 1.6? There are a few issues. IE 6 seems to be the most stable.

Apologies, this has been a tough bug...

The patch should apply fine and you shouldn't experience any problems from the admin side, however the functionality of SP3 is slightly different. Lots of security changes, but also some...