BI

Technical Article

RE: Linked servers query problem

  • Reply

If I understand you right, yes. My understanding of severity levels on errors isn't what it should be- I don't know if they error you are getting actually fails the batch/sp. Using string executes I would think it wouldn't matter though. Give it a shot unless someone more knowledgable gives a better solution.. fetch... begin […]

You rated this post out of 5. Change rating

2003-11-21

1 reads

Technical Article

RE: Recursive instead-of-delete triggers

  • Reply

The example can trace 'American family back to the Revolutionary War'. Quote from the article. Done the lineage stuff in 6.5 but the lineage storage (varchar(255)) was a problem because of the key sizes used for the parent/children relationship. With SQL 2000, 8000 characters one should be fairly safe. Lastly, I am a big fan […]

You rated this post out of 5. Change rating

2003-07-21

1 reads

Blogs

Set a Runtime Variable in an Azure DevOps Pipeline

By

Note: I DO NOT recommend this. Any changes to a pipeline should be in...

A New Word: Symptomania

By

symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...

Query Store Keeps Switching Itself Off, Getting it Moving Again

By

I recently received a complaint that Query Store for a particular database was turned...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers