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...

1. yes and no. I believe that RBS uses Filestream.

2. I think so, but I haven't implemented this. From my reading, you do.

You do not need to reboot to run a package.

IIRC, the package is scheduled by it's internal GUID, not name, so if you re-created it, you need to rebuild the...

In SQL Server we have the identity property, which is numeric only, actually integer only, and GUIDs.

How do you have an alphanumeric that increases? Does A1 increment to A2? Does...