My application is to capture employee locations.
Whenever an employee arrives at a location (whether it is arriving for
work, or at one of the company's other sites) they scan the barcode on
their employee badge.  This writes a record to the tblTSCollected table

How can I check (from TSQL) if a table is likely to bust the 8k limit?
Thanks
Mike

Wonder if you could help, I have a bog standard table called STOCKPRICES
that has served me well for a while, but now I need to change the structure
of it and because a number of users have used it in it's present form I need
to so the following in SQL script:

I am self taught in Access using the Jet database, and am now looking at
upsizing my databases to SQL.  I know enough to be dangerous, but not enough
to probably do the job correctly or get the most functionality out of SQL.  I
am looking for any training suggestions that you may ...

I am currently undertaking a review of the primary keys in a SQL Server
2000 database with a view to improving performance of queries.
I have heard that, in the case of compound primary keys, it is
important to select the correct order for the columns within the key.

Hi, is there a SQLServer utility or tool to equip regular non-techie users
with the ability to create, run and save their own reports?
That would be similar to the Webintelligence product of BusinessObjects:
It's basically a graphical drag&drop tool for creating SQL queries with ...

   We have a third party tool which maintains its own custom
database,DB1 on SQL Server 2000 on Server A (Windows 2000). We built an
inhouse application which maintains a transactional database, DB2 also
on Server A derived from DB1. Since the DB1 is frequently updated the

I want to select on the value of a portion of a field, rather than the whole
field, and I want it to be case insensitive.
For example, let's say I'm searching on field A1, and I want to find all
records where the first 7 characters (regardless of case) of A1 are

We have an asp.net app with about 200 data entry forms.  Customers may
enter data into any number of forms.  Each form's data is persisted in
a corresponding sql table.  When data entry is complete, it needs to be
processed.  Here's where the questions start.

A problem of security:
From a vb.net form I created the chance to add an SQL Server user with role
as administrator.
To create it, username and password are retrieved from two text box and then

I am running SQL Server 2000 with SP 4 on Windows Server 2003.  Every hour I
receive several notifications with the following:
   Reply: Message not found. Insertion strings:Error: 17805, Severity: 20,
   State: 3 Invalid buffer received from client.

Is there a place where I can find a database with countries-region-cities of
the world?
Country code - country name - region (state or province...) - city name
Eventually, I'll look for GMT- currency- country telephone code-city

I'm having trouble with an ODBC User that can't connect to 2003
Windows Server with SQL2000.
The ODBC fails when he tries to contact with TCP client connection.
When I view the Network Connection it is displaying TCP is checked,

I've read a whole slew of posts about creating temp tables using stored
proceedures to get the crosstab ability, but I'm wondering if, for this
specific case, there might be a more efficient way.
What makes this question different from the others that I've read is

I need to produce with T-SQL a user defined function or stored
procedure that make one SLQ-Statement and prepare as string from the
result set.
The request muss be able to return a very long unicode string. The