New answers tagged

1

I experienced this issue and it has been resolved by removing the SPN entry in the attributes of the computer account in AD for the server Find the machine account in AD Users and Computers(Advanced view) Then remove the two entries in servicePrincipalName for MSSQLSvc


2

A function may not see the same state of the database depending on whether it's VOLATILE or not, when this state is changing during the execution of the SQL statement it's called from, either because of the statement itself or because of another transaction if the isolation level is Read Committed. This is documented in https://www.postgresql.org/docs/...


0

I had a similar issue to this, and it turned out to be a connection time out. My program sets up a connection pool, and threads grab a connection from that pool when they need to make queries. Every morning when I would come in and try to run my program I would get the MySQL Server has gone away error. A lot of solutions I found said to increase the ...


0

SELECT ordertable.Order_ID AS OID, ordertable.Order_Status AS Status, ordertable.Delivery_Date AS Date, customer.Customer_Name AS Name, bill.Amount AS [Bill Amount] FROM ordertable INNER JOIN bill ON ordertable.Order_ID = bill.Order_ID INNER JOIN customer ON ordertable.Customer_ID = customer.Customer_ID WHERE ordertable.Order_status = 'completed'; Notes: ...


0

select order.order_status AS Status, order.Order_ID AS OID, order.Delivery_date AS [Date] from order inner join bill ON order.order_id = bill.Order_id


1

You have misunderstood the exact nature of FOREIGN KEYs. The field specified as a FOREIGN KEY has to exist in the table you are altering! I've put a correction of one issue into the fiddle here and pointed out some of your errors. I moved all of the table creation steps above the foreign key creation steps because that, in itself, can be a source of ...


0

Sounds like it is a syntax check complaining: select * FROM project where name='Anna' ^^^^ -- missing syntax keyword!


0

I experienced this issue just recently. I was running as the NT SERVICE account and when I switched to using a service account, I could no longer connect using SSMS with the machine name or the FQDN. I could connect with the IP address. With some digging I found that the SPN in Active Directory for the SQL instance was registered on the machine. Once I ...


Top 50 recent answers are included