How do I migrate reports to new server

Hi all,
I just installed reporting services on a new server and need to migrate
existing reports from an old server to the new one. Being new to Reporting
Services, I am not sure of how to do this. Any help you gurus can provide
will be greatly appreciated.
Thanks,
--
LynnYou might want to use Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
Any questions just drop me a mail using the link in the readme file
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Lynn" <Lynn@.discussions.microsoft.com> wrote in message
news:7BEBF34B-420F-42D0-BEB0-33BF5E01AD46@.microsoft.com...
> Hi all,
> I just installed reporting services on a new server and need to migrate
> existing reports from an old server to the new one. Being new to
> Reporting
> Services, I am not sure of how to do this. Any help you gurus can provide
> will be greatly appreciated.
> Thanks,
> --
> Lynn|||> I just installed reporting services on a new server and need to migrate
> existing reports from an old server to the new one. Being new to
> Reporting
> Services, I am not sure of how to do this. Any help you gurus can provide
> will be greatly appreciated.
Hi Lynn,
I think this tool [1] can help you.
Look in the generated script to find out how it is working.
[1] http://www.sqldbatips.com/showarticle.asp?ID=62
Best regards,
--
Martin Kulov
http://www.codeattest.com/blogs/martin
MCAD Charter Member
MCSD.NET Early Achiever
MCSD

How do I load SQL Samples?

Hello,

I am a total beginner to SQL and I'm unable to load the samples. I downloaded the .msi file and installed it but I don't know where to go from here.

Am I importing one of the samples in SQL or do I open them in Visual Basic?

The samples folder has several sub-folders with no executable so I don't know where to begin.

Can someone point me in the right direction?

thanks in advance.

Chris

Try this reference:

http://download.microsoft.com/download/d/8/6/d865cf0c-c44b-401b-b426-b3bf5c628112/GettingStartedWithSQLSamples.htm

|||

I read that reference and I'm still not sure how to load the samples. I don't know if I'm supposed to open them in VB or SQL and if so, which file?

I navigated to the "samples" folder on my local drive and there are eight folders "analysis services", "engine", "Integrated samples"......"Integration services", "notification services", "replication" and "reporting services.

Not really sure where to start.

Any and all help is appreciated.

Chris

|||

You need to read in Books Online (the SQL Reference) about using the ATTACH keyword.

How do I know when a patch is available for SQL Server?

I installed Service Pack a3. It seems that Windows Automatic Updates is not
able to catch any patch(not sp) for SQL Server. Is there anyway that I can
make the patching automatic(at least notify me when a patch for SQL Server is
available)?
Thanks in advance!
Bo Sun
I am sure that you don't want the SP auto patched you SQL server!
Sign up with http://www.microsoft.com/security/default.mspx for email
update.
"Bo Sun" <Bo Sun@.discussions.microsoft.com> wrote in message
news:234E0FB7-91CC-4103-9BEF-6F9D067BB44E@.microsoft.com...
>I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server
> is
> available)?
> Thanks in advance!
> Bo Sun
|||> I installed Service Pack a3. It seems that Windows Automatic Updates is
not
> able to catch any patch(not sp) for SQL Server.
This is because most post-SP3a updates are hotfixes for specific
bugs/problems, not security patches (and are not relevant for all users).
You can stay pretty much on top of new hotfixes here:
http://www.aspfaq.com/2160 ...
Remember, also, that windows update is for windows, not SQL Server. I
believe they are planning similar functionality for SQL Server 2005, but
don't hold me to that.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Hi
Patching SQL Server is currently not possible with Windows Update. This may
change in the future.
Regards
Mike
"Bo Sun" wrote:

> I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server is
> available)?
> Thanks in advance!
> Bo Sun

How do I know when a patch is available for SQL Server?

