Since its not working different...

Then it is not due to concurrent query issue.... but why it is showing that message.

as

The SQL Server has been...

I am having the sysadmin privileges, ok can be a network problem. Just now i saw my logs an i got this message

The SQL Server has been optimized for 8...

Using this command you can check how many transaction are currently open.

--This command gets you the spid of open transactions.

DBCC opentran

Check how many open transactions are there on the server.

I can suggest you to search on the net or in sqlservercentral for store procedures. You will get lot of codes and sample. This will also help you to find...

CREATE PROCEDURE procname

@value varchar(50),

@value2 varchar(150)

as

INSERT INTO myTable ( )

SELECT COUNT(*)+1, @value, @value2 FROM myTable

The above code which was posted by Gail Shaw is...

Here is the correct...

I dont have much experience in Access DB.....

Since it is a Database.. it should have locking facilities.

What I can suggest you is that ... if you are generating...

Can you let me know the requirement... why you want to lock records.

You can use the sp : sp_getapplock to lock records

for more info visit the link :

I think you are looking for multiple tables and files..i.e. you want to import data from multiple files to multiple tables.

For I suggest you to use the dynamic sql and...

It is not only for master DB.. you can call that sp in any of the database.

Also you can use the shortcut ALT+F1 to view the table design.

You can...

Try this script

declare @TableVariable table(id int,[name] varchar(20))

declare @state varchar(200)

declare @TableVariable1 table(id int,[name] varchar(20))

...

Try this statement :

select issueid, userid, max(createddate) from #tab1 group by issueid, userid

Yes Madhivanan is correct .. it will work fine.

Absolutely YES.. you need to use inner join if you want to insert values from different tables.

The result set which you will get in the select statement... same records will...