Click here for Vacation Photos

Archive for the 'MySQL / MSSQL / Postgre' Category

Rename SQL DB

Wednesday, June 25th, 2008

To rename a MSSQL database, run this code in Web Analyzer::

sp_renamedb >oldname< , >newname<

remember you must first make the database accessible by ONLY  -m “one user”
then you can run this SQL script…

SQL BAK restore

Wednesday, June 25th, 2008

DBconn config file

Thursday, June 19th, 2008

PostgreSQL vs MySQL

Monday, April 14th, 2008

Alias

Friday, December 7th, 2007

JOIN defined

Friday, December 7th, 2007

Select Statement

Friday, December 7th, 2007

Cart Capture

Thursday, December 6th, 2007

SQL SaveOut DB Snippet

Wednesday, November 14th, 2007

MySQL Installation

Tuesday, October 9th, 2007

DataReader Facts

Wednesday, December 27th, 2006

New UserConn

Sunday, October 29th, 2006