It's sometime useful to search an entire database to find out where some specific data is... for instance, you entered data into the UI but you aren't sure where it got stored.

This post contains a SQL Script to search a database for any specific string in any column in any table in your database.

To use this script, simply edit the first line to set the @value variable to the string you wish to search for (see the comment).  You can include "%" as the standard SQL Wildcard character.  As is, the script will search for any string starting with "C:\" ... but you can use exact strings or any arbitrary string you wish.

Any suggestions on how to promote from dev to test to prod and manage the database without re-keying the configuration please?

I wanted to ask the Community about the updates below that Windows Update is telling me that I need to install on my Windows 2008 Servers.  I am very diligent about keeping the servers updated with the monthly security patches but I am hesitant to pull the trigger on service pack updates and IE version changes.  I have been burned before with iMIS bombing in some way, shape, or form after a service pack upgrade (be it either to the OS itself or SQL).  I have a two server configuration consisting of a 32bit Windows 2008 iMIS application server and a 64bit Windows 2008 SQL Server 2005/Exchange 2007/Public Web server.  I wanted to check to see if I should install the SQL service pack 4 and IE 9 on the servers and if anyone had issues (or if ASI has reported issues).

I'm working on a project where we pull member data from a view and display on a page inside a sharepoint site. The view pulls Name, Address, affiliation, location, email, web link, and a couple of custom fields. These fields are pulled from multiple iMIS tables. When I try to update the view I get an error stating I cannot update a view that updates multiple base tables. How can I update a customers demographic information? It doesn't appear I can use the membershipwebservice? 

We need to access data in custom tables--not built-in tables that come with iMIS or user-defined tables (UDT’s), but plain old tables that we write in SQL and place into the iMIS database.  Although the iMIS application itself will leave these tables alone, they are used for custom development that involves integrating with iMIS.  Otherwise, they are plain old sql database tables.

We’ve ruled out using Business Object Designer to create Business Objects to access these.  Is better to access these custom tables with stored procedures or with an ORM tool such as NHibernate or Entity Framework?  Will the fact that these tables are in the iMIS database and the fact that these are used for custom development to integrate with iMIS cause one or the other to not work, or otherwise have any problems?

Hello,

There was a thread on this forum from last September about compatibility of iMIS 15 with SQL Server 2008. The message wasn't a good one ("failed miserably" was once phrase used). Has anyone tried or have there been any updates since that post? We're really hoping to upgrade to SQL Server 2008 and iMIS compatibility is a big obstacle.

Thank you!

My client upgraded from 15.0.3 yesterday to iMIS 15.1.2 yesterday.

The Manager password was working, but after I ran the iMIS DB Repair Utility to Reset the Permissions and Prepare the database I am no longer able to login.

The error states the login is not valid. (Please see screenshot.)

The staff that is currently logged intot he desktop is able to continue working, but none of the staff are able to login to iMIS either.

I'm currently testing iMIS 15 in a development environment and need to move the database, not the application, from one SQL Server to another. Is it possible to modify the database connection string on the iMIS 15 server? And if so, how? I already tried modifying the ODBC data sources, and grep'd through the entire iMIS 15 program tree looking for the server name, so it must be encoded somewhere... Is there a tool I can use to reset it?

I have been having an issue with slowness involved with calling the Save() method on a CContact object using iBO for .NET.  When saving a CContact object, it consistantly takes 8-12 seconds to complete. We have a rather large database (over 600,000 records in the Name table), and it seems that the issue lies within the asi_Name_Insert_Update trigger, more specifically the asi_FixDuplicateIndividualRows stored procedure that runs when the MEMBER_TYPE, COMPANY_RECORD, or MEMBER_RECORD columns are edited.

Hi people.

In 10.6  our users run an ADHOC query to identify which records they have touched during the day to produce labels to post out their results..

In this case the Name_Results_Summary  table where their username is entered into the table in the updated_by field.

Here is the username element fo the adhoc..

Name_Results_Summary.UPDATED_BY = Substring(user_name(),1,Case when charindex('_',user_name()) > 0 Then charindex('_',user_name())-1 Else len(user_name())End )