At a guess I'd say you are not using the correct password in your ODBC connection for MySQL user 'root'.

In general for security reasons it is not a good idea...

Hi pandionk1977,

What you have is a recursive trigger.

After an Insert or Update to table Blanco_B2 you are running another 3 Updates to table Blanco_B2 which will each fire the trigger...

Are you sure you want a database full of tables where the name has been generated by something a user entered in Excel?

Will the names follow some pattern? What about...

Hi omalie24,

As toddsad said you really need to get your data types correct or else you will be creating problems for yourself in the very near future. And you don't...

There's not much to go on here for anyone trying to help.

Is your print formatting instructions table in SQL Server 2005?

Please provide:

1. Table definition of formatting table as CREATE TABLE...

Hi Mitch,

At this point we need more info.

Please provide:

Table definitions as CREATE TABLE statements.

Sample data as INSERT statements.

Any other relevant CREATE VIEW or CREATE PROCEDURE statements.

A description in business terms...

Assuming that the column you are checking is a DATETIME then this should work faster:

BETWEEN DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 15) AND DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 14)

Better from a design viewpoint to FTP the file to a directory on the server called something like C:\Inetpub\FTProot\appname\Input and have your IS package pick it up from there.

Using C:\...

I think maybe GSquared's reply should say:

case @FIELD15 when '0' then NULL else @Field15 end

rather than

case @FIELD15 when 0 then 'NULL' else @Field15 end

Are you sure your Master table...

Hi Amy,

You could try this to redirect display to nowhere:

gpg --<your gpg parameters> > nul

or to a file:

gpg --<your gpg parameters> > path\filename

As the previous posters said the column in the table should be kept as datetime and it's a matter of presentation as to how it's displayed.

The following will get your...