Grrrrrrrrrr, I've just answered the same question on

http://www.sqlservercentral.com/Forums/Topic548775-149-1.aspx

And there is another one at http://www.sqlservercentral.com/Forums/Topic548774-386-1.aspx

Please do not cross post in the future, your answers will be scattered around and difficult...

Grrrrrrrrrr, I've just found your other two posts with the same question. One of them was already answered!

http://www.sqlservercentral.com/Forums/Topic548780-145-1.aspx

and

http://www.sqlservercentral.com/Forums/Topic548774-386-1.aspx

Please do not cross post in the future, your answers be scattered...

In the first case you do pass in apostrophes, so this will not match.

Your next mistake is:

declare @phone char(20)

Note that you create a char(20), which will be 20 characters...

Posted and answered here: http://www.sqlservercentral.com/Forums/Topic548871-146-1.aspx

If you cross post, then the answers may be difficult to find for others.

- Andras

If you do not have very large tables then table partitioning is most likely to be useless for you. If you do, it may be a lifesaver. This is just...

run:

isqlw

You may actually want to consider...

If you need this data in retrospect, you may be able to dig out stuff from your default trace on 2005. You can run

SELECT *

FROM ...

You could try "LEFT JOIN"

Regards,

Andras

Le Rhun Philippe (8/7/2008)

---

[font="Times New Roman"]Hello,

I'm looking for the way to change default values for those two option in SQL Server Agent Properties :

Maximum job history log size ...

Yes, it does. You can find out approximately how much space it will require by running checkdb...

First make sure that your table indeed has the columns you want to be in the pk as the pk columns:

SELECT i.name

, ic.index_column_id

...

And a reference for...

If you rebuild the index then it will update the statistics. If you just reorganize them, then the statistics will not be updated.

Regards,

Andras

saurabh.punn (8/5/2008)

---

Hi All

Tis is the result:

"sp_dbcmptlevel 'myDBName'

go

select @@version"

The current compatibility level is 80.

...

Vijaya Kadiyala (8/5/2008)

---

Hi,

All these queries are tied to the Customer ID, If i know these values in advance then i can use PIVOT or CASE to convert the rows into...