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

  1. Christine0701

    Question about Set Ansi Nulls on and off

    I did set ansi_nulls and ansi_warnings on at the creation time of the stored procedure and I still get the error message. EX: SET ANSI_NULLS ON SET ANSI_WARNINGS ON GO Create Procedure pr_MyStoredProcedure ... Any other ideas? Thanks!
  2. Christine0701

    Linked tables?

    Look into Linked Servers.
  3. Christine0701

    Is there a way to trace who inserted a particular record?

    We also have added fields to certain tables --Initial entry by and Last modified by. To get host name: host_name() To get user name: suser_sname()
  4. Christine0701

    Linked tables to Access as a front end

    Yes and No. If you link to MSAccess and run the query from your computer it will send the entire table back and forth (in otherwords client side processing). However, if you create an internet related application/page on the server, then the server will process the data and return the results...
  5. Christine0701

    Question about Set Ansi Nulls on and off

    Did you ever find a solution to this problem?
  6. Christine0701

    SQL Stored Procedure + Linked Server

    I am trying to create a Crystal Report that uses a sql server stored procedure. The stored procedure connects to some data thru a linked server to MSAccess data. When I try to create the report, it lets me add the stored procedure but then it gives me a general SQL Server error. I checked the...

Part and Inventory Search

Back
Top