Sorry I can not be any more specific, but if you enter 'sp_getschemalock' in the search window in the upper right hand corner of this forum page you will...

rjv_rnjn

Thank you for sharing your code. Hopefully it will assist other members of this community who have the same or a similiar problem ...

BobMcC

Be sure you and your user read this BEFORE installing SSMSE server

http://blogs.msdn.com/billramo/archive/2009/02/20/sql-server-2008-management-studio-express-released-to-the-web.aspx

BobMcC

Since Express is a free download, why not try using and find out.

From the SQL Express download site at:

http://www.microsoft.com/express/sql/default.aspx

The same advanced database engine as the other editions...

Look in Books On Line for the function @@Rowcount

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/97a47998-81d9-4331-a244-9eb8b6fe4a56.htm

Matt Whitfield

there are people starving in africa, people who are persecuted day in day out in too many parts of the world to even list. I think it's quite easy...

You are correct about doing a...

Not the most efficient method, but you may want to try this:

SELECT DISTINCT colorCode1 FROM #T1

IF @@RowCount = 1

BEGIN

SELECT id,colorCode2 FROM...

This article and the contained T-SQL statement may help you identify what T-SQL may be creating your problem.

What SQL Statements Are Currently Executing? By Ian Stirk, 2008/10/28 ...

Zumao1

You may want to read this excellent article by Gail Shaw and alter your database backup mode and/or timing of log backups. The aricle contains a very clear explanation...

From a previous forum post on the same question (by another individual), but my answer to that question at:http://www.sqlservercentral.com/Forums/Topic786999-149-1.aspx

I strongly suggest that you use Books On Line starting with:

Backward Compatibility...

I strongly suggest that you use Books On Line starting with:

Backward Compatibility

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/4760732b-aa3c-4f07-96ec-ba920476dd69.htm

Reading each subject listed on that page, paying particular attention to the fact that your can not...

The problem lies within Excel as acknowledge by Microsoft. Read this

Article ID: 244435 - Last Review: February 19, 2008 - Revision: 6.1

How to reset the last cell in...

Look up the LIKE operator in Books On Line and pay particular attention to the use of the ESCAPE modifier.

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/581fb289-29f9-412b-869c-18d33a9e93d5.htm

CREATE TABLE #Td(

ClientInfo VARCHAR(50)

)

INSERT INTO #td(ClientInfo)

SELECT 'TEST1 1, 0001' UNION...

If you elect to use a trigger or a single procedure to insert into the 2nd table, read the following.

SQL Server 2005 Books Online (September 2007)

SCOPE_IDENTITY (Transact-SQL) ...