Extending SQL Server 2005 Mgmt Studio?

Hi,

I've had requests for a version of my product ViEmu, a VS.NET 2003-VS2005 add-in, which will work within SQL Server 2005 Management Studio. I had a look at the Mgmt Studio, and it seems to be a version of the VS2005 environment customized for the product. There is a registry hive along the line of the one in Visual Studio, but located in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell.

I looked for any hint online, but it seems largely undocumented.

I tried plugging my software by writing the right 'Packages' and 'AutoloadPackages' keys, and running "SqlWb /setup", which seems to do something. Nothing happened afterwards, anyway, the DLL doesn't seem to be loaded into the process. I tried using the '/log' option, but an error message comes up (which doesn't describe the /setup option either).

Is there a way to load a VS package into SQL Server 2005 Mgmt Studio? Is this a problem with the PLK? Is it unsupported? Has anybody been successful in such a feat? Would it be ok if I hack some way, no matter how obscure? Is this deliberately turned off, as in the Express editions?

Best regards and thanks in advance,

- J
-
ViEmu - vi/vim emulation for Visual Studio

Try the SQL Tools forum.

-Jamie

Extend MSDE to Enterprise

I have a system that came with the MSDE database, because of the 2G limit I
am trying to point it to the enterprise version of SQL 2000. All connection
strings have been changed to the enterprise (With vendor help). The connec
tion is established and acc
ording to a trace from Profiler, all queries are running and inserting the d
ata in the right table. But there is no data in the tables! No errors eith
er.
One of my tests was to point it to another MSDE and it worked fine. What is
different between these two versions that will cause data not to be written
to the tables.
ThanksHi,
Can you insert few records in to the tables manually and see what is
happening. I feel that application is
still pointing towards a different database.
Thanks
Hari
MCDBA
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I have a system that came with the MSDE database, because of the 2G limit
I am trying to point it to the enterprise version of SQL 2000. All
connection strings have been changed to the enterprise (With vendor help).
The connection is established and according to a trace from Profiler, all
queries are running and inserting the data in the right table. But there is
no data in the tables! No errors either.
> One of my tests was to point it to another MSDE and it worked fine. What
is different between these two versions that will cause data not to be
written to the tables.
> Thanks|||It is pointing to the right DB because at first I pointed it to a DB that ha
d records and from the front end the viewer showed the Data (but did not ins
ert any) then, I pointed it to an empty DB and the viewer showed empty rows
and still wouldn't insert a
ny records. Are there any differences between MSDE and SQL to cause such th
ing?
Thanks
"Hari Prasad" wrote:

> Hi,
> Can you insert few records in to the tables manually and see what is
> happening. I feel that application is
> still pointing towards a different database.
>
> Thanks
> Hari
> MCDBA
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I am trying to point it to the enterprise version of SQL 2000. All
> connection strings have been changed to the enterprise (With vendor help).
> The connection is established and according to a trace from Profiler, all
> queries are running and inserting the data in the right table. But there
is
> no data in the tables! No errors either.
> is different between these two versions that will cause data not to be
> written to the tables.
>
>

Extend MSDE to Enterprise

I have a system that came with the MSDE database, because of the 2G limit I am trying to point it to the enterprise version of SQL 2000. All connection strings have been changed to the enterprise (With vendor help). The connection is established and acc
ording to a trace from Profiler, all queries are running and inserting the data in the right table. But there is no data in the tables! No errors either.
One of my tests was to point it to another MSDE and it worked fine. What is different between these two versions that will cause data not to be written to the tables.
Thanks
Hi,
Can you insert few records in to the tables manually and see what is
happening. I feel that application is
still pointing towards a different database.
Thanks
Hari
MCDBA
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I have a system that came with the MSDE database, because of the 2G limit
I am trying to point it to the enterprise version of SQL 2000. All
connection strings have been changed to the enterprise (With vendor help).
The connection is established and according to a trace from Profiler, all
queries are running and inserting the data in the right table. But there is
no data in the tables! No errors either.
> One of my tests was to point it to another MSDE and it worked fine. What
is different between these two versions that will cause data not to be
written to the tables.
> Thanks
|||It is pointing to the right DB because at first I pointed it to a DB that had records and from the front end the viewer showed the Data (but did not insert any) then, I pointed it to an empty DB and the viewer showed empty rows and still wouldn't insert a
ny records. Are there any differences between MSDE and SQL to cause such thing?
Thanks
"Hari Prasad" wrote:

