How to attach a database using SQL Server 2005

Hello
In the full version of SQL Server I can use enterprise manager to attach a
database. I have an SQL Server 2005 database from another machine which I
want to attach to a new computer with SQL Server 2005 Express. Is there a
tool I can use or do I need to run a command?
Angushave you try the sp_attach stored procedure?
"Angus" <nospam@.gmail.com> wrote in message
news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>|||Yes I have found the sp_attach syntax - but how do I run these commands?
Can I run them from the command line? But if I navigate to prog
files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg sp_attach?
Is this not the right path?
Or have I maybe not installed something?
There is a Start menu item, Microsoft SQL Server 2005... Configuration
Tools... SQL Server Configuration Manager - but can't see where I could type
commands in there?
Angus
"Jeje" <willgart@.hotmail.com> wrote in message
news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...
> have you try the sp_attach stored procedure?
> "Angus" <nospam@.gmail.com> wrote in message
> news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> > Hello
> >
> > In the full version of SQL Server I can use enterprise manager to attach
a
> > database. I have an SQL Server 2005 database from another machine which
I
> > want to attach to a new computer with SQL Server 2005 Express. Is there
a
> > tool I can use or do I need to run a command?
> >
> > Angus
> >
> >|||"Angus" <nospam@.gmail.com> wrote in
news:ecHo7S8kHHA.4188@.TK2MSFTNGP02.phx.gbl:
> Yes I have found the sp_attach syntax - but how do I run these
> commands? Can I run them from the command line? But if I navigate to
> prog files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg
> sp_attach? Is this not the right path?
> Or have I maybe not installed something?
> There is a Start menu item, Microsoft SQL Server 2005... Configuration
> Tools... SQL Server Configuration Manager - but can't see where I
> could type commands in there?
You can use the OSQL command-line utility to run stored procedures. See
BOL for how to use it.
> Angus
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...
>> have you try the sp_attach stored procedure?
>> "Angus" <nospam@.gmail.com> wrote in message
>> news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
>> > Hello
>> >
>> > In the full version of SQL Server I can use enterprise manager to
>> > attach
> a
>> > database. I have an SQL Server 2005 database from another machine
>> > which
> I
>> > want to attach to a new computer with SQL Server 2005 Express. Is
>> > there
> a
>> > tool I can use or do I need to run a command?
>> >
>> > Angus
>> >
>> >
>|||On Fri, 11 May 2007 12:52:21 +0100, "Angus" <nospam@.gmail.com> wrote:
>Hello
>In the full version of SQL Server I can use enterprise manager to attach a
>database. I have an SQL Server 2005 database from another machine which I
>want to attach to a new computer with SQL Server 2005 Express. Is there a
>tool I can use or do I need to run a command?
>Angus
SQL Server Management Studio Express has an attach command.
Click on Databases, right context mouse click, attach..
Another way to move a database from one machine to another is to make
a backup and then restore the backup to the new machine.|||Hi
CREATE DATABASE ...command has FOR ATTACH option ,please take a look at
BOL.
"Angus" <nospam@.gmail.com> wrote in message
news:%23iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>

How to attach a database using SQL Server 2005

Hello
In the full version of SQL Server I can use enterprise manager to attach a
database. I have an SQL Server 2005 database from another machine which I
want to attach to a new computer with SQL Server 2005 Express. Is there a
tool I can use or do I need to run a command?
Angushave you try the sp_attach stored procedure?
"Angus" <nospam@.gmail.com> wrote in message
news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>|||Yes I have found the sp_attach syntax - but how do I run these commands?
Can I run them from the command line? But if I navigate to prog
files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg sp_attach?
Is this not the right path?
Or have I maybe not installed something?
There is a Start menu item, Microsoft SQL Server 2005... Configuration
Tools... SQL Server Configuration Manager - but can't see where I could type
commands in there?
Angus
"Jeje" <willgart@.hotmail.com> wrote in message
news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...[vbcol=seagreen]
> have you try the sp_attach stored procedure?
> "Angus" <nospam@.gmail.com> wrote in message
> news:#iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
a[vbcol=seagreen]
I[vbcol=seagreen]
a[vbcol=seagreen]|||"Angus" <nospam@.gmail.com> wrote in
news:ecHo7S8kHHA.4188@.TK2MSFTNGP02.phx.gbl:

> Yes I have found the sp_attach syntax - but how do I run these
> commands? Can I run them from the command line? But if I navigate to
> prog files\microsoft SQL Server\MSSQL.1\MSSQL\Binn\ - I cannot run eg
> sp_attach? Is this not the right path?
> Or have I maybe not installed something?
> There is a Start menu item, Microsoft SQL Server 2005... Configuration
> Tools... SQL Server Configuration Manager - but can't see where I
> could type commands in there?
You can use the OSQL command-line utility to run stored procedures. See
BOL for how to use it.

> Angus
> "Jeje" <willgart@.hotmail.com> wrote in message
> news:uGaU5N8kHHA.2272@.TK2MSFTNGP02.phx.gbl...
> a
> I
> a
>|||On Fri, 11 May 2007 12:52:21 +0100, "Angus" <nospam@.gmail.com> wrote:

>Hello
>In the full version of SQL Server I can use enterprise manager to attach a
>database. I have an SQL Server 2005 database from another machine which I
>want to attach to a new computer with SQL Server 2005 Express. Is there a
>tool I can use or do I need to run a command?
>Angus
SQL Server Management Studio Express has an attach command.
Click on Databases, right context mouse click, attach..
Another way to move a database from one machine to another is to make
a backup and then restore the backup to the new machine.|||Hi
CREATE DATABASE ...command has FOR ATTACH option ,please take a look at
BOL.
"Angus" <nospam@.gmail.com> wrote in message
news:%23iTQZL8kHHA.4936@.TK2MSFTNGP03.phx.gbl...
> Hello
> In the full version of SQL Server I can use enterprise manager to attach a
> database. I have an SQL Server 2005 database from another machine which I
> want to attach to a new computer with SQL Server 2005 Express. Is there a
> tool I can use or do I need to run a command?
> Angus
>sql

How to apply SQL Server 2005 Express SP1 to the version of SQL Server 2005 Express which install

When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.

How can apply SQL Server 2005 Express SP1 to update this existing instance?

Currently, if I run this query:

SELECT @.@.version

I get the following:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

After applying SP1, I should get 9.00.2047.00.

Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:

http://msdn.microsoft.com/vstudio/express/sql/download/

Thank you,

Bashman

Follow the instructions on the readme file in the setup package. SQL Express SP1 is not a Service pack fix, its a full product. The instructions in the readme are very detailed to get through the process.

HTH, Jens Suessmeyer.

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

Its easy to just say go read the Readme!

Which Readme you talking about?

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005Advanced.htm

Neither of the two above Readme(s) tells me anything related to the VD2005 SQL 2005 Express that I am talking about.

If you know of any other Readme(s), please list the links!

Thanks for NOTHING!

|||

Since I didn't get any meaningful answers, I decided to take a chance and see what happens if I just run the upgrade setup as is.

I made sure I had backups first, then I stopped the SQLEXPRESS service.

Run the setup and followed the instructions on the screen using the default answers for all except for selecting which instance to upgrade.

All went well.

So for anyone looking at this thread, the quick answer is backup and install as is you'll be fine!

Again, thanks for nothing!

|||Hi,

its http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm

3.1 Prepare for a SQL Server Express SP1 Installation

HTH, Jens SUessmeyer.

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

That's exactly the section I followed (Backup & Stop the service).

Other than that, the rest of the Readme didn't apply to my original question.

Also, good thing that you read the Readme now that I listed the link readly for your reading enjoyment!

Enjoy everyone,

Bashman

|||I lost you, what does "Also, good thing that you read the Readme now that I listed the link readly for your reading enjoyment!" mean ? Which readme do you expect if you are struggeling with SQL Server Express SP1 and you have problems with SQL Server Express SP1. The section if was talking about in my previous post was just about that, for making that clearer I posted you the link to the relevant readme.

You asked the question which should be investigated at 06:08, at 06:12 you answered that you did not get any meaningful explanations, what do you expect the response times to be in a public forum, thats not a monitored chat or a paid support forum. So, you did not receive any answer in 4 minutes ? Thats really "horrible".

HTH, Jens SUessmeyer.

http://www.slqserver2005.de|||

Methinks the lady protests too much!

I always knew that my PC was fast, but I didn't know that it was that fast. Where I actually can backup my data & run a lengthy SQL server installation and post a reply in 4 minutes or less!

I realy have a FAST computer. If anyone is interested, I can list my PC specs for you!

