Posts Tagged ‘SQL’

SQL tip for ProLaw Queries: LEN and DATALENGTH on different data types

Wednesday, April 10th, 2013

When queryuing various information from ProLaw through reports or the SQL Management Studio, its important to know which fields are TEXT, VARCHAR, or other forms of strings as the functions used to call the data can vary.

Tags: , , , , , ,
Posted in ProLaw Case Management, Technical | No Comments »

Importing data to ProLaw from Excel

Thursday, February 7th, 2013

We recently had an issue were we were importing data from Excel sheets into a staging table in SQL, then importing that data into ProLaw.  Some of the fields in excel were getting truncated and causing issues on the imports.

Tags: , , , , , ,
Posted in ProLaw Case Management, Technical | No Comments »

Prolaw and SQL Replication – Creating, Breaking, and Updating Prolaw

Monday, January 30th, 2012

This guide will cover the various aspects of replication for a Prolaw SQL server.  If you have a replicated environment and are updating any aspects of Prolaw such as the custom tabs or updating Prolaw itself, you will need to stop replication first.  You may also refer to this guide if you need to set up a replicated environment.  This guide will focus on the SQL portion itself, assuming you already have the document shares replicated via DFS or other means. You may refer to other posts on this blog on how to set up test versions of Prolaw or how to install updates.

Tags: , , ,
Posted in ProLaw Case Management, Uncategorized | No Comments »

Page 1 of 11