you can create DDL Trigger to restrict any operation

You have to check the credential that are used to run the job, if you are using any proxy account or any other account you have to make sure either...

You need not to repeat this thing on other node since it is actice/passive configuration ,so after runnnig the query you have mentioned or right click on the instance and...

Try This

USE [SchoolLM]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[usp_GetMgrEmail]

@locationId VARCHAR(36) = null,

@identifier VARCHAR(10) = 'School',

@emailAddress VARCHAR(50) OUTPUT

AS

BEGIN

SET NOCOUNT ON;

IF(@identifier = 'School')

--SELECT 'School'

SELECT @emailAddress = (s.Sch_Id + '@' + b.Brn_Domain)

FROM...

Use Len() function .

like select * from tablename where len(ltrim(rtrim(cloumnname))) >9

HWH..

use bulk insert and point to location where you want to store the output of query .

How backup was taken - native or any third party tool

What is version of SQL Servers from where backup and where restore is happen

By default SQL Server reserve 2 Gb for maximum memory, you have to increase it to your prefered value if there is one lne instance and ther is no other...

From 2005->2008 Yes , but not 100% vice versa

I am suspecting how can you restore SQL Server 2008 database on SQL Server 2005 coz reverse compatibility is not what SQL Server supports.

I guess if your SP needs to pull/push data to other databases for diffrent servers then Linked Server , Open query aresimple solutions but if you means using SP in...

What version/edition of SQL Server you have installed?

DBCC CLEANTABLE reclaims space after a variable-length column or a text column is dropped by using the ALTER TABLE DROP COLUMN statement. The command does not reclaim space after a...

your Subscriber should be equal or have to have higher version than Publisher so if your Publisher Server is 2000 then Subscriber should also be atlease 2000 not 7.0

Can you share the Logic/Code of SP to better dig in ....