What query can return the names of all the stored procedures in a SQL Server database If the query could exclude system stored procedures, that would be even more helpful.

These come in very handy if your database contains encrypted objects (views, procedures, functions) because you can’t easily search for these using system tables.

Connect to LocalDB in SSMS Open Server Properties -> Database Settings Change Data/Log/Backup locations -> click OK When I click OK I get this error: Found some blogpost …

I need help with setting a database that was restored in SINGLE_USER mode to MULTI_USER. Every time I run ALTER DATABASE BARDABARD SET MULTI_USER; GO I get this error: …

Is it possible to list information about the files (MDF/LDF) of all databases on an SQL Server? I'd like to get a list showing which database is using what files on the local disk. What I tried:...

In my case, I'm using SQL Server 14.0 with Management Studio 17.9.1, and I have to say this is the only answer thats works to me. I was wanting to delete some databases wich accomplish a …

I had this situation restoring a database to an SQL Server 2005 Standard Edition instance using Symantec Backup Exec 11d. After the restore job completed the database remained in a …

I used the following the script to attach a database. But the database created is read only. What modifications should I make in the script to make it read-write. Please help me. USE [master] …

What is the best way to get the names of all of the tables in a specific database on SQL Server?

Copied database.mdf and database_log.ldf from the above mentioned folder (SQL 2012), then transferred those 2 files to a new server with different version (SQL Express 2014) of SQL …