• I must be the only one who still can't get this to work properly. I am using SQL 2005 so the issues specific to SQL 2000 don't apply. I've removed all parts that are for SQL Server 2000 and removed the "IF THEN" items so that the only parts left are the call to sp_MSForEachDB and the INSERT done via the SELECT and while the thing does run, after going through a few DB's on the server it eventually retruns the erro message:

    Msg 102, Level 15, State 1, Line 10

    Incorrect syntax near '.'.

    I can't seem to get it to not return this error. I even ran the thing manually on each DB, removing the use of sp_MSForEachDB to try and determine which DB is the culprit but when I do that I no longer get any errors.

    GO figure?

    Anyone else have a similiar problem?

    Kindest Regards,

    Just say No to Facebook!