Search results for query: *

here are some details: I have 2 databases: base1 and base2. Base1 has some roles with memmbers. In base2 I have following view named View_1: SELECT [base1].dbo.PERM_CATEGORY.PERMIS FROM (SELECT Roles_1.Role_Name AS dbrole, Principals.name AS MemberName, Principals.sid AS...

yes, both databases are attached to the same SQL Server instance. sorry, I forgot about it.

Hello, As a topic, I have 2 databases (eg. base1; base2) with the same users, could You help me how to grant permissions to a user, that he would be able to read data from another database system tables, I mean tables: sys.database_principals sys.database_role_members and then use it in a...

thank You for solution!

hi, I would like to create xsl file to transform xml file #1 to another xml file #2 with different structure: xml file #1: <?xml version="1.0" encoding="utf-8" ?> <orders> <doctorname>Andrew Dixon</doctorname> <orderid>10/10/03</orderid> <compound> <name>Riboflavorific</name>...

hi, I would like to import following xml file to dtabase to table Orders: xml file: <?xml version="1.0" encoding="utf-8" ?> <orders> <doctorname>Andrew Dixon</doctorname> <orderid>10/10/03</orderid> <compound> <name>Riboflavorific</name> <amount>27</amount> </compound>...