Referencing Remote Data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Referencing Remote Data

12 posts, Page 2 of 2

««1 2

Referencing Remote Data

Rate Topic

Display Mode

Topic Options

Author

Message

Ed Zann

Posted Tuesday, January 10, 2012 9:45 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 457, Visits: 944

We have a reporting system that contains monthly snapshots of our core system database. Each snapshot is a database with a naming convention like Snapshot20111231. We frequently have SSRS reports that compare this month vs last month. I use synonyms in the main report query in order to avoid the messiness of constructing a dynamic sql statement. The reports are based on sprocs where the first thing that happens is redefining the synonyms to point to the month end snapshots the user requests via report parameters. It works well. Only drawback I see is the elevated permissions required by the reporting login to drop and recreate the synonyms.

Post #1233357

Sigerson

Posted Tuesday, January 10, 2012 11:05 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 11:07 AM
Points: 32, Visits: 173

We frequently have SSRS reports that compare this month vs last month. I use synonyms in the main report query in order to avoid the messiness of constructing a dynamic sql statement. The reports are based on sprocs where the first thing that happens is redefining the synonyms to point to the month end snapshots the user requests via report parameters.

That's a pretty creative solution to managing repetitive files where the date is part of the names. I have a couple of processes to implement this way. Thanks for posting it.

Sigerson

"If you have no enemies, you have no character." - Paul Newman

Post #1233407

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions