Unfortunately, that does sound reasonable Sue.  I haven't reviewed BCP in awhile.  Is there a way to specify server like -S[Spec8\Inst2]???

This will give you the 1st entry made in the diary per person in the People table.  You will need to modify the VIEW to use your table fields

CREATE VIEW...

I would create an NT Group and assign any/all the users that MIGHT potentially do this to the NT group.  Then assign the appropriate permissions to the NT group and...

As you walk the temp table and build the @var you can build in your formatting as you go.  Then you could EXPORT the HEADER and DETAIL information

I had to find SOMETHING to get you on You are always a great sounding...

Sue,

I have gotten lazy and have done it through EM.  Through EM can you see the tables/views?

Try the following:  CREATE a table that ONLY exists in your spec5 system. ...

Unfortunately for you, you are doing nothing incorrect.  At this time (haven't tried with SQL 2K5) you can't get there from here.  The IN clause doesn't know how to interpret...

Are you connected via QA to the main instance or the named instance??  I have several linked servers setup against named instances and use the following context SELECT * FROM...

Why not create 2 different NT Groups and assign the users to one or the other?  Inside SQL add the group(s) and then assign the permissions at the group level...

You may want to research Erwin or System Architect.  One of them may work for you

How bout...

UPDATE a SET a.sno = 3

  FROM test1 a

There are a bunch of different softwares out there i.e. Veritas Backup EXEC, Veritas NetBackup, Tripoli (I think), Harbor, etc..  I even think one of the sponsors here is SQL...

As long as the users are not a part of the dbo group like Jonathan stated CREATE TABLE and explicitly provide the users name as owner.  Then in your sp...

Sounds like the following may work:

SELECT [Name], '1900-01-01' ProcessedDtTm INTO #tmpTable

FROM Country_Master

WHERE [id] < 3

Then you would need to "walk" the #tmpTable for the 1st instance WHERE the record was not processed...

I just installed it yesterday and find it VERY pretty...  (but can they fight) (had to add the dirty dozen ref.).   I have to get used to the new way...