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 bkrike 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: *

  1. shanegarcia

    Getting the Computer Name from T-SQL

    Hi, I'm writing a trigger that logs updates to the database as part of audit requirements. I can get the SQL Login name of the user who made the changes but I'm also being asked to log the workstation used to perform the update. Is there a way to do this in SQL? I'm using Windows 2000 and SQL...
  2. shanegarcia

    Stored procedure problem...

    This is the stored procedure that I'm trying to call, however, when I get the resultset in Crystal it only shows the header table... Any ideas on how I can get the other tables (i.e. details, etc.) Any inputs would be greatly appreciated... Thanks.... <STORED PROCEDURE CODE> if exists...
  3. shanegarcia

    How do I call a stored procedure involving 3 result tables?

    This is the stored procedure that I'm trying to call, however, when I get the resultset in Crystal it only shows the header table... Any ideas on how I can get the other tables (i.e. details, etc.) Any inputs would be greatly appreciated... Thanks.... <STORED PROCEDURE CODE> if exists...
  4. shanegarcia

    How do I set the database location for a large number of CR reports?

    Hi, Is there a way for me to set the database location for a large number of CR reports? For example, from a test server to a live server without having to go in and set each one individually? We're talking 200+ reports here... Alternatively, could you suggest a way for me to do this...
  5. shanegarcia

    ADO resultset returns an EOF when called from a proc in ASP

    Hi, I have an ASP program that queries a SQL database based on multiple user selections stored in an array. I then SPLIT() the array to get at individual items. My problem is that after the initial pass (which gets data successfully), the second call of the sub with the corresponding parameters...
  6. shanegarcia

    ADO resultset returns an EOF when called as a procedure...

    Hi, I have an ASP program that queries a SQL database based on multiple user selections stored in an array. I then SPLIT() the array to get at individual items. My problem is that after the initial pass (which gets data successfully), the second call of the sub with the corresponding parameters...

Part and Inventory Search

Back
Top