Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL 2012 - General |
How Do You Change Data Type from uniqueidentifier - In the ss below you can see that I have a table (dbo.clan.spouses) with a column (spousesID) that has a datatype of uniqueidentifier. I assigned that value not knowing the consequences. The column (spouseID) is supposed to be the primary key with the IDENTITY attribute so that each record will have this value incremented. In […] |
SQL Server 2019 - Administration |
SSL Certificate Chain - SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m encountering an SSL certificate chain issue when trying to connect to my SQL Server from a Power BI server. The server connects, but when I click refresh, this error appears. Below are the details: Error Message: Microsoft SQL: A connection was […] |
SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI - I’m encountering an SSL certificate chain issue when trying to connect to my SQL Server from a Power BI server. The server connects, but when I click refresh, this error appears. Below are the details: Error Message: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login […] |
sqlserver metrics to capture - Can this baselining and benchmarking sqlserver be done using extended events ? what are the various events from underneath which can be captured as metrics to benchmark/baseline a sqlserver ? SELECT xp.[name], xo.* FROM sys.dm_xe_objects xo, sys.dm_xe_packages xp WHERE xp.[guid] = xo.[package_guid] AND xo.[object_type] = 'event' ORDER BY xp.[name]; What are the free options to […] |
SQL Server 2019 - Development |
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 source and target to be our dev box. One of the tables , "sales" has code behind it that looks like this "select * from vfactsales". I'm just the messenger here. moments before i imported, i changed […] |
tabular model processed but wont deploy - hi i imported a tabular model from production into vs 2022, changed the data source to my dev azure vm engine's DW database and ssas target "deploy to server" the azure vm as well. chose no on upgrading from what is probably a 2019 model to 2022. Im not the one who installed ssas […] |
Restoring replicated data - I am a software developer using MS SQL server as my database. I have setup transactional replication between two servers (A as publisher and B as subscriber). My application is running on server A. This has been running smoothly until my server A crushed. A new server has been provisioned for data to be restored […] |
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 (dbas, myself etc etc) from using a certain linked server that is plumbed to a production accounting instance of netsuite. Presumably plumbed to a dsn set up with the creds to see data there. I think i have […] |
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 (dbas, myself etc etc) from using a certain linked server that is plumbed to a production accounting instance of netsuite. Presumably plumbed to a dsn set up with the creds to see data there. I think i have […] |
SQL Server 2008 - General |
Why I get null instead I should get 0 - Code for mssql 2008 DECLARE @CompanyID TINYINT DECLARE @MemNo decimal DECLARE @MemberFrom Integer DECLARE @MemberTo Integer DECLARE @AreaFrom Integer DECLARE @AreaTo Integer DECLARE @status integer select @MemNo = 5, --@MemberFrom = 1, --@MemberTo = 3395, --@AreaFrom = 1, --@AreaTo = 44, @status = 1 create table #Memberlist( NoAhlilama int null, NoAhli int null ) create […] |
General |
Making Additions and Changes; Getting Error Preventing Them - MS SQL Server/SSMS are my tools. As my project evolves I find I need to add data elements (Columns) to my existing tables. I'm confident I will need to add additional tables to the database at some point. The first time I added a column and tried to close/save the table, I got an error […] |
SSMS Object Explorer Not Showing Tables - If this post doesn't meet protocol here, please tell me how to improve as I'm new here. I thought a screenshot would best help my question. In the ss you can see that I have a database (db?) created named hutchinsCLAN. I created - and even modified - 3 tables for it: clanPEOPLE, clanMARRIAGES, clanDEATHS. […] |
Integration Services |
bypass a non existing server - I have an execute task(has server list from a table) pointing to foraeachloop foreachloop has dataflowtask which has oledb source and oledb destination Everything runs fine as long the servers are available. In case a server is removed and still exists in the execute task (table) the package fails. How can I bypass a non […] |
SQL Server 2022 - Administration |
Services SqlServer and SqlServerAgent don't start. How resolve?? - Hi I have just installed again on win 11 sql server express 2022 with istance name OFFICINASERVIZI. But after first start it not work properly.. I already have done this: Power Shell (as admin) New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow New-NetFirewallRule -DisplayName "SQLServer Browser service" -Direction Inbound -LocalPort […] |
SQL Server 2022 - Development |
Or condition in where clause works differently in MS SQL comparing with Sybase - Hello, I ran below statements in MS SQL, and got error, but fine in Sybase: create table testDiffTypeSameCol (IssueNo int null, StringNumeric varchar(30) null) insert into testDiffTypeSameCol values (1, 'this is string') insert into testDiffTypeSameCol values (2, '123.456') select * from testDiffTypeSameCol where ( ( IssueNo = 2 and convert(numeric(15,2),StringNumeric) > 1.0 ) or ( […] |