How can we help you today? How can we help you today?
mortenn
Activity overview Badges (0) Posts (4) Comments (11)

Activity overview

Latest activity by mortenn

and counter is only in the table important_message_limit_count, I do believe. Maybe it gets confused by the left join outside the subquery part where this popup is opened.. / comments
  1. Community
  2. SQL Prompt
  3. Unhelpful popup
and counter is only in the table important_message_limit_count, I do believe. Maybe it gets confused by the left join outside the subquery part where this popup is opened..
0 votes
I don't remember seeing it for other queries, but it consistently happens for this one view definiton; SELECT<br>&nbsp;&nbsp;&nbsp; important_messages.id, name, alias, operation AS product_operation, important_messages.message, comment_startup, comment_stop,<br>&nbsp;&nbsp;&nbsp; registered, registered_by, selection.article, batch, counter, from_date, to_date<br>FROM (<br>&nbsp;&nbsp;&nbsp; SELECT &nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; dbo.important_messages.id,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; dbo.important_message_limit_batches.article,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; batch<br>&nbsp;&nbsp;&nbsp; FROM dbo.important_messages<br>&nbsp;&nbsp;&nbsp; JOIN dbo.important_message_operations ON (dbo.important_messages.id = dbo.important_message_operations.message)<br>&nbsp;&nbsp;&nbsp; JOIN hqas_product_operations ON (dbo.important_message_operations.operation = dbo.hqas_product_operations.id)<br>&nbsp;&nbsp;&nbsp; JOIN dbo.important_message_limit_batches ON dbo.important_messages.id = dbo.important_message_limit_batches.message<br>&nbsp;&nbsp;&nbsp; UNION<br>&nbsp;&nbsp;&nbsp; SELECT &nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; dbo.important_messages.id,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; dbo.hqas_batch_operations.article,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; dbo.hqas_batch_operations.batch<br>&nbsp;&nbsp;&nbsp; FROM dbo.important_messages<br>&nbsp;&nbsp;&nbsp; JOIN dbo.important_message_operations ON (dbo.important_messages.id = dbo.important_message_operations.message)<br>&nbsp;&nbsp;&nbsp; JOIN hqas_product_operations ON (dbo.important_message_operations.operation = dbo.hqas_product_operations.id)<br>&nbsp;&nbsp;&nbsp; JOIN dbo.hqas_batch_operations ON dbo.hqas_product_operations.id = dbo.hqas_batch_operations.source<br>&nbsp;&nbsp;&nbsp; JOIN dbo.hqas_batches ON dbo.hqas_batch_operations.article = dbo.hqas_batches.article AND dbo.hqas_batch_operations.batch = dbo.hqas_batches.batch<br>&nbsp;&nbsp;&nbsp; JOIN dbo.important_message_limit_count ON dbo.important_messages.id = dbo.important_message_limit_count.message<br>&nbsp;&nbsp;&nbsp; WHERE counter > 0<br>&nbsp;&nbsp;&nbsp; UNION<br>&nbsp;&nbsp;&nbsp; SELECT &nbsp;&nbsp;&nbsp; <br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; dbo.important_messages.id,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; dbo.hqas_batch_operations.article,<br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; batch<br>&nbsp;&nbsp;&nbsp; FROM dbo.important_messages<br>&nbsp;&nbsp;&nbsp; JOIN dbo.important_message_operations ON (dbo.important_messages.id = dbo.important_message_operations.message)<br>&nbsp;&nbsp;&nbsp; JOIN hqas_product_operations ON (dbo.important_message_operations.operation = dbo.hqas_product_operations.id)<br>&nbsp;&nbsp;&nbsp; JOIN dbo.hqas_batch_operations ON dbo.hqas_product_operations.id = dbo.hqas_batch_operations.source<br>&nbsp;&nbsp;&nbsp; JOIN dbo.important_message_limit_date ON dbo.important_messages.id = dbo.important_message_limit_date.message<br>&nbsp;&nbsp;&nbsp; WHERE GETDATE() BETWEEN from_date AND to_date<br>) AS selection<br>JOIN important_messages ON selection.id = dbo.important_messages.id<br>JOIN dbo.important_message_operations ON (dbo.important_messages.id = dbo.important_message_operations.message)<br>JOIN hqas_product_operations ON (dbo.important_message_operations.operation = dbo.hqas_product_operations.id)<br>LEFT JOIN important_message_limit_count ON (important_messages.id = important_message_limit_count.message)<br>LEFT JOIN important_message_limit_date ON (important_messages.id = important_message_limit_date.message) / comments
  1. Community
  2. SQL Prompt
  3. Unhelpful popup
