Can you modify the query to use two part naming standard [SchemaName].[ObjectName] and see if that helps?


SELECT SUBSTRING(a,0,PATINDEX('%[0-9]%',a)-1) + REVERSE(SUBSTRING(REVERSE(a),0,PATINDEX('%[0-9]%',REVERSE(a)))) AS A
FROM #t


What error message did you get when executed sp_dropdistpublisher?

CREATE TABLE #TempTable
(
 ID INT NOT NULL,
 Status VARCHAR(10) NOT NULL,
 StartDate DATE NOT NULL
)

INSERT INTO #TempTable
(ID,Status,StartDate)
VALUES
(1,'open','01/31/2017'),(1,'IP','03/31/2017'),(1,'cl','05/31/2017')

SELECT TT.ID, TT.Status, DT.EndDate
FROM...

Have you tried using sys.dm_exec_procedure_stats DMV?

Did you check in MSRepl_commands and MSRepl_transactions tables in distribution database?

Have you tried to use program_name column from sys.dm_exec_sessions DMV?

If you are using replication stored procedures to replicate then you can temporarily modify the delete stored procedure to not raise an error when records are not found at the...

You can use __$update_mask column with sys.fn_cdc_is_bit_set CDC function to find columns which were updated for a particular record.

You can try the following query but not sure whether it is the most efficient way of doing it.

SELECT CASE WHEN RowRank = 1 THEN Name ELSE '' END AS...

You can also use __$update_mask column with sys.fn_cdc_is_bit_set CDC function to find columns which were updated for a particular record.

Backupset table in Dev server will also contain information about backups that were taken on other servers and restored on Dev server.

''?'' can be used in the SELECT statement to get names of databases.

exec sp_MSForEachDB

'

USE ?;

if exists

(select table_name

from information_schema.tables

where table_name = ''RS_Patient_6'')

begin;

select ''?'' as dbname, * from RS_Patient_6...

This is not the most efficient way of doing it but it works

SELECT ' USE ' + Name +

char (10) + ' go ' + char(10)

+ ' alter statement '...

SELECT * INTO DevTable

FROM ProdTable ----with the use of OPENROWSET()