Hari,

I tried using drynamic query with in the function but getting the following error while executing.

'Only Functions and extended stored procedures can be executed from within a function.'

Thanks

Hi Hari,

Initially I tried for Functions. Since I need to use a dynamic query in that I can't use the function.

Is there any other approach that can be followed...

Hi Hari,

Thanks for your suggestions.

Sorry for not mentioning the scenario clearly..

The Situation is this...

I should derive a single select query that would return 8 columns. 3 column values are directly...

Hi,

 I got the solution for this problem. I changed the MSSQLSERVER and SQLAgent service account to my domain account and it works fine.

When i execute from TSQL or through Job i get the following error msg:

DTSRun:  Loading...

DTSRun:  Executing...

DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_1

DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_1

DTSRun OnStart:  DTSStep_ZIPFileTask.ZIPTask_1

DTSRun OnError:  DTSStep_ZIPFileTask.ZIPTask_1, Error...

SQLAgent service account is my domain account and permission wise everything is fine. The thing is iam using a custom task(to zip a file) in DTS. If i remove the...

sqlserver service was running in windows account only and access rights had been provided to the share for this account.Actually in BCP i am connecting to the SQLSERVER through an...

I had tried providing "Everyone" access rights to the share. But doesn't resolve