Since July 2008 I have been telecommuniting with the required trips for deployments and team meetings. I love it for obvious reasons. 1) Saves my vehicle from all the wear...

I put one together sometime ago but this is by far much better then what I had pieced together, matter of fact this puts mine to shame.

Thank you for...

I have shrunk the log before but never the database. If the recovery model was set to Full I would change it temporarily to Simple then perform the shrink which...

Just for inquiry purposes, was this a database that was recently created? Run this exec sp_helpdb 'database_name' it will tell you the size of the data and log files for...

It turned out to be an email relay authorization of the server. Once the server's ip address was authorized for email relay in the Exchange Hub Transport all subscriptions were...

Have you had any luck with this since you posted? I am running into the same wall. The subscription sends emails within the domain just fine, but as...

Yes you are correct it recalcs.

I like to use computative column with datediff to calculate the age.