> Hi,
> Can you insert few records in to the tables manually and see what is
> happening. I feel that application is
> still pointing towards a different database.
>
> Thanks
> Hari
> MCDBA
> "Niles" <Niles@.discussions.microsoft.com> wrote in message
> news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I am trying to point it to the enterprise version of SQL 2000. All
> connection strings have been changed to the enterprise (With vendor help).
> The connection is established and according to a trace from Profiler, all
> queries are running and inserting the data in the right table. But there is
> no data in the tables! No errors either.
> is different between these two versions that will cause data not to be
> written to the tables.
>
>

Extend MSDE to Enterprise

I have a system that came with the MSDE database, because of the 2G limit I am trying to point it to the enterprise version of SQL 2000. All connection strings have been changed to the enterprise (With vendor help). The connection is established and according to a trace from Profiler, all queries are running and inserting the data in the right table. But there is no data in the tables! No errors either.
One of my tests was to point it to another MSDE and it worked fine. What is different between these two versions that will cause data not to be written to the tables.
ThanksHi,
Can you insert few records in to the tables manually and see what is
happening. I feel that application is
still pointing towards a different database.
Thanks
Hari
MCDBA
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:4937BB3E-CD2B-4DA1-9C83-2C03E8470989@.microsoft.com...
> I have a system that came with the MSDE database, because of the 2G limit
I am trying to point it to the enterprise version of SQL 2000. All
connection strings have been changed to the enterprise (With vendor help).
The connection is established and according to a trace from Profiler, all
queries are running and inserting the data in the right table. But there is
no data in the tables! No errors either.
> One of my tests was to point it to another MSDE and it worked fine. What
is different between these two versions that will cause data not to be
written to the tables.
> Thanks

Express version just upgrade of MSDE?

Is the Express 2005 version just an upgrade of MSDE 2000?
never mind heh.
"SQL Server Express is the evolution of MSDE 2000 in SQL Server 2005"
|||It's what MSDE will evolve into in the SQL Server 2005 timeframe. Please
note that it's only a technical preview at the moment. You can get more info
at http://www.microsoft.com/sql/express/, including a pre-beta download.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Blackwell" <robOMGwowcentralDOTcom> wrote in message
news:OTvW$uFZEHA.2576@.TK2MSFTNGP10.phx.gbl...
> Is the Express 2005 version just an upgrade of MSDE 2000?
>
|||Aha, you were likely reading the same page that I was. :-) There are some
really cool things with it such as the removal of the workload governor and
the increased database size.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Blackwell" <robOMGwowcentralDOTcom> wrote in message
news:OtzerzFZEHA.3596@.tk2msftngp13.phx.gbl...
> never mind heh.
> "SQL Server Express is the evolution of MSDE 2000 in SQL Server 2005"
>
|||Thanks, I'm checkin all that stuff out.
|||Don't miss following the link to the resources on MSDN. At the very bottom
of that page there's another link to community resources, i.e. SQL Express
and SQL Mobile newsgroups. The SQL Express newsgroup is already pretty
active.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Blackwell" <robOMGwowcentralDOTcom> wrote in message
news:eHYQrmGZEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Thanks, I'm checkin all that stuff out.
>
|||I'm not seeing the express server in my list.
I have 2 ms private news accounts, one for xpsp2 and then the one I signed
up for yesterday for csharp express.
I didn't see the proper login information on this page
|||oops, this page
http://communities.microsoft.com/new...r2005&slcid=us
alt it has is the server address.

Express SP2 install error

Hi, try to install (not an upgrade) SQLExpressSP2 on WinXPSP2 from SQLEXPR32.exe package.

.NET version 2.0 is already installed however get error below before last step of Server setup ( Excerpt from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_Core(Local) ):

</- START OF Excerpt >

<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/2/14 16:58:23, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/2/14 16:58:23
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/2/14 16:58:23
Message pump returning: 1603
</- END OF Excerpt >

Cud u please advise workaround?

cheers,

Fred

N.B.

Also have tried to register my installation of SQL Express SP2 but the registration web page has a bug and

does not enable me to register at https://profile.microsoft.com/ProductActivation/ProductActivation.aspx?lcid=1033&WizId=0569136c-78c8-454b-bf27-cb7d7863de63

This message appears in "Red' even when legitimate email-address was entered:

"*Required: E-Mail Address"

cheers,

Fred

Tyodotnet wrote:

Hi, try to install (not an upgrade) SQLExpressSP2 on WinXPSP2 from SQLEXPR32.exe package.

.NET version 2.0 is already installed however get error below before last step of Server setup ( Excerpt from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_Core(Local) ):

</- START OF Excerpt >

<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/2/14 16:58:23, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/2/14 16:58:23
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/2/14 16:58:23
Message pump returning: 1603
</- END OF Excerpt >

Cud u please advise workaround?

cheers,

Fred

|||

Not finding much on this one, I'm going to move this to the setup forum so the experts can take a look.

Mike

|||

Hi Mike,

Thanks for your assistance.

Meanwhile I have found out the problem i.e:
1. Instead of running SQLEXPR32.EXE I have extracted the contents
into a new folder using the commandline SQLEXPR32.EXE -X

2. I have created an autostart CD from the extracted data.

3. Run the CD, autorun will open splash.hta automatically.
This installation menu will appear:

Prepare
Review hardware and software requirements
Read the release notes
Install
Run the SQL Server Installation Wizard
Run the SQL Native Client Installation Wizard
Other Information
Browse this CD
Visit the SQL Server website
Read the SQL Server license agreement
4. Run the SQL Native Client Installation Wizard, with success,
installation closes all screens.

5. Run CD again and run the SQL Server Installation Wizard
got into error: current user (the Administrator!)
has not enough access rights to write in "C:\Program Files\Microsoft SQL Server"

6. Check and change access control with Explorer "C:\Program Files\Microsoft SQL Server"
Indeed it was totally unwritable by Admin!

7. Run CD again and the SQL Server Installation Wizard is running flawless.
All steps can be finished.

cheers,
Fred

Express SP2 install error

Hi, try to install (not an upgrade) SQLExpressSP2 on WinXPSP2 from SQLEXPR32.exe package.

.NET version 2.0 is already installed however get error below before last step of Server setup ( Excerpt from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_Core(Local) ):

</- START OF Excerpt >

<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/2/14 16:58:23, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/2/14 16:58:23
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/2/14 16:58:23
Message pump returning: 1603
</- END OF Excerpt >

Cud u please advise workaround?

cheers,

Fred

N.B.

Also have tried to register my installation of SQL Express SP2 but the registration web page has a bug and

does not enable me to register at https://profile.microsoft.com/ProductActivation/ProductActivation.aspx?lcid=1033&WizId=0569136c-78c8-454b-bf27-cb7d7863de63

This message appears in "Red' even when legitimate email-address was entered:

"*Required: E-Mail Address"

cheers,

Fred

Tyodotnet wrote:

Hi, try to install (not an upgrade) SQLExpressSP2 on WinXPSP2 from SQLEXPR32.exe package.

.NET version 2.0 is already installed however get error below before last step of Server setup ( Excerpt from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_Core(Local) ):

</- START OF Excerpt >

<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
<Func Name='DisplaySCCWizard'>
CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.3042.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2007/2/14 16:58:23, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run:
Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition:
Condition "The Clustered SQL Server instance that hosts is installed." returned false.
Running: ReportChainingResults at: 2007/2/14 16:58:23
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Thu Nov 16 20:31:57 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3416

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2007/2/14 16:58:23
Message pump returning: 1603
</- END OF Excerpt >

Cud u please advise workaround?

cheers,

Fred

|||

Not finding much on this one, I'm going to move this to the setup forum so the experts can take a look.

Mike

|||

Hi Mike,

Thanks for your assistance.

Meanwhile I have found out the problem i.e:
1. Instead of running SQLEXPR32.EXE I have extracted the contents
into a new folder using the commandline SQLEXPR32.EXE -X

2. I have created an autostart CD from the extracted data.

3. Run the CD, autorun will open splash.hta automatically.
This installation menu will appear:

Prepare
Review hardware and software requirements
Read the release notes
Install
Run the SQL Server Installation Wizard
Run the SQL Native Client Installation Wizard
Other Information
Browse this CD
Visit the SQL Server website
Read the SQL Server license agreement
4. Run the SQL Native Client Installation Wizard, with success,
installation closes all screens.

5. Run CD again and run the SQL Server Installation Wizard
got into error: current user (the Administrator!)
has not enough access rights to write in "C:\Program Files\Microsoft SQL Server"

6. Check and change access control with Explorer "C:\Program Files\Microsoft SQL Server"
Indeed it was totally unwritable by Admin!

7. Run CD again and the SQL Server Installation Wizard is running flawless.
All steps can be finished.

cheers,
Fred

Express SP1 No version #

I downloaded the SQL Server 2005 Express SP1 product today. If I right click SQLEXPR.EXE, select Properties, and select the Version tab, the File Version value is 0.0.0.0. The version listed for the GA product was 9.0.1399.6.

Is this a problem to be concerned about?

Hi,

that shouldn′t bother you, smae for me here. Look at the digital signature date, if it is sometime in April 2006 signed (as mine is) this is the right one for you. Starting the File will also come up with a EULA shwoing the Service pack Level.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