I installed Service Pack a3. It seems that Windows Automatic Updates is not
able to catch any patch(not sp) for SQL Server. Is there anyway that I can
make the patching automatic(at least notify me when a patch for SQL Server is
available)?
Thanks in advance!
Bo SunI am sure that you don't want the SP auto patched you SQL server!
Sign up with http://www.microsoft.com/security/default.mspx for email
update.
"Bo Sun" <Bo Sun@.discussions.microsoft.com> wrote in message
news:234E0FB7-91CC-4103-9BEF-6F9D067BB44E@.microsoft.com...
>I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server
> is
> available)?
> Thanks in advance!
> Bo Sun|||> I installed Service Pack a3. It seems that Windows Automatic Updates is
not
> able to catch any patch(not sp) for SQL Server.
This is because most post-SP3a updates are hotfixes for specific
bugs/problems, not security patches (and are not relevant for all users).
You can stay pretty much on top of new hotfixes here:
http://www.aspfaq.com/2160 ...
Remember, also, that windows update is for windows, not SQL Server. I
believe they are planning similar functionality for SQL Server 2005, but
don't hold me to that.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Hi
Patching SQL Server is currently not possible with Windows Update. This may
change in the future.
Regards
Mike
"Bo Sun" wrote:
> I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server is
> available)?
> Thanks in advance!
> Bo Sun

How do I know if SQLXML 3.0 is installed

I downloaded and installed (at least I think I did), sqlxml 3.0
However when I go into Visual Basic.NET and try to add a reference, I dont
see in my list of COM objects, SQLXMLBULKLOADLib
HOWEVER, I can do a objBulkLoad =
CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
Can anybody HELP?
It should be in ARP (Add/Remove Programs). If you don't have it there,
download the latest v3, which is SQLXML 3.0 SP3.
Best regards
Niklas Engfelt
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:4135CD77-7669-43EF-901C-D65CE702CDB1@.microsoft.com...
>I downloaded and installed (at least I think I did), sqlxml 3.0
> However when I go into Visual Basic.NET and try to add a reference, I dont
> see in my list of COM objects, SQLXMLBULKLOADLib
> HOWEVER, I can do a objBulkLoad =
> CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
> Can anybody HELP?

How do I know if SQLXML 3.0 is installed

I downloaded and installed (at least I think I did), sqlxml 3.0
However when I go into Visual Basic.NET and try to add a reference, I dont
see in my list of COM objects, SQLXMLBULKLOADLib
HOWEVER, I can do a objBulkLoad =
CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
Can anybody HELP?It should be in ARP (Add/Remove Programs). If you don't have it there,
download the latest v3, which is SQLXML 3.0 SP3.
Best regards
Niklas Engfelt
"MSSQLServerDeveloper" <MSSQLServerDeveloper@.discussions.microsoft.com>
wrote in message news:4135CD77-7669-43EF-901C-D65CE702CDB1@.microsoft.com...
>I downloaded and installed (at least I think I did), sqlxml 3.0
> However when I go into Visual Basic.NET and try to add a reference, I dont
> see in my list of COM objects, SQLXMLBULKLOADLib
> HOWEVER, I can do a objBulkLoad =
> CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")
> Can anybody HELP?

How do I know if it is working?

Hi
I think I have installed MSDE sucessfully. The new servie is running, but how can I test ifit is working? Can I place my files anywhere on the system?
All help appreciatedAs the service is running try to access it using "osql" utility.

If you are talking about data files, yes you can declare the path while creating your database...

check create database syntax for thissql

How do I know if I need SQL SP3 or 3A?

My verions of SQL is 8.00194 (RTM) Does this mean I am current. How would
I
go about finding our if I need a service pack installed or not?
--
MandyHYou're not current. I personally would install the latest service pack
(SP3A).
Your SQL Server is currently open to security risks which, along with
patches, the service pack addresses.
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH|||Please review the ProductLevel option of the serverproperty() function.
You'll find more details in Books Online...
this will tell you what service pack you have. RTM means released to
manufacturing and means it's the initial release of SQL 2000 with no service
packs. You are currently exposed to a LARGE number of security and other
problems.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH|||Okay, thanks very much
"Brian Moran" wrote:

> Please review the ProductLevel option of the serverproperty() function.
> You'll find more details in Books Online...
> this will tell you what service pack you have. RTM means released to
> manufacturing and means it's the initial release of SQL 2000 with no servi
ce
> packs. You are currently exposed to a LARGE number of security and other
> problems.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> would I
>
>|||Okay. Thanks very much
"Armando Prato" wrote:

