Well there is DimStudent and DimSubject which is handled as proper Dimension tables. However a link between those two is captured in BridgeStudentSubject. Applying SCD rules to the bridge table...

Thanks Joie

I tried the "Fix the SSRS Compatibility Issue at the Server Level" option, but it seems SSRS 2016 dont have that metatag.

This fix seem to...

I found a sloppy work around. By ensuring the reports are in the same folder ... it works. I then just hide the sub report.

Unless I am missing something I...

Wait ... so how do I that?

PS: I realised my previous response was epicly idiotic.

I was thinking towards something in the line:

Temporarily Disable Logging to Transaction Log

Executing the DELETE statements but ensuring that it doesn't get written to the log.

I don't think my company will pay that amount of many for a additional tool. 🙁

Thanks for the suggestion though.

I was actually thinking the same thing. Where data is transferred (bulk insert) to an empty temp table. And then using Stored Procedures one could perform complex T-SQL update/insert processes.

Thnx

kramaswamy (1/9/2012)

---

Using SSIS, first put an Execute SQL Task, and do a query similar to "UPDATE sSET m.Fields = s.Fields FROM SubDB m JOIN MainDB s ON m.ID = s.ID"....

Sounds like a plan.

But please note that the databases are on different servers.

This is why I think SSIS is needed, instead just stored procedures.

One would think with all the intelligence at Microsoft they would be able to provide us with a very simple item that enables the data two tables to be merged...

Ok so here are a few solutions I found all on my own.

Make sure that:

1. the BrokerID for the databases on the instance are different

2. the Broker is enabled.

3. the...

All the examples I saw so far creates a new database. I have not seen ONE example where they show you how to setup up the service broker on an...

@ hallidayd - sending message between the two system is possible but for the unique way the two system operate it wouldn't really work.

Seems like the best solution would...

Just another question guys ... does rebuilding indexes have any effect on the cache query plan of a procedure.

I was just wondering cuase we had a few incidents where...

Thanks for the help guys.

Will be having celebration cup of coffee soon! :w00t: