We've been here before! (in oneof the Yukon forums I think).

This was the answer I gave then...

For a cheap but very workable soultion, try installing one of the freeware/shareware pdf...

Don't forget that although individual varchar or nvarchar fields can have a length of 8000, there is also a limit of 8000 characters total on the row. If the total...

I have a stored procedure sp_Restore which I use for this purpose, see code below. A couple of notes:

1. all my transaction backup files are titled DBNAMEtransbak, so the DBNAME...

Ooops!!  Just goes to show you need to test with every possible option!

BETWEEN does a string comparison and would allow anything beginning with 'A' ..'Y' .

However, I anwered

ALTER TABLE employee

ADD CONSTRAINT CK_minit

CHECK (minit LIKE '[A | Z]' OR minit = '...

Try changing David's example to create first a temporary date table covering the date range in which you are interested. You can then cross join taht to the SINFORM table...

Do you have a case-sensitive collation? We use a binary collation and I have had problems like this when the domain/username selected from a browse window is imported with a...

Print Screen is OK for small diagrams, but if you have spent ages laying out the ERM for a huge database, you then have to zoom out to fit it...

In our cluster all the access is granted via membership of domain wide groups. We don't use groups local to the cluster member nodes at all.

Hi Larry,

Couldn't agree more. I am in the process of building a new production box, and it has 2 mirrored drives for the OS and program code, and a RAID 0+1 drive...

Hi Paulo,

I checked out that URL, and it does provide an expanation for what happened; between shipping logs I had done some SERIOUS rebuilding work on indexes etc, to fix...

We have our production servers configured so that the transaction logs are on RAID 0+1 disks. I answered (incorectly) RAID 0, and as you stated in your answer, "RAID 1...

All the resources for the virtual servers are installed on cluster-managed resources, and are thus owned and run by only one of the nodes at a time. They are 'virtual'...

The virtual server is Server1 on which is running a SQL instance Server1\SQL1 (or just plain Server1 if it was a default instance instead of a named instance)

Thanks Alzdba, there's some really useful information there.