> You're not current. I personally would install the latest service pack
> (SP3A).
> Your SQL Server is currently open to security risks which, along with
> patches, the service pack addresses.
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> would I
>
>

How do I know if I need SQL SP3 or 3A?

My verions of SQL is 8.00194 (RTM) Does this mean I am current. How would I
go about finding our if I need a service pack installed or not?
MandyH
You're not current. I personally would install the latest service pack
(SP3A).
Your SQL Server is currently open to security risks which, along with
patches, the service pack addresses.
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH
|||Please review the ProductLevel option of the serverproperty() function.
You'll find more details in Books Online...
this will tell you what service pack you have. RTM means released to
manufacturing and means it's the initial release of SQL 2000 with no service
packs. You are currently exposed to a LARGE number of security and other
problems.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH
|||Okay, thanks very much
"Brian Moran" wrote:

> Please review the ProductLevel option of the serverproperty() function.
> You'll find more details in Books Online...
> this will tell you what service pack you have. RTM means released to
> manufacturing and means it's the initial release of SQL 2000 with no service
> packs. You are currently exposed to a LARGE number of security and other
> problems.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> would I
>
>
|||Okay. Thanks very much
"Armando Prato" wrote:

> You're not current. I personally would install the latest service pack
> (SP3A).
> Your SQL Server is currently open to security risks which, along with
> patches, the service pack addresses.
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> would I
>
>

How do I know if I need SQL SP3 or 3A?

My verions of SQL is 8.00194 (RTM) Does this mean I am current. How would I
go about finding our if I need a service pack installed or not?
--
MandyHYou're not current. I personally would install the latest service pack
(SP3A).
Your SQL Server is currently open to security risks which, along with
patches, the service pack addresses.
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH|||Please review the ProductLevel option of the serverproperty() function.
You'll find more details in Books Online...
this will tell you what service pack you have. RTM means released to
manufacturing and means it's the initial release of SQL 2000 with no service
packs. You are currently exposed to a LARGE number of security and other
problems.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH|||Okay, thanks very much
"Brian Moran" wrote:
> Please review the ProductLevel option of the serverproperty() function.
> You'll find more details in Books Online...
> this will tell you what service pack you have. RTM means released to
> manufacturing and means it's the initial release of SQL 2000 with no service
> packs. You are currently exposed to a LARGE number of security and other
> problems.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> > My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
> would I
> > go about finding our if I need a service pack installed or not?
> > --
> > MandyH
>
>|||Okay. Thanks very much
"Armando Prato" wrote:
> You're not current. I personally would install the latest service pack
> (SP3A).
> Your SQL Server is currently open to security risks which, along with
> patches, the service pack addresses.
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> > My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
> would I
> > go about finding our if I need a service pack installed or not?
> > --
> > MandyH
>
>

How do I install sqlcmd.exe in my SQL Server client

I have SQL Server 2000 client installed in my machine and I need to call stored procedures thru sqlcmd utility. When I tried using this utility, I got an error message from command prompt sqlcmd command does not exist.

I have osql utility in my client version, but i need to have sqlcmd utility.

Please advice how do I install sqlcmd.exe in my SQL Server client?SQLCMD was introduced in SQL Server 2005. For SQL Server 200, you can either use the OSQL.exe or the ISQL.exe tool.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

How do I install SQL Server Management Studio

From everything I read SQL Server Management Studio is only installed when you install SQL 2005 server.

I am using SQL Server 2000 sp3 so I have the Enterprise Manager.

Is there a way to install it or some other tool I can use to manage/view my sql everywhere database?

You could install the SQL Express management Tools and try them.

|||I figured it out and forgot to post the solution. On the SQL Server 2005 install cd you can install the tools.sql

How do I install MSDE after SQLServer 2000?

