Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite...
2014-09-15
1 reads
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite...
2014-09-15
1 reads
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...
2014-09-15
480 reads
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc. Steps to start...
2014-09-04
3 reads
Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master...
2014-09-08 (first published: 2014-09-04)
43,766 reads
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the...
2014-08-26
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative...
2014-08-26
700 reads
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all...
2014-08-25
25 reads
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not...
2014-08-25
7,048 reads
Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...
2014-08-11
5 reads
Error : Database backup is getting fail with below reason.
The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is...
2014-08-11
1,127 reads
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers