Try changing WHERE DATEDIFF(dd,CONVERT(VARCHAR(8),sjh.run_date), GETDATE()) <= 1

to

WHERE DATEDIFF(hh,CONVERT(VARCHAR(8),sjh.run_date), GETDATE()) <= 1

Please don't post multiple times with the same question. sp_reassign_dtspackageowner only works with DTS packages, not SSIS packages. See my reply in this thread: http://www.sqlservercentral.com/Forums/Topic587199-148-1.aspx

The owner of the package doesn't really matter. I'm not even sure that SSIS packages have owners. What matters is what the protection level of a package is...

I think you need to use the 'WITH REPLACE' argument of RESTORE DATABASE. Here's a thread that discusses the same subject: http://www.sqlservercentral.com/Forums/Topic490956-357-1.aspx

If this is a one time thing, I suggest using the Import/Export Wizard in SSMS. Right-click on either the source or destination database, select Tasks, and select either Import data......

No, members of db_owner can execute all stored procedures in the database. A note of caution: members of the db_owner role can drop the database in SQL 2005,...

I'll second Happycat's endorsement of SQL Agent jobs. When you create a new job and a new step, choose "SQL Server Integration Services Package" as the type then fill...

Ah, makes sense now. I've heard you should backup up databases before upgrading, but I've never seen a recommendation to detach them.

I'm not sure what you mean by "detach all jobs". Do you mean script them out prior to doing an in-place upgrade?

I've not done an in-place upgrade....

I'm not even going to ask why you need to count the columns. 😛

This should give you a count of user table columns in the current database:

select count(c.name) from syscolumns...

As I recall, Developer edition isn't a free download unless you have an MSDN subscription.

The dollar sign isn't stored in SQL Server. If you need to display the money columns with the symbol, it should be applied in the application.

Read the article I mentioned. It contains all the steps and information you need.

I'll suggest that what you're looking for isn't an application role or you're querying in the wrong database. Can you see the application role in SSMS when you expand...

I'll suggest that what you're looking for isn't an application role or you're querying in the wrong database. Can you see the application role in SSMS when you expand...