Interesting SQL code editor

Please check out:
Fast SQL Editor
A new and powerfull SQL editor for the professional user.
www.activefrog.com
We are still looking for Beta Testers of this new product. Please visit the
web site and download this amazing tool.
The activeFrog.com team
"activefrog.com" <mail@.activefrog.com> schrieb im Newsbeitrag
news:%23YStFAwIFHA.1096@.tk2msftngp13.phx.gbl...
> Please check out:
> Fast SQL Editor
> A new and powerfull SQL editor for the professional user.
> www.activefrog.com
> We are still looking for Beta Testers of this new product. Please visit
the
> web site and download this amazing tool.
> The activeFrog.com team
Although this question should be forbidden in this group... :-) Do you
plan to go cross platform, i.e. support other SQL dialects as well?
Kind regards
robert
|||One question I have is why develop a new sql editor considering that the
market is flooded anyway?
activefrog.com wrote:
> Please check out:
> Fast SQL Editor
> A new and powerfull SQL editor for the professional user.
> www.activefrog.com
> We are still looking for Beta Testers of this new product. Please visit the
> web site and download this amazing tool.
> The activeFrog.com team
>
>

Integration Services won't install

I am installing Visual Studio 2005 Professional on Windows XP.

I have finished installing Visual Studio 2005 Professional along with Service Pack 1. Now I am installing the Developer version of SQL 2005 that comes with Visual Studio 2005 Professional .

During the installation of SQL Server 2005, I got the following error during
the integration services installation portion:

Failed to install and configure assemblies: c:\program files\microsoft sql
server\90\dts\tasks\microsoft.sqlserver.msmqtask.d ll in the COM+ catalog.
Error -2146233087

Error message: unknown error 0x80131501
Error description: You must have administrative credentials to perform this
task.

I'm logged into Windows as Administrator.

This machine did previously have VS 2005 Standard and SQL 2005 Standard loaded. The software was RTM software as provided by Microsoft at their launch event. I did uninstall both products before attempting the upgrade.

Any help would be much appreciated.

Hi,

Refer below links for workaround

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136467&SiteID=1

http://geekswithblogs.net/waterbaby/archive/2006/08/03/87048.aspx

HTH

Hemantgiri S. Goswami

|||

This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:

1. Open Administrative Tools\Component Services

2. Go to Component Services\Computers\My Computer\COM+ Applications

3. Delete Microsoft.SqlServer.MSMQTask

Integration Services and VS 2005 Pro

My client machine has VS Studio 2005 Professional installed. My server has SQL Server 2005 Enterprise with BIDS installed. I would prefer to do my task development on my client instead of the server. How do I get the Integration Services projects on my installation of VS 2005? I went so far as installing SQL Express and BIDS on my local machine, but the only Business Development projects I get are Report Server. Any assistance would be greatly appreciated.

Thanks,

Lee

You need to get SQL Server 2005 Developer Edition on your local machine. SSIS isn't included in Express edition.

|||

Why do I even need a version of SQL Server locally? Can't I utilize the installation of SQL Server Enterprise on my server?

|||You don't have to have the database installed, just the tools.

Integration Help

I have a Visual Studio 2005 professional and Sql Server 2005 Express.

I download the 'Books on line for Sql Server' but when call help in VB interface or in

Management Sql Express the message appear:

Integrated help is not available ....

This is a bug?

Thanks,

Marsenne

Hi Marsenne,

It would be helpful to know the following information:

1. What version of Books Online did you download? The December 2005 or April 2006 version?

2. In what order did you install the components (VS, Express, Books Online).

3. Did you install Express from the VS installation or did you download SQL Express separately?

Regards,

Gail

|||

Hi Gail,

1. The version is December 2005 (SqlServer2K5_BOL_Dec2005.msi)

2. I install in order: VS, Express, Books Online.

3. Begin, I install Sql Express include in VS, but do not language brazilian portuguese. I remove this and install Sql Express spk1 (download).

Thanks and Regards,

Marsenne Negreiros

|||

Hi Marsenne,

It may be some issue between the December BOL and SQL Express SP1. WIll you please download the April version of BOL from here: (http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en and see if you have the same problem?

Thanks,

Gail

|||

Hi Gail,

I unistall the Dez/2005 and Install the Abri/2006.

The help is now integrated. Very good.

Thanks,

Marsenne

|||

Hi Marsenne,

Glad to hear that solution worked for you.

Regards,

Gail