master key in the database error SSISDB
Please create a master key in the database or open the master key in the session before performing this operation. (Microsoft SQL Server, Error: 15581)
Archivo de la categoría: Windows
HandBrakeThe open source video transcoder
https://handbrake.fr/ HandBrake is a open-source tool, built by volunteers, for converting video from nearly any format to a selection of modern, widely supported codecs. Reasons you’ll love HandBrake:
How to fix endless reboot loop installing Microsoft ODBC Driver 17 – message: microsoft ole db driver for sql server a previous installation required a reboot
It basically requires cleaning the value of PendingFileRenameOperations (replacing the multi-string value with an empty string) under the registry key
How to: Configure an SSIS Package to Execute as a Proxy Account
To run an SSIS package with specific permissions, you can create a service account and configure the package to inherit the run as account. This way, developers won’t need to know the password. However, proxies can also be used for any SQL job step, not just SSIS packages. To create a new proxy, follow these… Leer más »
Create a Database Mail Profile
https://learn.microsoft.com/en-us/sql/relational-databases/database-mail/create-a-database-mail-profile?view=sql-server-ver16
How to assign permissions by schema in SQL Server
To assign permissions to a schema in SQL Server, you must first create a security role and assign permissions to the role. Then, assign the role to the desired user or group of users. Here is an example of code to assign SELECT permissions to a «test_schema» schema: sqlCopy code– Create a security role CREATE… Leer más »
SQL Duplicates Count Query for two or more columns
This query uses a commonly used query (CTE) to group the results and count duplicates in the zip_to_fips table. The first part of the query, the CTE, selects the columns «fips», «cnty_name» and adds an additional column «DuplicateCount» that uses the ROW_NUMBER() function to assign a unique number to each row that has equal values… Leer más »
User, group, or role already exists in the current database
You moved the database to another instance and created a new login for this database instead of moving the login from the old instance to the new instance. I recommend that you read my article “How To Move Logins To Another Instance(sp_help_revlogin)”. You may receive this error when you want to authorize the login that you created for the database… Leer más »
How to run a stored procedure on a daily /weekly/monthly basis?
In SQL Server, you should use JOBS to run a stored procedure based on schedule. Open SQL Server Management Studio. Expand SQL Serve Agent. Right-click on jobs and select a new job. Provide a name for the job and description. Click on the steps option> click new. Write the name of the step. Select the type of… Leer más »
SQL query to get start and end date from a result set
-1 I am working on one of requirement the raw data is in following format Requirement – Startdate should be the date when status changed to 1 and enddate should be the 1st date after the record status changed from 1 to any other number. Customer Status Date A123 0 7/2/2021 A123 0 7/15/2021 A123 0… Leer más »