From what you have posted nobody can offer much help. The description is pretty vague and there is nothing to work with. Please see the first link in my signature...

Don't shrink tempdb. You are asking for problems doing that. You can end up causing yourself all sorts of problems.

Here is one link that refers to the issues.

http://support.microsoft.com/kb/307487

http://sirsql.net/blog/2011/5/18/dont-shrink-tempdb.html

Search around for...

Now for the mechanism you suggested to work robustly it would depend on the sql server client being able to verify back to the server that it has received the...

You have...

blakmk (10/8/2012)

---

Having tested it on a very large table. The transaction rolls back. Although i know there is sql process that kicks in periodically to rollback transactions. However not sure...

+1

Especially since this an ASP.NET application using transactions like this is incredibly...

Or for an even better approach don't use pass through sql from your .NET app. Instead use parameters. From the issues you are facing it is very likely that your...

blakmk (10/8/2012)

---

I have a requirement to return a batch of records and then mark the batch complete. I was thinking to acheive this with a select and the update. Something...

The code looks ok. It is impossible for us to know if it is correct though. You need to figure out what the error is. This can be somewhat painful...

bitbucket-25253 (10/5/2012)

---

Sean Lange (10/5/2012)

---

ben.brugman (10/5/2012)

---

bitbucket-25253 (10/5/2012)

---

I have what I call a sandbox DB to hold scripts, some T-SQL and have it set up so as to be able to search...

David_D (10/5/2012)

---

[font="Arial Black"]Regarding this book:[/font]

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer) [Paperback]

Paul Turley (Author) & Dan Wood (Author)

[font="Arial Black"]Which SQL Developer Edition...

You're welcome. Glad that worked and thanks for letting me know.

54.69.6d.20 (10/5/2012)

---

Sean Lange (10/5/2012)

---

54.69.6d.20 (10/5/2012)

---

hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried...

This should work based on your example.

create table #SomeTable

(

[ACCOUNTKEY] [int] NOT NULL,

[ACCOUNTSERVICEKEY] [int] NOT NULL,

[SERVICEOPTIONSKEY] [int] NOT NULL

)

insert #SomeTable

select 1000, 1050, 1016 union all

select 1000, 1051, 1020 union all

select 1000,...

54.69.6d.20 (10/5/2012)

---

hmm.. DMZ is off on the firewall and doesn't make sense why other machines are working right now. BUT... I am getting a new error. Tried it on the...