SQLEXPR.EXE is a compressed archive, you'll find version numbers on the actual files that are installed.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Express SP1 No version #

I downloaded the SQL Server 2005 Express SP1 product today. If I right click SQLEXPR.EXE, select Properties, and select the Version tab, the File Version value is 0.0.0.0. The version listed for the GA product was 9.0.1399.6.

Is this a problem to be concerned about?

Hi,

that shouldn′t bother you, smae for me here. Look at the digital signature date, if it is sometime in April 2006 signed (as mine is) this is the right one for you. Starting the File will also come up with a EULA shwoing the Service pack Level.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

SQLEXPR.EXE is a compressed archive, you'll find version numbers on the actual files that are installed.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Express Manager for Sept CTP

Does anyone know if there will be a version of Sql Express Manager (XM) for the September CTP?

Regards

Graham

There will not, no|||Any idea of what product will replace it?

|||A lite version of Management Studio.|||Good to know. Thanks.
Scott

Express Manager for Sept CTP

Does anyone know if there will be a version of Sql Express Manager (XM) for the September CTP?

Regards

Graham

There will not, no|||Any idea of what product will replace it?

|||A lite version of Management Studio.|||Good to know. Thanks.
Scott

Express Manager download for RTM version of SQLServer Express

Has MS updated the Express Manager tool for the RTM version of SQLServer Express? It's a great tool and not having it causes so much pain (I have to use the command line tools!).

Thanks in advance!We're working on an update to the Express Manager. We expect to release a Community Technology Preview of it by the end of the year. In the mean time your options are to use the command line tools, use Visual Studio, or acquire the Developer or Evaluation Editions of SQL Server 2005 and use the full-blown Management Studio.

Dan|||I tried to install the client tools from SQL Server 2005 developer edition but the installer for this (after downloading another 2.8GB!) says components are already installed and cannot be upgraded (or message similar to this).

I'll use the command line tools I guess

Thanks anyways!

Express Manager / Management Studio Express

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express Manager

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express Manager

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express Manager

When will the express manager be available for the msdn version that is scheduled to ship later this month. If express manager isn't going to ship then what tool will allow me to create users in my express 2005 database.I'm wondering that also. I think I heard something about MS dropping Express Manager.|||We've dropped Express Manager. Instead, you can download and use SQL Server Management Studio Express to manage your Express servers. SSMSE is a subest of the full Management Studio tailored for SQL Server Express functionality. SSMSE can also connect to uplevel SQL Server 2005 servers, SQL Server 2000 servers, and MSDE 2000 servers.

You can download it from MSDN here: http://msdn.microsoft.com/vstudio/express/sql/ Look for the "Free Management Tool" paragraph on the page. It has a link to the Management Studio Express download page.

A few things to be aware of:

First, Management Studio Express is currently a Community Technology Preview, so there are still a few minor defects that remain to be fixed before it formally ships in the first half of 2006. If you use SSMSE, you can use this MSDN Forum to provide feedback. Issues raised on these forums have added weight with the dev team when it comes to prioritizing changes.

Second, Management Studio Express cannot run side-by-side with SQL Server 2005 Management Studio. SSMSE is supposed to have an error message that pops up telling you to use Management Studio if it detects the full product on your machine, but this appears to be broken for many people, for whom nothing happens at all when the try to start Management Studio Express on machines that have a version of the full Management Studio installed.|||Thanks for the info and the link!|||After reading a number of posts and trying out SSMSE, I would have to say that you have done an excellent job on 2005.

Dave
Retired SQL Sever DBA with 35+ years experience|||

Hi there.

I have just installed the Express editions of VB and SQL.However, I can't seem to find an IDE for SQL Server. I have been able to create a database through VB, but not directly in SQL Express as there is no way into a UI. Is this normal?

I would like to create and manage databases independently of VB and VWD and then connect to them in the way it was probably done before 2005. Is this possible? Do I have to install the SQL Server Management Studio Express (SSMSE)?

Many thanks in advance,

Chris

By the way, very impressed with the whole Express Edition initiative and with the tools themselves. It's a brave move. Well done to all involved. I'm sure these editions will help to ensure .NET dominance over other technologies for years to come.

|||You will want to download and install SSMSE. Here's a link to the November CTP of SSMSE. It will allow you to run SQL scripts to create, manage and query databases.|||

That's great. Thanks for your help.

Chris

|||

I downloaded and tried Management Studio Express because I need a substitute for Query Analyzer for users to run adhoc queries and save the results to files. This looks good, but is is a Community Technology Preview November 2005 version and it states that it is an unsupported pre-release version. Is there a RTM version available? If not will there be one? Can I give this to power users as a substitute for the Query Analyzer?

