Search
-
SQL Source Control
I want to buy SQL Source Control for my company and needed some clarification. Came across the pricing below and not sure about the '1 license' part. $495 Total (excluding VAT) 1 license 1 year of support & upgrades What is 1 licence means? 1 User? 1 user multiple activation? 1 Machine? if means 1 user multiple activation,… -
Formatting help
Discussion by CraigRichards · · Home› Discontinued and Previous Versions› SQL Prompt Previous VersionsDoes anyone know how to get the following formatting to work? From IF EXISTS ( SELECT TOP 1 1 FROM inserted ) IF EXISTS ( SELECT TOP 1 1 FROM deleted ) /*Update Block*/ To IF EXISTS ( SELECT TOP 1 1 FROM inserted ) IF EXISTS ( SELECT TOP 1 1 FROM deleted ) AND This FROM deleted INNER JOIN INSERTED ON DELETED.PeopleId =… -
Can not get access to localDb
When attempting to install server components for localDb, I get could not find (shows my machine name) which is the machine I'm on and zero problem when doing the same for SQLEXPRESS (which works). So step 1 fails and I am a admin on this machine, step 2 validates, never get to step 3 but selected windows authentication. -
Re: memory issue
-
How to generate the consistent result for multiple days of data.
I am using SQL Data generator first time and trying to generate the data for following scenario for stress test. Scenario : I am trying to populate the MasterData in DailyFeedData table for each Business Day. BusinessDay_Id and MasterData_Id are foreign keys. The problem is Generator is populating the data in random… -
Re: Build server pipeline failing after auto-update of SQL Change Automation (v 4.4.22194.30982)
Hi It looks like a similar issue might have occurred again? TeamCity server version is 2022.10.2 (build 117025) RedGate SQL Change Automation Plugin: 5.0.7 [15:38:05] : [Step 1/6] Invoke-DatabaseBuild, SQL Change Automation 4.5.23032.654, Copyright ¸ Red Gate Software Ltd 2014-2023 ... [15:38:05] : [Step 1/6]… -
Re: Connection failed Internal SQL Monitor error "namespace root/mscluster is invalid"
-
An unexpected null value has been found while running postprocessing operations on the script databa
-
Re: SQL Prompt not working when using AAD - Universal with MFA authentication
2024-04-18 13:52:14.864 -05:00 [Warning] Failed to load server xxxxxxxx Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user '<token-identified principal>'. at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at… -
bug:Case and when become a word.
>5988 results