Tag Info

New answers tagged

2

You only have to run in Administrator mode because you haven't added any users to SSRS. You need to grant permissions. For example on the root folder in SSRS add a windows user/group to the Browser role. For more details see https://technet.microsoft.com/en-us/library/ms156014%28v=sql.110%29.aspx


1

I worked with a very similar situation like this in the past in a 24x7 manufacturing company and finally decided to use transactional replication. It is possible to configure DDL to be replicated such that you can push out whatever the patches change to the subscriber. Obviously there are pros and cons to everything and you need to weigh them to determine ...


3

By all means put it into a standardised set of tables so that you can tweak the import stage rather than having to change complex report(s) and queries. But the data should still be normalised which will require multiples tables (but with good indexes). As others have mentioned, don't use triggers, sync in batches. Don't worry about lots of joins, when ...


2

My plan was to write all of these records to one "catch-all" table, and write triggers on the original tables to maintain the records in this aggregate table. Triggers have so many problems you should avoid them: An error in a trigger can cause the original transaction to abort Triggers that correctly handle multi-row operations are hard to write ...


7

If I understood you correctly, you have a large third-party system, you don't have much control over it, you make complex reports that read data directly from this third-party database, your queries depend on the internal structure of the third-party database. I would approach it like this: Set up my own separate database, which I have full control ...


1

Yes, that's correct, there was bug in earlier version saying "If you set up a SQLAgent job to have a recurring weekly schedule, the job executes successfully the first day, but may later become disabled and the job may not run the next day and thereafter." But later also, quite a few have reported and it worked for them once they upgraded to SP2+( ...



Top 50 recent answers are included