Using MS SQL Server

Almost there with bulk insert
I have BULK INSERT T-SQL statements that work for all of my basic data tables except for one. Here is the problem statement (with obvious replacement of irrelevant path info): BULK INSERT igbconts_tmp FROM 'C:\\my_code_path\\IGBCONTS.txt' WITH (KEEPNULLS, FORMATFILE = 'C:\\my_data_path\\contacts.fmt'... 14 Aug 2006 22:44

transaction logs full
I am running a website with a SQL Server database attached. My transaction logs are full and my hosting co. won't allocate more disk space for me. I need to delete my database transaction logs and asume I will need to run an SQL script to do this. Problem: I do not have MS Enterprise Manager of any database u... 14 Aug 2006 19:02

format files for use with bulk insert
I used bcp to produce the apended format file. How can it be modified to recognize the quotes that surround the text fields and not insert the quotes along with the text? Invariably, the first four columns have text surrounded by quotes and are terminated by tabs. If the first column has "abc", only abc ought t... 14 Aug 2006 13:40

Tying together tables
Hello. I've got a table I'm trying to tie to two other tables. The problem is that there is nothing distinct between the 3 tables. Yes, I know... But this is what I have to work with. Let me explain exactly what it is I'm trying to do with a little background history. First, the fast food company I work for... 10 Aug 2006 18:01

On to Bulk Insert issues
OK, I tried this: USE Alert_db; BULK INSERT funds FROM 'C:\\data\\myData.dat' WITH (FIELDTERMINATOR='\t', KEEPNULLS, ROWTERMINATOR='\r\n'); And I got the following errors. Msg 4864, Level 16, State 1, Line 3 Bulk load data conversion error (type mismatch or invalid character for the specif... 9 Aug 2006 18:02

Error 22272: Cannot load the DLL xpstar.dll...
Hi, I'm running SQL Server 2000 on a Windows 2003 server. It's serving several small web site databases. About a month ago my automatic backups stopped working, and whenever I try to edit or set up a new maintenance plan or export or import data through Enterprise Manager, I get the following error: Erro... 10 Aug 2006 17:29

understanding triggers
Please consider the following example. CREATE TABLE test ( an_ndx int NOT NULL primary key identity(1,1), a_var varchar(48) NOT NULL, last_edit_timestamp datetime NOT NULL default CURRENT_TIMESTAMP ); CREATE TABLE test_history ( an_ndx int NOT NULL, a_var varchar(48) NOT NULL, last_edit_timesta... 8 Aug 2006 01:23

table owner
hi, how do i change the table's owner as dbo using sql server 2000 query. kalai ... 4 Aug 2006 06:04

Migrating data from DB2 to SQL Server
Hello, I am trying to migrate data from a DB2 database to SQL Server 2005 database. Does anyone know about any migration tool that does that? I have heard about DB2 Migration Tool kit, but I think you can only migrate data to a DB2 database with that. Thank you. Sincerely, Eldhose Cyriac ... 6 Aug 2006 09:00

ODBC readonly (viewonly) linked tables....
Hi, I have a prod database (main bread & bread DB) and have a small access database that sales team is using... I created a login inside SQL 2000 and gave db_read permission and SELECT permissions... and public. Role of public is EXEC store procs and view some systables... I linked those tables that I gave per... 3 Aug 2006 17:54