Hello,
I have SQLServer 2000 installed on a PC and I want to install
MSDE as well.
The attempted MSDE installation immediately fails with the
message:
"The instance name specified is invalid"
I looked at the autorun.inf file and I see that there is no name
specified for the new MSDE installation. Presumably it takes the
default machine name? The default machine name is already taken
by the existing SQL Server installation.
What are the correct lines to add to the MSDE autorun.inf file
for the default MSDE server name and sa account password?
After I have MSDE working is it possible to connect to it? I
would like to develop an ASP.NET web application that uses MSDE.
Ideally I would like to use something like Enterprise Manager
but to manage MSDE, at the very least I need something like
Query Analyser to work.
I note that there are some ASP.NET web apps in development that
emulate both Enterprise Manager and Query Analyser for MSDE. Has
anyone used these tools?
If necessary I can install MSDE on an other machine as I have a
LAN running here. I would prefer not to do that.
Hi,
Try executing the setup with Instance name:-
Setup.exe INSTANCENAME=<name> SAPWD=<sapassword >
Thanks
Hari
MCDBA
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||On Wed, 23 Jun 2004 08:50:23 +0100, Zenobia
<6.20.zenobia@.spamgourmet.com> wrote:

>Hello,
>I have SQLServer 2000 installed on a PC and I want to install
>MSDE as well.
>The attempted MSDE installation immediately fails with the
>message:
>"The instance name specified is invalid"
>I looked at the autorun.inf file and I see that there is no name
>specified for the new MSDE installation. Presumably it takes the
>default machine name? The default machine name is already taken
>by the existing SQL Server installation.
>What are the correct lines to add to the MSDE autorun.inf file
>for the default MSDE server name and sa account password?
>After I have MSDE working is it possible to connect to it? I
>would like to develop an ASP.NET web application that uses MSDE.
>Ideally I would like to use something like Enterprise Manager
>but to manage MSDE, at the very least I need something like
>Query Analyser to work.
>I note that there are some ASP.NET web apps in development that
>emulate both Enterprise Manager and Query Analyser for MSDE. Has
>anyone used these tools?
>If necessary I can install MSDE on an other machine as I have a
>LAN running here. I would prefer not to do that.
Apologies for wasting your time. I needed to add some lines to
the setup.ini file:
++++++++++++++++++++++++++++++++++++++++
[Options]
InstanceName="instance_name"
SAPWD="sa_password"
SecurityMode=SQL
++++++++++++++++++++++++++++++++++++++++
See:
http://msdn.microsoft.com/library/de...stsql_84xl.asp
http://support.microsoft.com/default...99&Product=sql
++++++++++++++++++++++++++++++++++++++++
But if anyone's reading. I'd appreciate help on utilities for
editing and creating MSDE databases and...
Now that MSDE is running I can't even see it on my machine. I
now have 2 Sqlservr.exe processes running, which have 2
different memory usages (16M and 8M). But why can't I see the
new database instance in my Tray. Is that normal. Surely, if I
have a process running, I should have an icon in my tray
allowing me to stop and start it?
I running XP pro SP1.
|||Zenobia,
--For the MSDE install issue
Try to run the setup in command line specifying a instance name, as
mentioned in the below syntax:
<path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
c:\<path>\msdeInstallation.log
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
> Hello,
> I have SQLServer 2000 installed on a PC and I want to install
> MSDE as well.
> The attempted MSDE installation immediately fails with the
> message:
> "The instance name specified is invalid"
> I looked at the autorun.inf file and I see that there is no name
> specified for the new MSDE installation. Presumably it takes the
> default machine name? The default machine name is already taken
> by the existing SQL Server installation.
> What are the correct lines to add to the MSDE autorun.inf file
> for the default MSDE server name and sa account password?
> After I have MSDE working is it possible to connect to it? I
> would like to develop an ASP.NET web application that uses MSDE.
> Ideally I would like to use something like Enterprise Manager
> but to manage MSDE, at the very least I need something like
> Query Analyser to work.
> I note that there are some ASP.NET web apps in development that
> emulate both Enterprise Manager and Query Analyser for MSDE. Has
> anyone used these tools?
> If necessary I can install MSDE on an other machine as I have a
> LAN running here. I would prefer not to do that.
>
|||>>>> > After I have MSDE working is it possible to connect to it?
Ofcourse.It will be just like a SQLServer instance.
[vbcol=seagreen]
MSDE is devoid of any GUI but you can always use EM/QA from other editions
to manage.
[vbcol=seagreen]
Aaron has a collection.Please search www.aspfaq.com
Dinesh
"Dinesh T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:#zwrcyPWEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Zenobia,
> --For the MSDE install issue
> Try to run the setup in command line specifying a instance name, as
> mentioned in the below syntax:
> <path>...\msde\setup INSTANCENAME="<instance_name>" /L*v
> c:\<path>\msdeInstallation.log
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
> news:atcid0l4i7qnu18vc7udj2ihmhru0neef5@.4ax.com...
>
|||On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
<tkdinesh@.nospam.mail.tkdinesh.com> wrote:

