Does SRS sql engine break things that used to work?

I've noticed that when I take stable SQL 2000 engines that are at SP3A where
the sqlservr executable is at build 8.00.760 and install SRS I get a new
build of the sql engine.
SQLServr.EXE build is 8.00.859 in SRS and things that used to work don't.
For example, stored procedure debug doesn't work at all on an SRS SQL Server.
I know I have seen a few other things that are now broke.
Does anyone know of any hotfixes that repair features that SRS breaks?RS doesn't do anything to the SQL Engine. If you are talkin about the 859
hotfix that we require in certain situations, there is a newer hotfix that
resolves the problem. You need to request it from product support. See
http://support.microsoft.com/default.aspx?scid=kb;en-us;831997.
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:22305D8C-975B-4283-BC11-8264CDDEEB1E@.microsoft.com...
> I've noticed that when I take stable SQL 2000 engines that are at SP3A
> where
> the sqlservr executable is at build 8.00.760 and install SRS I get a new
> build of the sql engine.
> SQLServr.EXE build is 8.00.859 in SRS and things that used to work don't.
> For example, stored procedure debug doesn't work at all on an SRS SQL
> Server.
> I know I have seen a few other things that are now broke.
> Does anyone know of any hotfixes that repair features that SRS breaks?|||Thank-you for the quick reponse Brian.
I think maybe I wasn't too clear on my question.
If I install SQL Server 2000 Standard and then take it up to SP3A the build
level of my SQL engine is 760.
However, if I then apply SQL Reporting Services on top of this installation
my SQL engine gets taken up to build 859. Maybe this is not directly related
to SRS, but it certainly takes place upon installation of SRS.
At that point I no longer have the capability to debug stored procs (I
believe thru the sp_dbidbg xp).
So the downside is that I have to make a choice between having SRS and then
losing the capability of stored proc debug or not having SRS.
If there is a hotfix that addresses that I would love to have it.
thanks,
dan
"Brian Welcker [MS]" wrote:
> RS doesn't do anything to the SQL Engine. If you are talkin about the 859
> hotfix that we require in certain situations, there is a newer hotfix that
> resolves the problem. You need to request it from product support. See
> http://support.microsoft.com/default.aspx?scid=kb;en-us;831997.
>
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Dan" <Dan@.discussions.microsoft.com> wrote in message
> news:22305D8C-975B-4283-BC11-8264CDDEEB1E@.microsoft.com...
> > I've noticed that when I take stable SQL 2000 engines that are at SP3A
> > where
> > the sqlservr executable is at build 8.00.760 and install SRS I get a new
> > build of the sql engine.
> >
> > SQLServr.EXE build is 8.00.859 in SRS and things that used to work don't.
> >
> > For example, stored procedure debug doesn't work at all on an SRS SQL
> > Server.
> >
> > I know I have seen a few other things that are now broke.
> >
> > Does anyone know of any hotfixes that repair features that SRS breaks?
>
>|||The RS setup proces does not touch the version of the SQL engine. We really
don't. We recommend a specific SQL engine hotfix during the installation
process that does do this. You would need to call product support for the
hotfix. I don't think it is generally downloadable.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dan" <Dan@.discussions.microsoft.com> wrote in message
news:DA304849-A7E9-4A92-A39D-5E338227EF52@.microsoft.com...
> Thank-you for the quick reponse Brian.
> I think maybe I wasn't too clear on my question.
> If I install SQL Server 2000 Standard and then take it up to SP3A the
> build
> level of my SQL engine is 760.
> However, if I then apply SQL Reporting Services on top of this
> installation
> my SQL engine gets taken up to build 859. Maybe this is not directly
> related
> to SRS, but it certainly takes place upon installation of SRS.
> At that point I no longer have the capability to debug stored procs (I
> believe thru the sp_dbidbg xp).
> So the downside is that I have to make a choice between having SRS and
> then
> losing the capability of stored proc debug or not having SRS.
> If there is a hotfix that addresses that I would love to have it.
> thanks,
> dan
>
> "Brian Welcker [MS]" wrote:
>> RS doesn't do anything to the SQL Engine. If you are talkin about the 859
>> hotfix that we require in certain situations, there is a newer hotfix
>> that
>> resolves the problem. You need to request it from product support. See
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;831997.
>>
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Dan" <Dan@.discussions.microsoft.com> wrote in message
>> news:22305D8C-975B-4283-BC11-8264CDDEEB1E@.microsoft.com...
>> > I've noticed that when I take stable SQL 2000 engines that are at SP3A
>> > where
>> > the sqlservr executable is at build 8.00.760 and install SRS I get a
>> > new
>> > build of the sql engine.
>> >
>> > SQLServr.EXE build is 8.00.859 in SRS and things that used to work
>> > don't.
>> >
>> > For example, stored procedure debug doesn't work at all on an SRS SQL
>> > Server.
>> >
>> > I know I have seen a few other things that are now broke.
>> >
>> > Does anyone know of any hotfixes that repair features that SRS breaks?
>>sql

