Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Log Shipping Not Able to Restore Log Files in Secondary - I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL Server 2017 Standard. I have restored the database in the follow storage layout on the SQL Server 2017 machine: D:\Data\.mdf L:\Logs\.ldf When I execute the restore job and it skips all log backups. I ran restore verifyonly for the log backups […] |
SQL Server 2017 - Development |
Fax/Phone Area code Substring - Hello, For the below SQL, why the column "Phone_Country_Code" Code is showing "0" instead of Empty String, tried various logical function but always display 0. WITH SM AS (SELECT 'US' country_code, '8009222820' order_phone UNION ALL SELECT 'US','' order_phone UNION ALL SELECT 'CA', '15403262611' order_phone UNION ALL SELECT 'CA', null order_phone UNION ALL SELECT 'CA', […] |
SQL Server 2016 - Administration |
Migrating MDS model individually using MDS UI - Hi All, Is there a way i can create package for an individual model from MDS and then import to another sql server? I tried using MDSModelDeploy command, however it failed as below without much details Creating a package for model My_Model MDSModelDeploy operation failed. Elapsed time: 00:00:00.9550522 Error: A database error has […] |
SQL Server 2016 - Development and T-SQL |
Update records based on several common columns - I have 4 tables (apologies for the formatting of the tables, I don't know how to better show it) Order lines table: | Id | RateTierIds | price| | -----|-------------|---| | 1 | 1 | 20 | | 2 | 2 | 30 | Rate plans table: | Id | Name | | ---|--------| […] |
Eliminate a function by writing out the code is now throwing an error - /* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016 is telling me implicit conversion from datetime2 to float can not be done. Is there a way I can get around this, while still ellimating (writing out) the function? dbo.to_numb is just another function, shouldn't effect the CASE this query works […] |
SQL Server 2019 - Administration |
ExecutionLog3 table in Reportserver Database - I have a SSRS report for which users are complaining to be slow, but from querystore, I can see that the SP (Report only has this SP execution) is taking less than 15sec. In ExecutionLog3 table, timedataretrieval for the same report is showing up to be for more than 20 mins. Could anyone tell me […] |
SQL Server Maintenance Plan Feedback - Hi I set this up today. I wanted to get some feedback. I have some questions: 1. How often should I be running each subplan? 2. What order should each subplan be run? Here is the plan (proposed): Thank you |
Error when trying to enable cdc . Could not update the metadata - Server and db in SQL SERVER 2019. I have multiple tables that are enabled for CDC , however starting in the last two weeks I started getting this error Msg 22832, Level 16, State 1, Procedure sys.sp_cdc_enable_table_internal, Line 673 [Batch Start Line 6] Could not update the metadata that indicates table [DBO].[XXXX] is enabled for […] |
Server Role for User Database Access - I am looking to simplify a development server access issue. Databases are constantly being added to this server/cluster which requires me to add the developer AD group to the new database as a DB_OWNER to allow them to do the needful. This is a PITA! I have in the past used a job created to […] |
SQL Server Migration - Redirecting Old Instance Connections to New AG Listener - Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a highly available environment with minimal disruption (Not wanting to update the connection strings) I’d love to get some advice from the community on the best approach. Current Setup (For the sake of this post) Existing SQL Server: SQLSERVER\INSTANCE New SQL Server […] |
SQL Azure - Administration |
Create managed identity on Azure SQL MI/ Azure SQL DB using sql login - I am able to successfully create managed identity on Azure SQLMI & Azure SQLDB, i login through MFA and my account has sysadmin privileges. I need to be able to create managed identity using sql login and that sql login only has db_owner permissions, when i try to create managed identity it fails with […] |
Azure SQL database import permissions - What the required permissions are for "Database import" on an Azure SQL database Trying to import a database or copy it from another Azure sql With database import, before you get to the selection of subscription ... Extension: SqlAzureExtension Content: DatabaseImportBlade Resourceid /subscriptions/1ec..... Error: 403 |
SSRS 2012 |
Parameter dataset doesn't show results in dropdown - My report has been working fine. Now, when I run the report, the Location parameter randomly loses its data. When I use the dropdown, it is blank. It's filling in now but, tomorrow it may be blank. Any thoughts |
SQL Server 2022 - Administration |
Installing SQL FCI Instance certificates - SQL FCI Instance certificates I have a client who has a requirement for certificates bound to the instance in a FCI environment. I have create the certificate and installed on both nodes, but I get a cluster error when failing over. The environment setup Node1 Node2 FCI Instance name\SQLInstance Have set the FCI and […] |
Merge Replication - Lost Change - I have a server set up as publisher/distributor and another as subscriber to a merge publication that includes tables/views/sprocs. The merge process runs every 10 seconds and is generally working fine. Recently, a change was pushed to a table included in the publication that added a column and assigned an FK constraint to another table […] |