|||

There is no RTM version of Management Studio Express yet. We do plan to release a final version soon.

Management Studio is intended to be a replacement for Query Analyzer 2000 and SQL Enterprise Manager 2000, so it should be appropriate for your power users.

Regards,

Steve

|||Thanks Steve. Is there any target date yet for the RTM version of Management Studio Express? I need something very soon for a production system.

Express

Hi:

I have installed SQL Express version, however it comes without the Pub and Northwind database examples, therefore is there an alternative or plug-in one can use?

I'm new to database development, therefore I would need to use such examples, when it comes to building tables, etc.

Thanks

OliverHi:

I have installed SQL Express version, however it comes without the Pub and Northwind database examples, therefore is there an alternative or plug-in one can use?

I'm new to database development, therefore I would need to use such examples, when it comes to building tables, etc.

Thanks

Oliver

The sample databases are not installed by default in SQL Server Express. The Northwind and pubs sample databases can be downloaded from this Microsoft Web site (http://www.microsoft.com/downloads/details.aspx?FamilyId=06616212-0356-46A0-8DA2-EEBC53A68034&displaylang=en). The Adventureworks sample database can be installed from this Microsoft Web site (http://www.microsoft.com/downloads/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en).

Exporting to word

Hi,

I'm using Crystal Reports in Microsoft Visual C# .NET version 1.1.

I've never used Crystal reports before, so I'm just finding my way around. I have created a very simply report embedded in a windows form which just displays a few columns from a database table.

My problem is this: When I click the "export" button I just get an egg timer.

I gather that there may be some dll's requirered for the exporting functionality to work. Could this be the problem? If so, where do I get then from? Or do I have to implement some code myself which will enable the export dialog to appear?

many thanks for any help offered.

update: I've just tried the exe on someone elses machine and it worked ok, so I think this is a problem with my .NET installation.http://support.businessobjects.com/library/kbase/articles/c2010787.asp



Hi,

I'm using Crystal Reports in Microsoft Visual C# .NET version 1.1.

I've never used Crystal reports before, so I'm just finding my way around. I have created a very simply report embedded in a windows form which just displays a few columns from a database table.

My problem is this: When I click the "export" button I just get an egg timer.

I gather that there may be some dll's requirered for the exporting functionality to work. Could this be the problem? If so, where do I get then from? Or do I have to implement some code myself which will enable the export dialog to appear?

many thanks for any help offered.

update: I've just tried the exe on someone elses machine and it worked ok, so I think this is a problem with my .NET installation.|||http://support.businessobjects.com/library/kbase/articles/c2010787.asp

Many thanks for the reply, but that isn't my problem.

When I click the "export" button I just get an egg timer. I am not trying to export a TIF, and I don't get any error message.

Exporting to Excel 2000

We recently changed over to SQL 2000 RS. Many of our customers are not able
to make sense of a report exported in Office 2000 version of Excel. It is
completely unreadable.
Many are not in the position to be able to Upgrade to Office XP or 2003.
Any ideas on how to help customers with this issue?Make sure you are running SP1 of RS 2000 on the report server and report
designer machines. The Excel rendering extension of SP1 will generate the
Excel output in the BIFF format which is supported by Excel 2000 etc.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"rfoster@.intralearn.com" <rfoster@.intralearn.com@.discussions.microsoft.com>
wrote in message news:F748223F-36E3-4689-A784-6C6445416C2C@.microsoft.com...
> We recently changed over to SQL 2000 RS. Many of our customers are not
> able
> to make sense of a report exported in Office 2000 version of Excel. It is
> completely unreadable.
> Many are not in the position to be able to Upgrade to Office XP or 2003.
> Any ideas on how to help customers with this issue?

Exporting the Report into Excel : Timeout Problem

Hi,

I have installed the SSRS 2005 beta version, when I am exporting the report into excel format it is working if my report has 1 to 3 pages. But the same report contains more than 10 pages then I will be getting the TimeOut error.

The operation has timed out

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The operation has timed out

Any suggestions are welcome.

Thanks in Advance

Hello,

Can you export to other formats (HTML, PDF) without problems? How much information do you actually have on a page ? How many columns and rows in your excel spreadsheet?

Thank you,

Nico

|||

Hi,

I made the same experience, when exporting to XLS I got a timeout error message. This also happens when exporting to pdf, but not when exporting to csv, html. This only happens with larger reports (In our case approx. 700 pages). We would need some help here, too.

Thx

Michael