SQL Server query to find all permissions/access for all users in a …
Aug 13, 2011 · 289 I would like to write a query on a sql 2008 that will report all the users that have access to a specific database, or objects within the database such as tables, views, and …
Select SQL Server database size - Stack Overflow
Aug 2, 2013 · How can I query my SQL server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size …
sql server - Get size of all tables in database - Stack Overflow
Oct 25, 2011 · 801 If you are using SQL Server Management Studio (SSMS), instead of running a query (which in my case returned duplicate rows) you can run a standard report. Right click on …
Get all table names of a particular database by SQL query?
Oct 12, 2010 · I am working on application which can deal with multiple database servers like "MySQL" and "MS SQL Server". I want to get tables' names of a particular database using a …
Script to list the SQL Server Databases, Size and Utilisation by ...
May 29, 2012 · The answer (s) provided here return the size of the database files, which is not necessarily the size of the data in the database. To get the size of data in each database on a …
Query to list number of records in each table in a database
Sep 18, 2009 · 51 To get that information in SQL Management Studio, right-click on the database name, then select Reports --> Standard Reports --> Disk Usage by Table. This quickly …
Find out the history of SQL queries - Stack Overflow
Oct 18, 2018 · An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the …
How can I get the size of a MySQL database? - Stack Overflow
Not a single answer or comment even mentions a possible overhead of the database tables and doesn't take this into account in the SQL query. This is the most common mistake when …
How do I search an SQL Server database for a string?
Dec 8, 2019 · 152 I need to search an SQL Server database for all mentions of a specific string. For example, I would like to search all tables, views, functions, stored procedures, ... for string …
sql - Find out current database name (MSSQL) - Stack Overflow
7 With the MSSQL queries below, you can check the current database: SELECT DB_NAME() GO master In addition, if you don't specify a database on sqlcmd, "master" database is used by …