Add this line:

conn1.Open()

Just before ExecuteNonQuery.

The context connection is, of course, already open, but in this case you are opening the SqlConnection object (allowing it to connect to the already open...

Salary history can help or hurt you. My husband (C++ developer) in 2000 was at a position where he was underpaid and the job market was hot. He refused to...

Oh yes, the SELECT isn't required. You're right, of course.

No, I despise VB. I've been working almost exclusively in C# for several years and am not currently a DBA,...

I realize that the author threw in the Age computed column as a test of whether we knew that computed columns take up no space in a row. However, as...

Bert,

I worked for a company that treated its people that way. They were software developers, mostly. A lot of people got "promotions" that added the word "acting" to their title....

Yes, I'm running on a laptop. I hate to change my power settings because sometimes I work without the power cord attached (briefly, this thing has terrible battery life) and...

I got it to work!! There are so many little gotchas with Service Broker. I've made a huge mess of my schema trying all sorts of manipulations. Anyway, this is what...

I'm closer to solving this problem but I'm still having issues.

I discovered where the errors are.

SELECT * FROM

Interesting... I'm running SQL Server 2005 Dev Ed. Your script performs the same on my server. I've been testing it with other numbers divisible by 4, but errors don't occur...

PW provided a good trigger solution.

However, I want to point out that in your original trigger code, the first IF statement is not necessary. In the later query, you are...

It does help, gives me a direction. I've never used SSIS. I know what it stands for and that it has something to do with data import/export. Microsoft's edition chart indicates...

Almost everyone who's posted agrees that anyone who bought the DVDs should expect to pay for them after Amazon figured it out. Many also say that those who noticed the error...

Thanks, Dinakar, for shooting holes in my plans. No, really, thanks. I needed to know that before I went any further in the wrong direction.

My problem now is not technical...

Love the editorial... a lot of good points. The points are general, I see myself in some of the points, but not all of them.

Sports!! You hit the nail on...

I would love to be able to implement a better solution. I wish I could say this project was in design stage. However, it's in PRODUCTION already and the customer...