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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ToddF

  1. ToddF

    7357 err w/openquery to excute a stored proc on a linked sysbase ser

    Unfortunately this is not the problem. If I take the values I am trying to pass and set them as the default to the parameters in the stored procedure it runs fine.
  2. ToddF

    7357 err w/openquery to excute a stored proc on a linked sysbase ser

    I have set a linked server to a sybase server from my sql server. I can execute stored procedures on the sybase server using the following select * from openquery(sysbasServe,' execute todd_test_1') but when I put add an input parameter and call it using select * from...
  3. ToddF

    Problem using ASP to insert new record in sql db table

    When I use the excute property of the connection object on an asp page to insert a new record into a sql table, it creates two records. The key field "id" is a int field with Identity seed of 1. The code I am using is dcndb.Execute "insert into csc_workload_resp...
  4. ToddF

    using asp script to retrieve data from sql stored proceedure

    when retieving data from sql db using asp script on a web page, I can use a stored procedure with no problem until I use a temp table in the stored procedure. If I do this I get an asp error noting the data source is closed. Any ideas on how to make this work?
  5. ToddF

    truncate transaction log

    I was not backing up a SQL Server database and the transaction log grew unchecked. I now do not have enough space to backup the database on the server. Is it possible to just delete the transaction log. If not any suggestions on how to deal with this?
See more

Part and Inventory Search

Back
Top