Azure Data Factory

Technical Article

RE: Logshipping

  • Reply

****IAM page (4:62991) for object ID 2073058421 is incorrect. The table ID on page is 413960551; should be 2073058421. The entry in sysindexes may be incorrect or the IAM page may contain an error. The above error suggests that the sysindexes is corrupt - normally if any of the system tables is corrupt, it is hard to […]


Technical Article

RE: Login failed for user ''''(null)''''

  • Reply

Teresita,Your SQL Agent is running on a local account. you have to use a domain account for it. If your domain is SQL_Smart then use an account like that for your Agent on the publisher and grant access to that account on your SQL at the subscriber. 


Technical Article

Removing a Full Text Catalog

  • Topic

I am trying to shrink a 50 Gb Db and I believe the Full Text Catalog is getting in the way. But trying to delete this object has not proven easy. I have tried the following:EXEC sp_fulltext_database 'enable'EXEC sp_fulltext_catalog 'ux_t100_full_text', 'drop'But the files are already gone so this returns an errorAccess is denied or the path […]


10 reads

Technical Article

RE: Re: Problem w/ the cursor in sproc

  • Reply

Just correcting myself here : In my previous post I assume that you are creating a bitmap so I suggested you do something like this : Declare @BitMap as int set @BitMap = 0 Select @BitMap = @BitMap | MyBit from ( Select 1 as MyBit union all Select 2 as MyBit union all Select […]



What Do I Do to Relax?


I’ve republished an editorial today from another author, called What do you do to...

Daily Coping 9 Dec 2022


Today’s coping tip is to find out something new about someone you care about....

Advent of Code 2022


Foreword Advent of Code is an annual event in which participants solve a series of...

Read the latest Blogs


các thế mai vàng đẹp và ý nghĩa phong thủy của chúng

By tt140411

các thế mai vàng đẹp và ý nghĩa phong thủy của chúng Trong giai...

Poking the Bear

By Grant Fritchey

Comments posted to this topic are about the item Poking the Bear

SSRS - Add end date for all SSRS subscriptions

By pwalter83

Hi, Could you please advice if it is possible to add an end date...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers