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 […]


3 reads

Technical Article

RE: Re: Problem w/ the cursor in sproc

  • Reply

exactly... also you should convert it to int (unless it's impossible with the data). Also even some have disagreed about this I've seen a huge speed improvement in changing my primary keys from char(6) to int on a orders table (yup crappy set-up but I can't change it). I simply copied the data to a […]


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 ? 


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  



Deadline for Microsoft MVP contributions is 20 March 2023


Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Goal Progress for Jan 2023


The grade for January is a D. Details below, but just not making a...

Context Info Across Databases–#SQLNewBlogger


Does Context Info work across databases? This post shows it does. Another post for...

Read the latest Blogs


Storing a text file in a VARCHAR(MAX) column

By Mick Opalak

I'm using OPENROWSET to put the contents of a text file into a VARCHAR(MAX)...

"ID" primary key from two separate tables as a foreign key in a new table

By Edub1122

I have two tables: tblProfessors with ProfessorID as the primary key and tblStudents with...

blocking issue

By vsamantha35

Hi All, We are seeing SELECT's blocking DML's like UPDATE statements. When we tried...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers