5 samples are analyzed for lead in three different tests. Not every
sample is necessarily analyzed in each test, resulting in gaps in the
table.
create table results

If I want to do it where is the catch 22 ?

I encounter a weird locking problem but it does not seem to be a
deadlock problem.
My server program is written in Java with JMS (activeMQ) and MS Sl
driver. The direct problem is that the JMS queue processor stop

I have a problem trying to set up permissions for a user at my
office.  He wants to use Microsoft SQL Server Management Studio to
view data but does not want any ability to modify the data in any
way.  The stated conditions are non-negotiable so responses like

We are a small pharmaceutical company and we have to gather many
documents and to be able to retrieve them quickly as needed.
Documents are
1- Scientific pubblications and studies, Clinical studies, saved web

I have a table called Accounts_History that has 10860150 rows right now
and when I run DBCC SHOWCONTIG ('accounts_history'), I got this result
DBCC SHOWCONTIG scanning 'accounts_history' table...
Table: 'accounts_history' (965578478); index ID: 1, database ID: 11

Good day. I am having a SQL Server connectivity issue as below: -
web.config
----------
 <connectionStrings>

How or when does a clustered index update?  i haven't done much with sql
server and am trying to figure out an intermittant problem on sql server
2005.  This database has a table that gets written to from a web service
using an insert, the new records replace existing entries.  ...

I am a newbie to SQL Server, I'll apolgise for that 1st.  My problem
is that the following sql does not seem to work.
SET ANSI_NULLS ON
GO

I have dysfunction in SQL Server 2008 Express
I'm sorry to bother you, but I have no one else to ask.
I installed on my computer C# 2008 Express and SQL Server 2008 Express.
And I cannot change values in database tables.

is there a rule of thumb what is better/faster/more performant in SQL
Server 2005?
a) SELECT * FROM A INNER JOIN B ON B.ID = A.ID AND B.Cond1 = 1 AND
B.Cond2 = 2

Just a quick question on the availability of debugging stored procs.
At the moment, if I have an issue, what I do is firstly work out what
the SP is doing. Then I look over it, looking for an abvious error
(We're assuming wrong data is being returned). If I can't spy the

I have an Access 2002 front end that is connected to an SQL Server 2000 back
end.  The ODBC links connected to the front end are DSNless and have
indexes, so they are updatable.  When I try to modify information in the
table (accessing the table directly through the database ...

I'm working on a Windows 2000 machine which hosts a SQL 2005 Express
Database.
This database is backed up using the following method -
http://www.sqldbatips.com/showarticle.asp?ID=27

hello, i can login to our network as administrator
and windows authetication works fine for sqlserver 2005
when i change to a reg user, i get the cant
generate sspi context error when loging on with