I don't have a system to try this on, but I think if you change the definition of @c to varchar, you'll find it will work. Remember, a char(10)...

Yep, I was afraid of that...

Thanks for the quick response.

Is there a trigger on the table in the new database that might be recursively calling itself based on data being manipulated?

Am I misreading the problem? Are you sending more than 100000 insert statements as one variable into sp_executesql? One of them is hanging the process and therefore the...

If you're running this inside the SQL Server, isn't it using the SQL Server account as the context under which to run? If so, it may be trying to...

Maybe there is an assumption within the community that the Next Great Leap will be an extension of the Relational Model. I'd certainly like to believe that. It...

I've heard a lot of people who should know better ask for this option. If MS ever implements it I think it should be:

SET CORRUPT_MY_DATABASE_AT_THE_WORST_POSSIBLE_TIME = True

If you do an explicit

BEGIN TRAN

then select, update or delete something, the locks obtained by the DML statement should be maintained until an explicit commit or rollback is issued on...

The only other thing I'd look closely at is the backup strategy. Does the consolidation introduce any conflicts with backup configurations? Will the larger number of backups require a...

If you're talking about the relational division operator, a decent explanation with some SQL as an example is http://www.dbazine.com/ofinterest/oi-articles/celko1.

I'm not a big Celko fan, but this (and the included references)...

Grant Fritchey (7/23/2009)

---

David Webb (7/23/2009)

---

For the younger crowd, I'd stay away from Delaney. His "Dhalgren" is perhaps the strangest book ever written and x-rated to boot. As a...

For the younger crowd, I'd stay away from Delaney. His "Dhalgren" is perhaps the strangest book ever written and x-rated to boot. As a work of style, construction,...

Andre Norton has some excellent material for that age. I'd recommend Star Man's Son.

I'd also recommend Zelazny's "A Night in the Lonesome October" for anyone, like me, who enjoys...

Grant Fritchey (7/23/2009)

---

Another completely off-topic post.

My 11 year old is starting to discover books (YAY! Finally). He just tore through Zelazny's "Damnation Alley." I need more in this vein. Any...

I'd guess not. Wasn't he asking people to vote for an enhancement that allowed foriegn keys to be supported by pointers? I'd say that a true relational fanatic...