JacekO (2/20/2009)

---

ALZDBA is probably right and the 1=1 is because of the dynamically generated SQL Select by the user interface.

My comment is that such a technique is a BAD,...

Those shouldn't be a problem:

http://support.microsoft.com/kb/917828

karthikeyan (2/20/2009)

---

The statement like......

select top 100 * from xyz

where 1=1

AND (sid IN ( 111 ) or oid IN ( 089 ) )

and timein >= N'02/02/2009...

Probably that sql statement is being generated dynamically.

Some bright minds use it in their starting where clause because they don't know if other conditions will be added.

It guarantees the where...

That's just SQLServer performing the internal db upgrade at restore time if your backup originates from a lower version.

That also occurs if you attach a db from a lower version.

And...

Judy (2/19/2009)

---

It was not related to SP3 installation. We used to have one big physical drive which crossed two Arrays. And then this physical drive was seperated into three logical...

what software level are you on ?

select @@version

You are using a login that is member of the sqlserver administrators group, right ?

Judy (2/19/2009)

---

Actually, I applied SP3 at my new active/passive Cluster server and did test. Everything looks fine for SP3. But our SAN was broken somehow and every setting on both...

russell.sage (2/19/2009)

---

On this subject I have a quick question. I can't recall since it's been awhile since I've seen an install of SQL but is it possible to apply...

Check "Monitoring Mirroring Status " in Books online to start with.

It explains there is a whole set of tools to serve you.

Thank you for the confirmaton.

I did set it to checksum on the upgraded databases.

Shouldn't be necessary on SQL 2005 or...

Another save point has been set 😎

I know (and have activate on all our db) PAGE_VERIFY at db level.

Is my perception correct that this would detect any issue as...

We doublechecked all clustered things were hosted on the same node.

(quorum + instances)

- shut down all applications that use sqlserver (because you know the instance(s) will get offline at some...

We use this sequence:

1) restore the db to SQL2005

2) DBCC for DATA_PURITY

3) switch to dblevel 90 (if possible)

4) rebuild all indexes (individually)

5) dbcc updateusage with count_rows

6) sp_updatestats

7) synchronize users

8) create...

rhjohnson (2/17/2009)

---

Thank you, ALZDBA. I have made adjustments to my database as you suggested. The only thing I left null was the ModelID in the tblPDF because I...