Tag Archives: query

Query from WIN 7 to AD DC server

1. Command “net group” may be used only directly on AD server 2. Iz komandne linije (koja je OBAVEZNO otvorena kao user pod željenim domenom) pustiti komandu : “C:\Windows\System32\rundll32.exe” dsquery.dll,OpenQueryWindow Koja otvara prozor sa upitima : I to daje priličnu … Continue reading

Posted in WIN | Tagged , | Comments Off on Query from WIN 7 to AD DC server

SQL query to another server

How to send a query to another server, while being attached to the first server? There are two ways, from MSSQLSMS (Microsoft SQL Server Management Studio) : 1) Servers are linked : 2) Under MSSQLSMS all the servers we wish … Continue reading

Posted in WIN | Tagged , , | Comments Off on SQL query to another server

SQL query : computer name

1) How to get computer name using SQL query : select ServerProperty(‘ComputerNamePhysicalNetBIOS’); 2) And some additional info concerning SQL : select ServerProperty(‘ComputerNamePhysicalNetBIOS’),ServerProperty(‘Edition’); 3) Product version : select ServerProperty(‘ComputerNamePhysicalNetBIOS’),ServerProperty(‘MachineName’),ServerProperty(‘Edition’),ServerProperty(‘ProductLevel’); Nore : first two items usually give the same output, so I … Continue reading

Posted in WIN | Tagged , , | Comments Off on SQL query : computer name

SQL query : CPU and RAM that DB uses

Query depends on the SWL server version that is being queried. Query should always be done on “master” DB, soa s to gain data for the whole server : The data gained from sys.dm_os_sys_infodepend on the SQL server version (link) … Continue reading

Posted in WIN | Tagged , , , | Comments Off on SQL query : CPU and RAM that DB uses

SQL queries

I am starting to work a bit with MS SQL. Up until now all I have done were some small MySQL queries. Good link for beginners, like me. ***** A few things to begin with : SQL stands for Structured … Continue reading

Posted in WIN | Tagged , | Comments Off on SQL queries