Stored procedure and two databases

Tech-Archive recommends: Fix windows errors by optimizing your registry

I need to create stored procedure that transfers data from one database to
another. I don't know how to make two connections in the same time - can I
do it in stored procedure or can stored procedure take connections as
arguments? I'm working in C# and writing procedure in SQL Server.
Thanks a lot


.

Relevant Pages

  • Re: user permissions
    ... A user should be able to kill connections only for a specific database. ... stored procedure, by doing an EXECUTE AS LOGIN and then kill any connection. ...
    (microsoft.public.sqlserver.security)
  • Re: Restore Fail
    ... But I can't create stored procedure in the server. ... Can I disconnect all connections by program? ... > DECLARE @ver VARCHAR ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connections query
    ... Execute method against the command. ... this bit of code opens up two connections. ... Firstly select @@connections returns +2 on my previous call to it. ... stored procedure than the first recordset. ...
    (microsoft.public.sqlserver.programming)
  • Hardcoded database names
    ... We have a stored procedure which transfers data from a set of tables in ... Right now one of the database names is hardcoded in the stored procedure, ... there a way of doing what we need without hardcoding the database name? ...
    (microsoft.public.sqlserver.programming)
  • Re: kill user connections
    ... Also Tibor Karaszi has a stored procedure that I always use.. ... to kill all of the connections on a particular database... ... Wayne Snyder, MCDBA, SQL Server MVP ...
    (microsoft.public.sqlserver.server)