Technical Article

Automatically Failover (Enable or Disable) Jobs Based on HADR Role

  • Script

If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.

5 (1)

2018-11-14 (first published: )

3,309 reads

Technical Article

RE: what does DBCC stand for?

  • Reply

Just a thought, but it struck me that the difference between Consistency Check and Concole Command could possibly be significant in a certification exam.  I would really hate to miss a question on something so trivial.Myself, it'll always be the former, I harken back to the 4.21a days on top of LanMan/OS2.


Technical Article

Dynamically set DTSDestination column name from variable

  • Topic

I need to be able to set the DTSDestination column dynamically using a variable for the column name.  Here is the code I am using:   strColName = cstr(DTSSource("ColName"))    DTSDestination(strColName ) = DTSSource("QVal") I am getting the error "Invalid procedure call or argument: 'DTSDestination'".  I'm sure that I am just missing something.Thanks!


3 reads

Technical Article

RE: Question of the Day for 29 Jan 2004

  • Reply

I didn't know that you could license SQL Server to a person.  I thought there were only two licensing options.CALPer processorIn my case I deal exclusively with systems accessible via the web so only per processor applies to me.Most people don't give a pair of fetid dingos kidneys about licensing until FAST come knocking at […]


Technical Article

RE: VBScript command-line performance question

  • Reply

This may be a dumb question, but is DTS an option for you? Using a text file as the source and an table as the destination can be extremely fast. With straight ActiveX copy columns I've been loading around 700,000 records in about 9 minutes. These are not small records, either....over 150 columns, and our […]


1 reads


What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Speaking at SQLSaturday MN 2022


Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Read the latest Blogs


Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

10 years as Sql server dba but still fears of Interview and lack of Confidence

By anoop.mig29

I dont know whether i may asking question at right or worng place but...

T-SQL Code Review - Where Field DOES NOT contain

By carlton 84646

Hello community, Quick question to get your opinion on simply T-SQL code. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers