Ahh, so the problem was blanks/empty strings.

You may also want to look at converting this subquery in the where clause:

( SELECT MAX(R.EstDate)

...

I've never used litespeed, but if you restore to a new DB you can just run an update statement across DB's using the PK's to update the single column.

You will need to go through each of the users and add their new domain account. I'd script out all the logins and permissions and then edit the script...

Are you storing data on the mobile devices or are they connecting to a central database as needed?

Will the shared data be changed in both applications or just the accounting...

I think the error is fairly clear, you have some data in the flat file that is too big for the int datatype. What I normally do in these...

I don't miss mine at all. I can always write something in SQL Server that will do this...

I agree with John and Prasad in regard to the function. If you are creating a view or views you can put the case statement directly in the view...

THis query won't work unless you have...

You also need to look at the lock events, CacheHits, and Recompiles in Profiler. It may be taking time because of these reasons as well.

What is the...

I don't know of anyway to reliably get this information from any of the system tables.

I can't imagine NOT having SQL Server Agent jobs that are checking things. I've used jobs, and even some RS reports with subscriptions to monitor data integrity. I...

What we have done is create an Encryption DLL in .NET that is used in the UI (actually businaess layer) that we signed so I could use it in SSIS....

I just guessed on File Numbers. I gave you the wrong command earlier. You want the RESTORE HEADERONLY which has the File Number in the POSITION column. ...

This worked for me:

Declare @Reccom table (KeyValue varchar(20), USerTitle varchar(25), Date varchar(14), Details varchar(max))

Declare @temp table(row_id int,KeyValue varchar(20), USerTitle varchar(25), Date varchar(14), Details varchar(max))

Declare...