It is not a bug.

The documentation specifically states that databases in 7.0 compatibility mode are not supported by SQL Server maintanance plans.

I thought that you could create a database snapshot of a mirror that you could use to run queries.

I'm a littel disappointed that no one wanted to play.

Ed Salva (3/27/2009)

---

"convince them your a nut and that they had better stay away from you." -- Grasshopper

never been able to successfully accomplish this, can't seem to get past the...

select * from information_schema.columns where column_name = 'lname'

In the spirit of the completely ridiculous, here goes:

SELECT id, CASE WHEN Abs( Sin(Ascii(Reverse ...

Use a check constraint on the table for the first rule:

( case when col2 is not null then 1 else 0 end + case when col3 is not null then...

select WorkTime = convert(varchar(5),dateadd(ss,sum(Work)*3600,0),114)

from

( --Test Data

select Work = 4.75 union all

select Work = 1.50

...

george sibbald (3/25/2009)

---

...Michael, I like the boot from SAN idea, do you do that?. Our intel guys don't seem keen, saying there are performance problems. Seems to me it would...

It's best to just set the files to equal size, and to set the growth size equal on each file.

As you add data over time, the files with less data...

I try to keep my disagreements with other posters on the level to discussion of the issues and avoid name calling.

Not because I like to take the high road or...

How would you like to see the output, considering that all rows in the result set must have the same number of columns and they must have the same datatype?...

Have you considered boot from SAN? Windows 200 and 2003 support it, so it is really just a matter of finding a SAN vendor that supports it at the...

You cannot use an Exchange server email alias.

Reporting services uses only SMTP format email addresses, so it must be in the form name@company.com

If you reindex the tables in the database with a maintenance plan job, the database data file has to be large enough to hold all the data, plus enough extra...