If you use a cursor then you can get locking issues because the table is held open while the cursor runs.

My looping code only locks the record that is selected...

Your log file won't shrink if it has uncommitted transactions in it.

Any mass inserts, deletes, updates will cause the log file to grow significantly.

Try the following

CREATE FUNCTION dbo.fnGetNode (

@lNodeId Int --##PARAM @lObjId The parent node for which children will be retrieved.

) RETURNS @tblNode TABLE (

ObjId Int PRIMARY KEY ,

ParentId Int

)

AS

BEGIN

DECLARE @lNextNode Int

SET...

If you put SET FMTONLY ON in the head of a query then no results will be returned, only the column headers.

If you put SET FMTONLY ON in the head of a query then no results will be returned, only the column headers.

I take it that the machine works fine when NOT using the application?

Thank God it was repeated!

In the book on presentations "I can see you naked" it poses the question "should you ever smoke during an presentation"?

The answer was an emphatic NO. The argument was...

DBCC CHECKIDENT ('your table',RESEED ,your new identity value)

Your variable is out of scope hence the problem

Why not simply put

SELECT @Count = COUNT(*)

FROM app_client

WHERE first_name = @name

AND last_name = @Last

WOW!!!!!!!

I would never have believed this could be done so quickly!

Can I ask how you generated the Schema? Is it via a tool or is it manually via an...

Thanks, I should be extremely grateful for any help you can offer.

Well the schema I came up with looks like this

<?xml version="1.0" ?>

<Schema xmlns="urn:schemas-microsoft-com:xml-data"

xmlns:dt="urn:schemas-microsoft-com:xml:datatypes"

xmlns:sql="urn:schemas-microsoft-com:xml-sql" >

<ElementType name="BetID" dt:type="string" />

<ElementType name="CustomerID" dt:type="string"...

The problem with the UK tidal power is building something strong enough to last. There was an experimental tidal turbine on one of the isles off Scotland. It...

I know that you can get LED bike lights. Scarily bright and run for ages on a small battery. compare that to Lead acid halogens which only last...

My personal preference would be to have the nights backup files stored in a particular location.

When the user selects the database they want to copy they get a restore of...