OK, all resolved. Seem to always forget this one ;o)

RTRIM(colname) 'alias'

All resolved, well sort of. The upper function is not liked by the DTS wizard, any columns with upper applied are not recognised. Is this a bug??

Phil.

Well, it seems that all of a sudden, it decided not to like " chars, changed them them to ' chars and all is well.

PRINT 'There...

quote:

---

Ok first what is line for

WHERE publication_id = inserted.publication_id

and are you getting any records in the table? Also, describe what it is...

I get an error message when I run this SP:

Warning: Unicode language locale 2057 in database differs from server Unicode language locale of 1033.

How can I change the locale of...

Unfortunately, I am not a DBA, but a web developer who has a very basic understanding of SQL Server, well enough to get my applications working anyway :o). I have...

Hi Paul,

The MDF/LDF files are a result of a disk recovery after a hacker deleted the boot sector of the HDD :o( No backups were available for the databases I...