Activity overview
Latest activity by BluThing
Hello.
sad, nothing happens here.
But you fixed the problem with the newest version 5.1.8.2 of SQL Prompt! Pleease fix it in SQL Search as well and we're happy!
Lutz
BluThing wrote:
Hi folks
I have this problem on the two machines I've testet it on so far. Even with the latest Version downloaded today.
OS: Windows 7 64 Bit German / Windows Server 2003 R2 SP2, SQL Server 10.0.4 German
The same problem exists in SQL Prompt when double clicking invalid obects.
Could you fix this meanwhile?
Thanks
Lutz
/ comments
Hello.
sad, nothing happens here.
But you fixed the problem with the newest version 5.1.8.2 of SQL Prompt! Pleease fix it in SQL Search as well and we're happy!
Lutz
BluThing wrote:
Hi folks
I hav...
Thanks for replying.
Sure, using a temporary table would solve my problem with SQL Prompt. Unfortunately there are some restrictions when using temporary tables with SQL Server. E.g. for debugging reasons we decided to use named tables.
A procedure that creates a table and then uses it, isn't really invalid. Is there no way for SQL Prompt to recognize this a valid or simply ignore it?[/quote] / comments
Thanks for replying.
Sure, using a temporary table would solve my problem with SQL Prompt. Unfortunately there are some restrictions when using temporary tables with SQL Server. E.g. for debugging ...
Thanks for your answer. Maybe I should have made clearer, that the stored procedure is found to be invalid only when table TMP doesn't exist.
So I guess this is the better example, because it removes table TMP when finished: CREATE PROCEDURE spTest
CREATE TABLE tmp
(
somecolumn INT
)
-- make something with table tmp
DROP TABLE tmp;
There isn't anything else to be done than create it, start it and then look for inavlid objects.
spTest is always found to be invalid as long as table tmp doesn't exist. / comments
Thanks for your answer. Maybe I should have made clearer, that the stored procedure is found to be invalid only when table TMP doesn't exist.
So I guess this is the better example, because it remov...
invalid stored procedures with CREATE TABLE inside
Hi,
the stored procedure
CREATE PROCEDURE test AS
CREATE TABLE TMP
(
somecolumn INT
)
INSERT INTO TMP(somecolumn) VALUES (1)
is discovered by sqlprompt as an...
Hi folks
I have this problem on the two machines I've testet it on so far. Even with the latest Version downloaded today.
OS: Windows 7 64 Bit German / Windows Server 2003 R2 SP2, SQL Server 10.0.4 German
The same problem exists in SQL Prompt when double clicking invalid obects.
Could you fix this meanwhile?
Thanks
Lutz / comments
Hi folks
I have this problem on the two machines I've testet it on so far. Even with the latest Version downloaded today.
OS: Windows 7 64 Bit German / Windows Server 2003 R2 SP2, SQL Server 10.0.4...