seen from Lithuania
seen from India
seen from Czechia
seen from Greece
seen from Malaysia
seen from United States
seen from United States
seen from Türkiye
seen from Türkiye
seen from India
seen from United Kingdom
seen from Australia
seen from Germany
seen from Qatar
seen from United States
seen from Türkiye
seen from Malaysia
seen from United Kingdom
seen from Malaysia
seen from Türkiye
List All Databases in SQL Server
List All Databases in SQLÂ Server
One of the important tasks of a Database Administrator is to keep track of what databases exist on which SQL Server instances. Using the query below, you can get the information about what databases exist on your server:
EXECÂ sp_helpdb
This returns:
Column name Data type Description name sysname Database name. db_size nvarchar(13) Total size of the database. owner sysnameDatabase…
View On WordPress
Getting Help from SQL Server
Getting Help from SQLÂ Server
Sometimes, when using any software, you need a little help in remembering a command or step-by-step instructions on how to perform a task. SQL Server provides a little help in understanding objects in the database with the sp_Help command. This can be helpful if you see an object referenced in a stored procedure or view, and want to get a quick list of information about that object.
sp_help …
View On WordPress