does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

does sqlserver install auto w/Small Bus Srv 2003

Does SQL server install automatically with SBS?
I did an install last night for a client, not at server
at this time.
Did this install auto?I do not believe that it is part of the automated setup.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Does SQL Server Exist

Hi All,

I am trying to write an application to install a product that my company has developed. As part of the install I want to perform some validation ie is IIS running is SQL 2000 running etc before installation. The application is in VB .net can anyone tell me if it is possible to check if SQL Server 2000 exists and is running?

Thanks in advance for your help.

Cheers,

SamBefore using SQL DMO or something to check the service state of SQL Server, why not issuing a simple command like "Select 1" to check whether the server is up or not. Of you want to check for the presence of a database you might issue the command:
Select 1 from master..sysdatabases Where name = 'YourDBNametoCheckfor'

HTH, Jens Suessmeyer|||i would first check if network is available, after check if the server (not sql database server) is on-line... and then check if database server is installed... i'm using this for now till i find something better
i open connection to the server for default database and if its not there (exception) then the sql server is either not runing or it's service is stoped...
hope this helps a bit.... its not perfect but it helps for now...
Private Function CheckServer() As Boolean
Try
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
MyCnn.Close()
Return True
Catch ex As SqlException
Return False
Catch ex As Exception
Return False
End Try
End Function

and here i check if database with that name exists
Private Function CheckDb() As Boolean
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
With MyCmd
.Connection = MyCnn
'this line of code well sql query i found somewhere on this forums
.CommandText = "Select 1 from master..sysdatabases Where name = '" & m_dbName & "'"
.CommandType = CommandType.Text
End With
Try
Select Case (MyCmd.ExecuteScalar).ToString
Case 1
Return True
MyCnn.Close()
Exit Function
Case Else
Return False
MyCnn.Close()
Exit Function
End Select
Catch ex As NullReferenceException
Return False
MyCnn.Close()
Exit Function
End Try
MyCnn.Close()
End Function

Does SQL Server Exist

Hi All,

I am trying to write an application to install a product that my company has developed. As part of the install I want to perform some validation ie is IIS running is SQL 2000 running etc before installation. The application is in VB .net can anyone tell me if it is possible to check if SQL Server 2000 exists and is running?

Thanks in advance for your help.

Cheers,

SamBefore using SQL DMO or something to check the service state of SQL Server, why not issuing a simple command like "Select 1" to check whether the server is up or not. Of you want to check for the presence of a database you might issue the command:
Select 1 from master..sysdatabases Where name = 'YourDBNametoCheckfor'

HTH, Jens Suessmeyer|||i would first check if network is available, after check if the server (not sql database server) is on-line... and then check if database server is installed... i'm using this for now till i find something better
i open connection to the server for default database and if its not there (exception) then the sql server is either not runing or it's service is stoped...
hope this helps a bit.... its not perfect but it helps for now...
Private Function CheckServer() As Boolean
Try
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
MyCnn.Close()
Return True
Catch ex As SqlException
Return False
Catch ex As Exception
Return False
End Try
End Function

