Viewing 15 posts - 1 through 15 (of 6,377 total)
Adding another entry to get to second page...
January 31, 2023 at 9:13 pm
DDL of Transactions table and ransactions_type below. I tried changing the column name.
What do you mean by this - 'I tried changing the column name'. If you have control...
January 31, 2023 at 9:12 pm
Make sure you are in the correct database - put a USE statement and a GO before the CREATE VIEW:
USE {your database here};
GO
CREATE VIEW ...
...
GO
And - please...
January 31, 2023 at 7:48 pm
Unless I am missing something - you are not going to be successful using SQL Server Express Edition. It looks like the original application was using SQL Server Express LocalDB.
Start...
January 31, 2023 at 7:38 pm
It sounds like you are installing a named instance on the server - and not a default instance. Named instances do not use the default port unless they are configured...
January 31, 2023 at 7:14 pm
It isn't SQL that is the problem - it would be network latency between sites causing the issues or maybe the routing on the network. SQL Server receives the request,...
January 31, 2023 at 7:05 pm
What is the current OS on the server(s) - and was that performed as an in-place upgrade also? The minimum OS to support SQL Server 2019 is Windows Server 2016. ...
January 30, 2023 at 9:46 pm
It also looks like you are not performing regular frequent transaction log backups. In SQL Server - when the database is not in simple recovery model, you must take frequent...
January 30, 2023 at 5:37 am
I would take the time to reinstall/reconfigure the workstations - using a CNAME alias instead of the actual server name. In the future when you have to perform another upgrade...
January 29, 2023 at 6:07 pm
That is very interesting - learn something new every day. Thanks for the update.
January 24, 2023 at 9:55 pm
Is this part of an availability group?
January 20, 2023 at 7:21 pm
So you changed it from Azure to an Azure Managed Instance - and no, it isn't currently possible to setup an AG with an on-prem instance and an Azure Managed...
January 12, 2023 at 11:06 pm
Another option is to use SSRS instead of SSIS - which then gives the end users a portal where they can access the 'report' and export it whenever and however...
January 11, 2023 at 9:35 pm
It should be possible - I think it depends on the version and maybe edition. How much effort is involved in setting it up may have changed with SQL Server...
January 10, 2023 at 7:45 pm
Since the installation now includes enabling that feature - and when checked it places the per-service SID in the appropriate local policy, I am not sure why there is any...
January 7, 2023 at 6:01 pm
Viewing 15 posts - 1 through 15 (of 6,377 total)