hemanth T (1/9/2011)

---

when i tried to execute chained state of stored procedures.

system encountered exception error no:266

with following message.

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is...

They had to have been referring to ad hoc, client side code. A parameterized query or a stored procedure are basically the same thing, so you're already on the right...

Who knows. Could be anything. Maybe it's a nested transaction and starting another one causes an error. I'd just place it inside the TRY statement, just in case. One example,...

I wouldn't necessarily jump off a building yet. There is specialization, and this product is so absolutely huge, that no one is going to know everything. But you can be...

If you perform the update within a transaction, other users should not be able to access.

Are you doing this to create an identification generation engine? Or, to put it another...

I agree with what everyone else has said. I think they've caught the obvious stuff. Now, to keep going, can you post the execution plan from the query, preferably after...

I'm not seeing anything radically different either.

The only exception is, I'd move the BEGIN TRAN inside the BEGIN TRY statement so that if there are errors on the initiation of...

OK. I've narrowed it down a bit. It's not a limit on number, it's specific feeds from SSC. The 2008 backup forum doesn't work, but the General & TSQL ones...

Thank you. I hope the book has been useful.

There's also Red Gate SQL Virtual Restore, that would allow you to "restore" the database to a different location and pull the data off. The nice thing about this is,...

You have a lot of options. We do this at work just using the nightly backup to perform a restore. It does two things. It gets us that test environment...

I would be extremely cautious about taking the missing index reports at face value. They are frequently more than a little bit inaccurate and can lead to too many indexes...

pascalbjr (1/7/2011)

---

Well, good point there. We need row locks for several critical tables updated by our application server, to serialize access to them, and avoid deadlocks due to some denormalized...

Another vote for Red Gate tools. They're pretty amazing. They primarily will help in development and maintenance. In terms of performance, they have a new tool, SQL Monitor that will...

Craig Farrell (1/7/2011)

---

Donalith (1/7/2011)

---

I was told that both types of restore require the same space requirements. Is this true? If I have a 400 gig database do I need another...