Comments
Sort by recent activity
I can not, at this time, do anything with SQL Prompt 4.
I have removed it until the patch release comes out.
I am using SQL Prompt 3.9. / comments
I can not, at this time, do anything with SQL Prompt 4.
I have removed it until the patch release comes out.
I am using SQL Prompt 3.9.
Tanya
I sent you an email with a script attached.
I experienced the error starting on line 482.
That is where I was making an update to the script. / comments
Tanya
I sent you an email with a script attached.
I experienced the error starting on line 482.
That is where I was making an update to the script.
I am having the same problem.
It does not matter if I am in SSMS 2008 or VS 2008.
I will be going back to ver 3.9 until the version after 4.0.2.53 comes out. / comments
I am having the same problem.
It does not matter if I am in SSMS 2008 or VS 2008.
I will be going back to ver 3.9 until the version after 4.0.2.53 comes out.
You must not have read my entire post.
Once I ran devenv /resetsettings
SQL Prompt is now there. / comments
You must not have read my entire post.
Once I ran devenv /resetsettings
SQL Prompt is now there.
I removed the path.
I then added the path.
Restarted VS 2008.
No error but no SQL Prompt 4.
I went in to Add-in Manager and checked the box for it to load.
Restarted VS 2008.
Received the same error.
I am running Vista Enterprise 64 bit.
Once I ran the devenv /resetsettings
SQL Prompt 4 is now there. / comments
I removed the path.
I then added the path.
Restarted VS 2008.
No error but no SQL Prompt 4.
I went in to Add-in Manager and checked the box for it to load.
Restarted VS 2008.
Received the same erro...
Management studio is fine, just VS 2008 is not.
I went in and checked the box for it to load.
When I restarted VS 2008, I get the following error:
The Add-in 'SQL Prompt 4.0' failed to load or caused an exception.
Error Message: Unspecified error
Error number: 80004005 / comments
Management studio is fine, just VS 2008 is not.
I went in and checked the box for it to load.
When I restarted VS 2008, I get the following error:
The Add-in 'SQL Prompt 4.0' failed to load or caus...
Any idea of a time frame for the fix for this problem?
I am having the same issue with a DECLARE tmp CURSOR FOR SELECT ... statement.
Everything is left justified. / comments
Any idea of a time frame for the fix for this problem?
I am having the same issue with a DECLARE tmp CURSOR FOR SELECT ... statement.
Everything is left justified.
I have tried inline comments.
FROM
dbo.Users u
JOIN [$(csql2)].[$(UserAdmin)].dbo.Person AS p -- @A1A
ON u.External_Person_Key = p.TechId -- @A1A
and I get the following:
FROM
dbo.Users u
JOIN [$(csql2)].[$(UserAdmin)].dbo.Person AS p
-- @A1A
ON u.External_Person_Key = p.TechId -- @A1A
/ comments
I have tried inline comments.
FROM
dbo.Users u
JOIN [$(csql2)].[$(UserAdmin)].dbo.Person AS p -- @A1A
ON u.External_Person_Key = p.Te...
I am having samilar problem.
I have determined that SQL Prompt does not function properly in an Update statement that has a From clause.
If I try to do the following:
Update Person
set ExpirationDate = a
From Person as p
join OpData.dbo.ST_PROG as sp
on p.TechId = sp.TECH_ID
The prompting works fine where I would expect it to.
When I add a second join:
Update Person
set ExpirationDate = a
From Person as p
join OpData.dbo.ST_PROG as sp
on p.TechId = sp.TECH_ID
join OpData.dbo.
The candidate list has the columns for the table Person.
When I add any additional letters the list goes blank.
Refreshing the cach does not update the list.
If I do the following:
--UPDATE Person
--SET ExpirationDate = a
SELECT *
FROM Person AS p
JOIN OpData.dbo.ST_PROG AS sp
ON p.TechId = sp.TECH_ID
JOIN OpData.dbo.
Then I get the list of tables and views from OpData.
I have this problem in SSMS 2008 and VSTS 2008.
I hope this information helps to isolate the problem and solve it.
Microsoft SQL Server Management Studio 10.0.1600.22
Operating System Vista Enterprise 64bit SP1
Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.31124.01 / comments
I am having samilar problem.
I have determined that SQL Prompt does not function properly in an Update statement that has a From clause.
If I try to do the following:
Update Person
set ExpirationDa...
David,
I did do a "Connect to Server" and chose the deployment database, but the tab key did not work.
Now that I have reinstalled SQL Prompt, the tab key works.
Although I still do need to do the "Connect to Server", it is a minor inconvience.
Otherwise, SQL Prompt is a great product that I would recommend to other DBA's.
Thanks
Bill / comments
David,
I did do a "Connect to Server" and chose the deployment database, but the tab key did not work.
Now that I have reinstalled SQL Prompt, the tab key works.
Although I still do need to do the ...