and here i check if database with that name exists
Private Function CheckDb() As Boolean
Dim MyCnn As New SqlClient.SqlConnection(m_CnnString)
Dim MyCmd As New SqlClient.SqlCommand
MyCnn.Open()
With MyCmd
.Connection = MyCnn
'this line of code well sql query i found somewhere on this forums
.CommandText = "Select 1 from master..sysdatabases Where name = '" & m_dbName & "'"
.CommandType = CommandType.Text
End With
Try
Select Case (MyCmd.ExecuteScalar).ToString
Case 1
Return True
MyCnn.Close()
Exit Function
Case Else
Return False
MyCnn.Close()
Exit Function
End Select
Catch ex As NullReferenceException
Return False
MyCnn.Close()
Exit Function
End Try
MyCnn.Close()
End Function

Does SQL Express support upgrade from MSDE2000 Chinese Edition?

I've tried to download the sql express and install, but it doesn't allow me to select upgrade the default instance (which i've installed msde2000 chinese edtion), it told me due to the language problem, sql express can't upgrade the default instance and only could install sql express in new instance.

I have no idea for the language edition for sql express since the download page doesn't have a language selection.

So does anyone know that,
1. would sql express have multi language edtion ?
2. if sql express would have one language edtion, how could install it to upgrade from one existing msde2000 simplified chinese edtion ?Upgrading across languages is not supported. If you want to upgrade your Chinese databases you'll need to wait until the Chinese edition of Express is released. The currently released version of Express is English only.

Does reporting services run on the same machine as SQL Server?

Hi,
We're getting ready to install and start using SQL Server Reporting
Services. Do we install it on the same server as SQL Server? If yes, is that
the only way to do it? Can we install it on a separate server? Does it make
sense to do so?
Thanks,
SamIf you install it on the same server as a current licenced copy of SQl Server
2000 then it's free. If you install it on it's own server then you have to
pay a licence fee for Reporting Services (which I think is equivalent to a
SQL Server licence).
"Sam" wrote:
> Hi,
> We're getting ready to install and start using SQL Server Reporting
> Services. Do we install it on the same server as SQL Server? If yes, is that
> the only way to do it? Can we install it on a separate server? Does it make
> sense to do so?
> Thanks,
> Sam
>
>

Does reporting services need SQL Server for the RS application tables?

Would it be possible to buy a license for SQL server, not install SQL
server and then have both the data and application tables in an Oracle
database?
A customer of ours does not want to support SQL Server at all. I can
accept that they need a SQL license to use RS, but is there a way to
get around the SQL requirment for the app tables? Will moving the
tables from SQL to Oracle (and the configuring RS to use Oracle)
result in application errors?
I was hoping someone knew the answers before I started testing the
scenarios above.No. SQL Server is needed by Reporting Services. The data can be anywhere but
RS needs SQL Server to operate (the database can be on a separate server but
it has to be somewhere).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"coldfact" <bryan@.coldfact.com> wrote in message
news:249185cd.0410261208.1283bdf1@.posting.google.com...
> Would it be possible to buy a license for SQL server, not install SQL
> server and then have both the data and application tables in an Oracle
> database?
> A customer of ours does not want to support SQL Server at all. I can
> accept that they need a SQL license to use RS, but is there a way to
> get around the SQL requirment for the app tables? Will moving the
> tables from SQL to Oracle (and the configuring RS to use Oracle)
> result in application errors?
> I was hoping someone knew the answers before I started testing the
> scenarios above.

does not install SQL Query Analyzer

Hi,

I am developing and application in pocket pc windows mobile 2003. I have added a reference to System.Data.SqlServerCe.dll but when i deploy the application query analyzer doesnt seem to install. Any help please?

cheers,

michael

Hi,

Sorry... for info I am using CS VS2005 and SQL Mobile.

Thank you.

michael

|||

Query Analyzer 3.0 should deploy automatically if you are building and deploying a DEBUG build in VS2005 given your reference to System.Data.SqlServerCe.dll version 2.0. You can also just grab the dev tools CAB and install it to your device/emulator to save time. it is located (depending on your device's WinCE kernel) at:

<drive:>\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce400\armv4\sqlce30.dev.ENU.ppc.wce4.armv4.CAB

or

C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\<device CPU architecture>\

Darren

Does MSDE (SP4) support Full Text Research?

How can i install eand run Full text research Service in Windows xp Sp2
hi,
S. Luca wrote:
> How can i install eand run Full text research Service in Windows xp
> Sp2
MSDE does not support (and provide) Full Text engine..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Does Log Shipping Handle Schema Changes from Primary to Secondary

Anyone, we have a Vendor application where we install modules or
software that updates our primary production database. We have a
reporting database that is updated via log shipping. I believe that
the article by Paul Ibison log shipping v. replication answers my question
but wanted
to know if I was missing something. So here goes. When we do an
install of a module or software it modifies our primary database. From
Paul is saying in his article it looks like any schema changes in
the primary database would not be done in the reporting database. Is
this correct?
References:
Log Shipping v. Replication
http://www.sqlservercentral.com/columnists/pibison/logshippingvsreplication.asp
Using Secondary Servers for Query Processing
http://msdn2.microsoft.com/en-us/library/ms189572.aspx
Thanks,
Chad
Hi Chad - absolutely. This is one of the differences cf replication - ALL
schema changes are replicated. In SQL Server 2005 you can replicate ddl
changes which makes it closer but not all changes are replicated to the
subscribers.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

does anyone have the old SQL server versions?

I would really love to see how the old SQL server versions looked like ..I
would love to get a copy to install and see what it looked like..
Any verion prior to 7.0. Can anyone upload it to their site if its legal to
download ?
Thanks
Check out www.ebay.com for SQL Server 6.5 and 7.0. You should determine for
yourself that any software you purchase is genuine and legal.
David Portas
SQL Server MVP
|||For a real laugh, have a look at version 4.21 - the one I started with.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Hassan wrote:
> I would really love to see how the old SQL server versions looked like ..I
> would love to get a copy to install and see what it looked like..
> Any verion prior to 7.0. Can anyone upload it to their site if its legal to
> download ?
> Thanks
>
|||Me too - quality software (just like Windows NT 3.51 - quality).
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Mark Allison wrote:

> For a real laugh, have a look at version 4.21 - the one I started with.
|||Looks great on OS/2 Warp too. :-)
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mike Hodgson wrote:
> Me too - quality software (just like Windows NT 3.51 - quality).
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>
|||Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Looks great on OS/2 Warp too. :-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Mike Hodgson wrote:
http://www.mallesons.com[vbcol=seagreen]
|||Not me. The earliest one I've kept is 6.5 but I've worked with 4.21,
6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to go back
prior to 7.0 now (I've been spoilt). Can't wait to start plugging away
on Yukon production boxes (up until now it's been only "play" instances)
- I find Yukon a really exciting new version (with a fair bit of
potential for abuse, i.e. CLR integration - good for some things like
user-defined aggregates but should be used with extreme care methinks).
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Hassan wrote:

>Do you guys have a copy of 4.2 ? Would love to have it as a collectible
>"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
>news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
>
>http://www.mallesons.com
>
>
>

does anyone have the old SQL server versions?

I would really love to see how the old SQL server versions looked like ..I
would love to get a copy to install and see what it looked like..
Any verion prior to 7.0. Can anyone upload it to their site if its legal to
download ?
ThanksCheck out www.ebay.com for SQL Server 6.5 and 7.0. You should determine for
yourself that any software you purchase is genuine and legal.
--
David Portas
SQL Server MVP
--|||For a real laugh, have a look at version 4.21 - the one I started with.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Hassan wrote:
> I would really love to see how the old SQL server versions looked like ..I
> would love to get a copy to install and see what it looked like..
> Any verion prior to 7.0. Can anyone upload it to their site if its legal to
> download ?
> Thanks
>|||This is a multi-part message in MIME format.
--040700040605000703020101
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Me too - quality software (just like Windows NT 3.51 - quality).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Mark Allison wrote:
> For a real laugh, have a look at version 4.21 - the one I started with.
--040700040605000703020101
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Me too - quality software (just like Windows NT 3.51 - quality).</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Mark Allison wrote:
<blockquote cite="midODn$KMxcFHA.3488@.tk2msftngp13.phx.gbl" type="cite">For
a real laugh, have a look at version 4.21 - the one I started with.
<br>
</blockquote>
</body>
</html>
--040700040605000703020101--|||Looks great on OS/2 Warp too. :-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mike Hodgson wrote:
> Me too - quality software (just like Windows NT 3.51 - quality).
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>|||Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Looks great on OS/2 Warp too. :-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Mike Hodgson wrote:
> > Me too - quality software (just like Windows NT 3.51 - quality).
> >
> > --
> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
http://www.mallesons.com
> >|||This is a multi-part message in MIME format.
--050308050508020305020302
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Not me. The earliest one I've kept is 6.5 but I've worked with 4.21,
6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to go back
prior to 7.0 now (I've been spoilt). Can't wait to start plugging away
on Yukon production boxes (up until now it's been only "play" instances)
- I find Yukon a really exciting new version (with a fair bit of
potential for abuse, i.e. CLR integration - good for some things like
user-defined aggregates but should be used with extreme care methinks).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Hassan wrote:
>Do you guys have a copy of 4.2 ? Would love to have it as a collectible
>"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
>news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
>
>>Looks great on OS/2 Warp too. :-)
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602m.html
>>
>>Mike Hodgson wrote:
>>
>>Me too - quality software (just like Windows NT 3.51 - quality).
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>
>http://www.mallesons.com
>
>
>
--050308050508020305020302
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Not me. The earliest one I've kept is 6.5 but I've worked with
4.21, 6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to
go back prior to 7.0 now (I've been spoilt). Can't wait to start
plugging away on Yukon production boxes (up until now it's been only
"play" instances) - I find Yukon a really exciting new version (with a
fair bit of potential for abuse, i.e. CLR integration - good for some
things like user-defined aggregates but should be used with extreme
care methinks).</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
Hassan wrote:
<blockquote cite="mid%23VjR3E2cFHA.2436@.TK2MSFTNGP10.phx.gbl"
type="cite">
<pre wrap="">Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:mark@.no.tinned.meat.mvps.org"><mark@.no.tinned.meat.mvps.org></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl">news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Looks great on OS/2 Warp too. :-)
--
Mark Allison, SQL Server MVP
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.markallison.co.uk</a>">http://www.markallison.co.uk">http://www.markallison.co.uk</a>
Looking for a SQL Server replication book?
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.nwsu.com/0974973602m.html</a>">http://www.nwsu.com/0974973602m.html">http://www.nwsu.com/0974973602m.html</a>
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Me too - quality software (just like Windows NT 3.51 - quality).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!--><a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.mallesons.com</a>">http://www.mallesons.com">http://www.mallesons.com</a>
</pre>
<pre wrap=""><!-->
</pre>
</blockquote>
</body>
</html>
--050308050508020305020302--

does anyone have the old SQL server versions?

I would really love to see how the old SQL server versions looked like ..I
would love to get a copy to install and see what it looked like..
Any verion prior to 7.0. Can anyone upload it to their site if its legal to
download ?
ThanksCheck out www.ebay.com for SQL Server 6.5 and 7.0. You should determine for
yourself that any software you purchase is genuine and legal.
David Portas
SQL Server MVP
--|||For a real laugh, have a look at version 4.21 - the one I started with.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Hassan wrote:
> I would really love to see how the old SQL server versions looked like ..I
> would love to get a copy to install and see what it looked like..
> Any verion prior to 7.0. Can anyone upload it to their site if its legal t
o
> download ?
> Thanks
>|||Me too - quality software (just like Windows NT 3.51 - quality).
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Mark Allison wrote:

> For a real laugh, have a look at version 4.21 - the one I started with.|||Looks great on OS/2 Warp too. :-)
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mike Hodgson wrote:
> Me too - quality software (just like Windows NT 3.51 - quality).
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* [url]http://www.mallesons.com[/url
]
>|||Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Looks great on OS/2 Warp too. :-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Mike Hodgson wrote:
http://www.mallesons.com[vbcol=seagreen]|||Not me. The earliest one I've kept is 6.5 but I've worked with 4.21,
6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to go back
prior to 7.0 now (I've been spoilt). Can't wait to start plugging away
on Yukon production boxes (up until now it's been only "play" instances)
- I find Yukon a really exciting new version (with a fair bit of
potential for abuse, i.e. CLR integration - good for some things like
user-defined aggregates but should be used with extreme care methinks).
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Hassan wrote:

>Do you guys have a copy of 4.2 ? Would love to have it as a collectible
>"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
>news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
>
>http://www.mallesons.com
>
>
>

documentation to install sql 2005 express remotely

Hi all,

I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.

Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.

For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.

If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".

Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?

Any help on this issue would be greatly appreciated.

Thanks.

I'm not totally up on the capabilities of VWD with regards to database management. There is also the issue of User Instances, which is the default when creating database in VS for many cases. User Instances do not support remote connections, so that would cause problems.

In order to troubleshoot this one, you should simply the scenario by taking VS out of the picture. Use either Managment Studio Express of SQLCmd from your local computer to connect to the remote instance of SQL Express and try to create a database. If that works, try to perfrom some other task against that database. If that works, then the issue is in VS. If you have problems with SSMSE or SQLCmd, then we can look more closely at the SQL issue.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

As you were saying using Management Studio Express is fine. I can connect to the database remotely and am able to create databases and all that.

The only problem is that I'm currently learning ASP.NET and most of the books utilise VWD Express Edition interface to create, manage and run databases including using the inbuilt (Database Explorer) stored procedures capabilities in VWD. And what they are teaching is to use these locally and not in a remote situation.

I'm just wondering, is there a way to create a stored procedures folder or something similar in SQL Management Express?

I haven't had much experience with MS SQL so please bear with me :)

Thanks for your prompt reply and help.

|||

Stored Procedures are a built-in part of SQL Server, you don't need to create a folder for them. In Management Studio, you should see a folder icon that says Programmability. If you expand that, you will find a place already there for Stored Procedures. When you create a Stored Procedure, they automatically appear in that list, there is no need to specifically put them there.

In order to create a new Stored Procedure in Management Studio you can either right-click on the Stored Procedure "folder" and click the New command, or you can simply open a new query windows against your target database and write a CREATE PROCEDURE script in T-SQL.

Like I mentioned, I think the problem you are facing is related to the default settings of VWD that result in using a User Instance, which only supports a local connection. All of the VS Express products are designed to be used for local development by default. I don't know any specifics about using them to develop against a remote server, other than the fact that you can't use User Instances. As far as I know, there is no way to turn off the default use of User Instances in VS Express products, but you can modify the connection strings manually once they've been created to remove the keyword. This would likely require you to move the database from your local system to the remote server and attach the database there as well.

I would suggest you check out http://forums.asp.net/ to ask more specific question about VWD functionaltiy. I'm out of my element when it comes to web development and VWD.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

Thanks for that. I'll try and post up some questions on the asp.net forums.

documentation to install sql 2005 express remotely

Hi all,

I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.

Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.

For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.

If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".

Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?

Any help on this issue would be greatly appreciated.

Thanks.

I'm not totally up on the capabilities of VWD with regards to database management. There is also the issue of User Instances, which is the default when creating database in VS for many cases. User Instances do not support remote connections, so that would cause problems.

In order to troubleshoot this one, you should simply the scenario by taking VS out of the picture. Use either Managment Studio Express of SQLCmd from your local computer to connect to the remote instance of SQL Express and try to create a database. If that works, try to perfrom some other task against that database. If that works, then the issue is in VS. If you have problems with SSMSE or SQLCmd, then we can look more closely at the SQL issue.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Hi Mike,

As you were saying using Management Studio Express is fine. I can connect to the database remotely and am able to create databases and all that.

The only problem is that I'm currently learning ASP.NET and most of the books utilise VWD Express Edition interface to create, manage and run databases including using the inbuilt (Database Explorer) stored procedures capabilities in VWD. And what they are teaching is to use these locally and not in a remote situation.

I'm just wondering, is there a way to create a stored procedures folder or something similar in SQL Management Express?

I haven't had much experience with MS SQL so please bear with me :)

Thanks for your prompt reply and help.

|||

Stored Procedures are a built-in part of SQL Server, you don't need to create a folder for them. In Management Studio, you should see a folder icon that says Programmability. If you expand that, you will find a place already there for Stored Procedures. When you create a Stored Procedure, they automatically appear in that list, there is no need to specifically put them there.

In order to create a new Stored Procedure in Management Studio you can either right-click on the Stored Procedure "folder" and click the New command, or you can simply open a new query windows against your target database and write a CREATE PROCEDURE script in T-SQL.

Like I mentioned, I think the problem you are facing is related to the default settings of VWD that result in using a User Instance, which only supports a local connection. All of the VS Express products are designed to be used for local development by default. I don't know any specifics about using them to develop against a remote server, other than the fact that you can't use User Instances. As far as I know, there is no way to turn off the default use of User Instances in VS Express products, but you can modify the connection strings manually once they've been created to remove the keyword. This would likely require you to move the database from your local system to the remote server and attach the database there as well.

I would suggest you check out http://forums.asp.net/ to ask more specific question about VWD functionaltiy. I'm out of my element when it comes to web development and VWD.

Regards,

Mike Wachal
SQL Express team

|||

Hi Mike,

Thanks for that. I'll try and post up some questions on the asp.net forums.

docs for 2003 enterprise cluster

Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
http://www.sage-eshop.com
Installing SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:

> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> http://www.sage-eshop.com
>
>

docs for 2003 enterprise cluster

Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL200
0
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:

> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>

docs for 2003 enterprise cluster

Im looking for documentation that explains how to install SQL 2000
Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
running an install of Sage MMS 3.5 for SQL 2000 Server.
---
http://www.sage-eshop.comInstalling SQL2000 in a failover cluster is documented pretty well in SQL2000
Books Online under "Advanced Installation Options" and "Failover Clustering"
The content is not specific to Win2K3 or SAN. But as far as installing
SQL2000 itself is concerned whether it's Win2000 or Win2K3 or a shared disk
that is not presented from a SAN shouldn't matter. Configuring the cluster
itself at the OS level is different though. If you need to configure msdtc
yourself, read this KB article http://support.microsoft.com/?kbid=301600.
Linchi
"Scott" wrote:
> Im looking for documentation that explains how to install SQL 2000
> Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Im
> running an install of Sage MMS 3.5 for SQL 2000 Server.
> ---
> http://www.sage-eshop.com
>
>

Do you need 1 or 2 SQL licenses to install RS on separate web server?

Plese help with this issue by reading and responding!!!

If you install Reporting Services 2005 on a separate web server from the database engine do you need 1 or 2 SQL licenses? It's a more complex issue than it initially appears to be. Please go to the following thread and read the bottom of page 1 and page 2.

Please help verify this! Page 2 contains a post with 5 steps that you can perform to verify that only 1 license is actually need!

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

Note: Unfortunately this discussion got started in a off topic thread in the wrong category. I wrote this thread so that interested people could find it.

I am pretty sure that you need a license for each if you separate them. This is a scenerio page from MS:

http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx

|||steveareno,

The "license.txt" file that ships on the SQL 2005 install disks says the exact opposite.

Thanks,
Greg
|||I'm shocked by the lack of interest in this. SQL licenses are quite expensive after all.

Is anyone out there planning to run Reporting Services on a separate server from the SQL database engine? I figued that would be a common configuration but maybe I'm wrong?

Thanks,
Greg Van Mullem
|||I'm puzzled as to what more information you're looking for. The information in the link provided bysteveareno tells you all you need to know.|||I found out the answer to my question. Here it is:

You only need 1 SQL license to install RS 2005 on a separate web server!

Thanks for the help with this it's quite confusing because some of the docs on Microsoft's web site are bogus! Read the "license.txt" file that ships on the SQL 2005 standard edition disk if you don't believe me.

Thanks,
Greg Van Mullem