Generate SQL script to extract user permissions from a SQL database
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
10,905 reads
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
10,905 reads
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
4,181 reads
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
2018-04-19
14,206 reads
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
The other day I came across an interesting repo on github, KubeDiagrams. What this...
Hi there to all SQL gurus So, here is the scenario. I have a...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
1, Customer table [TBLMEMBER] 's structure CREATE TABLE [dbo].[TBLMEMBER]( [TRANNO] [int] IDENTITY(1,1) NOT NULL,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers