I became aware of Cache Monitor yesterday and that may be a solution, but if I can accomplish the same end using SSMS that's the route I'd prefer to take. I'd still use the linked server and the EXECUTE or OPENQUERY syntax for queries driving reports I push out to our Report Server. If it's doable, I'd love to get my instance of SSMS configured so I could write queries directly against Cache. I know some people use WinSQL to connect to Cache and a Cache tech support person thought SSMS could perform the same role, but he doesn't use SSMS personally so didn't know how to configure the connection. Our MID department can't seem to fix the problem so I'm looking for workarounds. AT or OPENQUERY syntax.īut I can't view namespaces/schemas or write direct queries against Cache.Ī recent upgrade messed up the SQL portal in the System Management Portal where I normally start building queries. The Microsoft JDBC Driver for SQL Server is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available on the Java platform. We already have a linked server to Cache and I run queries against Cache using EXECUTE. SQL Server Management Studio (SSMS) is a Windows client app that allows database developers and database administrators to configure and manage SQL Server and Azure SQL databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |