Is there a possible MS media player file demo of Reporting Service

I heard, from a friend, that there is a possible Microsoft media player file
that shows a demo of Reporting Services. The demo is supposed to show how to
access multiple textboxes in the Custom code, place a chart into a table,
etc...
Does any one know of the demo?
Thanks in AdvanceHave you looked on the Reporting Services web site for it yet? There's a
.wmv file at
http://www.microsoft.com/sql/reporting/productinfo/RS_AuthoringDemo.asp that
says it demos how to author, manage, and deliver reports but I haven't
watched it myself to see if it matches your description.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:C71996BA-6302-4B26-8A4E-89CC1D0073C3@.microsoft.com...
>I heard, from a friend, that there is a possible Microsoft media player
>file
> that shows a demo of Reporting Services. The demo is supposed to show how
> to
> access multiple textboxes in the Custom code, place a chart into a table,
> etc...
> Does any one know of the demo?
> Thanks in Advancesql

IS there a FTP uploading utility in SQL server 2000

HI,

I wanted to know if there is an FTP uploading utility in SQL server 2000 ?

I am doing a reporting service wherein a report is generated in the server and needs to be uploaded into an FTP location for the client.

Can anyone suggest a solution for this....

The only uploading mechanism I am aware of is the one in DTS / Integration Services. Perhaps you can trigger an external program to have your files uploaded via FTP, having either a regular schedule or a file system watcher in place.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Is there a free Web Service for the weather, and/or mapping

I'm looking to embed the weather report or mapping into a RS report.
First of all, is this possible? Secondly, do you know of any free web
services for travelers - weather, mapping, anything else of interest to
travelers?
Also, these reports are being stored on the client, not a report server.
I appreciate your response!
Shane
--
Thank You!On Sat, 8 Oct 2005 11:25:29 -0700, "Shane Eckel"
<ShaneEckel@.discussions.microsoft.com> wrote:
>I'm looking to embed the weather report or mapping into a RS report.
>First of all, is this possible? Secondly, do you know of any free web
>services for travelers - weather, mapping, anything else of interest to
>travelers?
>Also, these reports are being stored on the client, not a report server.
>I appreciate your response!
>Shane
Shane,
I don't know the answer to your question but it might help you to get
an answer if you provide an indication of the geographical area you
are interested in.
Global weather? Some specific locality or localities?
Andrew Watt
MVP - InfoPath|||Sorry, I need it for the US and Canada. If I could get the weather for major
cities or for the airports, that would be great.
The second part, mapping, would be great for the US and Canada to be able to
place multiple plotting points on a map within a report.
Thanks again.
Shane
Seattle, WA
--
Thank You!
"Andrew Watt [MVP - InfoPath]" wrote:
> On Sat, 8 Oct 2005 11:25:29 -0700, "Shane Eckel"
> <ShaneEckel@.discussions.microsoft.com> wrote:
> >I'm looking to embed the weather report or mapping into a RS report.
> >
> >First of all, is this possible? Secondly, do you know of any free web
> >services for travelers - weather, mapping, anything else of interest to
> >travelers?
> >
> >Also, these reports are being stored on the client, not a report server.
> >
> >I appreciate your response!
> >
> >Shane
> Shane,
> I don't know the answer to your question but it might help you to get
> an answer if you provide an indication of the geographical area you
> are interested in.
> Global weather? Some specific locality or localities?
> Andrew Watt
> MVP - InfoPath
>sql

Is there a Cluster command line I can run which will stop my "SQL Agent Service"?

Gurus,
Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
Cluster command line I can run which will stop my "SQL Agent Service"?
Spin
Hi
How about NET STOP?
John
"Spin" <Spin@.invalid.com> wrote in message
news:656t5iF2eq3dbU1@.mid.individual.net...
> Gurus,
> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
> Cluster command line I can run which will stop my "SQL Agent Service"?
> --
> Spin
>
|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:e2yjJedkIHA.5368@.TK2MSFTNGP04.phx.gbl...
> Hi
> How about NET STOP?
No can do John. NET STOP stops the service outside of the Cluster
environment. What will happen is the Windows Cluster service will detect
the service down then automatically restart it! What I need is a Cluster
service command line tool which gracefully stops the service per "knowledge"
if you will, of the Cluster service.
|||For the default instance:
cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
For a named instance (assuming that the instance name is SQL2):
cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
/offline
Linchi
"Spin" wrote:

> Gurus,
> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
> Cluster command line I can run which will stop my "SQL Agent Service"?
> --
> Spin
>
>
|||Thanks! I'll shout back on Monday if this works...
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@.microsoft.com...[vbcol=seagreen]
> For the default instance:
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
> For a named instance (assuming that the instance name is SQL2):
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
> /offline
> Linchi
> "Spin" wrote:
|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@.microsoft.com...
> For the default instance:
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
> For a named instance (assuming that the instance name is SQL2):
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
> /offline
> Linchi
Worked!!!!! You are a Gentleman and a Scholar!
Spin

Is there a Cluster command line I can run which will stop my "SQL Agent Service"?

Gurus,
Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
Cluster command line I can run which will stop my "SQL Agent Service"?
--
SpinHi
How about NET STOP?
John
"Spin" <Spin@.invalid.com> wrote in message
news:656t5iF2eq3dbU1@.mid.individual.net...
> Gurus,
> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
> Cluster command line I can run which will stop my "SQL Agent Service"?
> --
> Spin
>|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:e2yjJedkIHA.5368@.TK2MSFTNGP04.phx.gbl...
> Hi
> How about NET STOP?
No can do John. NET STOP stops the service outside of the Cluster
environment. What will happen is the Windows Cluster service will detect
the service down then automatically restart it! What I need is a Cluster
service command line tool which gracefully stops the service per "knowledge"
if you will, of the Cluster service.|||For the default instance:
cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
For a named instance (assuming that the instance name is SQL2):
cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
/offline
Linchi
"Spin" wrote:
> Gurus,
> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
> Cluster command line I can run which will stop my "SQL Agent Service"?
> --
> Spin
>
>|||Thanks! I'll shout back on Monday if this works...
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@.microsoft.com...
> For the default instance:
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
> For a named instance (assuming that the instance name is SQL2):
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
> /offline
> Linchi
> "Spin" wrote:
>> Gurus,
>> Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
>> Cluster command line I can run which will stop my "SQL Agent Service"?
>> --
>> Spin
>>|||"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@.microsoft.com...
> For the default instance:
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline
> For a named instance (assuming that the instance name is SQL2):
> cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
> /offline
> Linchi
Worked!!!!! You are a Gentleman and a Scholar!
--
Spin

Is the SQL Server Service Running?

Can Enterprise Manager tell us *definitively* if the SQL Server service is
running/started on a particular SQL Server (where the SQL Server is not the
local machine on which EM is running)?
What is the most reliable way to determine if the SQL Server service is in
fact up and running on any SQL server (assuming local admin access to the
server is possible)?
Thanks!Sometimes MMC answer slowly in such cases and you was thinking that
everything goes fine but you was wrong. I don't know which is the best way
for that,open the QA and try do 'use db'...
"Guadala Harry" wrote:

> Can Enterprise Manager tell us *definitively* if the SQL Server service is
> running/started on a particular SQL Server (where the SQL Server is not th
e
> local machine on which EM is running)?
> What is the most reliable way to determine if the SQL Server service is in
> fact up and running on any SQL server (assuming local admin access to the
> server is possible)?
> Thanks!
>
>|||Guadala,
1. Enterprise Manager
2. SQL Server Service Manager
3. Admin Tools --> Services --> connect to another machine
4. NET
5. SQL-DMO
6. WMI
7. WSH
HTH
Jerry
"Guadala Harry" <GMan@.BeansAndTacos.org> wrote in message
news:Odxvj5Y1FHA.464@.TK2MSFTNGP15.phx.gbl...
> Can Enterprise Manager tell us *definitively* if the SQL Server service is
> running/started on a particular SQL Server (where the SQL Server is not
> the local machine on which EM is running)?
> What is the most reliable way to determine if the SQL Server service is in
> fact up and running on any SQL server (assuming local admin access to the
> server is possible)?
> Thanks!
>|||or using terminal services or VNC program
"Jerry Spivey" wrote:

> Guadala,
> 1. Enterprise Manager
> 2. SQL Server Service Manager
> 3. Admin Tools --> Services --> connect to another machine
> 4. NET
> 5. SQL-DMO
> 6. WMI
> 7. WSH
> HTH
> Jerry
> "Guadala Harry" <GMan@.BeansAndTacos.org> wrote in message
> news:Odxvj5Y1FHA.464@.TK2MSFTNGP15.phx.gbl...
>
>|||Thanks Jerry and enric... But I was hoping to get your perspective on how we
can know *for sure* (thus my hilighting of *definitively*) in the OP!
Let me put it another way. Suppose someone put a loaded gun to your head and
said they'd pull the trigger if you answered this question incorrectly: "Is
the SQL Server service running/started on our SQL Server?"
In that situation, which of the 7 methods you listed would you use?
Remember, you'd get shot in the head if the method you chose told you the
wrong answer.
- I hope this clarifies what I'm after!
Thanks!
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eyRm1%23Y1FHA.3720@.TK2MSFTNGP14.phx.gbl...
> Guadala,
> 1. Enterprise Manager
> 2. SQL Server Service Manager
> 3. Admin Tools --> Services --> connect to another machine
> 4. NET
> 5. SQL-DMO
> 6. WMI
> 7. WSH
> HTH
> Jerry
> "Guadala Harry" <GMan@.BeansAndTacos.org> wrote in message
> news:Odxvj5Y1FHA.464@.TK2MSFTNGP15.phx.gbl...
>|||It's ok. Very clear...
One solution would be the following:
-Open a DOS session
-Launch NET START statement
-Retrieves the list
-Look for 'MSSQLSERVER'
If appears, it's running.
Of course, these above steps could be done from a stored procedure or a
snippet of VB code, WMI, etc...
Regards,
Enric
"Guadala Harry" wrote:

> Thanks Jerry and enric... But I was hoping to get your perspective on how
we
> can know *for sure* (thus my hilighting of *definitively*) in the OP!
> Let me put it another way. Suppose someone put a loaded gun to your head a
nd
> said they'd pull the trigger if you answered this question incorrectly: "I
s
> the SQL Server service running/started on our SQL Server?"
> In that situation, which of the 7 methods you listed would you use?
> Remember, you'd get shot in the head if the method you chose told you the
> wrong answer.
> - I hope this clarifies what I'm after!
> Thanks!
>
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:eyRm1%23Y1FHA.3720@.TK2MSFTNGP14.phx.gbl...
>
>|||Create a VBScript which makes an ADODB connection to the server.
Send an execute "SELECT 1 AS Test" and return the results to the recordset.
If you get
Test
1
Then your server is up.
Here's a sample script, obviously there is no error handling and you can do
all the nice funky COM things if you get an error or when it works (emails,
fileI/O etc)
Dim cnn
Dim rs
Dim sServerName
Dim sDatabase
sServerName = "MyServer"
sDatabase = "Master"
Set cnn = CreateObject("ADODB.Connection")
cnn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=" & sDatabase & ";Data Source=" &
sServerName
set rs = cnn.Execute( "SELECT 1 AS TEST" )
msgbox rs.fields("Test")
rs.Close
cnn.Close
Set rs = Nothing
Set cnn = Nothing
"Guadala Harry" <GMan@.BeansAndTacos.org> wrote in message
news:uQYDRTZ1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> Thanks Jerry and enric... But I was hoping to get your perspective on how
we
> can know *for sure* (thus my hilighting of *definitively*) in the OP!
> Let me put it another way. Suppose someone put a loaded gun to your head
and
> said they'd pull the trigger if you answered this question incorrectly:
"Is
> the SQL Server service running/started on our SQL Server?"
> In that situation, which of the 7 methods you listed would you use?
> Remember, you'd get shot in the head if the method you chose told you the
> wrong answer.
> - I hope this clarifies what I'm after!
> Thanks!
>
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
> news:eyRm1%23Y1FHA.3720@.TK2MSFTNGP14.phx.gbl...
to
>|||Your test could easily yield "false negatives". The ADODB connection could
fail for any number of reasons (network card is dead, network cable
unplugged, etc), AND the SQL Server service could be in fact running on your
server. So, in the "gun to your head" scenario, if the ADODB connection
failed, you'd say "geeze - guess the SQL Server servics isn't
started/running" when in fact it could be.
I'd hate to see what happens next : )
Still looking for a method to get the definitive answer to the question: Is
the SQL Server service running/started on our SQL Server?"
Please note that I'm not asking if the SQL Server is available on the
network. I'm asking about the SQL Server service, itself.
Thanks!
"Rebecca York" <rebecca.york {at} 2ndbyte.com> wrote in message
news:4357c486$0$135$7b0f0fd3@.mistral.news.newnet.co.uk...
> Create a VBScript which makes an ADODB connection to the server.
> Send an execute "SELECT 1 AS Test" and return the results to the
> recordset.
> If you get
> Test
>
> 1
> Then your server is up.
> Here's a sample script, obviously there is no error handling and you can
> do
> all the nice funky COM things if you get an error or when it works
> (emails,
> fileI/O etc)
>
> Dim cnn
> Dim rs
> Dim sServerName
> Dim sDatabase
> sServerName = "MyServer"
> sDatabase = "Master"
> Set cnn = CreateObject("ADODB.Connection")
> cnn.ConnectionString = "Provider=SQLOLEDB.1;Integrated
> Security=SSPI;Persist
> Security Info=False;Initial Catalog=" & sDatabase & ";Data Source=" &
> sServerName
> set rs = cnn.Execute( "SELECT 1 AS TEST" )
> msgbox rs.fields("Test")
> rs.Close
> cnn.Close
> Set rs = Nothing
> Set cnn = Nothing
>
> "Guadala Harry" <GMan@.BeansAndTacos.org> wrote in message
> news:uQYDRTZ1FHA.1040@.TK2MSFTNGP14.phx.gbl...
> we
> and
> "Is
> to
>|||You pointed out one of the methods I didn't think about.
Thanks!
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:DB62D4E5-2588-4FDF-9D47-0FF3DEDABE74@.microsoft.com...
> It's ok. Very clear...
> One solution would be the following:
> -Open a DOS session
> -Launch NET START statement
> -Retrieves the list
> -Look for 'MSSQLSERVER'
> If appears, it's running.
> Of course, these above steps could be done from a stored procedure or a
> snippet of VB code, WMI, etc...
> Regards,
> Enric
> "Guadala Harry" wrote:
>|||yes,
-Open a DOS session
-Launch NET START statement
-Retrieves the list
-Look for 'MSSQLSERVER'
"Guadala Harry" wrote:

> Your test could easily yield "false negatives". The ADODB connection could
> fail for any number of reasons (network card is dead, network cable
> unplugged, etc), AND the SQL Server service could be in fact running on yo
ur
> server. So, in the "gun to your head" scenario, if the ADODB connection
> failed, you'd say "geeze - guess the SQL Server servics isn't
> started/running" when in fact it could be.
> I'd hate to see what happens next : )
> Still looking for a method to get the definitive answer to the question: I
s
> the SQL Server service running/started on our SQL Server?"
> Please note that I'm not asking if the SQL Server is available on the
> network. I'm asking about the SQL Server service, itself.
> Thanks!
>
> "Rebecca York" <rebecca.york {at} 2ndbyte.com> wrote in message
> news:4357c486$0$135$7b0f0fd3@.mistral.news.newnet.co.uk...
>
>

Is the MSSQL2000 report server only support for .NET framework 1.1?

Good day.

Please can somebody help me about my problem regarding the report service of the MSSQL2000. is the REPORT SERVER of the MSSQL2000 report service only support for the .net framework 1.1?i have try that if the report server is .NET 1.1 ts is ok but i change it to frame work 2.0 there is a error prompt in the page.

