No. If you want people to respond on this thread, add a link on the old one and I'll delete the duplicate post link above.

See? My ignorance is...

What do you mean with "effected"?

Modified?

Currently locked?

...?

Edit. Removed as requested.

GilaMonster (2/14/2012)

---

I wish I'd seen this earlier...

Dropping a column is a meta-data only operation. SQL just changes the metadata to say that the column isn't there any longer and bumps...

+1

I guess you're complicating things too much.

Can you...

You could try Mladen Prajdic's ssmstoolspack[/url].

It has a "script results" feature.

Thank you very much for the great feedback, George!

I'm very surprised to see that the column was dropped instantaneously. I'm still wondering why.

Under which account is SQL Server Agent running? Is it [NT SERVICE\SQLSERVERAGENT] or a domain user?

Please run this to discover the service account name.

SELECT servicename, service_account

FROM sys.dm_server_services

WHERE servicename LIKE...

I don't understand what OSQL does here.

I would connect to SQL 2000 with query analyzer as "RemoteSql" and try to query the linked server.

Does this work?

Where does RemoteSql login come from? Is this the login used by the linked server security or the login that runs the Agent job?

I don't think such a syntax exists. I'm afraid you will...

This should do the trick:

DECLARE @A TABLE (

col1 varchar(3),

col2 date,

col3 int

);

INSERT INTO @A

SELECT 'us', '01/01/2012', 10

UNION ALL SELECT 'us',...

You're welcome. Glad I could help.

Maybe.

If you post table scripts, sample data and expected results based on sample data things would be much easier for us.

Please, read the article linked n my signature line and...