Search results for query: *

>>My main question is what is it for and how will it affect the GP interface by forcing data into the tables outside the applications normal process. There should be no problem related to the dex_row_id column. I don't know of any situations where the application relies on data in this column...

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...

dex_row_id is an identity column. The value is automatically supplied by SQL each time a row is inserted into the table. Therefore, you should not include this column when importing your data. If you are using an INSERT statement for the import, you will need to specify all of the table...

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...

Thanks Terry, I added a little code to select for tables with the desired column: insert tablerwcount select o.name, i.rowcnt, c.name from syscolumns c join sysobjects o on c.id = o.id join sysindexes i on o.id = i.id where c.name = 'sub' and i.indid < 2 and o.xtype = 'U' and i.rowcnt > 0...

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...

Terminal Server on Win2k has two modes of operation: 1) Remote administration or 2) Application. You only need to worry about client licensing if your server is set up for Application mode. Remote Administration allows up to two connections from any client. You can check the mode by opening...

Yes, I can access the DSN through the Control Center on the server. I can establish an ODBC connection to the DB using an application on the server, but not from a client. I am using TCP/IP and have tried both Server name and IP address.

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...