Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2017 - Administration |
Generate scripts with least privilege - How to execute "Generate scripts" option for database with minimum privilege ? I am using "Generate scripts" for "Types of data to script" - Schema only option. There are some confidential data in some database , hence we don't want to give other user data view/modify permission. Is it possible to give a User/login "view […] |
SQL Server 2017 - Development |
Case Statement - I am having an error with this code: select customer_name, order_id, (case when sum(status = 'delivered') = count(*) then 'completed' when sum(status = 'delivered') > 0 then 'in progress' when sum(status = 'submitted') > 0 then 'awaiting progress' else 'awaiting submission' end) as status from customer_order group by customer_name; error = Msg 156, Level 15, State 1, Server dbrank-tsql, Line 2 Incorrect syntax near the keyword 'when' |
Is it possible to migrate a solution from SSMS to SSDT?? - VS 2017, SQL Server 2016 and 2017, is it possible and or making sense to migrate a solution from SSMS to SSDT? The main purpose is to incorporate large solutions with multiple files into TFS that SSMS is not supporting. |
SQL Server 2016 - Administration |
Tempdb Showplan for user without login - I'm running into the following issue. The stored procedure I need to performance tune uses a user without login. This is needed for row-level security. But the problem I ran into is that I cannot give this user showplan rights in the tempdb database. Does anyone have a solution or workaround for this? |
SQL Server 2016 - Development and T-SQL |
Complicated insert - I want to insert values from Table1 to Table2 Conditions: when thier is a location with "xx", the row needs to be inserted twice the Empno in table2 is a primary key with identity seed. Expected Output |
Missing Indexes - We are noticing a lot of I/O latency on our SQL server. Is it common to have a lot of missing indexes? We are trying to narrow down what could be causing all the I/O latency we are seeing. Thanks for any help! |
Administration - SQL Server 2014 |
Backup SQL database generates error - Hi I have a server running Microsoft SQL 14 on window server 2012. At december 06 it stopped to take backups every night. I got following error message: The operating system returned the error '1(Incorrect function.)' while attempting 'ReadFile' on 'C:\Program Files\Microsoft SQL Server\MSSQL12.OPUS\MSSQL\DATA\OPUSDATA\a488f2a0-564d-44ce-8e57-7d5425d5b798\c55b8372-9595-4dce-9b68-16f5f5466a44\00016be8-000001a9-0005 I have checked if the file in the error message exist […] |
No objects listed for "SQL Server performance condition alert"? - Hi All, Facing a weird issue. We are trying to create some alerts in our SQL Server 2014 BI edition. Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box. SQL Server event alerts are working. Issue is only with "SQL Server performance condition […] |
SQL Server 2019 - Administration |
password expiration policy- should it be enabled? (linked servers/SSRS) - Hi, I would like to ask you for 'best practices' regarding password expiration policy for accounts used by linked servers and SSRS, or other applications. I can see that due to security reasons it makes sense to enforce password policy expiration for all accounts which use SQL server authentication. At the same time, I can […] |
Linked server to Unisys DMSII - HI, I am creating a linked server to Unisys DMSII database. I installed MCP driver and created a ODBC connection. The ODBC was working 2 weeks ago, but now the ODBC connection could not remember the password. If I put the password in the password field and test it, it works, but if […] |
SQL Server 2019 - Development |
Start Sql server agent job after a trigger - Is it possible to start Sql server agent job after a trigger? what i want to do is after a certain table updates a certain column, then it runs a job that has various sql stored procedures. if not possible at all, is there something similar to this? |
The same value across 5 or more columns in a table , How can I write a query - I got a table with 5 integer columns and one varchar(100) column. Select * from tbl1 where col1 = col2 or ....col5=col4 ..... I dont want to do this. Can we concatenate these fields and somehow comeup with a RegEx or some other way to find the rows that have the same integer values across […] |
Trying to print barchart to PDF file using Python within SQL Server ML module - There are likely to be several unrelated errors here, but I'm going to start with the first one what I can get my mind around. I'm trying to use the "Python within SQL Server" mechanism to generate a barchart to PDF. I get an error message that I don't have permissions to the directory I'm […] |
Reporting Services |
accessing a shared data source that is created in report server, by report desig - Hello There, I created a shared data source over SSRS report server web-portal; I am wandering, if it can be used /accessed by report-designer while building a report? I got this concern, because, as I tried to find a way out to access a shared data source by right click on shared data source > […] |
Anything that is NOT about SQL! |
SSC Fantasy Football 2022 - Placeholder for the 2022 league. Congrats to the 2021 winners: First - Jimbabwe Seahawks - $100 Second - British Bulldogs - $75 Third - Green Machine - $50 |