Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pmurch
  • Content: Threads
  • Order by date
  1. pmurch

    Integrated Security vs. User ID/Password

    It seems so often that security is what stumps me. My situation: 1. Running an Excel spreadsheet with VBA code that executes a stored procedure on our SQL server. 2. We have an SQL login called abcdefg that has been given Execute rights to the stored procedure. 3. The connection string for...
  2. pmurch

    Running SQL Query From Excel Macro

    I have a stored procedure that runs on an SQL server (running SQL Server 2008 R2 SP2), updating an SQL table. I also have an Excel 2007 spreadsheet with a macro that opens a recordset to the SQL stored proc, initiating the update of the SQL table. Through initial development, there were no...
  3. pmurch

    Getting Backup Filename from Database

    Is it possible to determine the backup filename that was used to restore a database? We have a restored database, and there is a question as to which backup file was used for the restore. Is the backup filename kept anywhere in the metadata for the database? Thanks in advance for your help!
  4. pmurch

    Using USE in a Stored Proc

    We have a number of stored procedures that need to run against a set of similar databases (~25). Our desire is a single proc that can step through all the databases, probably via a cursor. Unfortunately, we run into issues because the USE statement does not allow a variable. The only...

Part and Inventory Search

Back
Top