I think you have a typo in the test data because I think you wanted the data in the first insert of fromtable to match the last insert of @totable,...

You can't use {} without the oj. I just learned this by trying it in SSMS and without the oj it throws an error. It is ODBC outer...

There are several products out there that are designed to help manage SQL Servers. You can check out RedGate, Idera, SQLSentry, SYmantec has its i3 product.

Have you looked at...

It looks like you have data in the child table that does NOT exist in the parent table. Meaning you have an invalid entry in Historical_Propertys.Prop_Manager_ID.

Most folks try to answer in a timely fashion, of course, that depends on when we get on.

I think the Workgroup edition will have it because Database Mail is built...

I don't think there is a way because paging is determined after the report has been processed. I tried using ReportItems("txtPage").Value, but since the page number is not created...

I'm pretty sure that all versions of SQL Server 2005, including Express, include Database Mail.

But, it sounds like you are looking for a MAIL SERVER and database mail...

I would think there is less room for error by having fewer steps so I would do it in the dump from staging to production. Unless you have instances...

This is column 13 in the first select of the union:

cast(con.WNS_ID as varchar),

And notice that you do not provide an alias. If you provide an alias the create view...

Either of the other suggestions will work, but I would agree with Steve because INFORMATION_SCHEMA is an ANSI standard while sys.procedures is a Microsoft view that could be deprecated or...

There are several ways to move a database. You can put the database in single user move and detach the db, copy the mdf to the other server, and...

That's a fair trade. I thought you knew about this already because I learned about it from a thread that I think you were in along with Matt Miller....

Great I'll take a look either over the weekend or on Monday morning.

This isn't exactly a better way to handle the problem you encountered, but may be a better way to manage security so it is less of an issue. Use...

Sure you can execute multiple statements in an Execute SQL Task. I usually put a GO between them, but you don't have to. The only issue is that...