Hi

I know it's been long time for this post... but I have across with an issue during "CLR Assembly with Asymmetric Key". I have searched  and could not found any...

Thanks Lynn...I'll check and share the results..

you are right Gila...happened at work and we testing the situation as this raised by someone in group at work.

and I was not able figure after tried. Thought to ask...

This is brilliant... the way you have explained it...

Shall we replace rank() over function with T-SQL (or any other way)?

I mean this line select AgentID,DT,AgentStatus,TeamID

, rank() over...

You have valid questions...I like know how step by step workout for the results for this problem rather just use functions that do all the work for me.

I appreciate if...

No I haven't... any other way that do not use any function rather may be while loop with flag to the records or any other method.

Thanks..

how do we use profiler to capture the modification of objects and store the results in a table?.

Pls help..

Hi Folks

I have same problem but with strange instance that I ave created 2 LInked servers with MYSQL server using 2 different databases. Created ODBC System DSNs for them....

I have send the mail... Tommy

Thanks Tommy...

As I am totally new for using SSIS (or DTS)..plus using script in SSIS..so, could you plesae guide me how I am going to implement in SSIS.

Thanks...

Diwakar

I have same problem.....so please could you guide me through or share the approach you taken to create 'sspCmdShell procedure'

Thanks.

sonny

Hi

thanks for response... any refer for document on it cos could able find any thing in BOL.

regards

Hi ron k 

Here it is explanation...

I try to get following results

1. List of users exists in databse... ( can be found from...

Hi noeld 

thnx for reply.. but distinct will not slove the problem. I have tried before posted it. I also have tried group and...

Hi Remi

thnx for response.. yes i have done in static sql and working fine.. but u see I am using this in store procedure and user will allow to enter two parameters...