EDIT- Whoops. Made the @@Version comment about the wrong post. My bad.

I need to see a shot of the variable from the variables window AND the entire properties box when...

Try naming the Transaction. See if that gets around the error.

Also, what you wrote makes no sense. You have a transaction with no way of backing out if there's...

sonal_anjaria (6/16/2011)

---

It is a Execute SQL Task. Trying to move tables from a sql server staging database to a production database

I have created two variables at the container level, not...

Sqlchicken (6/16/2011)

---

viduvs (6/16/2011)

---

Thanks for your reply.

I was having the same solution to install a new fresh instance and then configure the things.

Though we don't have a backup (even external backups),...

Lowell (6/16/2011)

---

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know...

princa (6/16/2011)

---

Lowell (6/16/2011)

---

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i...

I wish I could tell you otherwise, but unless you've got some other availability set up (log shipping, Database Mirroring, etc.), you're stuck doing it the old fashioned way.

Has anyone actually written an SSC article on how to write up and submit PASS abstracts?

I know I'd be interested in seeing the process as my abstracts tend to suck....

I like using subqueries and an Identity column. If you don't have an Identity, add it to the table. Then join the table to a subquery searching for the MIN()...

"Error" is a generic term in the SQL Server logs. You need to look at the Severity in order to understand if you're reading a true error or an informational...

DUPLICATE POST! Please direct all responses here: http://www.sqlservercentral.com/Forums/Topic1126304-149-1.aspx

We definitely need more information. If that is all the information, though, then FYI: Pivot does not work if you don't have something to aggregate on.

You need to SUM()...

viduvs (6/16/2011)

---

Hi folks,

This is some critical issue we are facing in our production environment.

We have a production instance which was installed on SAN-LUN.

Somehow that LUN got deleted, and now SQL...

Don't just check the application log. Check the system log. It is more likely to have relevant information.

Also, the security log might give you information on who or what was...

Look into BEGIN TRANSACTION and END TRANSACTION. You'll probably want to name it. Try using the "new" TRY - CATCH functionality for error trapping.

You can find information on both of...