sql 2008 has a new feature which prevents changes been made that require the table to rebuilt.

in 2005 this did not happen so quite often the user was unaware what...

As long as it starts snowing once i get home and not before then it will be fine

does the agent account have access to the destination?

you can add a format parameter to the report url to make it open in excel

rs%3aFormat=excel

To avoid guesswork and to get the best advice you will need to post the table stucture, some sample data and a few examples of the queries that are...

well you would need a seperate one for each data source...

sorry i didn't make that clear

posting sample data is usually expected from these sorts of questions, and helps cut down on the guess work..

also it allows someone with a few minutes spare to have...

parthi-1705 (11/17/2010)

---

steveb. (11/17/2010)

---

It seems like you could use 65 seperate flat file connections and then use a derived column to add an ID to differnetiate the files in the...

It seems like you could use 65 seperate flat file connections and then use a derived column to add an ID to differnetiate the files in the destination table.

or you...

I would take what DETA has to say with a very large grain of salt.

The best best for indexes is to design them yoursellf based upon the types of queries...

harm.vanderlinde (11/17/2010)

---

So, if I understand correctley. Management studio it self doesn't have a tool to copy or move complete tables (including data and definition) and never had this abbility.

is that...

harm.vanderlinde (11/17/2010)

---

Thanks for your reaction.

But I'm copying about 200 tables, and time is not my biggest resource.

In wat way can I copy the tables including table definition from database TEST...

The keys and indexes are part of the table definition and are not contained in the data, to obtain this information right click on the source table and click...

right click on the database, click on properties then click on files and check the box 'enable full-text indexing'

if you are having trouble getting the test data into a usable form for help, there is a nice script here that may help.

http://www.sqlservercentral.com/articles/T-SQL/66987/