Tuesday, September 28, 2010

Can't initialize OCI Toad on Vista

Right-click on the Toad icon and choose "Run as Administrator".

Monday, September 27, 2010

SQL 2008 to SQL 2005 Conversion

1. Create a new 2005 Database
2. Use SQL Compare to copy the Schema. If you copied the constraints, you need to deleted them creating a script using the following:

SELECT 'ALTER TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME +
'] DROP CONSTRAINT [' + CONSTRAINT_NAME + ']'
FROM information_schema.table_constraints
WHERE CONSTRAINT_TYPE = 'FOREIGN KEY'

NOTE: You have to run the output of the SQL above to actually delete the constraints.

3. Use SQL Management Studio “Import Data” to copy large tables (memory error if SQL Data Compare is used).
4. Use SQL Data Compare to copy smaller tables
5. Use SQL Data Compare to generate a script if it does not work within SQL Data Compare and open / run the script in SQL Management Studio.
6. Re-run SQL Compare to add back the constraints

Sunday, September 26, 2010

Court Stuff

The purpose of civil contempt is to compel action rather than punish an action already committed. Bishop v. Bishop, 90 N.C. App. 499, 503, 369 S.E.2d 106, 108 (1988) (citations omitted).

Friday, September 24, 2010

Appealing Civil Case North Carolina

Rules of the Appellate Court Procedure
http://www.aoc.state.nc.us/www/public/html/rules.htm

Cost
$250 Fee
$10 Filing Fee
$1.75 Copy Fee Per Page x2

Notice of Appeal
* Parties taking the appeal
* Order from which the appeal is taken
* Signed by counsel / party
* Served

If case was heard in District Court file Notice with http://www.nccourts.org/Courts/Appellate/Supreme/. Small Claims goes to District Court - search for court form on Web site.

Record on Appeal
Briefs
Motions

Check This Out!

More Links to Good Information