Skip to content

Instantly share code, notes, and snippets.

@ShadobaAI
Created November 8, 2021 05:37
Show Gist options
  • Select an option

  • Save ShadobaAI/90cf556050a8ab2c208de87c5ec430f3 to your computer and use it in GitHub Desktop.

Select an option

Save ShadobaAI/90cf556050a8ab2c208de87c5ec430f3 to your computer and use it in GitHub Desktop.
#1С #SQL #user
USE [Имя_Вашей_Базы_Данных]
GO
/*EXEC sp_rename 'v8users', 'v8users_tmp'
GO
UPDATE [Params]
SET [FileName] = 'users.usr_tmp'
WHERE [FileName] = 'users.usr'
GO*/
/*DROP TABLE [v8users]
GO
EXEC sp_rename 'v8users_tmp', 'v8users'
GO
UPDATE [Params]
SET FileName = 'users.usr'
WHERE FileName = 'users.usr_tmp'
GO*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment