hardware

RE: Database Wizard to copy from SQL7 to SQL2K ???

• by mybid2003

• TechNet Blogs

• Reply

Thank You.

2003-05-08

RE: Maintenance Plan Bug?

• by jguff

• Tom's Hardware

• Reply

Ignorance is my only defense - Should I avoid Personal Folders, if so, how do I remedy this?

2003-05-07

1 reads

RE: Maintenance Plan Bug?

• by Brian Kelley

• Tom's Hardware

• Reply

This is a MAPI issue and can occur in Outlook as well, so it's not specifically a Maintenance Plan issue. Is there a reason you are using Personal Folders (which is represented by the .pst)? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

2003-05-07

1 reads

RE: Number of columns allowed in sqlserver 2000

• by PBirch

• Tom's Hardware

• Reply

Check out the section "Maximum Capacity Specifications" in BOL. That has limitations and capacities for all version of SQL Server 2000. Patrick

2003-05-07

1 reads

RE: Using the 'LIKE' comparison

• by Scout7

• SQLServerCentral

• Reply

Thanks evorsten, these links are very helpful. Just a side note, I have been looking into the collation settings of my SQL installation and notice that there is an option setting for 'ACCENT-INSENSITIVE/SENSITIVE'. Before I start looking into rebuilding all of my databases in order to change the collation settings, would having this option set […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-06

RE: Using the 'LIKE' comparison

• by evorsten

• SQLServerCentral

• Reply

DoubleMetaphone is a kind of Soundex, but more powerful. The original article describing the method can be found at: http://www.cuj.com/articles/2000/0006/0006d/0006d.htm?topic=articles A translation of this function in T-SQL can be found at: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=519&lngWId=5 It is quite an elaborate function, but the nice thing is you can improve it yourself. I myself use this method in a […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-06

RE: Not for Replication seems to be ignored

• by jonespm

• TechNet Blogs

• Reply

Hi Jay, Ok, we have restored the database and published one article (tblACNAcntCodes). The snapshot and creating the subscription worked fine. See below for the two triggers involved. AAAA is our own trigger and BBBB was added when we published the table. The "EXEC master.." was added to both triggers so we could log what […]

2003-05-05

1 reads