Lowell - Thanks for the detail explanation but the sql script that i have on my post is working perfectly on my server but it does not work on my...

Hi Mr or Mrs 500,

I am login into server as Administrator and login into SQL Server as Administrator as Window Authentication. but it is giving me an error.

Also, i...

Hi Jack,

I am having the same issue as BKW where i have to monitor a Folder where user drop the EXECL file and my SSIS package run. But what i...

Manu - Thank you for your link. I looked at it but it seem like that script does not Decrypt the SP.

I run his SP on SSMS 2005 and...

Can anyone you provide me how to create SP with encryption method?

Manindar,

Thanks for your reply,

On other note: Do you know who do you encrypt your views and SP in ssms? is there a 3rd party software you use or how...

Imu92 & Rob,

Here is my sample code where i found out how to do cross tab by using 92's suggestion on RoW_NUMBER() function.

DROP TABLE ##TBL1

CREATE TABLE ##TBL1

(Accountvarchar(20),

Prod_codenumeric(18,0),

AmountMoney

)

INSERT INTO ##TBL1...

Rob, Sorry about not providing more detail but it is true that in some case where Product has more than two price. It is very difficult to say that each...

Imu92,

I think i need to try your Row_Number() function where you have supply Account, Prod_code as partition by .. I am going to try to use your method and...

Guys,,,this is very good feed back for me to start work on your suggestion. Please accept my big apology that i didnt provide you detail. But in some case where...

These is great. Let me start looking into

Humm...

I think the code that Lowell provided is working AWSOME for me and I ready put that one in production.

Thanks a Million LOWELL>

Bhuvnesh,

Thank you for the links but what I am looking for is to have documents that talk about login rights.

For example: if you have readonly access to remote...

Same company but two different servers.

As per your guidance. I have set the Owner of the job as SA but i am getting below error.

Message

Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'DOMAIN_NT\SERVERB$'. [SQLSTATE...