*cool* 😎

http://www.sqlservercentral.com/search/?q=backup+all+databases&t=s

Well it looks like we might have an SSC party at the PASS Summit after all for those of you that are going. No deal with PASS, but we'll likely...

There are quite a few on the site. A search will turn up many.

Here is one: http://www.sqlservercentral.com/scripts/T-Log/69750/

For service broker, you'd essentially run a piece of code in SQL Server, which would put a message in a queue. I think that might be overkill for this. If...

The way I've usually done this is create a table to store a message of some sort. Could be a bit, could include a user, time, etc. Then what I...

Jeff Moden (8/16/2011)

---

You're absolutely barking up the wrong tree with me on that subject. 😉 For...

800GB isn't really a monster. There are 1TB drives these days and lots of backup products are built to handle multi-TB backups.

Best advice, use backup compression first. If you have...

cengland0 (8/16/2011)

---

I really want an SSD for personal use. I've seen demos for booting up computers where slower computers with SSD's boot 45 seconds faster then a faster computer...

completely agree. There ought to be better interfaces here

I would expect you to use sp_change_log_shipping_secondary_primary (http://msdn.microsoft.com/en-us/library/ms180034%28v=SQL.100%29.aspx) or sp_change_log_shipping_secondary_database (http://msdn.microsoft.com/en-us/library/ms177507%28v=SQL.100%29.aspx) to change the settings for the secondary server.

The easy way to do this is use the identity property.

You don't need to insert a value, SQL Server will calculate an incrementing value.

CREATE TABLE MyBigInt

(

MyID bigint IDENTITY(100000000000000,...

Thanks, we'll take a look

Thanks for the update. I believe for all OS versions, you need to log off and log on for new variables to appear. In your case, it would depend on...

You shouldn't have to restart SQL Server.

An environment variable should be read when it's accessed. Depending on how you created it, it's possible that it needs a new logon...