Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
DECLARE @user_ID INT=NULL IF EXISTS(SELECT userAccount_ID, createdBy_ID FROM USER_Permissions WHERE userAccount_ID = @userAccount_ID AND menuItem_ID = @menuItem_ID) BEGIN UPDATE USER_Permissions SET allowUpdate = @iUpdate ,allowView = @iView ,createdBy_ID = @user_ID ,updatedBy_ID = @updatedBy_ID ,dateUpdated = GETDATE() WHERE userAccount_ID = @userAccount_ID AND menuItem_ID = @menuItem_ID END ELSE
|MS SQL Server - Looking to filter rows based on column value||3||46|
|date diff with Fiscal Calendar||4||52|
|SQL Syntax: How to force case sensitive query?||2||44|
|Create SQL Server Job to perform backups of all the databases in a server instance||17||39|