Laden...
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
OPENJSON and Versions | |
OPENJSON is a SQL Server 2016 TVF. I have a database on an SQL Server 2019 instance that is set to compatibility level 120. What happens when I run this command: SELECT openjson(oj.myjson) FROM mytable AS oj | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
The Incomplete Standby I have a backup of a database from SQL Server 2019 that I want to restore on another SQL Server 2019 instance. The version levels are the same. I run this command: USE [master] RESTORE DATABASE [sandbox3] FROM DISK = N'D:\SQLBackup\New folder\sandbox_20210308.bak' WITH FILE = 1 , STANDBY , NOUNLOAD, STATS = 5 GOWhat happens? Answer: The database does not restore as a standby file is needed Explanation: If you use the standby option, you need to provide a filename for storing the recovery efforts for the database. Ref: RESTORE ARGUMENTS - https://learn.microsoft.com/en-us/sql/t-sql/statements/restore-statements-arguments-transact-sql?view=sql-server-ver16 |
Featured Script |
Python Script to generate test data tggirish from SQLServerCentral Very often there is a need to create test data manually. This script will provide a mix of names that will make more sense rather than randomly generating meaningless names.
|
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2016 - Administration |
BCP with ODBC 18? - Hello all. My org has identified ODBC driver version 17 as having security vulnerabilities. It looks as though 17.10.4.1 remedies these, but we're considering v18 anyways. It looks as though bcp requires version 17. Is this the case? Surely not, though I don't see otherwise. |
Administration - SQL Server 2014 |
Maintenance Task Failed - how to log the error - I've a Multi step Maintenance plan of 5 steps called "Reindex". This automatically created an Agent job called "Reindex..Subplan_1" There's an email alert on failure of the Agent job. Is there any place in maintenance task design to put an alert in or do I always have to use add the alert to Agent task […] |
Development - SQL Server 2014 |
Replace bad characters - Hi all I need help to replace bad characters with space in string. select col1, patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1) as [Position], substring(col1,patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1),1) as [InvalidCharacter], ascii(substring(col1,patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1),1)) as [ASCIICode] from myTable where patindex('%[^ !-~]%' COLLATE Latin1_General_BIN,col1) >0 Here is the result: Col1 […] |
SQL Server 2019 - Administration |
Error 500 when accessing SQL Server 2019 database - Need help! - I've recently set up a SQL Server 2019 database for a project I'm working on. The issue I'm encountering is that whenever I try to access the database, whether it's through my application or directly using SQL Server Management Studio, I'm getting an "Error 500" message. This error appears to be quite generic and doesn't […] |
Event ID 17806 - We have had SSPI errors across a dozen servers in an hour span. SQL error 17806 : Error code 0x8009030c – How to fix Per the above link : Stuck at the very first point... Cause of SQL error 17806 1.SQL Server engine account running with a Domain service account, and that account locked at […] |
disable seeding mode - hello , On one of our servers with 4 Replicas 2 synchronous and 2 asynchronous we see too many waits with the "VDI_CLIENT_WORKER" type almost 93% of the wait statst do you have to deactivate the seeding mode to minimize these times ? What do you think of this recommendation? |
SQLPackage Import Error - Hi After 1h the import fails with the error: Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 155, Level 15, State 1, Line 3 'AUTO_DROP' is not a recognized CREATE STATISTICS option. SQL Server 2019: 15.0.4316.3 sqlpackage.exe: 162.0.52.1 May the sqlpackage is to new but I didn't find the one who fits exactly. Thanks for […] |
SQL Server 2019 - Development |
MS Sync Framework Error - Failed to Execute the command BulkUpdateCommand - It turns out that the error is in a trigger on the Transfers table, so this can be ignored. Sorry if you've wasted your time reading this. Hi, I've got two databases at distant locations that sync evey few minutes using the Ms Sync Framework 2.1. I'm getting this error occurring: ERROR , SyncBPO, […] |
Odd columns datatype precisions showing in SSMS View... - Okay... haven't posted in a long time and was hoping I'd have a better topic to share but... we're seeing issues when expanding the view columns in SSMS and it's showing the wrong precision. The view is pulling from underlying tables using DECIMAL(11,2) but the view shows the columns as DECIMAL(12,2) - what would cause […] |
SQL code help to get one row for each sequential entry - Hi, I am looking for a sql help to generate one row per each sequental door_area, for a given employee, based on the sample data that looks like this: Current Output: Desired Output: Here is my code to test for sample data. CREATE TABLE dbo.emp_seq ( emp_id int, product_code int, clock_in datetime, clock_out datetime, door_area […] |
SQL Azure - Administration |
Connecting to SQL Azure - Best practice / method? - New to Azure SQL, so I'll start with that! We've had SQL on-premise for years and we're exploring moving to a SQL Instance in Azure (not a VM). A lot of our apps are desktop .Net apps that connect very simply over our internal network currently or VPN. We'd like to ditch that approach and […] |
Reporting Services |
Migrating Reports from SQL Server 2014 to SQL Server 2022 via Visual Studio 2022 - Migrating Reports from SQL Server 2014 to SQL Server 2022 via Visual Studio 2022 with Reporting Services extension installed. I am having trouble with parameters and the error message: "Must declare the scalar variable @TellMeWhyIdontlikeThisMonday". I'm also getting the error message: "Custom parameter layout was removed from the report. SQL Server 2014 Reporting Services and […] |
SQL Server 2022 - Administration |
Having problems with SQL Server 2022 CU5 (docker ubuntu image) - is it ready? - Ubuntu image came from here - https://hub.docker.com/_/microsoft-mssql-server?tab=description DBCC is failing - "can not create database snapshots" syspolicy_purge_history is failing due to a missing PowerShell installation master.sys.dm_server_services - is not listing the engine at all while listing agent running? Can't enable SQL Server Agent Alerts - most likely due to master.dbo.sp_MSsetalertinfo and msdb.dbo.sp_set_sqlagent_properties usage of registry |
SQL Server 2022 - Development |
Running 32 bit SSIS package - This is my first post in this forum, so hello everyone! Would be most grateful for help with the following issue: a simple SSIS package (created in Visual Studio 2019) imports a table from an ODBC Source (MySQL Server 5.xxx) into a database in a SQL Server 2022. ODBC Source is 32-bit, the package runs […] |
Searching in date field provides inconsistent results - I have been working with SQL Server for too many years to count and this is baffling; perhaps someone has a clue on the cause. I am running this on SQL Server 2022. I put together a simple function to return a primary key integer for a lookup table that has mileage rates that are […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. [email protected] |
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Laden...
Laden...