the error.

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:

[No relevant source lines]

Source File: c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reports\1aad90e2\ae6e4852\App_Web_nbbt8tv0.14.cs Line: 0

-- can any one help me your help is much appreciated....thanx

Yes, Reporting Services 2000 is only supported for .NET/ASP.NET 1.1
It will not work with .NET 2.0 - only SQL Server Reporting Services 2005 will.

-- Robert

|||

Hello Robert.

Thanks for your info. I have already fixed it up the problem. that SQL2000 report server only support framework 1.1.

Thanks bro and more power.

Is sql2kdesksp3 always necessary?

Prior to installing any SP3a service packs:
VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
RTM
After installing sql2ksp3 and sql2kasp3 I get:
VERSION:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
SP3
I am having difficulty installing sql2kdesksp3 and was wondering if I was
trying to install it where it is not required?
I have an MSDN copy of SQL Server 2000 Developer Edition.
No. It appears that you have the Developer Edition of SQL Server 2000 and
did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp. A
little ways down that page it describes what each of the three files are.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"DesC" <xs667@.hotmail.com> wrote in message
news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> Prior to installing any SP3a service packs:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> RTM
>
> After installing sql2ksp3 and sql2kasp3 I get:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> SP3
>
> I am having difficulty installing sql2kdesksp3 and was wondering if I
was
> trying to install it where it is not required?
> I have an MSDN copy of SQL Server 2000 Developer Edition.
>
>
>
|||How then can you tell conclusively exactly what you have, i.e. SQL Server
2000 or MSDE 2000 ?
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> No. It appears that you have the Developer Edition of SQL Server 2000 and
> did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
> MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
A
> little ways down that page it describes what each of the three files are.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "DesC" <xs667@.hotmail.com> wrote in message
> news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
Windows[vbcol=seagreen]
Windows
> was
>
|||> After installing sql2ksp3 and sql2kasp3 I get:
Do you really have Analysis Services running? That's what sql2kasp3.exe is
for.

> I am having difficulty installing sql2kdesksp3
Probably because you don't need it. This file is for MSDE (desktop
edition).
Please read http://www.aspfaq.com/2440
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||Steve could tell because your @.@.VERSION returned "Developer Edition" in the
text.
If you have more than one installation of SQL Server, you will need to
repeat this process for every instance. Only you know how many instances
you have installed, but the SP3 page has information, I think, on
determining where your other instances live.
Also see http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DesC" <xs667@.hotmail.com> wrote in message
news:OrMYKOsMEHA.268@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> How then can you tell conclusively exactly what you have, i.e. SQL Server
> 2000 or MSDE 2000 ?
>
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
running[vbcol=seagreen]
http://www.microsoft.com/sql/downloads/2000/sp3.asp.[vbcol=seagreen]
> A
are.[vbcol=seagreen]
> rights.
> Windows
> Windows
I
>
|||Sql2kdesksp3 is for the Desktop Edition of SQL Server 2000. It appears
that you have the Developer Edition. These are not the same thing. You
already have service pack 3 (or 3a) on the SQL Server you posted the
@.@.version information from. If this is the one you are attempting to apply
sql2kdesksp3 to then it will not apply and if it did you probably do not
need it.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||You can also check your machine and/or network for all SQL Server instances
that are running. See the following URL (it may wrap):
http://www.microsoft.com/downloads/d...displaylang=en
|||Do you really have Analysis Services running?
Yes, I hope so anyrate, something wrong?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23xFJjOsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Do you really have Analysis Services running? That's what sql2kasp3.exe
is
> for.
>
> Probably because you don't need it. This file is for MSDE (desktop
> edition).
> Please read http://www.aspfaq.com/2440
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
|||> Yes, I hope so anyrate
Are you sure you know the difference between SQL Server and Analysis
Services? I think if you had any use for Analysis Services, you'd know
whether or not it was installed, instead of "I hope so"...
|||Well, I had an idea I was going to use DTS to pump data into a data
warehouse consisting of data-marts, data tables and dimension tables and
then extract static and dynamic cubes using Analysis Services (or OLAP as I
think it used to be called). I might be all wrong about this but one of my
contracts was for a major UK supermarket chain that produced a lot of data
and I figure larning how to do this kind of thing might be useful.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OG9uussMEHA.1348@.TK2MSFTNGP12.phx.gbl...
> Are you sure you know the difference between SQL Server and Analysis
> Services? I think if you had any use for Analysis Services, you'd know
> whether or not it was installed, instead of "I hope so"...
>

Is sql2kdesksp3 always necessary?

Prior to installing any SP3a service packs:
VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
RTM
After installing sql2ksp3 and sql2kasp3 I get:
VERSION:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
SP3
I am having difficulty installing sql2kdesksp3 and was wondering if I was
trying to install it where it is not required?
I have an MSDN copy of SQL Server 2000 Developer Edition.No. It appears that you have the Developer Edition of SQL Server 2000 and
did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp. A
little ways down that page it describes what each of the three files are.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"DesC" <xs667@.hotmail.com> wrote in message
news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> Prior to installing any SP3a service packs:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> RTM
>
> After installing sql2ksp3 and sql2kasp3 I get:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> SP3
>
> I am having difficulty installing sql2kdesksp3 and was wondering if I
was
> trying to install it where it is not required?
> I have an MSDN copy of SQL Server 2000 Developer Edition.
>
>
>|||How then can you tell conclusively exactly what you have, i.e. SQL Server
2000 or MSDE 2000 ?
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> No. It appears that you have the Developer Edition of SQL Server 2000 and
> did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
> MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
A
> little ways down that page it describes what each of the three files are.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "DesC" <xs667@.hotmail.com> wrote in message
> news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
Windows[vbcol=seagreen]
Windows[vbcol=seagreen]
> was
>|||> After installing sql2ksp3 and sql2kasp3 I get:
Do you really have Analysis Services running? That's what sql2kasp3.exe is
for.

> I am having difficulty installing sql2kdesksp3
Probably because you don't need it. This file is for MSDE (desktop
edition).
Please read http://www.aspfaq.com/2440
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Steve could tell because your @.@.VERSION returned "Developer Edition" in the
text.
If you have more than one installation of SQL Server, you will need to
repeat this process for every instance. Only you know how many instances
you have installed, but the SP3 page has information, I think, on
determining where your other instances live.
Also see http://www.aspfaq.com/2160
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DesC" <xs667@.hotmail.com> wrote in message
news:OrMYKOsMEHA.268@.TK2MSFTNGP11.phx.gbl...
> How then can you tell conclusively exactly what you have, i.e. SQL Server
> 2000 or MSDE 2000 ?
>
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
and[vbcol=seagreen]
running[vbcol=seagreen]
http://www.microsoft.com/sql/downloads/2000/sp3.asp.[vbcol=seagreen]
> A
are.[vbcol=seagreen]
> rights.
> Windows
> Windows
I[vbcol=seagreen]
>|||Sql2kdesksp3 is for the Desktop Edition of SQL Server 2000. It appears
that you have the Developer Edition. These are not the same thing. You
already have service pack 3 (or 3a) on the SQL Server you posted the
@.@.version information from. If this is the one you are attempting to apply
sql2kdesksp3 to then it will not apply and if it did you probably do not
need it.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||You can also check your machine and/or network for all SQL Server instances
that are running. See the following URL (it may wrap):
CDE4D933600&displaylang=en" target="_blank">http://www.microsoft.com/downloads/...&displaylang=en|||Do you really have Analysis Services running?
Yes, I hope so anyrate, something wrong?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23xFJjOsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> Do you really have Analysis Services running? That's what sql2kasp3.exe
is
> for.
>
> Probably because you don't need it. This file is for MSDE (desktop
> edition).
> Please read http://www.aspfaq.com/2440
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||> Yes, I hope so anyrate
Are you sure you know the difference between SQL Server and Analysis
Services? I think if you had any use for Analysis Services, you'd know
whether or not it was installed, instead of "I hope so"...|||Well, I had an idea I was going to use DTS to pump data into a data
warehouse consisting of data-marts, data tables and dimension tables and
then extract static and dynamic cubes using Analysis Services (or OLAP as I
think it used to be called). I might be all wrong about this but one of my
contracts was for a major UK supermarket chain that produced a lot of data
and I figure larning how to do this kind of thing might be useful.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OG9uussMEHA.1348@.TK2MSFTNGP12.phx.gbl...
> Are you sure you know the difference between SQL Server and Analysis
> Services? I think if you had any use for Analysis Services, you'd know
> whether or not it was installed, instead of "I hope so"...
>

Is sql2kdesksp3 always necessary?

Prior to installing any SP3a service packs:
VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
RTM
After installing sql2ksp3 and sql2kasp3 I get:
VERSION:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
SP3
I am having difficulty installing sql2kdesksp3 and was wondering if I was
trying to install it where it is not required?
I have an MSDN copy of SQL Server 2000 Developer Edition.No. It appears that you have the Developer Edition of SQL Server 2000 and
did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp. A
little ways down that page it describes what each of the three files are.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"DesC" <xs667@.hotmail.com> wrote in message
news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> Prior to installing any SP3a service packs:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> RTM
>
> After installing sql2ksp3 and sql2kasp3 I get:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> SP3
>
> I am having difficulty installing sql2kdesksp3 and was wondering if I
was
> trying to install it where it is not required?
> I have an MSDN copy of SQL Server 2000 Developer Edition.
>
>
>|||How then can you tell conclusively exactly what you have, i.e. SQL Server
2000 or MSDE 2000 ?
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> No. It appears that you have the Developer Edition of SQL Server 2000 and
> did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
> MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
A
> little ways down that page it describes what each of the three files are.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "DesC" <xs667@.hotmail.com> wrote in message
> news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> > Prior to installing any SP3a service packs:
> >
> > VERSION:
> > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
Windows
> > NT 5.1 (Build 2600: Service Pack 1)
> >
> > SERVERPROPERTY:
> > RTM
> >
> >
> > After installing sql2ksp3 and sql2kasp3 I get:
> >
> > VERSION:
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
> > NT 5.1 (Build 2600: Service Pack 1)
> >
> > SERVERPROPERTY:
> > SP3
> >
> >
> > I am having difficulty installing sql2kdesksp3 and was wondering if I
> was
> > trying to install it where it is not required?
> >
> > I have an MSDN copy of SQL Server 2000 Developer Edition.
> >
> >
> >
> >
> >
> >
>|||> After installing sql2ksp3 and sql2kasp3 I get:
Do you really have Analysis Services running? That's what sql2kasp3.exe is
for.
> I am having difficulty installing sql2kdesksp3
Probably because you don't need it. This file is for MSDE (desktop
edition).
Please read http://www.aspfaq.com/2440
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Steve could tell because your @.@.VERSION returned "Developer Edition" in the
text.
If you have more than one installation of SQL Server, you will need to
repeat this process for every instance. Only you know how many instances
you have installed, but the SP3 page has information, I think, on
determining where your other instances live.
Also see http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DesC" <xs667@.hotmail.com> wrote in message
news:OrMYKOsMEHA.268@.TK2MSFTNGP11.phx.gbl...
> How then can you tell conclusively exactly what you have, i.e. SQL Server
> 2000 or MSDE 2000 ?
>
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > No. It appears that you have the Developer Edition of SQL Server 2000
and
> > did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> > Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be
running
> > MSDE. Have a look at
http://www.microsoft.com/sql/downloads/2000/sp3.asp.
> A
> > little ways down that page it describes what each of the three files
are.
> >
> > --
> > Sincerely,
> > Stephen Dybing
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "DesC" <xs667@.hotmail.com> wrote in message
> > news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> > > Prior to installing any SP3a service packs:
> > >
> > > VERSION:
> > > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > > Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
> Windows
> > > NT 5.1 (Build 2600: Service Pack 1)
> > >
> > > SERVERPROPERTY:
> > > RTM
> > >
> > >
> > > After installing sql2ksp3 and sql2kasp3 I get:
> > >
> > > VERSION:
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows
> > > NT 5.1 (Build 2600: Service Pack 1)
> > >
> > > SERVERPROPERTY:
> > > SP3
> > >
> > >
> > > I am having difficulty installing sql2kdesksp3 and was wondering if
I
> > was
> > > trying to install it where it is not required?
> > >
> > > I have an MSDN copy of SQL Server 2000 Developer Edition.
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>|||Sql2kdesksp3 is for the Desktop Edition of SQL Server 2000. It appears
that you have the Developer Edition. These are not the same thing. You
already have service pack 3 (or 3a) on the SQL Server you posted the
@.@.version information from. If this is the one you are attempting to apply
sql2kdesksp3 to then it will not apply and if it did you probably do not
need it.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||You can also check your machine and/or network for all SQL Server instances
that are running. See the following URL (it may wrap):
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en|||Do you really have Analysis Services running?
Yes, I hope so anyrate, something wrong?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23xFJjOsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > After installing sql2ksp3 and sql2kasp3 I get:
> Do you really have Analysis Services running? That's what sql2kasp3.exe
is
> for.
> > I am having difficulty installing sql2kdesksp3
> Probably because you don't need it. This file is for MSDE (desktop
> edition).
> Please read http://www.aspfaq.com/2440
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||> Yes, I hope so anyrate
Are you sure you know the difference between SQL Server and Analysis
Services? I think if you had any use for Analysis Services, you'd know
whether or not it was installed, instead of "I hope so"...|||Well, I had an idea I was going to use DTS to pump data into a data
warehouse consisting of data-marts, data tables and dimension tables and
then extract static and dynamic cubes using Analysis Services (or OLAP as I
think it used to be called). I might be all wrong about this but one of my
contracts was for a major UK supermarket chain that produced a lot of data
and I figure larning how to do this kind of thing might be useful.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OG9uussMEHA.1348@.TK2MSFTNGP12.phx.gbl...
> > Yes, I hope so anyrate
> Are you sure you know the difference between SQL Server and Analysis
> Services? I think if you had any use for Analysis Services, you'd know
> whether or not it was installed, instead of "I hope so"...
>|||> Well, I had an idea I was going to use DTS to pump data into a data
> warehouse consisting of data-marts, data tables and dimension tables and
> then extract static and dynamic cubes using Analysis Services (or OLAP as
I
> think it used to be called). I might be all wrong about this but one of
my
> contracts was for a major UK supermarket chain that produced a lot of data
> and I figure larning how to do this kind of thing might be useful.
My original question was "do you have analysis services running?" to which
you said "I hope so."
I'm not questioning whether or not you think you can make use of Analysis
Services.
I'm questioning whether you should have even considered installing
sql2kasp3.exe.
A

Is SQl Service broker what I need?

Hi,

I am looking at the Service Broker as a way to notify multiple clients that there has been data changed on a table in the shared database. These clients may or may not be online. When there is a change, the notification should fire off a query to refresh the clients local cache. Is this a situation where Service Broker would help me? Can multiple clients recieve the notification at different times ( some recieve while online, some recieve when they come back online)? Any help on this would be appreciated. It seems from what I read that the messages are pulled off the queue when a notification has taken place. Is this correct? If so, can I set it to behave differently?

Thanks,

-paul

Service Broker could be used here, but I don't know if you necessarily need to use it here. It sounds like you just need to update some data for a client(s) to have available when they need it. In this case, just write some stored procedures or use a job to to make sure the data gets updated. The benefits of Service Broker is that it allows you to perform actions asynchronously and reliably, which leads to allowing you to build really scalable applications. Have you looked at some type of merge or transactional replication as an option for what you are doing? How many clients are you trying to alert? Why are you updating a local set of data for them rather than having them connect to the central database?

tim

Is SQL Server Service Manager still existing on SQL Express Edition?

