Hi,

If a login account is mapped to a 'database' user account then it in turn means that you are giving authority to that login to access the database. I...

hi,

SELECT object_name(id),name, COLUMNPROPERTY(id,name, 'IsIdNotForRepl') as I_INSERT

FROM syscolumns WHERE status = 0x80

If the I_Insert is 1 then Identity_Insert is not checked.

Prakash.

Hi,

I think u can use this query as well to find out the identity column.

SELECT object_name(id), name

FROM syscolumns WHERE status = 0x80

Regards,

Prakash.P

Hi,

What is the edition of the SQL server you are using?

Hi,

Nothing has really changed in SQL server 2005 related to the linked server. It must be a straightforward one.

Yeah you can send me a mail to this account prakash.padmanabha@gmail.com

Regards,

Prakash.P

Hi

Since the table is there in the dbo schema, the login with which you are accessing the table remotely (remote login, password) should have access to dbo schema objects. Try...

Hi,

Check what is the schema of the table you are trying to access on the remote server. Lets say if I am using one SQL account and is not...

Hi,

RPC will be there in the settings page (values will be true or false) . But I think this is not going to solve your problem as this is...

Hi,

xp_smtp_sendmail was an extended stored procedure which was sending the mails using an external component. Now that SQL server 2005 has its own components for sending the mails,...

Hi,

I am not sure if we can use sa account for linked server. I've recently configured a linked server by using a SQL account(login). We would have to provide...

Hey,

I am not sure if this is what you were looking for... but I can run this query to see the current server and all the linked servers on...

Hi,

I got this error too as the database compatibility level was set to 80 and I think for this table valued function to work the compatibilty level has to...