To add another solution, you could use :

SELECT CHARINDEX('@', column, 

               ...

Are there a lot of foreign key relationships in the updated table(s), also those referenced in the triggers.

There has been a thread a while back that mentioned this as a...

If you link more postal codes to a single groomer, you will have to provide a separate table.

About the subscription stuff, I was referring more to the process for groomers...

Maybe an alternative solution could be to construct a composite column, containing a concatenation of all of your fields in the table.

If you only include that column for the full...

Maybe another approach. Eliminate the exact copies, and construct a fourth database that contains the three tables that are the same in a single database.

Of course, you will have to...

I can confirm that you can use any column in a table as foreign key in other tables as much as you like. You cannot add two Primary keys to...

I guess this depends on the way you want to implement this.

You can create a connection in each thread or you can create a single connection and share that over...

That is an alternative way of doing. Exporting everything to a plain text file and inserting it back into MySQL.

There is a command, LOAD DATA INFILE, that does this in...

Business Objects is NOT an ETL tool. Its main purpose is a reporting tool. I do know they acquired an ETL tool manufacturer : ACTA Technologies.

Don't know anything about their...

Had too long day to really dive into this. I suggest the following :

1. Build a (temp?) table with all the time intervals you want to have results for :

create...

MyODBC is a (free) ODBC driver for MySQL. I have used it without problems (version 2.50.39.00).

It can be downloaded from http://www.mysql.com/downloads/api-myodbc.html.

You can't do it easily. Something like this will give the desired result.

SELECT SPACE(15 - len(cast(OID AS varchar(15)))) + cast(OID as varchar(15))

Seems obvious, doesn't. You should only store 'useful' data in your table. Adding leading zeroes is a presentation function.

There should be some posts or articles around about that. I guess...

Solved the mystery (I think)...

I have also tested the ownership chains in SQL2000 SP2 with dbo as owner. Turns out that apparently the dbo account is NOT the same user...

You're completely correct. With stored procedures, you don't need permissions on the tables it references.

I thaught that your app was referencing your tables directly, but apparently I was mistaking.

Am I...