INFORMATION_SCHEMA is an ANSI standard, so it should work on most RDBMSes, although I've never tried it on other vendors' platforms. It certainly works on SQL 2000 and 2005.

John

Was there a transaction running at the time you tried shrinking? What was the original size of the log file (ie when you created the database)?

John

Only shrink your log file if you're sure it's never going to grow to its current size again. Otherwise you waste processor and disk resources when it re-grows and...

Darryl Sibson (5/14/2008)

---

I've tested this already in our training environment which is why I use a backup device. Rather than doing each transaction separately I can roll back the...

Doing differential backups will reduce the number of backups to be restored from and make it...

Yes, it does. If you're looking for values that start with "LONDON",...

If you don't use brackets (parentheses), the conditions will be evaluated in the order they appear. So WHERE condition1 AND condition2 OR condition3 OR condition4 is the same as WHERE...

Might be an idea to recycle your errorlog every week or so to prevent it from growing very large. But I agree with the others - don't restart SQL...

MD (5/12/2008)

---

Agree with Steve, collecting 2G of changes in 20 minutes is a heck of a throughput. What I suspect is that your log file size is already 2Gs...

But be careful if your INSERT..SELECT..UNION ALL... statement is very big or your transaction log is very small.

John

Are you using the /3GB switch in your boot.ini file?

John

Please post your code.

Thanks

John

I think a better way would be to store the results of sp_helpsrvrolemember into a temp table, then LEFT JOIN syslogins to that so that you also get logins that...

OK, hopefully this should get you started. Please post again if there's anything you don't understand.

You can use ROW_NUMBER or RANK (read about both of them and decide which...

You're going to have to try harder than that if you want any of us to be able to help you. Please show us what you tried, and state...