Hi there. I am new to the SQL Express. I just finished installing the SQL Express 2005 with Advanced Services on a Windows XP SP2 computer. The first thing I noticed was the service manager (used to be on the taskbar) was being removed on the Express Edition. How do I get this feature back if it's even possible? I know you can find out the server status from the Configuration Manager but it's handy if the status is showned on the taskbar after logging in.

Any help will be greatly appreciated. Thank you.

KC

There is no Service Manager in any SKU of SQL Server 2005. There are some folks out there that have written their own however.

Is SQL Mulstiserver Administration a requirement with SP3a

In reading through the instructions for SQL SP3a there is a statement "before
you apply the service pack, you must upgrade your SQL Server 2000
master/target server configuration." Is this really the case? What if I
don't want to deal with the Multiserver administration? Another statement in
the instructions is “If you manage two or more servers and you want to
centralize maintenance tasks” The AND YOU WANT implies it not a requirement.
Anyone know for certain?
MandyH
Hi
It is not a requirement, but really eases administration. It is advice that
they give to help lower TCO (Total Cost of Ownership).
Regards
Mike
"MandyHancock" wrote:

> In reading through the instructions for SQL SP3a there is a statement "before
> you apply the service pack, you must upgrade your SQL Server 2000
> master/target server configuration." Is this really the case? What if I
> don't want to deal with the Multiserver administration? Another statement in
> the instructions is “If you manage two or more servers and you want to
> centralize maintenance tasks” The AND YOU WANT implies it not a requirement.
> Anyone know for certain?
> --
> MandyH
>
|||Wow - Thanks for such a quick response Mike. I REALLY appreciate having
someone like you out there .
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> It is not a requirement, but really eases administration. It is advice that
> they give to help lower TCO (Total Cost of Ownership).
> Regards
> Mike
> "MandyHancock" wrote:

Is SQL Mulstiserver Administration a requirement with SP3a

In reading through the instructions for SQL SP3a there is a statement "befor
e
you apply the service pack, you must upgrade your SQL Server 2000
master/target server configuration." Is this really the case? What if I
don't want to deal with the Multiserver administration? Another statement i
n
the instructions is “If you manage two or more servers and you want to
centralize maintenance tasks” The AND YOU WANT implies it not a requiremen
t.
Anyone know for certain?
--
MandyHHi
It is not a requirement, but really eases administration. It is advice that
they give to help lower TCO (Total Cost of Ownership).
Regards
Mike
"MandyHancock" wrote:

> In reading through the instructions for SQL SP3a there is a statement "bef
ore
> you apply the service pack, you must upgrade your SQL Server 2000
> master/target server configuration." Is this really the case? What if I
> don't want to deal with the Multiserver administration? Another statement
in
> the instructions is “If you manage two or more servers and you want to
> centralize maintenance tasks” The AND YOU WANT implies it not a requirem
ent.
> Anyone know for certain?
> --
> MandyH
>|||Wow - Thanks for such a quick response Mike. I REALLY appreciate having
someone like you out there .
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> It is not a requirement, but really eases administration. It is advice tha
t
> they give to help lower TCO (Total Cost of Ownership).
> Regards
> Mike
> "MandyHancock" wrote:
>

Is SQL Mulstiserver Administration a requirement with SP3a

In reading through the instructions for SQL SP3a there is a statement "before
you apply the service pack, you must upgrade your SQL Server 2000
master/target server configuration." Is this really the case? What if I
don't want to deal with the Multiserver administration? Another statement in
the instructions is â'If you manage two or more servers and you want to
centralize maintenance tasksâ' The AND YOU WANT implies it not a requirement.
Anyone know for certain?
--
MandyHHi
It is not a requirement, but really eases administration. It is advice that
they give to help lower TCO (Total Cost of Ownership).
Regards
Mike
"MandyHancock" wrote:
> In reading through the instructions for SQL SP3a there is a statement "before
> you apply the service pack, you must upgrade your SQL Server 2000
> master/target server configuration." Is this really the case? What if I
> don't want to deal with the Multiserver administration? Another statement in
> the instructions is â'If you manage two or more servers and you want to
> centralize maintenance tasksâ' The AND YOU WANT implies it not a requirement.
> Anyone know for certain?
> --
> MandyH
>|||Wow - Thanks for such a quick response Mike. I REALLY appreciate having
someone like you out there :).
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> It is not a requirement, but really eases administration. It is advice that
> they give to help lower TCO (Total Cost of Ownership).
> Regards
> Mike
> "MandyHancock" wrote:
> > In reading through the instructions for SQL SP3a there is a statement "before
> > you apply the service pack, you must upgrade your SQL Server 2000
> > master/target server configuration." Is this really the case? What if I
> > don't want to deal with the Multiserver administration? Another statement in
> > the instructions is â'If you manage two or more servers and you want to
> > centralize maintenance tasksâ' The AND YOU WANT implies it not a requirement.
> > Anyone know for certain?
> > --
> > MandyH
> >

Is SQL 7.0 obsolete yet?

Does anyone know what Microsoft plans are for SQL 7.0.
When will they stop selling it?
When will the Service Packs stop?
When will security upgrades stop?
When will they stop supporting it?
I need to justify the upgrade to SQL 2000 and need facts to support my
argument.
Thanks
http://support.microsoft.com/default.aspx?scid=fh;[ln];lifecycle
David Portas
SQL Server MVP
|||On Mon, 13 Sep 2004 06:41:15 -0700, David Portas
<REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote:

