Posts
Sort by recent activity
Event-Log Error: 0
In the SQL-Prompt Eventlog I got many error messages with the same error:
2011-05-30 10:48:18,636 [Data Source=xxxxx;Initial Catalog=master;Integrated Security=SSPI;Pooling=False;Application Name=U...
INSERT INTO ... doesn't return the correct column order
Hi,
I have a table function with a table as return value.
For example:CREATE FUNCTION [dbo].[GetAddress] (
)
RETURNS @Result TABLE (
_ID INT
, LastName NVARCHAR&...
Performance counter are not working Windows XP SP3
Hi,
we installed the ANTS Performance Profiler on 3 different Windows XP SP3 machines. And all show the same problem.
When we choose the ASP.NET web application (IIS) and just choose the Processo...
missing SQL Monitor in my SQLToolbelt-Package
I tried to install the SQL-Monitor from the SQL-Toolbelt.exe but it is not included.
The exe file is from April 2010. Is there a newer one? Where can I get it?
Prompt 5 extremly slows down SSMS with large Procedures
If I open a very large Procedure or Batch with more then 1000 rows, SSMS is getting very slow with SQL-Prompt 5.0. :shock:
I didn't have the problem with SQL-Prompt 4.0.
Any idea?
System.OutOfMemoryException -- After about 3 refreshes
Hi,
I have a compare project with a very large database with about 430 tables.
It works perfectly until i refresh the compare result for the 3rd or 4th time.
I had to change the mapping of some of ...
Why is there no fullscreen mode for the compare definition
Hi,
I try to compare 2 very large Databases with a lot of tables and the window to select the table and views is very small, and I can not read the full table or comparison key name. Even the colum...
(XML) value statement is autom. converted to uppercase!
When I use an XML variable and try to create a SELECT like this:SELECT T.C.value('@Test', 'INT') as Test
FROM @XML.nodes('V') T(C)
is changed to this:
SELECT T.C.VALUE...
Still no Variable hint in SQL-Prompt v4.0.3
Hi there,
I just installed the new SQL-Prompt v4.0.3 patch....
most of the problems where removed and it works perfectly except
that I don't get a variable hint after about 200 lines...
So, I guess...
INSERT INTO .... shows VALUES()
In 3.9 SQL-Prompt did not insert the VALUES () if I had a SELECT .... following the INSERT INTO...
Any chance to get this behaviour in 4.0 (or would it be possible to get the INSERT INTO ...columns...