Search results for query: *

Hi All, My doubt is regding Subscriptions in Reporting Services..I tried to configure a subscription which sends alert mails to some of our clients ..but it is giving error and the error details its asking to check in the log file..I think its some service pack issue but i do not know which one...

james thnks for your reply . I have another problem regarding this decrypting sp . I downloaded the code for the sp which decrypted the encrypted sp and gave some value add to it . What i actually intended was that my decrypting sp will also except a password along with the sp name (which has...

My problem is exactly that ...james. If I encrypt the sp using WITH Encryption the code for decrypting is also nowadays readily available in the website. Is there some other secure way??like xp_crypt which will always need a password for decrypting ??

Can we encrypt a stored procedure using xp_crypt ? pls guide me on the same and if so do add a method of decrypting it also. Thnks in advance.

Thanks Rob.... I think i shld check some other way out.

Hi All, As of now we Know the way of Encrypting a stored procedure in SQL2000 by giving the code 'With Encryption' and the code for decrypting the sp is also readily available in the Website. Can anyone help me with a more foolproof method wherein I can encrypt the sp with password. I mean to...

yes i mean duplicate rows. My table consists of rows in which all the records are duplicated. Actually i transferred data from Symix(ERP) to my SQL table and got duplicated records. For eg (pls dont mind if the fields are not in order) Empo Firsname Lastname Age Salary Address I1 smitha...

Pls give me the query of removing repititive rows from my table. Can it be done only with the help of a cursor???