I am wanting to send data from our local sql server residing within the
corporate intranet, across to a remote sql server. I have set them up
as linked servers using both the sp_addlinkedserver and
sp_addlinkedsrvlogin stored procedures. All works.. but...
What I would like to establish is the security of the session. How
secure are the login/password credentials as expressed via the
sp_addlinkedsrvlogin stored proc? Are these credentials being sent as
clear text across to the internet sql server? What about the parameters
i am passing in my user stored procedures? Are they being delivered as
clear text?
Extreme performance issues (SQL Server 2000/ADO.NET/C#) ... This process runs very quickly if run through Query... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ... (microsoft.public.dotnet.framework.adonet)
Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7 ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ... (microsoft.public.access.adp.sqlserver)
Re: Help understanding Stored proc Level Secuirty? ... Jasper Smith (SQL Server MVP)... I set permissions to my Stored Procedures,... Access to stored procs fail... (microsoft.public.sqlserver.security)
Re: Limiting views on data in a table ... returns the Windows login the user uses to connect to SQL Server.... > The way I was implementing this was to use Windows Auth with a Windows ... > covered by which salespeople,... > with it via the stored procedures.... (microsoft.public.sqlserver.security)
Re: Scripting T-SQL CREATE Statements ... a backup of user-defined SQL Server objects.... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ... (microsoft.public.sqlserver.programming)
