|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
An Updatable View | |
I have this view, based on a table where CityNameID is an identity field.
CREATE VIEW dbo.City AS SELECT cn.CityNameID, cn.CityName FROM dbo.CityName AS cn GOI want to make it updatable to run this code: INSERT City (CityName) VALUES ('Elbert')What do I need to do? | |
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) |
Error Severity 10 I have code that raises an error. RAISERROR ('My error', 10, 1); When the calling program receives the error, what severity is returned to the client that called this code? Answer: 0 Explanation: For compatibility reasons, errors with severity 10 are converted to 0 before returning to the client application. Ref: |
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 |
Long running open temp_db transaction.Age in seconds = 3456 secs - Version : Microsoft SQL Server 2016 (SP2-CU17-GDR) (KB5014351) - Microsoft Corporation Enterprise Edition. We keep receiving these alerts. Are there any parameters which can be "turned off" to suppress these messages ? |
Import sql objects definiton into individual file - Hi, I'm trying to put the initial object definition into Azure Devops. My sql servers are on prem 2016. How can I script all the objects definition( table, views, stored procs, function) with if exists drop on the top in to their own individual file so that I can push them to Azure devops. This […] |
SQL Server 2019 - Administration |
Server Audit Specifications, Audit Action Type -- SELECT UPDATE INSERT DELETE - I'm trying to capture an audit of ANYONE logging into a database on my SQL 2019 Enterprise instance. When setting up my 'Server Audit Specifications' the 'Audit Action Type' drop down is not showing options to select SELECT UPDATE INSERT DELETE as presented in online tutorials. I am both LOCAL ADMIN and SQL sysadmin on […] |
add a group in local security policy - i want to add a group in multiple local security policy like 'Adjust memory quotas for a process', 'Lock pages in memory' , 'Log on as a service', how can it be achieved as a script? please share ideas. |
Veeam backups and Tlog maintenance - Was testing with VEEAM to do SQL backups... Using app aware, the set up indicates the tlog would be truncated. But after testing I found the tlog content was not being truncated after backup. Does anyone else use VEEAM with App Aware with SQL Server and how to you mange the size of your tlogs? |
SQL Server 2019 - Development |
xp_dirtree - Hello. I'm using sys.xp_dirtree to get a list of files in a folder. exec master.sys.xp_dirtree '\\myServer\Users\Documents\BulkInsert\', 1, 1; This was working fine whilst the number of files was approximately 3000. Now the number of the files has double but xp_dirtree is only returned the circa 3000 files. I changed the statement to :- exec master.sys.xp_dirtree […] |
Table reference issue - We've been tasked for updating a system for a client on a more modern approach. Currently they do their business in access forms. The problem is when I try to reference the table I added to their existing table, I get the following error ,' columns in table do not match an existing primary key […] |
SQL Azure - Administration |
Azure SQL Limit on external connections - Hello All, I have a use case to setup a Azure SQL DB for analytics and report developers. Planning for 20 people that will be connecting via SSMS/Azure Data studio/ PBI , excel etc. Reading the documentation there appears to be a very strong limit on external connections (which I assume the above are?) Is […] |
Reporting Services 2008/R2 Administration |
update data source on all SSRS reports - I have many reports that are using a shared data source. The data source looks like this and it is deployed to a certain location on the reports server. I crossed out some sensitive information. But hopefully you can see what this is. Our Windows admin is about to delete this account and he has […] |
Integration Services |
Execution of a Job Skipping Tasks When Ran from Agent - Hello, I'm running VS SSDT 2017. I made a package in SSIS that I want for the SQL Server Agent to be able to execute as part of a scheduled job in the Job Activity Monitor in SSMS. The problem that I'm having is that when I execute the package from the activity monitor, a […] |
Filtering result set with a value selected from another Sql Server - Hi, I have a very slow view at one of the customer's database. I could speed up the select if I could filter the data with Value_Date. The "problem" is that there are two Sql Servers in this equation and I don't yet know how to use variables / expressions to accomplish this... I know […] |
VS Professional 22 (17.8.6) installed - I can\'t create a SSIS ETL Project - Hi, I used to work a lot with MS SSIS ETL but I have been away 5 years now - working with Sql Server, DB2 and Informatica PowerCenter ETL Now I have an assignment with a customer who wants me to convert their PowerCenter ETL to SSIS due to company strategic policy. I installed Visual […] |
MySQL |
Synchronous vs. Asynchronous Replication - Hi All, I want to deploy both Synchronous vs. Asynchronous replication in mysql nodes at the same time, basically I need to setup a 3 mysql nodes as a cluster on AWS instances (Synchronous replication) to sync between each other and one mysql node in my on premise server with Asynchronous replication to work as […] |
SQL Server 2022 - Administration |
Data Architecture Options - We have a requirement to have 0 downtime during Migrations, more like Active- Active. What options do we have on Microsoft SQL Server side ? What restrictions do we have on Azure MI Business Critical? basically scripts are applied , every week as a part of Product Release and we need 0 down time, any […] |
SQL Server 2022 - Development |
Migrating from SAP SQL Anywhere to SQL Server 2022 Standard - Good day We are in the progress of migrating SAP SQL Anywhere to SQL Server 2022 Standard. However, we have encountered numerous cases where the stored procedures pass a calculation as a parameter, e.g. Declare @Par INT = 10, @ReturnValue INT = NULL; /* a lot of calculations and variable assignment happening in this block*/ […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |