Any way to parameterize a database reference?

I need to refer to a second database from within the database that I login to. Can any one help me with how to abstract this reference? I would like to be able to change a parameter somewhere (i don't really care where) and have it effect any Stored Porcedure which references the second database.You could use the OpenQuery syntax or sp_execute <command>, you could even automatically update a link server - a bit extreme. However, I hate all those options. Stored procedure are at their best when they know about the tables they need to use. Introducing unknowns is not a great idea.

If you've only got one other database then I'd suggest you automatically generate the proc's at deployment or some similar choice.sql

Any keyboard shortcut for "open table" in Mgt Studio?

Folks, does anyone know if there is a keyboard shortcut to open a database table in Management Studio? I refer to the equivalent to right-clicking on a table to choose "open table", in order to view/edit the data.

I find no reference to an equivalent in the menu, nor even any reference to "open table" in the online help. I've dug around the web, to no avail. Surely other keyboard fans must groan at the need to touch the mouse for this frequent operation. Thanks in advance.

Windows functionality:

SHIFT+F10 Opens a shortcut menu for the selected item (this is the same as right-clicking an object
ALT+underlined letter in menu: Opens the menu

|||Might refer to the keyboard shortcuts on using SSMS ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/toolref9/html/fb4edf3c-71b6-4645-b1d1-ddfdd69f0d7b.htm link. Why do you need to open the table in SSMS which is slow if the table has too many rows or volume based. In thsi case using Query Analyzer is best one to go to view the data.|||Thanks very much. I'm a big keyboard fan, but that's one I'd just missed (or not had reason to notice it before). That does solve the problem for me.|||

Thanks, but that's about creating new shortcuts. I was looking for any existing ones. The previous answer about using shift-f10 will suffice.

As for why one would use the "open table" option, do you realize that it permits editing the data? That's certainly much easier in that interface than using SQL statements in query analyzer. Sure, you're right that if you had a large table it may not make sense. I don't, so it works fine for me.

Any ideas ?

Unable to encrypt or decrypt data managed by the Report Server instance.
Please refer to the Reporting Services online help for guidance in enabling
this functionality.
...In help there is no help...If I understand you corrrectly, one way to do it would be to use a custom
assembly to encrtpy and decrypt data.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michael Vardinghus" <michaelvardinghus@.notexisting.com> wrote in message
news:O3XEwo9oEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Unable to encrypt or decrypt data managed by the Report Server instance.
> Please refer to the Reporting Services online help for guidance in
enabling
> this functionality.
> ...In help there is no help...
>