Query Plans

RE: Installing Error: Invalid Instance

• by HenryTr

• SQLServerCentral.com

• Reply

Try running the Setup program from the top level of the CD directory.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-08-15

RE: Suspect Database Issue

• by Michael-Fried

• SimpleTalk

• Reply

Thanks for all the feedback. I could not do a database detach because the database is setup for replication. I ended up restoring an older version of the database and all is fine now. Still not sure what actually locked a portion of that particular log file. When the SQL Server services were shut down...I […]

2003-07-22

RE: comparing specific rows

• by Calvin-Lawson

• SimpleTalk

• Reply

achowe, Why won't Npeeters query work for you? That's a nice little piece of code, deletes all records except the one with the maximum date value. DELETE t1 FROM MyTable t1 JOIN MyTable t2 ON t1.Unique_ID = t2.Unique_ID AND t1.DateField < t2.DateField And, if you have an identity column and you insert earliest dates first […]

2003-07-18

1 reads

RE: MS Access 97: Linking Views

• by Steven-Hollander

• SQLServerCentral.com

• Reply

quote: We are useing MSAccess 2000 with SQL7. We have defined all large fields as TEXT rather than VARCHAR. This may help

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-06-02

RE: How to pronounce SQL

• by David Poole

• SQLServerCentral

• Reply

Obviously America is the king of the acronymn world. I seem to remember that one of the US Navy commander in chiefs has an acronymn for his title of USINCUS. For all the non-US subscribers do we invent any acronymns or do we just inherrit American ones?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-30

2 reads

RE: sp_help

• by Brian Kelley

• SQLServerCentral

• Reply

Put it in single quotes: EXEC sp_help 'PRODDTA.tablename' 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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-05-09