Technical Article

data display in table

  • Topic

hello, i am having a table in which the value of one field is too long, and it isnot being displayed i tried nvarchar, ntext eveything but its not working any new ideas?? thanks in advance


2 reads

Technical Article

deny alter table priv - how?

  • Topic

Hi all Im trying to deny the "alter table" command for a schema user. Basically I dont use DBO, the applications in the database get their own userid and create object using it. Ive created the following role to deny schema access but can add to it the "alter table" command to stop developers from […]


212 reads

Technical Article


  • Topic

Hello, I've created the alert for Memory-Pages/sec Alert Over 2 in Performance Monitor, I'm getting net send message as Pages\sec is being over 2. I'm confused and what should I do to overcome it. My production server has 523 MB Ram and I've specified SQL Server to use memory dynamically setting max as 440 MB. […]


8 reads

SQLServerCentral Article

Using InterDev's Toolbox

  • Article

If you've ever played around with the toolbox, you may have discovered one of InterDevs hidden gems. Did you know that the InterDev Toolbox allows you to add you own custom tabs? This feature allows you to access frequently used snippets of code in an instant


3,051 reads


Daily Coping 3 Feb 2023


Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023


Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023


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

Read the latest Blogs


Coding Magic Values

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Coding Magic Values

How to Check previous data loaded records vs current day in a table

By Zond Sita

Hello Good Morning, I have three Tables, Assume Table1, Table2, Table3 these three tables...

Permissions Changes Not Doing Anything

By EsquireDeveloper

Hi friends, So I have a Login to a server that is a windows...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers