Encryption in SQL Server 2005.

Can anyone tell me what is the best approach for Encyrption in SQLServer 200
5
? If there is any sample scripts that you link me to. Thanks,
Sam.
Message posted via http://www.droptable.comHow much of your data are you encrypting?
"SAM via droptable.com" <u33747@.uwe> wrote in message
news:7c011375421da@.uwe...
> Can anyone tell me what is the best approach for Encyrption in SQLServer
> 2005
> ? If there is any sample scripts that you link me to. Thanks,
> Sam.
> --
> Message posted via http://www.droptable.com
>|||I need to encrypt 2 colums in a table.Which contains the SQL login and the
password. The record count is around 100.
Decryption should be done by specific sql user /or role /or a Window Active
directory login. Any help would be appreciated. Thanks
Mike C# wrote:[vbcol=seagreen]
>How much of your data are you encrypting?
>
Message posted via http://www.droptable.com|||Check this out
Simple demo for how to encrypt and decrypt a table column in SQL Server 2005
http://blogs.msdn.com/lcris/archive.../09/427523.aspx
This uses the concept of keys in SQL Server 2005 with samples
"Prem via droptable.com" <u33747@.uwe> wrote in message
news:7c01762276e56@.uwe...
>I need to encrypt 2 colums in a table.Which contains the SQL login and the
> password. The record count is around 100.
> Decryption should be done by specific sql user /or role /or a Window
> Active
> directory login. Any help would be appreciated. Thanks
>
> Mike C# wrote:
> --
> Message posted via http://www.droptable.com
>

Encounter Error when FTP get file using tsql

Hi,
I have tried to create my procedure by cut and paste the sample FTP get file
using tsql from Author Nigel Rivett (
http://www.nigelrivett.net/FTP/s_ftp_GetFile.html).
When I tried to execute it by passing parameter as below:
exec s_ftp_GetFile
@.FTPServer = 'www.mysite.com' ,
@.FTPUser = 'mysite' ,
@.FTPPWD = 'xxxxxxx' ,
@.FTPPath = '' ,
@.FTPFileName = 'chat.asp' ,
@.SourcePath = 'D:\wwwusr\mysite\web' ,
@.SourceFile = 'chat.asp' ,
@.workdir = 'c:\Temp'
I encounter error ouput as below
1 User (mysite.comnone)): open www.mysite.com
2 Error opening local file D:\wwwusr\mysite\web\chat.asp.
3 NULL
4 NULL
5 NULL
6 get chat.asp D:\wwwusr\mysite\web\chat.asp
7 quit
8 > D:\wwwusr\mysite\web\chat.asp:Permission denied
9 NULL
Please advise...
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...tivity/200608/1Hi, Thank for all the reply..my problem solved, is due to wrong parameter
passing.
exec s_ftp_GetFile
@.FTPServer = 'www.mysite.com' ,
@.FTPUser = 'mysite' ,
@.FTPPWD = 'xxxxxxx' ,
@.FTPPath = '' , --Should specify the file directoty at Remote Server
@.FTPFileName = 'chat.asp' ,
@.SourcePath = 'C:\myftpfile', -- The source path should be the path the fil
e
will be stored in our local machine
@.SourceFile = 'chat.asp' ,
@.workdir = 'c:\Temp'
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...tivity/200608/1

EnableReportDesignClientDownload

Dear all
I would like to turn of the Report Builder Buttom in the Report Manager. It
worked with the following script out of msdn:
Class Sample
Public Shared Sub Main(ByVal prompt As String)
Dim rs As New ReportingService.ReportingService
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim props(0) As [Property]
Dim setProp As New [Property]
setProp.Name = "EnableReportDesignClientDownload "
setProp.Value = prompt
props(0) = setProp
Try
rs.SetSystemProperties(props)
Catch ex As System.Web.Services.Protocols.SoapException
Console.Write(ex.Detail.InnerXml)
Catch e As Exception
Console.Write(e.Message)
End Try
End Sub 'Main
My problem is now, when I try to enable the Report Builder Buttom, this does
not work. Any idea why?
Thanks in advance for your answer,
Marc
--
Best regards,
MarcHello Marc,
Users must have permission to the Execute Report Definitions task (normally
obtained via the System Users role) for the Report Builder button to be
displayed.
See Home->Site Settings->Configure system-level role definitions->System
User->Execute Report Definitions
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Peter
it worked well thanks!
Best regards,
Marc|||Welcome!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

EnableAltDesignerChanged in IQueryDesigner

A few weeks ago, Rajeev Karunakaran posted a sample QueryDesigner
implementation for a custom data adapter. This has been very helpful, but
it is not yet clear what the EnableAltDesignerChanged event in
IQueryDesigner is supposed to do. Can you please share the documentation
for this?
Thanks,
-SteveIt is used to enable/disable the toolbar button for toggling between the
custom query designer and the generic query designer.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Walch" <swalch@.proposion.com> wrote in message
news:eezIGHSXEHA.1152@.TK2MSFTNGP09.phx.gbl...
>A few weeks ago, Rajeev Karunakaran posted a sample QueryDesigner
> implementation for a custom data adapter. This has been very helpful, but
> it is not yet clear what the EnableAltDesignerChanged event in
> IQueryDesigner is supposed to do. Can you please share the documentation
> for this?
> Thanks,
> -Steve
>|||Not sure I get it. If I were to implement this event, who would subscribe
to it and when should I fire it?
"Rajeev Karunakaran [MSFT]" <rajeevkarunakaran@.online.microsoft.com> wrote
in message news:OhYgBcTXEHA.3664@.TK2MSFTNGP12.phx.gbl...
> It is used to enable/disable the toolbar button for toggling between the
> custom query designer and the generic query designer.
> --
> Rajeev Karunakaran [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Stephen Walch" <swalch@.proposion.com> wrote in message
> news:eezIGHSXEHA.1152@.TK2MSFTNGP09.phx.gbl...
> >A few weeks ago, Rajeev Karunakaran posted a sample QueryDesigner
> > implementation for a custom data adapter. This has been very helpful,
but
> > it is not yet clear what the EnableAltDesignerChanged event in
> > IQueryDesigner is supposed to do. Can you please share the
documentation
> > for this?
> >
> > Thanks,
> >
> > -Steve
> >
> >
>