Another positive from the classroom environment is that you're exposed to questions other people ask as well.

No problem.

On second thought: You can run it against any of your databases & it should yield the same result.

I ran this against Master:

select * from sys.databases

It sounds like the application is trying to insert a NULL value in a column that doesn't accept NULLs

Hi there,

I honestly don't know, but I don't think that sort of information gets stored anywhere, unless you explicitly write it to a log or table.

Are you referring to a third party product or the Visual Studio tools used to design these packages?

Also, what information are you looking for?

Sure, to an extent.

But BOL doesn't really explain topics from a 'business-needs' point of view. With your article you can actually imagine/think of scenario's where certain options work better than...

Hi there,

Try the following:

http://msdn.microsoft.com/en-us/library/ms137916.aspx

It's broken down pretty well.

A very good article Grant

Hi there,

There are quite a few ways to restore a database (From a backup file, a snapshot etc).

This is just a basic example:

RESTORE DATABASE [YourDatabase]

FROM DISK...

You can try the following link:

http://www.mssqltips.com/tip.asp?tip=1054

We get that when querying a log shipped database after a log restore - it makes sense though since the 'old' session is no longer valid.

Hi there,

Is this a production database? If not, how often does it get restored?

Thanks for the article.

I wonder how good it would be to use for it reporting purposes.

Besides reports running on the same server as a production db & the added...

You can also get the data accross using the Import/Export data tasks