SQL Server 2019 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  6 months, 1 week 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

  6 months, 1 week 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

  6 months, 2 weeks 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

  6 months, 2 weeks 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

  6 months, 3 weeks 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

  6 months, 3 weeks 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

  6 months, 3 weeks 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

  6 months, 4 weeks 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

  6 months, 4 weeks 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

  7 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

  7 months ago

  By: water490

• SSIS Connection Manager Errors

  issue resolved This topic was modified 7 months ago by water490.

  water490

  1 replies

  7 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

  7 months ago

  By: Phil Parkin

• Change all occurances of one field in DB

  Hi everyone I am doing some clean up of my DB.  There is one field that I want to change in all tab…

  water490

  5 replies

  7 months ago

  By: Jeff Moden

• locks in sql database 2019

  please help. Do they know if the use of try and catch for error control can produce crashes in the …

  yfiguero

  1 replies

  7 months ago

  By: pietlinden