Back to the subject, my reply to your "read the Readme" post was 24 hours after my original Post.

I see your answers on this board and they are usually typical of "read the Readme" kind of answers.

That's fine if you list or point to the Readme link and even better if you would point to the section of the Readme related to the answer of the question.

I did read the Readme(s) that I listed and found the section most apply to my question and took a chance on it.

Then I came back to the board and posted a reply to you and listed the two links (it took me about 4 minuts to write, slow typies but fast PC).

Four minutes later, I then listed what I did to get the job done.

I hope in the future when you answer with "Read the Readme(s)", you would try to point the link or the section most apply to the question/answer.

You know, I could just have gone and ignured this board "because I didn't get any answers from it".

But I came back and listed the Readme(s) and listed what I did so that the next time someone looking for this question/answer, would find something meaningful other than "Read the Readme(s)".

I don't know how long this is talking me to type, but I am the slow typest with a fast PC,

Bashman

|||From you post it seems that you didn′t know where to look at: "Neither of the two above Readme(s) tells me anything related to the VD2005 SQL 2005 Express that I am talking about." My assumptions was that you are smart enough to figure out that I ment the SQL Server Express SP1 readme, sorry for that. So I gave you another hint to look into that special readme under the mentioned section. Nevertheless, good that you fixed your problem.

HTH, Jens Suessmeyer.|||

You want the Credit, you got the Credit!

Yes, whithout your hint I was lost but then I was found! I realy didn't found my why without your reply!

I need your hand holding to lead me to the right Readme file.

By listing the two links, I showed you how loast I was!

But once your hint gave my the way, I managed to resolve my own problem in less than 4 minutes using my fast PC!

Thank you, Thank you, Thank you!

|||OK, you didn′t get it yet. Its just about being polite which you weren′t.

How to apply SQL Server 2005 Express SP1 to the version of SQL Server 2005 Express which ins

When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.

How can apply SQL Server 2005 Express SP1 to update this existing instance?

Currently, if I run this query:

SELECT @.@.version

I get the following:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

After applying SP1, I should get 9.00.2047.00.

Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:

http://msdn.microsoft.com/vstudio/express/sql/download/

Thank you,

Bashman

Follow the instructions on the readme file in the setup package. SQL Express SP1 is not a Service pack fix, its a full product. The instructions in the readme are very detailed to get through the process.

HTH, Jens Suessmeyer.

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

Its easy to just say go read the Readme!

Which Readme you talking about?

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm

http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005Advanced.htm

Neither of the two above Readme(s) tells me anything related to the VD2005 SQL 2005 Express that I am talking about.

If you know of any other Readme(s), please list the links!

Thanks for NOTHING!

|||

Since I didn't get any meaningful answers, I decided to take a chance and see what happens if I just run the upgrade setup as is.

I made sure I had backups first, then I stopped the SQLEXPRESS service.

Run the setup and followed the instructions on the screen using the default answers for all except for selecting which instance to upgrade.

All went well.

So for anyone looking at this thread, the quick answer is backup and install as is you'll be fine!

Again, thanks for nothing!

|||Hi,

its http://download.microsoft.com/download/b/d/1/bd1e0745-0e65-43a5-ac6a-f6173f58d80e/ReadmeSQLEXP2005.htm

3.1 Prepare for a SQL Server Express SP1 Installation

HTH, Jens SUessmeyer.

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

That's exactly the section I followed (Backup & Stop the service).

Other than that, the rest of the Readme didn't apply to my original question.

Also, good thing that you read the Readme now that I listed the link readly for your reading enjoyment!

Enjoy everyone,

Bashman

|||I lost you, what does "Also, good thing that you read the Readme now that I listed the link readly for your reading enjoyment!" mean ? Which readme do you expect if you are struggeling with SQL Server Express SP1 and you have problems with SQL Server Express SP1. The section if was talking about in my previous post was just about that, for making that clearer I posted you the link to the relevant readme.

You asked the question which should be investigated at 06:08, at 06:12 you answered that you did not get any meaningful explanations, what do you expect the response times to be in a public forum, thats not a monitored chat or a paid support forum. So, you did not receive any answer in 4 minutes ? Thats really "horrible".

HTH, Jens SUessmeyer.

http://www.slqserver2005.de|||

Methinks the lady protests too much!

I always knew that my PC was fast, but I didn't know that it was that fast. Where I actually can backup my data & run a lengthy SQL server installation and post a reply in 4 minutes or less!

I realy have a FAST computer. If anyone is interested, I can list my PC specs for you!

Back to the subject, my reply to your "read the Readme" post was 24 hours after my original Post.

I see your answers on this board and they are usually typical of "read the Readme" kind of answers.

That's fine if you list or point to the Readme link and even better if you would point to the section of the Readme related to the answer of the question.

I did read the Readme(s) that I listed and found the section most apply to my question and took a chance on it.

Then I came back to the board and posted a reply to you and listed the two links (it took me about 4 minuts to write, slow typies but fast PC).

Four minutes later, I then listed what I did to get the job done.

I hope in the future when you answer with "Read the Readme(s)", you would try to point the link or the section most apply to the question/answer.

You know, I could just have gone and ignured this board "because I didn't get any answers from it".

But I came back and listed the Readme(s) and listed what I did so that the next time someone looking for this question/answer, would find something meaningful other than "Read the Readme(s)".

I don't know how long this is talking me to type, but I am the slow typest with a fast PC,

Bashman

|||From you post it seems that you didn′t know where to look at: "Neither of the two above Readme(s) tells me anything related to the VD2005 SQL 2005 Express that I am talking about." My assumptions was that you are smart enough to figure out that I ment the SQL Server Express SP1 readme, sorry for that. So I gave you another hint to look into that special readme under the mentioned section. Nevertheless, good that you fixed your problem.

HTH, Jens Suessmeyer.|||

You want the Credit, you got the Credit!

Yes, whithout your hint I was lost but then I was found! I realy didn't found my why without your reply!

I need your hand holding to lead me to the right Readme file.

By listing the two links, I showed you how loast I was!

But once your hint gave my the way, I managed to resolve my own problem in less than 4 minutes using my fast PC!

Thank you, Thank you, Thank you!

|||OK, you didn′t get it yet. Its just about being polite which you weren′t.

How to adjust several SQL scripts in crystal report ?

Hi,

I wanted to adjust several sql scripts in the main crystal report without using subreports inorder to get data from an Oracle database version 8.17.

I am using add command in order to add my scripts.
I am using Oracle OLE provider in order to connect the oracle database.

I am using crystal report version 9.

Suppose there are four SQL scripts, I wanted that data from several columns of each SQL scripts should be display on separate detail section or separate page in a main crystal report without using subreports.

How should we do that?

Below you find some of the SQL scripts:

Thanks

Regards

Juma

Script1:

select vuser "DB User",vdatabase "Database",vclient "Client Name"
from temp where vuser
in (select username from v$session where username is not null and
username not in('SYS','SYSTEM', 'DBSNMP'))

Script2

select a.username "DB User",a.status "Status", a.sid||','||a.serial# "Sid & Serial#" ,
a.OSUSER "OS User",a.machine "Machine",a.TERMINAL "Terminal",a.program "Program"
from v$session a,v$sess_io cHi juma,
I dont think this is possible without subreports. Why do you want to do this without subreports?

Madhivanan

How to add a TCP endpoint in SQl Server 2005 Beta 2

Hi All,

I would like to know the syntax of creating an endpoint in SQL Server 2005 Beta 2 version.

The syntax which i am using is as follows:

create endpoint yuk1
state = started
as TCP
(
LISTENER_PORT = 4022
)
FOR SERVICE_BROKER (AUTHENTICATION = CERTIFICATE trpyuk1)

And i am getting the following error :

Incorrect syntax near 'CERTIFICATE'.

Regards
Deepak

You are using beta 3 syntax. Is there any reason why you are trying to use beta 2?|||Hi,

Ok, thanks for the update. SO is this syntax ok for the June Community Version?

Regards
Deepak|||Yes.

-mike

How to activate SQL server 2005

I want to know if there is a way to activate an evaluation version of SQL Server 2005 without re-installing the product completely. Running evaluation in a production environment while waiting on my purchase of Standard edition to be completed. All I have is my Microsoft Open License Order Confirmation.

Standard Edition does not allow 'activation' to upgrade from evaluation product to licensed product.

You will need to install the Standard Edition.

I suggest a side-by-side installation, moving the database files over to the Standard Edition server when installation is complete

Then when you have completed the transition, uninstall the eval version.

However, if you wish to keep the default Instance name the same as the computer name, then you will probably need to remove the eval version first.