Opendatasource

I'm trying to use OPENDATASOURCE in t-sql to update data on our AS/400 from MSSQL but don't know the property value for provider_name. Please help!!!"Control Panel"\"Administrative Tools"\"Data Sources(ODBC)"
Select a tab "File DSN", click "Add..", select server and click "Advanced".
Now you see sub-driver for ODBC (MSDASQL)

For MS SQL Server in MS SQL Server
select *
from OpenRowset('MSDASQL', 'Driver={SQL Server};Server=MyServer;User=MyUser','select * from sysobjects')

I do not have A/400 driver installed, that is why I cannot test this for A/400.

Good luck !|||my diagnosis is the your transactional properties of your neural defilibrator is going to require that you just replace the AS400 with SQL Server.

you better get to work.sql

only authorized users can access the database in enterprise manager in MSSQL Server

hello,

I want to give password when we open the enterprise manager .So that only the authorised users can access the database & see the tables .

Could u help me for solving this problem.
& Also tell me is it posible or not.

very urgent.........reply soonIf user's rights are restricted - he can't do much through Enterprise Manager.
Revoke all unwanted rights from users.|||tell me is it possible that first we enter the login name & password
if it is valid , only that user can see the database.

I want to do...........

If possible then how will be done.