MSDB database restore: query

Showing posts with label query. Show all posts

Wednesday, March 28, 2012

MSDE 2K vs SQL2K

Hello,
For my application I need to know how I can see the difference (by query) between a MSDE and SQL server.
I need to know if the server is MSDE or SQL...
Is there any information in the system tables where I can see it?
Thank a lot for your informationsI believe this will do it

select @.@.version|||This query returns a string wich described the version of the server.
I'm looking after a number version or something else wich does the same thing. I don't know if it exist... Maybe i'm looking for something that doesn't exist?|||select @.@.version on my pc gives this

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

I believe you can check whether or not your pc is a MSDE or SQL server 200o etc using this.

I just forgot this ... from the Holy Book (SQL server Books Online)

SERVERPROPERTY
Returns property information about the server instance.

Syntax
SERVERPROPERTY ( propertyname )

Arguments
propertyname

Is an expression containing the property information to be returned for the server. propertyname can be one of these values.

Property name Values returned
Collation The name of the default collation for the server.
Returns NULL if invalid input or error.

Base data type: nvarchar

Edition The edition of the Microsoft SQL Server instance installed on the server.
Returns:

'Desktop Engine'
'Developer Edition'
'Enterprise Edition'
'Enterprise Evaluation Edition'
'Personal Edition'
'Standard Edition'

Base data type: nvarchar(128)

Engine Edition The engine edition of the SQL Server instance installed on the server.
1 = Personal or Desktop Engine
2 = Standard
3 = Enterprise (returned for Enterprise, Enterprise Evaluation, and Developer)

Base data type: int

Monday, March 26, 2012

MSDE 2000 Release A - Query Analyzer included?

I installed MSDE 2000 Release A, but can't find the Query Analyzer. Is it
included, or only available with other SQL Server versions. If it is
included, then how do I install it? If not, can I download it from somewhere
else?
Hi
MSDE 2000 does not come with any of the tools like Query Analyzer or
Enterprise Manager.
You could download the evaluation edition of SQL Server 2000 and use those
tools for 120 days.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:41977C7A-205A-4CDA-AD56-843DF8779DE6@.microsoft.com...
>I installed MSDE 2000 Release A, but can't find the Query Analyzer. Is it
> included, or only available with other SQL Server versions. If it is
> included, then how do I install it? If not, can I download it from
> somewhere
> else?
>

Friday, March 23, 2012

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

Dear Experts,
I have downloaded MSDE 2000RelA and i installed it. But where is the
Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would be
greatly appreciated
Thanks
Manish
--
Three Cheers to Technet for the Help!Hi,
MSDE will not come with Enterprise manager or Query analyser. You have to
use the command prompt utilizty OSQL to execute all
the TSQL commands. See the details of OSQL utility in books online.
You could also download and use the WEB data ADMIN free tool from microsoft
site.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
Thanks
Hari
SQL Server MVP
"Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in
message news:42FB064A-B6B7-4F20-A3D4-C437096682E1@.microsoft.com...
> Dear Experts,
> I have downloaded MSDE 2000RelA and i installed it. But where is the
> Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would
> be
> greatly appreciated
> Thanks
> Manish
> --
> Three Cheers to Technet for the Help!|||Thanks Hari
--
Three Cheers to Technet for the Help!
"Hari Prasad" wrote:
> Hi,
> MSDE will not come with Enterprise manager or Query analyser. You have to
> use the command prompt utilizty OSQL to execute all
> the TSQL commands. See the details of OSQL utility in books online.
> You could also download and use the WEB data ADMIN free tool from microsoft
> site.
> http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en
> Thanks
> Hari
> SQL Server MVP
>
> "Manish Sawjiani" <ManishSawjiani@.discussions.microsoft.com> wrote in
> message news:42FB064A-B6B7-4F20-A3D4-C437096682E1@.microsoft.com...
> > Dear Experts,
> > I have downloaded MSDE 2000RelA and i installed it. But where is the
> > Enterprise Manager and Query Analyzer a-la SQL Server 7.0? Any help would
> > be
> > greatly appreciated
> >
> > Thanks
> > Manish
> > --
> > Three Cheers to Technet for the Help!
>
>

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

MSDE 2000 connectivity problem

Hi,
I have installed MSDE 2000 into my desktop machine.I can
connect from other machines to my desktop and accessing
databases using Query Analyser, Enterperise manager,
Profiler.but I didn't connect from ASP.NET application
using as "connectionstring".
Earlier it was worked.now its not working.
Send me your valuable reply ASAP.
Thanks and regards,
RafiqHow does your connection string look like?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Rafiq" <anonymous@.discussions.microsoft.com> wrote in message
news:088801c3a9ab$02032c50$a401280a@.phx.gbl...
> Hi,
> I have installed MSDE 2000 into my desktop machine.I can
> connect from other machines to my desktop and accessing
> databases using Query Analyser, Enterperise manager,
> Profiler.but I didn't connect from ASP.NET application
> using as "connectionstring".
> Earlier it was worked.now its not working.
> Send me your valuable reply ASAP.
> Thanks and regards,
> Rafiq

Monday, March 12, 2012

MSDE & SQL Server Agent

Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.
Yes, Agent is included.
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>

MSDE & SQL Server Agent

Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
--
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>

MSDE & SQL Server Agent

Can anyone tell me if the SQL Server Agent is included with MSDE? I realize
that Query Analyzer and Enterprise Manager are not included. I intend to use
MSDE for a project and would like to create jobs that will get scheduled by
SQL Server Agent.
Thanks.Yes, Agent is included.
Andrew J. Kelly SQL MVP
"Amos Soma" <amos_j_soma@.y_a_hoo.com> wrote in message
news:jMqdnVEia9dLsULdRVn-vA@.buckeye-express.com...
> Can anyone tell me if the SQL Server Agent is included with MSDE? I
realize
> that Query Analyzer and Enterprise Manager are not included. I intend to
use
> MSDE for a project and would like to create jobs that will get scheduled
by
> SQL Server Agent.
> Thanks.
>

Wednesday, March 7, 2012

MSDE

how to execute queries like query analiser or how can i see records
The SQL Server 2000 Desktop Engine does not include graphical management
tools. You can manage instances/run query against them with the help SQL
Server 2000 graphical tools if installed with another edition of SQL Server.
or use third party tools for MSDE
http://www.betav.com/Files/Content/Tools/tools.htm
At the same time you can use command line utilities like osql.exe to run
queries against the databases.
Vishal Parkar
vgparkar@.yahoo.co.in | vgparkar@.hotmail.com
"sailal" <sailal@.discussions.microsoft.com> wrote in message
news:A8B0C900-C642-412F-BA8D-24F07E032DC7@.microsoft.com...
> how to execute queries like query analiser or how can i see records
|||We have a program called MSDE Manager that's free for personal use. Details
at our site.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"sailal" <sailal@.discussions.microsoft.com> wrote in message
news:A8B0C900-C642-412F-BA8D-24F07E032DC7@.microsoft.com...
> how to execute queries like query analiser or how can i see records

Monday, February 20, 2012

MSDB database restore

I am trying to restore the msdb to another server. When I do, I get the
following message:
V-79-57344-33938 -
An error occurred on a query to database msdb.
V-79-57344-33938 - The backup of the system database on device
msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored because it
was created by a different version of the server (134218407) than this server
(134218262).
I understand what the message is saying but how do I find out what SPs and
hotfixes I need to install in order to get the target server to the correct
version? Is there a table or a document that will tell me what needs to be
installed on the target server?
ThanksYou can restore to a new version so as long as your up to the latest version
you should be OK. This generally isn't an issue when moving between service
pack and hot fixes so my guess is that you are trying to restore to a
pre-released version of SQL Server. Looking at the SELECT @.@.version output
should help determine what you are running.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
>I am trying to restore the msdb to another server. When I do, I get the
> following message:
> V-79-57344-33938 -
> An error occurred on a query to database msdb.
> V-79-57344-33938 - The backup of the system database on device
> msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored because
> it
> was created by a different version of the server (134218407) than this
> server
> (134218262).
> I understand what the message is saying but how do I find out what SPs and
> hotfixes I need to install in order to get the target server to the
> correct
> version? Is there a table or a document that will tell me what needs to
> be
> installed on the target server?
> Thanks
>|||The backup I am restoring from is on tape so I can not get it restored in
order to run the the select statement. All my databases were loaded from MS
CDs so a pre-released version of SQL server should not be an issue.
"Roger Wolter[MSFT]" wrote:
> You can restore to a new version so as long as your up to the latest version
> you should be OK. This generally isn't an issue when moving between service
> pack and hot fixes so my guess is that you are trying to restore to a
> pre-released version of SQL Server. Looking at the SELECT @.@.version output
> should help determine what you are running.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
> news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
> >I am trying to restore the msdb to another server. When I do, I get the
> > following message:
> >
> > V-79-57344-33938 -
> > An error occurred on a query to database msdb.
> > V-79-57344-33938 - The backup of the system database on device
> > msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored because
> > it
> > was created by a different version of the server (134218407) than this
> > server
> > (134218262).
> >
> > I understand what the message is saying but how do I find out what SPs and
> > hotfixes I need to install in order to get the target server to the
> > correct
> > version? Is there a table or a document that will tell me what needs to
> > be
> > installed on the target server?
> >
> > Thanks
> >
>|||So apply SQL 2005 SP2 and you will assuredly be more recent that the tape
backup.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
news:339C5DF0-6C3A-4FDA-B0AF-F65D59CB7349@.microsoft.com...
> The backup I am restoring from is on tape so I can not get it restored in
> order to run the the select statement. All my databases were loaded from
> MS
> CDs so a pre-released version of SQL server should not be an issue.
> "Roger Wolter[MSFT]" wrote:
>> You can restore to a new version so as long as your up to the latest
>> version
>> you should be OK. This generally isn't an issue when moving between
>> service
>> pack and hot fixes so my guess is that you are trying to restore to a
>> pre-released version of SQL Server. Looking at the SELECT @.@.version
>> output
>> should help determine what you are running.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
>> news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
>> >I am trying to restore the msdb to another server. When I do, I get the
>> > following message:
>> >
>> > V-79-57344-33938 -
>> > An error occurred on a query to database msdb.
>> > V-79-57344-33938 - The backup of the system database on device
>> > msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored
>> > because
>> > it
>> > was created by a different version of the server (134218407) than this
>> > server
>> > (134218262).
>> >
>> > I understand what the message is saying but how do I find out what SPs
>> > and
>> > hotfixes I need to install in order to get the target server to the
>> > correct
>> > version? Is there a table or a document that will tell me what needs
>> > to
>> > be
>> > installed on the target server?
>> >
>> > Thanks
>> >|||We are running SQL 2000 not SQL 2005.
"Roger Wolter[MSFT]" wrote:
> So apply SQL 2005 SP2 and you will assuredly be more recent that the tape
> backup.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
> news:339C5DF0-6C3A-4FDA-B0AF-F65D59CB7349@.microsoft.com...
> > The backup I am restoring from is on tape so I can not get it restored in
> > order to run the the select statement. All my databases were loaded from
> > MS
> > CDs so a pre-released version of SQL server should not be an issue.
> >
> > "Roger Wolter[MSFT]" wrote:
> >
> >> You can restore to a new version so as long as your up to the latest
> >> version
> >> you should be OK. This generally isn't an issue when moving between
> >> service
> >> pack and hot fixes so my guess is that you are trying to restore to a
> >> pre-released version of SQL Server. Looking at the SELECT @.@.version
> >> output
> >> should help determine what you are running.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm
> >>
> >> "Paul Oren" <PaulOren@.discussions.microsoft.com> wrote in message
> >> news:0C01112B-319F-4B14-8A49-F1EBAB72BF6A@.microsoft.com...
> >> >I am trying to restore the msdb to another server. When I do, I get the
> >> > following message:
> >> >
> >> > V-79-57344-33938 -
> >> > An error occurred on a query to database msdb.
> >> > V-79-57344-33938 - The backup of the system database on device
> >> > msdb_00__60f69b04_bfad_4b17_a284_4047d59b9e28_ cannot be restored
> >> > because
> >> > it
> >> > was created by a different version of the server (134218407) than this
> >> > server
> >> > (134218262).
> >> >
> >> > I understand what the message is saying but how do I find out what SPs
> >> > and
> >> > hotfixes I need to install in order to get the target server to the
> >> > correct
> >> > version? Is there a table or a document that will tell me what needs
> >> > to
> >> > be
> >> > installed on the target server?
> >> >
> >> > Thanks
> >> >
> >>
>

Wednesday, March 28, 2012

MSDE 2K vs SQL2K

Monday, March 26, 2012

MSDE 2000 Release A - Query Analyzer included?

Friday, March 23, 2012

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

MSDE 2000 Downloaded and Installed But where is Enterprise Manager

MSDE 2000 connectivity problem

Monday, March 12, 2012

MSDE & SQL Server Agent

MSDE & SQL Server Agent

MSDE & SQL Server Agent

Wednesday, March 7, 2012

MSDE

Monday, February 20, 2012

MSDB database restore

MSDB database restore

MSDB database restore

MSDB database restore

Blog Archive

About Me