SQL Prompt 5 crashes VS 2008

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Postby jloranger » Tue Feb 21, 2012 11:03 pm

I recently updated to version 5.2.4.1, now getting the VS 2008 crash, as reported by others. I have tried disabling SQL Prompt but still getting a crash when trying to preview a report. Is there any resolution, before I unistall? Been using SQL Prompt for years now, but this is a real problem for me.
jloranger
 
Posts: 1
Joined: Tue Feb 21, 2012 10:59 pm

Try Windows Update

Postby cousinsp » Wed Feb 22, 2012 8:47 am

We managed to get it sorted on one Windows XP machine by installing all Windows Updates (I think the problem was fixed by a .net update). Have another machine with the same problem, which I'll look at today to see if this corrects it.
Pete Cousins
cousinsp
 
Posts: 22
Joined: Thu May 21, 2009 1:15 pm
Location: Bournemouth, UK

Still crashing with SQL Prompt 5.2.8.2

Postby cousinsp » Tue Mar 13, 2012 12:14 pm

Disabling in BIDS work around still working for us.
Pete Cousins
cousinsp
 
Posts: 22
Joined: Thu May 21, 2009 1:15 pm
Location: Bournemouth, UK

Still crashing with SQL Prompt 5.3.2.2

Postby pagamecom » Wed May 23, 2012 7:57 pm

I have the same problem from within a VS 2008 report project where the reports are published to SSRS 2008 R2.

Currently running SQL Prompt 5.3.2.2

Disabled SQL Prompt add-in within VS 2008


From "About Microsoft Visual Studio"

Microsoft Visual Studio 2008
Version 9.0.30729.4462 QFE

Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: Professional

Microsoft Visual Basic 2008
Microsoft Visual C# 2008
Microsoft Visual C++ 2008
Microsoft Visual Studio 2008 Tools for Office
Microsoft Visual Studio Tools for Applications 2.0
Microsoft Visual Web Developer 2008
Crystal Reports Basic for Visual Studio 2008

Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899) KB944899
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282) KB945282
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040) KB946040
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308) KB946308
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344) KB946344
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581) KB946581
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171) KB947171
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173) KB947173
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180) KB947180
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540) KB947540
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789) KB947789
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127) KB948127
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256) KB953256
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971091) KB971091
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB971092) KB971092
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973674) KB973674
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB974479) KB974479
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140) KB945140
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888) KB947888
This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948484) KB948484
Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB948560) KB948560
Security Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB973675) KB973675
Security Update for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU (KB972222) KB972222

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 10.50.1600.1

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 10.50.1600.1

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 10.50.1600.1

Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453) KB956453
Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB967143) KB967143
Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB972221) KB972221
Terry
pagamecom
 
Posts: 2
Joined: Wed May 23, 2012 7:36 pm

Cant preview

Postby sayntin » Fri Aug 31, 2012 5:45 pm

Im having the exact same problem as the person that posted this.

Just installed SQL prompt 5.1.6.35 , and it caused same problems with VS2008 crashing out when trying to preview SQL2008R2 report.

I have uninstalled it,and now I am not having problems anymore. Guess I wont be using SQL prompt.
sayntin
 
Posts: 1
Joined: Fri Aug 31, 2012 5:42 pm

Postby pagamecom » Fri Aug 31, 2012 5:57 pm

I've found that the work around posted by David_S on Mon Jan 03, 2011 1:31 pm works within VS 2008. Doing this allows SQL Prompt to still be used within SSMS.

Although you may have to do it again when Redgate issues an update to SQL Prompt that installs a new version that resets its use in VS. I wasted a good part of this morning until I figured that out!

I've further noticed that if a report doesn't have any user selectable parameters VS doesn't crash/vanish. Very odd.
Terry
pagamecom
 
Posts: 2
Joined: Wed May 23, 2012 7:36 pm

Previous

Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 0 guests