Ok.

I configured it to SQLAgentReader Role.

and do you think we have any major difference between

SQLAgentUserRole and SQLAgentReader

Ok. I just need viewable permissions on the sql agent.

So, what role would be the best to grant least permissions

so that user can only be able to view the sql...

So my sql agent will not be enabled till all the databases are recovered

which means none of my job will be running till all DB's are recovered?

By directly connecting to the server.

and manually inserting the data using

insert into cc()

values()

1

Even though I try to insert the data manually, I am not able to insert.

So, I think its not the problem with the linkedserver.

We dont have any triggers on the table nor any constraints to prevent from inserting.

I also tried to ressign permissions but still having the same problem.

Yes Sir,

I ran the above mentioned script and I am the sysadmin for the server.

And I am trying to insert data through a linked server from a remote test server...

yes, i can select but iam not able to insert new records, think iam not able to update also....

Yes, I am the sys admin and I have permissions on all the tables.

Do you think the owner who created this table can avoid sysadmin to modify this table?

where do you want me to use this query?

In oledb destination?

Thanks all for the replies,

I actually restarted the server (using cluster environment, I just failed over).

And then it was working fine.

The problem is with the ODBC drivers on the prod...

Actually, One of our DBA was saying that

it initially gave an error message sayiing that

"catastrophic failure".

I tried to google this and they say that this might be due to...

Hello guys,

Not only my teradata linkedserver, but also my sybase linked server in not working.

when I run a small 1 row select query, Its taking infinite time.

at least iam not...

Inorder to create a linked server to teradata, we use DSN and then mention the DSN in the datasource coloumn while creating linked server.

here are complete details:

Firstly, I checked all...