My problem on the database that I setup, is when I take all the defaults, the new database thinks I am dbo. I can not assign myself to any...

Thank you very much!

thanks!

This history table will have one index based upon an identity column and 2 rows that are foreign keys to two other tables. there will be about 4,000 records loaded...

In your original statement you said "If you want to keep it in Varchar(x), use a LEFT in the derived column and import that."

Where would you have the derived column?...

what does the LEFT in the derived column and import that do? how does that help?

My goal is to transfer data from a selected tab in a workbook and transfer the data to sql server. I wangt to use ssis since that is what it's...

In answer to your question,"Does the Tab in Excel that you need to open remain the same, or does this change each month?", the data will change everytime the SSIS...

Thanks for your reply. However each excel spreadsheet goes to different companies

I have to change a sql server 2008 data driven subscription to sql server 2008 R2 standard subscription based upon what my company purchased. Thus, I am attempting to find...

Thanks! This sql works very well!

I forgot to mention that I am using sql server 2005 standard edition. I can not find sys.dm_sql_referenced_entities in the that edition. Is there something else I can use?

Thank you very much for your answer!

However, is there a way to see all and/or most of the values that are being used? My problem is I just inherited lots...

Here are some links you may want to refer to:

1. create table of contents and page numbers in SSrS2008

http://www.u2u.info/Blogs/U2U/Lists/Posts/Post.aspx?ID=10

setting up page numbers

2. Microsoft Dynamics NAV 2009 Reports: Pagenumbers x/y

3. allow...

That worked very well!

Thanks!