SQL Monitor

Technical Article

RE: Table Changes Don't Take

  • Reply

The public role was set up to have update permissions but I still did not work. This problem seems to have corrected itself because I can not make the changes that were impossible yesterday. It's probably something I changed with permissions but I am not sure what.


Technical Article

RE: Multiple select statements in a procedure

  • Reply

I would say that is a good way to accomplish your goal. You do have the ability to do something like this: select CountrySuperUser, (select MAX(VersionNumber) FROM tblVersion) as Version, col3, col4... from Sales... But I like the your way better. If you are returning multiple rows from the Sales table, it is more efficient […]


Technical Article

RE: Remote SP Failure

  • Reply

Its set up as a linked server. The remote login that it links to does have a default database of 'master'. The 'master' database also holds the SP that gets activated. I'm not sure that its anything to do with the login because the database does start restoring because you can see it in Enterprise […]


1 reads

Technical Article

RE: Insert n rows into table

  • Reply

Yup, I'm sure there is a better way to get where I'm going... all and any advice appreciated ... I have a table (tblBitMask) with two fields. A primary key and a non-null integer value field (BinaryValue). The value field will always be 2 to the power of an integer (e.g. 1,2,4,8,16 etc.). This table […]


2 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


Schedule Jobs on a Clustered SQL Server

By Prasad Chava

Comments posted to this topic are about the item Schedule Jobs on a Clustered...

Encrypting the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encrypting the Database Encryption Key

Privileges and Roles in SQL Server, Oracle and PostgreSQL - Part 1

By Additional Articles

Comments posted to this topic are about the item Privileges and Roles in SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers