The error message "Msg 208, Level 16, State 1, Line 1

Invalid object name 'dbo.PriceGroup'." is pretty straight forward; it means that the parser is unable to parse the object name.

If...

Can you check to see whether the "Nullable" check box is ticked for the columns in which the nulls are being replaced with 0s? I would have thought this...

Ok, well, this may or may not work, but you could try changing the encoding in the content column with a replace statement (you may need to check that it's...

Does the simple cast to xml in the subquery work as a standalone query? (Tried it on my test box and not having any issues).

I think my point was more along the lines of that it depends on how you are populating the original xml (eg from a table, from an application etc), or...

Why would you care if the subquery produces the desired result?

With COALESCE you can specify multiple columns and it will return the first non-null value; with ISNULL you can only specify one and is also non standard.

In terms of performance,...

I guess that depends how you're making the xml!

Well it depends on exactly what you're trying to do. I would suggest creating a script for the schema of the table, but perhaps export the data to a...

You can cast scientific values as a float; e.g. SELECT CAST('1.0002E7' AS float)

Or even more helpfully from the xml itself like such:

DECLARE @xml xml

SET @xml = '<Root>

<Row>

<Rowid>1</Rowid>

<date>2013-05-06</date>

<Balance>1.0002E7</Balance>

</Row>

</Root>'

SELECT @xml.value('/Root[1]/Row[1]/Balance[1]', 'float')

And following which of the two suggestions? As I said, I haven't actually tried the power shell mail within the windows service myself yet.

If it's the job...

What is the size of your script file?

Looks like you're having this problem:-

http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/51ef4b81-6677-4e2d-8b80-648633cf699e

I haven't actually tried this myself yet, but it should probably sort you out:-

http://sqlish.com/alert-when-sql-server-agent-service-stops-or-fails/

From within SQL Server itself, I don't believe you can send a mail when the service stops;...

You cannot grant, deny or revoke permissions on an object to the object owner and by default the owner receives the CONTROL permission on the schema which means that they...

It may also be worth noting that public is a server role; in each database there is a guest account which you can deny CONNECT on the database if you...