如何使用查询获取用户定义的数据库名称...... 注意: 1.我不想显示系统数据库等作为master,tempdb ..... select * from sys.databases join? result 显示每个数据库名称及其owner_sid 。 2.对于sys数据库,owner_sid保持不变。我不想使用owner_sid Where 子句。 3.要获取该owner_sid NAME,我应该将哪个表加入上述查询。
How to get the user defined databases name using query...... note: 1. I don''t want to show system databases such as master,tempdb..... select * from sys.databases join ? result It showing every database names and its owner_sid. 2. For sys databases owner_sid remains same. I don''t want to use owner_sid Where clause. 3. To get that owner_sid NAME to which table should I join that above query.
推荐答案查询返回用户数据库及其所有者的姓名: Query returns user databases and their owner''s name: select D.name, P.name from sys.databases AS D inner join sys.server_principals As P on D.owner_sid=P.sid where d.database_id>4
查询返回所有数据库及其所有者的姓名:
Query returns all databases and their owner''s name:
select D.name, P.name from sys.databases AS D inner join sys.server_principals As P on D.owner_sid=P.sid
更多推荐
如何查找SQL Server用户数据库名称
发布评论