Hi Lowell,

Thanks for the support.

sorry for not informing two things earlier, one is the version i am using is sql2000 and second one is the datetime datatype which i am...

Has anybody been able to resolve this issue?

yeah that is ok. I am getting error on execution of the function in dynamic sql. can u give me a sample Dynamic sql code to execute a function with...

any updates on this issue?

are you talking about service pack? if yes then it is sp2.

I can able to use the Filter and Search.

Yes. there are around 1500 sprocs in the database.How can i resolve this one?

ok. with sysadmin permission it is working fine for me.But i tried with select privilege on a table(Remotedb) to a (Remote)user and also ddl_admin(db role) along with select privilege...

creating linked server with SYSDBA user or a SA user it is working fine. my question is like what permission required for a remote user on remote data mapped to...

Yes i have used the following option "be made using this security context".

Both the users having dbowner permission

calvo,

i did little work on this. it works now.Thank you for the support

Regards,

Rock..

hello calvo

using the below query will give individual columns.

declare @sql nvarchar(2000)

set @sql='select col1,' + ' col2,' + ' col3,' + 'col4 from table'

exec (@sql)

actually i want to contatenate all...

I thank each and every one for best supporting

it works. Thank you very much