>Ofcourse.It will be just like a SQLServer instance.
>MSDE is devoid of any GUI but you can always use EM/QA from other editions
>to manage.
>
>Aaron has a collection.Please search www.aspfaq.com
Thanks.
After running server network utility I installed:
Named Pipes
TCP/IP
for my new MSDE installation aka machine_name\instance_name
After re booting it now shows to be 'running' in my system tray
as an option of my SQL Server and I have connected to it using
Enterprise Manager and QA.
Are these the 2 protocols I should install or will only one do?
|||Zenobia,
[vbcol=seagreen]
Its fine.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Zenobia" <6.20.zenobia@.spamgourmet.com> wrote in message
news:7vlid016ddkp0mdfpkvstd9kdgkoroe6ls@.4ax.com... [vbcol=seagreen]
> On Wed, 23 Jun 2004 14:21:43 +0530, "Dinesh T.K"
> <tkdinesh@.nospam.mail.tkdinesh.com> wrote:
editions
> Thanks.
> After running server network utility I installed:
> Named Pipes
> TCP/IP
> for my new MSDE installation aka machine_name\instance_name
> After re booting it now shows to be 'running' in my system tray
> as an option of my SQL Server and I have connected to it using
> Enterprise Manager and QA.
> Are these the 2 protocols I should install or will only one do?
>
sql

How do I get SQL Server integrated into VS2005?

I've had VS2005 installed for quite some time but I just purchansed SQL Server 2005 Developer and installed it. How do I accomplish integeration with SQL Server 2005 to VS2005? I had C# express at one point and SQL Express with the full tool install. That provided me with a designer for SQL Server (which was simply VS2005) and a seperate development environment under C# express. How do I integerate them so all the functionality resides within VS2005?

Any help you can provide will be much appreciated.

Thanks,

Dane R. Vinson

In Visual Studio, open the Server Explorer window.

Connect to your SQL Server.

You 'should' then be able to use Server Explorer in VS to write and test your SQL code.

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.

|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.

|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.
The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)
|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.
|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

How do I get AdventureWorks to show in sql2005.

How do you make the AdventureWorks sample show up (June ctp)? I already installed it using the msi file:
"C:\Program Files\Microsoft SQL Server\90\Tools\Samples\SQLServerSamples.msi"

But following these tutorial directions doesn't get me anywhere, since AdventureWorks won't show up on the database list (last step). What's missing?

Right-click Database Engine, point to New, and then click Server Registration. The New Server Registration dialog box opens. In the Server name text box, type the name of your SQL Server instance. In the Registered server name box, type AdventureWorks. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.
The adventureworks sample databases are not part of the MSI they are installed separately, did you select them at install time? If not then go back into Add/Remove programs and select them

-Euan|||

Yes, I selected everything in install time. I also ran: "C:\Program Files\Microsoft SQL Server\90Tools\Samples\SQLServerSamples.msi"

I see some adventureworks scripts and files in the sql server program directory, but I don't see how to make the sample show up as a database in sql management studio, or see the data.

|||The databases are not installed via that MSI, that contains the code and projects.

When you say you installed everything, did you go into the advanced tree from the component selection dialog, then drill down to sample databases and select both sample databases? They are not selected by default.

As a double check can you do a dir adv*.mdf /s from the root of the drive where you installed everything to please?

-Euan|||Yes AdventureWorks_Data.mdf and AdventureWorksDW_Data.mdf show up in my directory listing. (I installed everything by selecting "install ALL FEATURES to hard drive" on every option, exactly to avoid this kind of issue.)
|||Right click on the databases folder and select All Tasks, Attach Database, point the dialog at the .mdf files and all shold be well.

-Euan|||Thanks, that works. The directions in the docs should get corrected, at least the tutorial-type, for those who don't know their way around yet.
|||Fair point, actually the databases should have been auto attached and thats a bug.|||

I tried attaching Adventureworks and I get an error:

could not find row in sysindexes for database id 21, object id 1, index id 1...

could not open new database 'Adventureworks'. Create database is aborted. SQL Server Error: 602). Please advise. Thanks.

|||

This might be helpful?

The adventureWorks database installed at setup is only a starting point for creating

all the stored procedures used in the StoreFront. You must run the SQL install script

located in the C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP directory.

This procedure will create a new AdventureWorks.mdf that can be attached

in the App_Data Directory of your VS2005 project or site.

See the following

http://msdn2.microsoft.com/en-us/library/ms160715(en-US,SQL.90).aspx

|||Right click the DATABASE of the instance of your SQL server ,choose the "Attach to" ,in a new opened window click the "Add" button to find your the AdventureWorks.mdf which often is in the "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data " directiory. Additionally ,the .mis is AdventureWorksdb.mis.

How do I force new databases to be created on another drive on same server?

I successfuly installed SQL Server 2005 Enterprise Edition today (on the first shot!) but can't figure out how to force new databases, etc to be created on another drive on the server. SQL installed on the c: drive (I had no choice!) but it is a very small partition. I need to install Sharepoint Portal 2003 next (on a different server) and want to make sure everything goes on the other drive.

Help me, please!!

Thanks :-)

As far as I can remember Sharepoint let you choose the destination of the data files. Anyway the default data directory can be changed in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||Thanks, I'll give it a try.|||

I just tried it and it is still creating new databases on c: drive. We had to slick the server for another reason, so I have a fresh install and told it to install to d:\Program Files\.... during installation and the registry entry did not change; it still pointed to c: drive. I created a d:\Program Files\Microsoft SQL Server\Data directory and changed the registry and no joy. Even restarted the server a few times and it didn't matter.

Shouldn't there be a way to change this default in the Server Management Studio?!?

If any can help me, it would be appreciated! This problem is holding up installation of a few more apps.

Thanks!!

|||Sorry for that I copied the wrong key :-(

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

HTH, jens Suessmeyer.

http://www.sqlserver2005.de
|||

Hi,

Thanks. I actually found out where to do it in the SQL Server Management Studio!

SERVER--PROPERTIES--DATABASE SETTINGS

The path for databases and logs are blank. After I selected my folders on the D: drive I created a new db and it went to the correct path! Whew. Glad that's over with :-)

How do I find what version of SQL Server is installed?

Hello:
I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
editions.
Can you tell me how I can determine which flavor is installed?
I thought I had Standard Edition but when I tried to install Standard
Edition of the Reporting services, it said that it was a wrong type.
Thanks.
Venki
Sorry, I should have looked up the helpfile. I used the @.@.Version to realize
that I was running the developer's edition.
Venki
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||use master
select @.@.version
"vvenk" wrote:

> Hello:
> I know SQL Server 2000 come in Developer Edition, Standard and Enterprise
> editions.
> Can you tell me how I can determine which flavor is installed?
> I thought I had Standard Edition but when I tried to install Standard
> Edition of the Reporting services, it said that it was a wrong type.
> Thanks.
> Venki
|||Hi,
@.@.Version will serve you requirement. But have a look into the below link to
get all the versions for each patch level sql server.
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Thanks
Hari
SQL Server MVP
"vvenk" <vvenk@.discussions.microsoft.com> wrote in message
news:049E3C1C-ACF1-4D28-B659-475767027800@.microsoft.com...[vbcol=seagreen]
> Sorry, I should have looked up the helpfile. I used the @.@.Version to
> realize
> that I was running the developer's edition.
> Venki
> "vvenk" wrote: