I agree with you on the WORST way of entering data.  Quite honestly I have been using SQL since 6.5 and only within the last 2 months learned of this...

INSERT from T-SQL would work regardless of PK exist or not.  QA open table is a different animal

Trust me on this.  I have already gone through the same thing.

This is an old issue from ACCESS days where IF the table had no key the system would...

Hate to ask this but does the table have a PRIMARY KEY??

IF the table doesn't it will be READ-ONLY through QA.

Let me know.

Thanks,

AJ

Thanks.  I re-read the BOL and see where I made the mistake.

Thanks again for the quick reply

I got this wrong BUT I picked the CORRECT answer:

sysadmin is as follows: Listed under Fixed server role:  Performs any activity in SQL Server. The permissions of this role span...

I prefer Lysol(c) wipes ....  I have learned that not only do they clean glass, ceramic, paint off the walls, crayon, bleach the carpet and my daughter's hair.

But, they...

I hate to ask this but....  After adding ALL the servers you did save the config as something like michael.msc?  After that you are opening MMC michael.msc?

Good Luck,

AJ

Another option is to use the Import/Export utility and when you are selecting the methods use the bottom radial (don't have this in front of me right now)  I seem...

If I am reading this correctly the situation is as follows:

User 1 from PC 1 cannot transfer data

User 2 from PC 2 logged in to PC 2 as User 1...

Is this being run against static data ? or is this being run against data that is constantly changing?

Also,

You are using LIKE against the @status variable but the variable...

ah...

To my knowledge and use of EM no.  I think EM is used as an admin tool only and not to be used in anything other than a "viewer" type...

Ben,

Just run MMC from command line and then you can add pretty much anything you want to it.  Once you have added what you want you then save the configuration...

Racosta,

I don't think VARCHAR will work with EXECUTE..

Prasad,

I ran your scripts as posted above and received the below errors

Server: Msg 2717, Level 16, State 2, Procedure GETDAYS, Line 0

The size (8000) given to the parameter