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 TouchToneTommy 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: wltenney
  • Content: Threads
  • Order by date
  1. wltenney

    DBMail - cannot send mail using sp_send_dbmail

    I am trying to set up dbmail on SQL 2005. I have created a profile and account which uses smtp on an exchange server. All works fine when I use the Send Test E-mail in SQL Management Studio. However, if I attempt to send an email using sp_send_dbmail, the message is not sent. The SQL log...
  2. wltenney

    DTS error when importing to table w/timestamp column

    I am trying to import data from an Excel spreadsheet to a table using DTS. The table has a timestamp column which is giving me fits. I keep getting an error: "Integrity violation; attempt to insert NULL data or data which violates constraints." I have tried including the timestamp...
  3. wltenney

    Insert rowcount into table

    I need to create and populate a table with the table name and row count for selected tables. Getting the row count is the problem. The following script illustrates what I need to do, but the select count(*) statement returns an invalid object error on table_name. create table tablerowcount...
  4. wltenney

    ODBC Client/Server connection problem

    I am having trouble setting up an ODBC client DSN connection. I have Pervasive SQL 2000i (sp3) server installed on NT4 (sp6). I have created an ODBC engine DSN on the server. However, when I try to create a client DSN on the workstation (Win98 Pervasive 2000i sp3), I get a message...

Part and Inventory Search

Back
Top