I don't remember seeing it for other queries, but it consistently happens for this one view definiton;SELECT<br>&nbsp;&nbsp;&nbsp; important_messages.id, name, alias, operation AS product_operation...
0 votes
Unhelpful popup
  1. Community
  2. SQL Prompt
The use of ellipsis here is quite unhelpful..  -- Regards, Morten
2 followers 3 comments 0 votes
Hi, I have still not been able to resolve this.. Is it really that strange to want to secure the access to web frontends using NTLM/Kerberos? // Morten / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Windows authentication in IIS 7
Hi, I have still not been able to resolve this.. Is it really that strange to want to secure the access to web frontends using NTLM/Kerberos? // Morten
0 votes
I am trying to use windows authentication between my browser and the web site. / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Windows authentication in IIS 7
I am trying to use windows authentication between my browser and the web site.
0 votes
Windows authentication in IIS 7
  1. Community
  2. SQL Monitor Previous Versions
Hello, I am having some trouble getting SQL Monitor to use Windows authentication through IIS. If I enable windows authentication and disable forms authentication in IIS, I get prompted for a usern...
2 followers 4 comments 0 votes
I can confirm 10.0.0.160 as working properly for me. -- Regards, Morten / comments
  1. Community
  2. SQL Compare Previous Versions
  3. version 10 - tries to create db for remote dbs
I can confirm 10.0.0.160 as working properly for me. -- Regards, Morten
0 votes
Okay, it was the same error again, but somehow it didn't affect SQL Compare 10 before I installed the .160 version, how peculiar.. -- Cheers, Morten / comments
  1. Community
  2. SQL Compare Previous Versions
  3. version 10 - tries to create db for remote dbs
Okay, it was the same error again, but somehow it didn't affect SQL Compare 10 before I installed the .160 version, how peculiar.. -- Cheers, Morten
0 votes
Hi, I was getting this as well after upgrading, so I installed the new build.. Now my SQL Compare is crashing upon startup, like I was experiencing at one time, using version 9. Looking at the email from that time, then it was a AV/Firewall issue, but I cannot see anything in the log this time around. Debugging the application, I get this exception: System.Net.Sockets.SocketException An attempt was made to access a socket in a way forbidden by its access permissions at System.Net.Sockets.Socket.DoBind(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.Bind(EndPoint localEP) at #Ahw.#Fhw.#PdC(Int32 nMilliSecondsToWait) at #Ahw.#Fhw.#PdC() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() My previous problem was logged with the number F0050810. -- Regards, Morten / comments
  1. Community
  2. SQL Compare Previous Versions
  3. version 10 - tries to create db for remote dbs
Hi, I was getting this as well after upgrading, so I installed the new build.. Now my SQL Compare is crashing upon startup, like I was experiencing at one time, using version 9. Looking at the emai...
0 votes
It was blocking SQL Compare from listening on a local port, connecting to the SQL server wasn't blocked at all. Thanks for the help figuring this one out! // Cheers, Morten / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Compare 9 crashes on launch due to DragDrop registration
It was blocking SQL Compare from listening on a local port, connecting to the SQL server wasn't blocked at all. Thanks for the help figuring this one out! // Cheers, Morten
0 votes
Total activity
19
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4