I have one table with 300,000 records and 30 columns.
For example columns are ID, COMPANY, PhONE, NOTES ...
ID - nvarchar lenth-9
COMPANY - nvarchar lenth-30

What started this is that I was having the following problem with my SQL
Server Client.  The problem was in the Enterprise Manager SnapIn creating
database diagrams.  I think the error was 'Invalid Class ID.'
I attempted the fix this problem by reinstalling the Client over the

I was able to connect to a SQL Server 2000 instance using ODBC on a Windows
2000 workstation (Service Pack 4).  But after installing several security
updates and rollups, I am no longer able to connect to SQL Server.
The drivers tab in the ODBC Administrator lists SQL Server as ...

I have an Access Project front end that has alot of nicely formatted reports.  
Is there a way to create a SQL Job that can run a weekly Access Project
report and then save it out to a spot on our intranet?  (Each week saving
over top of the prior copy so that a somewhat current ...

I need a sql statment to return a list of tables for a given database
where the Recovery Model option is Simple.
TIA
Rob

Any recomendations on how to store organization trees on a database with
lots of paths and branches?  Any white papers out there that explain this?
Thanks

I have the following table:
Column 1   Column 2
A            A
A            B

We have standardized on Hyperion as our reporting tool.  So far I have
only set up a couple of Access databases as data sources for it.  Now
there is a request to report off our eOn (telephony management) SQL
Server database using Hyperion.  The eOn SQL Server box is in a

I have several default constraints defined on a table.  When I use the
Object Browser and expand the constraints for this table and
right-click and then select "Script Object to New Window As Create", a
create constraint statement for a different default constraint is

Sybase and DB2 both have the capability of tracking user activities at
a number of levels: invalid access attempts to databases, table, etc.;
creation/deletion/modification of database objects/users/groups,
grants/revokes.

I am trying to use the bulk insert command but I am getting the following
error:
---Begin Error Msg---
Server: Msg 4867, Level 16, State 1, Line 1

I am always confused about what to use as the key for a table.
Let's say I have a company-employee table.
[company]---*[employee]
My co-worker likes to use an AutoNumber or Counter as the key for the

I have one table with 300,000 records and 30 columns.
For example columns are ID, COMPANY, PhONE, NOTES ...
-------------------------------------------------
ID - nvarchar length-9

I would like to query tables from two databases (Vista and VistaPortal) and
would appreciate help on how to right the query in SQL 2000.
Please accept my appreciation in advance.

I am getting a type mismatch error when I do a bulk insert.
---Begin Error Msg---
Server: Msg 4864, Level 16, State 1, Line 1
Bulk insert data conversion error (type mismatch) for row 1, column 14