SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• Restoring replicated data

  I am a software developer using MS SQL server as my database. I have setup transactional replicatio…

  mcdaniell2000

  2 replies

  1 years, 1 months ago

  By: rothj

• Query Help to show record in single row

  Hi All, need help with an SQL query. We have an existing table that's already formatted this way, a…

  sqldba20

  2 replies

  1 years, 1 months ago

  By: Steve Collins

• how do you manage new columns in a tabular table

  Hi we run 2019 ssas std.  Yesterday i imported my tabular project to vs 2022 and changed data sourc…

  stan

  5 replies

  1 years, 1 months ago

  By: stan

• MSDTC not available on Windows 2022 clustered SQL 2019 CU30

  I connect to this clustered instance and run : begin distributed transaction Msg 8501, Level 16, St…

  Johan Bijnens

  1 replies

  1 years, 1 months ago

  By: Johan Bijnens

• blocking folks from using a linked server and plumbing one to specific dsn

  hi, as we get further and further into netsuite connectivity, we want to block just about everyone …

  stan

  5 replies

  1 years, 1 months ago

  By: Johan Bijnens

• tabular model processed but wont deploy

  hi i imported a tabular model from production into vs 2022,  changed the data source to my dev azur…

  stan

  2 replies

  1 years, 1 months ago

  By: stan

• blocking folks from using a linked server and plumbing one to specific dsn

  hi, as we get further and further into netsuite connectivity, we want to block just about everyone …

  stan

  1 replies

  1 years, 1 months ago

  By: frederico_fonseca

• IF then Else statement not exiting

  I have an always on availability group of 3 servers (1 primary and 1 secondary (both on primary sit…

  radders500

  6 replies

  1 years, 1 months ago

  By: Jeffrey Williams

• how to find the 2nd and 2nd to last entry in a table?

  Hi everyone I am working on a query where the calculation depends on whether the entry is the 2nd e…

  water490

  5 replies

  1 years, 1 months ago

  By: water490

• do i need a driver for mysql?

  hi we'll want to communicate with a mysql server at one of our locations from our sql dw server for…

  stan

  3 replies

  1 years, 1 months ago

  By: stan

• how to stop command prompt window from appearing when running PowerShell script?

  Hi everyone I have a PowerShell script that is run by Execute Process Task in SSIS.  Each time I ru…

  water490

  8 replies

  1 years, 1 months ago

  By: Jeffrey Williams

• Is it possible to create a parameter and use different datasets?

  Hello, I have an SSRS report, version 2019,  that has two parameters, which will call for three dif…

  Tamrak

  9 replies

  1 years, 1 months ago

  By: Phil Parkin

• Rollback Logic Isn't Working

  Hi Everyone I am not sure how to do this correctly.  The below code "looks" right but it didn't rol…

  water490

  24 replies

  1 years, 1 months ago

  By: water490

• SSIS Connection Manager Errors

  issue resolved This topic was modified 1 years, 1 months ago by water490.

  water490

  1 replies

  1 years, 1 months ago

  By: water490

• One SP is not running in SSIS and I don't know why

  Hi everyone I have an SSIS package that has close to 3o SP that are run.  One container has 22 SP. …

  water490

  3 replies

  1 years, 1 months ago

  By: Phil Parkin