sp_who2

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,477 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

Technical Article

RE: SQL Server Restore

  • Reply

Hi again... Now it'sServer: Msg 3206, Level 16, State 1, Line 1 No entry in sysdevices for backup device 'f:\cp.bak'. Update sysdevices and rerun statement. Server: Msg 3013, Level 16, State 1, Line 1 VERIFY DATABASE is terminating abnormally.  The backup is NOT from that server... undestand ? 

2005-03-14

Technical Article

RE: String Tokening

  • Reply

Not aware of a function, per se but you could try thisSELECT CASE WHEN PATINDEX('%[^0-9]%',[Input])>0 THEN LEFT([Input],PATINDEX('%[^0-9]%',[Input])-1) ELSE [Input] END  

2005-03-14

Blogs

Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022

By

Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight

By

This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs

Forums

Restore takes forever

By Edvard Korsbæk

Hi all! I have som pretty smal databases - the backup is app. 250...

DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers