External Article

So You Need to Expose JSON Endpoints

  • Article

Even the most experienced programmers can be caught out unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON method in an ASP.NET MVC controller class suddenly started to cause an exception on a production server, and how he fixed the problem.


2,813 reads

Technical Article

Truncate Log File

  • Topic

Hi all,I have written a program using vb6 and SQL 2000. The program run day by day and it make the log file of DB growth suprisingly, I have try to reduce the size of log file by backup the log file but i am not successful, please advise me how to divide the log […]


4 reads

Technical Article

RE: Standards for Backup

  • Reply

You can archive the catalogs (into cab files) and then back these up (this archive can be done manually or via a commandline tool), or alternatively backup the data files that are on disk (ie within the data directory) but when doing this you must ensure that you back up the repository at the same […]


Technical Article

RE: Error 22022: SQLServerAgent Error:

  • Reply

Does the error message show a job name or a long string of characters that is the ID of the job? If it is the latter then it may be that you have made changes to the job since it was scheduled. When you schedule a job using Enterprise Manager it uses the ID of […]


Technical Article

RE: Re: SQL2K SQL2K silent installation

  • Reply

Where did you hear from that unattended install only supports per-seat licensing mode? There is a known issue with unattended install using pre-processor licensing. See Q273769 - FIX: SQL Server Setup May Fail If You Select Per Processor Licensing Mode (http://support.microsoft.com/?id=273769) So, if there is a fix for it, my guess is that using unattended […]



Daily Coping 1 Dec 2022


Today’s coping tip is to discover your artistic side. Design a friendly greeting card....

New Database Job – The 6 Month Plan


So, we made it through our first 90 days, things start getting tougher now...

SQL Homework – December 2022 – What’s new in SQL Server?


SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still...

Read the latest Blogs


tậu mai giống ở đâu? Nơi bán phôi mai vàng giá rẻ, bán mai giống TPHCM

By tt140411

tậu mai giống ở đâu? Nơi bán phôi mai vàng giá rẻ, bán mai...

The Last Valid Restore Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Valid Restore Time

Getting started with ROUND() and Its Use Cases

By Manvendra Deo Singh

Comments posted to this topic are about the item Getting started with ROUND() and...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers