Yup.

They're...

Nothing wrong with the question,...

Reposted here: http://www.sqlservercentral.com/Forums/Topic769257-5-1.aspx

If you insert rows into a temp table in SQL and commit the transaction, the rows will be in the temp table until they are deleted or the temp table...

WilliamB (8/12/2009)

---

Similar problem here, I need to find out if the database logs will indicate that a database has been recovered and I need to show the log as proof...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769118-5-1.aspx

Why don't you test both options and see which is better? Offhand, I can't say which'll be faster.

Sorry, don't understand what you're asking. Transaction behaviour for Temp tables is pretty much the same as for normal tables.

Please read through this - Managing Transaction Logs[/url]

Try backing up to the local disk and then copying the files over the network after. It only takes a small network glitch for the backup to fail.

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769118-5-1.aspx

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769118-5-1.aspx

Top's not going to work here. Since you're using SLQ 2005, you can use the ROW_NUMBER function. If you can post table structure and sample data I can write a...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769125-1291-1.aspx

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic769122-5-1.aspx