If you want to find no of connections in SQL Server Query
Syntax: Select @@Max_Connections
For finding versions of SQL Server
Syntax: SELECT @@Version
For finding Current users Login into the Server
Syntax: SELECT Current_User
Default Databases:
Master:
Model:
MS_DB:
Temp:
Backup Types:
Syntax: Select @@Max_Connections
For finding versions of SQL Server
Syntax: SELECT @@Version
For finding Current users Login into the Server
Syntax: SELECT Current_User
Default Databases:
- Master
- Model
- MSDB
- Temp
Master:
- It Contains System Configurations, Connections with out Master Database the SQL Server will not Start.
Model:
- It contains Models that is Templates.
- Creating database templates
- Creating table Template
- Creating Stored Procedures.
- Creating templates for restoring DB.
MS_DB:
- It contains Data table backup
- Dts packages
- SSRS Variables, Folders
- SQL Server Jobs
- Replications
Temp:
- It contains temporary tables information.
Backup Types:
- Full back up
- Transaction log backup
- Referential back up
No comments :
Post a Comment