You could convert the collation in the compare but you would have to find out what was expected and where it was being actioned.

the syntax is something like

= (fld collate...

Haven't read through the thread so may be repeating / off topic.

The backup command has to fit in with the version of sql server so whenever you change sql server...

The idea is that the application should only allow valid updates to be made. The integrity constraints are to catch bugs in the application and incompatible changes that have been...

You would probably be better off checking for referential integrity before actioning the command.

To retrieve the error message you can use

http://www.nigelrivett.com

spFormatOutputBuffer

(you will need to change some of the...

Don't allow temp tables - must make for an interesting system.

The good thing about temp tables is that they clear themselves up when you close the connection and so you...

>> Unfortunately, due the usual political guff, I am not allowed to access the command prompt or desktop of the server. My only access is via SQL EM or SQL...

also do you really want to use different fields depending on the length. Looks like you may be trying to cope with a dropped leading 0 (and trying not to...

Decide what changes you want to cater for.

There will be some things that will be fairly common - like adding columns/tables.

You need a release method for these.

Indexes are quite easy.

For...

Is this a good way of taking backups?

Or is method being given priority over objective?

You will need to put quotes in the path to allow the embedded space.

'''C:\"PROGRAM FILES"\TMS\"Dialer List Utility"\DLU.EXE'

Don't know if that is the problem but it won't help.

sql server often gets the query plan wrong on updates - but inserts are usually better.

If the select is ok on it's own you could probably get round it by

INSERT...

or coalesce

It will try to ersolve the object cmss_skoda_3.dbo.rob1 at run time as it is in another database. This doesn't exist so it can't generate a query plan for the statement...

You can call a SP from a job, the SP just loops calling your transfer SP every 10 secs or so - see if they notice the 10 sec delay.

Just...

can't include a go in a stored procedure.

If you call a another SP after the alter to access the table then this will be called at run time with the...