>http://support.microsoft.com/default.aspx?scid=fh;[ln];lifecycle
>
Product Name - General Availability Date - Mainstream Support
Retired - Extended Support Retired
SQL Server 7.0 01-Mar-1999 31-Dec-2005 Review note 3 below
SQL Server 7.0 EE 01-Mar-1999 31-Dec-2005 Review note3 below
3. Extended support will end December 31, 2010 or two years after the
next version of this product is launched, whichever length of time is
longer.

IS service won't start after installing SP1

I have just installed SP1 and now the IS service will not start at all. I have tried using the LocalSystem account and an account with domain admin rights that I use to run all the other SQL Server services.

Before the SP was applied the service was running fine.

I have tried starting it from the command prompt, services and configuration manager but none of them work, I get the following error message:

"The service did not respond to the start or control request in a timely fashion"

This message is also in in the System Event Viewer, but there are no messages in the Application Event Viewer for the IS Service so I am now officially stumped (not to mention frustrated)

Please help!

This issue is all voer the web: http://www.google.com/search?hl=en&lr=&q=ssis+%22The+service+did+not+respond+to+the+start+or+control+request+in+a+timely+fashion%22

Here for example: http://blogs.conchango.com/jamiethomson/archive/2006/04/26/3877.aspx

-Jamie

|||

Thanks for the help Jamie, I have found the kb article (918644).

Now I have to install 5 separate fixes, that fix problems caused by a big bunch of fixes!! Wow

|||

bobbins wrote:

Thanks for the help Jamie, I have found the kb article (918644).

Now I have to install 5 separate fixes, that fix problems caused by a big bunch of fixes!! Wow

Err yeah, that's basically it!

|||

will keep me busy I suppose

I am tempted to take a trip to the feedback centre and it won't be pretty

Cheers again

Is Service Broker Enabled?

Hello,

I've been trying for two days now to get SQL Cache Dependencies to work. So far, nothing has worked, and I have been around the block a few times now on this one. So now I'm going back to basics, as I think my code and queries are fine. My first question is how to confirm that I have a Service Broker that is up and running. I am using SSX as my database engine. Other posts mention how the "look at the service broker folder", and I don't see a folder anywhere. Can someone tell me what to look for? I've added various SP's based on tutorials on web sites, so I can't tell if those SP's are mine or theirs at this point (I've been at this too long). Where is the "folder" the other posts have mentioned? Do I need to do anything special to get it? Did I install all the right files?

Mike

Service Broker is built in into the SQL Server engine, is not possible to install/uninstall the broker compenent independently of the engine itself. Is has no external files/folders whatsowever. So if you have a SQL Server 2005 instanc eup and running, then Service Broker is up and running too. That being said, individual databases can have the broker in them disabled. To check this, look into the is_broker_enabled column in sys.databases. I guess the 'Broker folder' adice you found refers to the Object Explorer view in SQL Server Management Studio.

One place I would look first to troubleshoot SqlDependency issues is the sys.transmission_queue view in your database. If notifications were fired but cannot be delivered, you will find them there, pending delivery. The transmission_status column should indicate the reason why they cannot be delivered.

HTH,
~ Remus

|||

Remus,

Does this apply to SQL Server Express as well?

Thanks for you response,

Michael

|||

Yes. Note that the Express version of the Management Studio doesn't have a 'Service Broker' folder in it's Object Explorer.

HTH,
~ Remus

|||

Remus,

There is nothing in the sys.transmission_queue. I'm not even sure messages are GETTING to the database. In my event log, I just noticed a message I haven't seen before. It says:

Service Broker needs to access the master key in the database 'EventSystem'. Error code:25. The master key has to exist and the service master key encryption is required.

I'm not sure what this means. I suppose it's a starting point. Have you seen that one before?

Overall, I'm VERY frustrated with the Service Broker and cache dependencies. I've added more stored procedures and granted more permissions than should be necessary for a feature that is "built in" and "easy to use". So far, the exact OPPOSITE is true.

Thanks for all the help!

Michael

|||

I found a post that suggested I needed to create a master key. I ran the following statement:

CREATE MASTER KEY ENCRYPTION BY PASSWORD = '1ComplexPassword!'

Next, I ran my code again, and saw the following error in the logs:

The query notification dialog on conversation handle '{A1AFE272-1391-DB11-B928-0004230B9AA7}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service &apos;SqlQueryNotificationService-15eb7e6d-e2b3-4355-b082-8f0235f5fe3f&apos; because it does not exist.</Description></Error>'.

I thought I had run all procs that were necessary after going through literally a dozen pages on how to set this all up, but perhaps I missed one? I sure wish a single web site had steps that I could follow to get this all to work, start to finish. I promise to post all my steps when I am done, because I am sure others are having the same problem as me.

Michael

|||

I had similar problems.

The reason for my problem was that the database was in SQL Server 2000 compatibility mode.
Changing that to SQL Server 2005 helped.

Is reporting service support C# syntax

When I need to type code in the report that I must use VB syntax. Dose it support C# syntax.No it doesn't. An easy way to get syntax colouring and intellisense for the VBA code is to start up Excel or Word, and use the macro editor to write your code, then copy and paste it into your report.|||The only way to use C# code is to use a custom assembly with your report. You can write C# in the assembly, the have your report reference the assembly.

As far as code blocks and expressions in the report, it is all VB.