If memory serves well : Tablix, create new group. Page break after the group. On export there should be a new tab for each group in excel.

From there...

I wish you better luck than I'll...

Where's the frighing unsubscribe button????

I used another method... not quite as good but acceptable for the users. For the 203 reports that needed this I changed the group by to the description instead...

Definitly possible to do.

Put all the subscriptions into a special folder.

Then loop in all excel files.

Then rename all tabs for each files.

Definitly a kludge, but that would work.

Most reporting table are empty untill they are used....

Might want to script them and move them to a backup db in case you need them later.

Are you sure you are in the right database?

Who is the owner of the object?

Have you tried this way objectowner.tablename?

IE :

select * from dbo.detail

I've used it only once but as far as I remember you basically select both environements. Then you run a compare between a and b.

Once done a sql script...

look up "database mail" and

"sp_send_dbmail"

in books online

Ya been there. The only to export the report from SSRS is with the export button or with a subscription.

From there on out you can always save the file...

Sarab. (3/5/2010)

---

Yes you are right, this approach will surely help you

for fk keys

i think the below mentioned query may help in case of fk relationship

Exec sp_MSforeachtable 'alter table ?...

Sarab. (3/5/2010)

---

Angela S. (3/4/2010)

---

I Needed a training database. So I copied our main database and renamed it so it won't get confusing. But now it has all the...

It' already submitted as qotd ;-).

Just for the sake of it...

use tempdb

go

create table a (b int)

go

insert into a (b) values (1), (2), (3)

select * from a

begin tran

truncate table a

select * from a

rollback tran

select * from...

What's the freaking point of having a users table if you have less than 2 users in the production system?

That's not a bad assumption to take into consideration.

As others stated,...