Have you tried setting the transaction isolation level?

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

Do this inside the body of the stored proc, before you declare the cursor.

eseosaoregie (10/28/2008)

---

Could you explain briefly how I give NTFS permissions (at the folder level) to the account that runs the SQL Server services on the secondary server. What is NTFS...

eseosaoregie (10/28/2008)

---

I am currently studying for my SQL server exams. I am currently going though McGraw Hill.MCITPDatabase.Developer.All.in.One.Exam.Guide. I am currently doing an exercise on log shipping. I have created 2...

siddartha pal (10/28/2008)

---

It appears from the records in db that we are not getting the correct value. Is that possible that some other transaction is also inserting the value after...

siddartha pal (10/28/2008)

---

We are inserting values in table A and there is a ID col on the smae table. After inserting the value, we need to get the value of...

FreeHansje (7/22/2008)

---

Tnx for answering, I will give this a try.

I am still curious why the file is chopped up. Is there some setting I should check? Tried to find info...

I'm not sure if there's a way simple way to concatenate the files. But you could automate loading them all into a table.

Use xp_dirtree to get the list of...

Martin Harrison (7/16/2008)

---

All,

Recently a victim of a sql injection attack on our server. The exploit queried the sysobjects table and then pasted malicious code throughout varchar/text field of our database.

What...

In this situation what you'd want to do is normalize a little by splitting the table into two tables.

You'd have one table, called Course (for example) that contains all of...

That will work. However, it's not...

That's correct

exec master..xp_cmdshell 'SET USERNAME'

That will give you the user that the cmdshell is running under.

Apparently there was a bug that caused this option to be set to OFF whenever an index was created with management studio. This has been fixed in sp2.

The default...

It's been a while since I've used xp_cmdshell - and you shouldn't really use it - but I think that when using xp_cmdshell you're going to be running in the...

As you've noticed SQL Server datetime types include the time as well. So you'll have to take this into account. Try this:

select count(datetime) from XYZ where datetime between...