I have a simple maintenance job that runs at Midnight to cycle the SQL Error Log. That way a Log covers a Maximum 24 Hr Period.

Dear All

Maybe 2008 has a mechanism for doing this but 2005 certainly does not.

These scripts All assume that the Collation of the SERVER is set to what you need it...

Personally I use Red Gate SQL Compare for the Schema Changes. I also use Red Gate SQL Data Compare once the schema changes have been loaded to add / update...

Must get round to writing this as an articel some time. 😀

This document assumes that the SERVER is at the correct collation and that the DATABASE is a different collation...

Hi There

If anyone is interested, I have collected all the required files into an MSI that can be installed onto the PC that is using IE to access an SSRS...

Easiest way to secure SSRS Reports is to set the security of the report on the report server.

Call Up the report

Click on the properties tab

Click on the security menu option...

Hi there

been there done that

As I understand it, you have a database that your client wants changed so that it's collation matches his server collation.

Steps to follow

1. Change Database...

I've been thru this procedure once due to the production and UAT servers having different collations and have worked out that you will need a set of processes defined to...

I'm very lucky in this respect. My current (so far) manager is not from an IT background but rather from a communications one.

At first I dreaded entering his office or...

Got called by work on my honeymoon - Billing run failed due to a HD crash (Company did not implement RAID to save Money). Spent a few hours being stared...

Neat Trick but check out win Server 2008 - It does not have SUBST available so you might have to rethink your strategy.

The best way I have found to make...

Very usefull to have the master app

easiest way to ensure that everyone has a current version is to deploy it via the user logon script to copy to a local...

Hi

There are 3 Major areas that you need to be looking at in conjection with your Application Developer. I am assuming that an Access Front End will be used...

Just an extra note

If you are using DBMail with 2K5 you need to apply SP1. There is a known problem with 64bit SQL 2k5 that SP1 fixes.

Hi There

Usually means that the column you are posting into is shorter than the data destined for it