??? !

????? ?sys ??? ??“select name from all_views where name like 'dm%'”????? ????DMV ?? ??

I got it when I login as sys and select name from all_views where...

??? 1-part names 2-part names 3-part names ??

Could I ask what is 1-part names,2-part names,3-part names?

?MSDN??:

In the MSDN :

Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.

???...

???DMV?,??????,????????,???????!!

What is DMV? I have never read about it . Could man share some material. for every one to learn.

???,???????????????,??????,???

Thanks,man. It seems that you r a senior in the forum. if I have any qus. in the future, ask you OK?

?? ???????????? ?? SQL Server ?????????????????

how does the sql server encrypt the data , through what kind of method to encrypt the data?

????

??????????

create database test

--????

on primary

(

--??????

name='test _lj',

--?????

filename='D:\Develop_Files\Database\ test.mp3',

--???????

size=3MB,

--???????

Maxsize=10MB,

--????

filegrowth=1MB

)

--??????

log on

(

--??????

name=' test _log',

--???????

filename='D:\Develop_Files\Database\ test.doc',

--????????

size=3MB,

--????????

Maxsize=10MB,

--????

filegrowth=1MB

)