Blocks

Technical Article

sp_what

  • Script

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.

*Dont you just love totally non subjective assessments like this?

4 (5)

2018-11-01 (first published: )

2,481 reads

Technical Article

Unable to create Publication

  • Topic

Hello,I am having a strange problem. I am unable to create ANY new publication on any of the databases. I try to add it using the SQL Enterprise Manager or Query Analyzer and get the following error for exec sp_addpublication :Server: Msg 14294, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 24 Supply either @job_id or @job_name […]

2005-05-03

3 reads

Blogs

Query Store Hints in SQL Server 2022

By

Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Daily Coping 30 Nov 2022

By

Today’s coping tip is to learn a new skill from a friend or share...

Encrypting Your SQL Data Should be Your Default Option

By

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we...

Read the latest Blogs

Forums

dtexecui

By Anita Lakhani

I have some IT peeps that will run an SSIS package manually from a...

Technical support for SQL Server

By Ram

Hi, Do we have to pay for  opening a support ticket with Microsoft for...

Basic Checks on a New AWS RDS SQL Server

By Br. Kenneth Igiri

Comments posted to this topic are about the item Basic Checks on a New...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers