Attach e Detach database

Maybe this a stupid question, but is there any differences beetwen detach
and attach a database from Enterprise Manager (All Tasks-Detach/Attach) or
with the system stored procedures ?
e.g.
if I look at KB 224071
http://support.microsoft.com/support/kb/articles/q224/0/71.asp (Moving SQL
Server Databases to a New Location with Detach/Attach) the articole said to
detach the database as follows :
use master
go
sp_detach_db 'mydb'
go
and to re-attach the database as follows :
use master
go
sp_attach_db 'mydb','...','...'
go
I think it's more simple to detach and attach the database from Enterprise
Manager than to write the stored procedure ...
Thanks,
Michele L.EA justs acts as a nice GUI. In the backgroud it actually
runs the sp_detach_db, sp_attach_db.
So your answer is - no not really ;)
J
>--Original Message--
>Maybe this a stupid question, but is there any
differences beetwen detach
>and attach a database from Enterprise Manager (All Tasks-
Detach/Attach) or
>with the system stored procedures ?
>e.g.
>if I look at KB 224071
>http://support.microsoft.com/support/kb/articles/q224/0/71
.asp (Moving SQL
>Server Databases to a New Location with Detach/Attach)
the articole said to
>detach the database as follows :
>use master
>go
>sp_detach_db 'mydb'
>go
>and to re-attach the database as follows :
>use master
>go
>sp_attach_db 'mydb','...','...'
>go
>I think it's more simple to detach and attach the
database from Enterprise
>Manager than to write the stored procedure ...
>Thanks,
>Michele L.
>
>
>
>
>.
>

Attach Detach System Databases

Hi. We are migrating databases from a server with
Standard edition (2000) to Enterprise Edition (2000).
Trying to find out if there is any difference in system
databases between these versions. For example, can we
move the master database from the Standard instance to
the Enterprise instance without any hangups. Thanks.
You can move the system databases from one Edition of SQL Server to another
Edition.
Rand
This posting is provided "as is" with no warranties and confers no rights.
sql

Attach Detach System Databases

Hi. We are migrating databases from a server with
Standard edition (2000) to Enterprise Edition (2000).
Trying to find out if there is any difference in system
databases between these versions. For example, can we
move the master database from the Standard instance to
the Enterprise instance without any hangups. Thanks.You can move the system databases from one Edition of SQL Server to another
Edition.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Attach Detach System Databases

Hi. We are migrating databases from a server with
Standard edition (2000) to Enterprise Edition (2000).
Trying to find out if there is any difference in system
databases between these versions. For example, can we
move the master database from the Standard instance to
the Enterprise instance without any hangups. Thanks.You can move the system databases from one Edition of SQL Server to another
Edition.
Rand
This posting is provided "as is" with no warranties and confers no rights.

attach db MS SQL 2000 .BAK with enterprise manager

hello everyone
i am the worst newbie that exists,,.. and on top my english is terrible !
i hope someone can help me :)
I need to attach .BAK db MS SQL 2000 with enterprise manager
I have a file de db sqlserver 2000 called hello_db_20060410man.bak
my last host has transfered to me .i am not hosted anymore and trying to attach my sqldb to use on IIS on my computer
but..... enterprise manager asks me for files in
.mdf and .log
How can I transform this .bak ?
when i try to restore it enterprise i CANNOT include it
message is that this ,bak is not a sql file !!!
Thanks in advance for your help

Quote:

Originally Posted by julia777

hello everyone
i am the worst newbie that exists,,.. and on top my english is terrible !
i hope someone can help me :)
I need to attach .BAK db MS SQL 2000 with enterprise manager
I have a file de db sqlserver 2000 called hello_db_20060410man.bak
my last host has transfered to me .i am not hosted anymore and trying to attach my sqldb to use on IIS on my computer
but..... enterprise manager asks me for files in
.mdf and .log
How can I transform this .bak ?
when i try to restore it enterprise i CANNOT include it
message is that this ,bak is not a sql file !!!
Thanks in advance for your help

Hi

Where you get this "hello_db_20060410man.bak" this file seems s BACKUP file ,you have restore this file then you will get the .mdf and .log files

RESTORE DATABASE <DESIRE DATABASE NAME>
FROM DISK = '<PATH OF WHERE hello_db_20060410man.bak RESIDES>'
WITH MOVE '<DAT FILENAME>' TO '<PATH WHERE YOU WANT .MDF FILE>',
MOVE 'LOGFILE NAME' TO '<PATH WHERE YOU WANT .LDF FILE>'

EXAMPLE:

RESTORE DATABASE TESTDB1 FROM DISK = 'C:\TEST\TESTDB.BAK'
WITH MOVE 'TESTDB_DAT' TO 'C:\TEST\TESTDB.MDF',
MOVE 'TESTDB_LOG' TO 'C:\TEST\TESTDB.LDF'|||THANKS a lot sponguru_dba :))
it seems to work i have ot my 2 files..
however.. seems i am having a problem to log into yhe site on my IIS :((
i will try again and let you know if you dont mind :)
Thanks again
Julia

attach db

How can I attach a remote db via Enterprise Manager or Query Analyzer?
Am I wrong if I launch a "sp_attach" sql file (from my local machine) to the remote server?
Do I really have to detach local db before?
Please can someone just tell me how he did?

SaoriHi saori,
1. Did you try to post your question in the DBA section of these forums:

http://www.sqlteam.com/Forums/


http://www.sql-server-performance.com/forum/default.asp

2. Hope some DBA will help you.|||Thanks for the answer.
I'll (quickly) give it a try.

(I posted a msg there 'cause it is above all a question of method about sql server tools)

Saori|||Honestly, I attach remote db's by creating a new registration. Unless you mean something else like fiberchanneling or something, but as for having your SQL Enterprise Manager utilize a Remote SQL Server, just create a new registration.

For T-SQL based methods, you're not necessarily attaching. I'd say it's more Linked Server, or Using Remote Servers. check books online for those two in the Index tab.

SP_LinkedServers and the other method would be actually using the enterprise manager to create the registration.|||Saori,

You didn't clearly define your question about what you want to 'attach', but I think I have understood what you were saying. I would redefine your question with several possible solutions.

Assume, you have a local SQL server in your machine, and there is another SQL server in a remote machine. There is a database called pubs1 existing in the remote SQL server. You want it APPEARS ('attach') in your SQL server.

1. Logical APPEAR:
As KraGiE suggested you could make a new Server Registration in your local SQL Enterprise Manager to LINK to that remote SQL server. In this way, you would bring the whole SQL server including the pubs1 into your local SQL Enterprise Manager.

However, to do so, you need to have the access to the database, say: machine name, login name and password. It is possible that you could only access one database in that server, say, pubs1. But that is enough for you. By the way, if the remote server is not within your LAN, and need to be linked through HTTP, you should have the server IP address and also the access to possible firewall.

I called this kind of 'attach' as logical APPEARS, because the database is not physically in your machine, but still at the remote server. You can only access the database through your Enterprise Manager. The database pubs1 appearing in your Enterprise Manager is just a pointer linked to the remote server.

2. Physical APPEAR:
In short, get a physical copy from the remote server and 'attach' it to your local server.

Step 1:
Copy the database file and the log file into your local machine. In this case, pubs1 files are located by default at:
C:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1.MDF
C:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1_log.LDF
You need shut down the remote database for copy/past, otherwise, it wouldn't work.

Step 2:
from Enterprise Manager, right click the Databases object in your local SQL instance, choose all tasks --> attach database ... . From the Attach Database window, choose your database file, pubs1, and then OK.

3. If you didn't have SQL 2000, instead of SQL 7.0, then the Step 2 would not avaiable in Enterprise Manager. You would have to use the command 'sp_attach_db' to do the job. Something like:

EXEC sp_attach_db @.dbname = N'pubs',
 @.filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1.mdf',
 @.filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log1.ldf'

4. Finally, if you even didn't have SQL server 7.0, you couldn't do the trick of 'attach'. But, you could do the job with SQL server 6.5 Enterprise Manager 'Database/Object transfer' tool given you have access to the remote database, where there is equivalent tools in both SQL 7.0/2000, called Import Data/Export Data, but not as easy used as the ATTACH method.

Hope this helps.|||Thanks Phuoc, KraGiE and ghan.
This really helped me understand essential issues.

Great analysis , ghan (copied in my notepad)!
Just one little thing:
When I attach db via Enterprise Manager, do I automatically transfer log file as well?|||saori,

I am really happy to hear that. You know what, when I made some analyses to other people, I just summarize what I have done and clear my understanding about this issue myself.

When I attach db via Enterprise Manager, do I automatically transfer log file as well?

You see the example:

EXEC sp_attach_db @.dbname = N'pubs',
 @.filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs1.mdf',
 @.filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log1.ldf'

There are two files, one is *.mdf, the data file, another is *.ldf, the log file.

When you use enterprise manager to do the job, you will see, (at STEP 2) you only need browse the *.mdf file in, while the *.ldf file will be brought in automatically, assuming you have copied the two files into the same directory (Step 1).

Good luck.|||I have a project lets say project1. I have a copy of it running on my development server and a copy of it on my production server. I have detached db from development server and attached it to my production server. I can work in db using Enterprise manager but when I try to run my applications it doesnt work. I know why it doesnt work its because its looking for user developmentserver and now its on productionserver. Is there a way to set permissions for user productionserver without having to do every table and stored procedure one at a time? I would like to do it quickly and efficiently and doing all by hand one at a time is neither.
Please help.|||There is a security issue. You must use Windows Authentification, instead of SQL Server Authentification. You might change your connection string to use SQL Server authentification. If you want to keep to use windows authentification, you need to setup your security in your production server to make your application assistent with your SQL server.

attach database option disabled

Hi,
I am trying to attach a database via enterprise manager
but the option to this is disabled. Is there anyway I can
enable this option?
Thanks in advance
JenC
Is the server you're connected to using SQL Server 7? If so, then no, you
cannot enable it. However, you can do the attach via Query Analyzer using
sp_attach_db (look up syntax in BOL).
"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
> Hi,
> I am trying to attach a database via enterprise manager
> but the option to this is disabled. Is there anyway I can
> enable this option?
> Thanks in advance
> JenC
|||Hi,
I am using SQL 2000 and I have tried using sp_attach_db
but with no joy.
Thanks.

>--Original Message--
>Is the server you're connected to using SQL Server 7? If
so, then no, you
>cannot enable it. However, you can do the attach via
Query Analyzer using
>sp_attach_db (look up syntax in BOL).
>
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
can
>
>.
>
|||Check the version of SQLServer you are trying to attach the DB to.
If you use SQL 2000 Enterprise Manager to administer a SQL 7 server, the
Attach Database menu item will be disabled.
"JenC" wrote:

> Hi,
> I am trying to attach a database via enterprise manager
> but the option to this is disabled. Is there anyway I can
> enable this option?
> Thanks in advance
> JenC
>
|||"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
> I am using SQL 2000 and I have tried using sp_attach_db
> but with no joy.
Do you want to post your error and some more information about the
problem? How was the database detached?
|||Hi,
I have sorted it out now (touch wood). Basically we have a
setup program that as part of the install installs MSDE
2000, unfortunately on some PC's (mainly Win XP PCs) it
installs the earlier version of MSDE and this is what
caused the confusion. I have now successfully installed
MSDE 2000 and I can now attach databases to my hearts
content.
Thanks for your help.
Jen

>--Original Message--
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
> Do you want to post your error and some more
information about the
>problem? How was the database detached?
>
>.
>

attach database option disabled

Hi,
I am trying to attach a database via enterprise manager
but the option to this is disabled. Is there anyway I can
enable this option?
Thanks in advance
JenCIs the server you're connected to using SQL Server 7? If so, then no, you
cannot enable it. However, you can do the attach via Query Analyzer using
sp_attach_db (look up syntax in BOL).
"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
> Hi,
> I am trying to attach a database via enterprise manager
> but the option to this is disabled. Is there anyway I can
> enable this option?
> Thanks in advance
> JenC|||Hi,
I am using SQL 2000 and I have tried using sp_attach_db
but with no joy.
Thanks.
>--Original Message--
>Is the server you're connected to using SQL Server 7? If
so, then no, you
>cannot enable it. However, you can do the attach via
Query Analyzer using
>sp_attach_db (look up syntax in BOL).
>
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1b4401c4999a$277726f0$3a01280a@.phx.gbl...
>> Hi,
>> I am trying to attach a database via enterprise manager
>> but the option to this is disabled. Is there anyway I
can
>> enable this option?
>> Thanks in advance
>> JenC
>
>.
>|||"JenC" <anonymous@.discussions.microsoft.com> wrote in message
news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
> I am using SQL 2000 and I have tried using sp_attach_db
> but with no joy.
Do you want to post your error and some more information about the
problem? How was the database detached?|||Hi,
I have sorted it out now (touch wood). Basically we have a
setup program that as part of the install installs MSDE
2000, unfortunately on some PC's (mainly Win XP PCs) it
installs the earlier version of MSDE and this is what
caused the confusion. I have now successfully installed
MSDE 2000 and I can now attach databases to my hearts
content.
Thanks for your help.
Jen
>--Original Message--
>"JenC" <anonymous@.discussions.microsoft.com> wrote in
message
>news:124b01c4999d$6ca7ada0$a301280a@.phx.gbl...
>> I am using SQL 2000 and I have tried using sp_attach_db
>> but with no joy.
> Do you want to post your error and some more
information about the
>problem? How was the database detached?
>
>.
>

Attach database - error 602

Hello,

After re-installation of MS SQL Server 2000 (Developer edition), I wanted to attch I previously available instances in the Enterprise Manager.
But, when I select "Attach database", I get the error:

Error 602: Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

When I run this "DBCC CHECKTABLE", I get the message that no errors have been found.

What should I do?SQL Server is finding a problem with the db when trying to attach so it wants you to run DBCC against that db and you can't because it isn't attached. You can try attaching manually with sp_attach_single_file_db or if you have a backup of the db, restore from backup.|||

IS that database detached properly previsouly?

If not try to use RESTORE statement from the backup file and also ensure the service pack level from the previous installation should match with it.

|||No, the databases were not detached previously. But anyway, I restored a backup.
Thanks anyway...|||

I'm glad you were successful but if you don't tell us what you did it doesn't help others. Can you tell us what you did to resolve the issue?

Thanks

|||If there is a problem with DETACH/ATTACH process then if the latest backup is available then you can recover the database using the RESTORE functionality.

Attach database - error 602

Hello,

After re-installation of MS SQL Server 2000 (Developer edition), I wanted to attch I previously available instances in the Enterprise Manager.
But, when I select "Attach database", I get the error:

Error 602: Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

When I run this "DBCC CHECKTABLE", I get the message that no errors have been found.

What should I do?SQL Server is finding a problem with the db when trying to attach so it wants you to run DBCC against that db and you can't because it isn't attached. You can try attaching manually with sp_attach_single_file_db or if you have a backup of the db, restore from backup.|||

IS that database detached properly previsouly?

If not try to use RESTORE statement from the backup file and also ensure the service pack level from the previous installation should match with it.

|||No, the databases were not detached previously. But anyway, I restored a backup.
Thanks anyway...|||

I'm glad you were successful but if you don't tell us what you did it doesn't help others. Can you tell us what you did to resolve the issue?

Thanks

|||If there is a problem with DETACH/ATTACH process then if the latest backup is available then you can recover the database using the RESTORE functionality.sql

Attach Database

in the Enterprise Manager when one goes to attach a database it lets
you choose an MDF / LDF file. It then verifies the validity of the
database before attaching. (I also assume that it detects if the
database was spanning multiple files). I am wondering if there is a
sproc/sprocs that can be called to do this or is this done via
proprietary knowledge of the format that the mdf/ldf files are stored
inThe attaching or the check on spanning multiple files?
Attaching: sp_attach_db or sp_attach_single_file_db
Check for files: this is included in the header of the .mdf, primary data
file. When the database comes online, this information is populated into th
e
virtual sysfiles.
Sincerely,
Anthony Thomas
"johndoe@.driver.net" wrote:

> in the Enterprise Manager when one goes to attach a database it lets
> you choose an MDF / LDF file. It then verifies the validity of the
> database before attaching. (I also assume that it detects if the
> database was spanning multiple files). I am wondering if there is a
> sproc/sprocs that can be called to do this or is this done via
> proprietary knowledge of the format that the mdf/ldf files are stored
> in
>|||So If i wanted to see all the files attached to a database I would need to
read the file myself and parse the header?
"AnthonyThomas" wrote:
[vbcol=seagreen]
> The attaching or the check on spanning multiple files?
> Attaching: sp_attach_db or sp_attach_single_file_db
> Check for files: this is included in the header of the .mdf, primary data
> file. When the database comes online, this information is populated into
the
> virtual sysfiles.
> Sincerely,
>
> Anthony Thomas
>
> "johndoe@.driver.net" wrote:
>|||Not too sure what the issue is.
If the database is online, then sp_helpdb <database name> will list out all
of the files used by the database.
If the database is detached and all you have is the primary data file, you
could try to use sp_attach_single_file_db and read the error messages as the
y
come up. This will tell you what the system is looking for.
However, if you or someone else has detached a database and you or someone
else didn't know what files belonged, shame on you. You should have checked
before you detached.
Sincerely,
Anthony Thomas
"johndoe@.community.nospam" wrote:
[vbcol=seagreen]
> So If i wanted to see all the files attached to a database I would need to
> read the file myself and parse the header?
> "AnthonyThomas" wrote:
>

Attach Database

in the Enterprise Manager when one goes to attach a database it lets
you choose an MDF / LDF file. It then verifies the validity of the
database before attaching. (I also assume that it detects if the
database was spanning multiple files). I am wondering if there is a
sproc/sprocs that can be called to do this or is this done via
proprietary knowledge of the format that the mdf/ldf files are stored
inThe attaching or the check on spanning multiple files?
Attaching: sp_attach_db or sp_attach_single_file_db
Check for files: this is included in the header of the .mdf, primary data
file. When the database comes online, this information is populated into the
virtual sysfiles.
Sincerely,
Anthony Thomas
"johndoe@.driver.net" wrote:
> in the Enterprise Manager when one goes to attach a database it lets
> you choose an MDF / LDF file. It then verifies the validity of the
> database before attaching. (I also assume that it detects if the
> database was spanning multiple files). I am wondering if there is a
> sproc/sprocs that can be called to do this or is this done via
> proprietary knowledge of the format that the mdf/ldf files are stored
> in
>|||So If i wanted to see all the files attached to a database I would need to
read the file myself and parse the header?
"AnthonyThomas" wrote:
> The attaching or the check on spanning multiple files?
> Attaching: sp_attach_db or sp_attach_single_file_db
> Check for files: this is included in the header of the .mdf, primary data
> file. When the database comes online, this information is populated into the
> virtual sysfiles.
> Sincerely,
>
> Anthony Thomas
>
> "johndoe@.driver.net" wrote:
> > in the Enterprise Manager when one goes to attach a database it lets
> > you choose an MDF / LDF file. It then verifies the validity of the
> > database before attaching. (I also assume that it detects if the
> > database was spanning multiple files). I am wondering if there is a
> > sproc/sprocs that can be called to do this or is this done via
> > proprietary knowledge of the format that the mdf/ldf files are stored
> > in
> >|||Not too sure what the issue is.
If the database is online, then sp_helpdb <database name> will list out all
of the files used by the database.
If the database is detached and all you have is the primary data file, you
could try to use sp_attach_single_file_db and read the error messages as they
come up. This will tell you what the system is looking for.
However, if you or someone else has detached a database and you or someone
else didn't know what files belonged, shame on you. You should have checked
before you detached.
Sincerely,
Anthony Thomas
"johndoe@.community.nospam" wrote:
> So If i wanted to see all the files attached to a database I would need to
> read the file myself and parse the header?
> "AnthonyThomas" wrote:
> > The attaching or the check on spanning multiple files?
> >
> > Attaching: sp_attach_db or sp_attach_single_file_db
> >
> > Check for files: this is included in the header of the .mdf, primary data
> > file. When the database comes online, this information is populated into the
> > virtual sysfiles.
> >
> > Sincerely,
> >
> >
> > Anthony Thomas
> >
> >
> > "johndoe@.driver.net" wrote:
> >
> > > in the Enterprise Manager when one goes to attach a database it lets
> > > you choose an MDF / LDF file. It then verifies the validity of the
> > > database before attaching. (I also assume that it detects if the
> > > database was spanning multiple files). I am wondering if there is a
> > > sproc/sprocs that can be called to do this or is this done via
> > > proprietary knowledge of the format that the mdf/ldf files are stored
> > > in
> > >

Attach Database

in the Enterprise Manager when one goes to attach a database it lets
you choose an MDF / LDF file. It then verifies the validity of the
database before attaching. (I also assume that it detects if the
database was spanning multiple files). I am wondering if there is a
sproc/sprocs that can be called to do this or is this done via
proprietary knowledge of the format that the mdf/ldf files are stored
in
The attaching or the check on spanning multiple files?
Attaching: sp_attach_db or sp_attach_single_file_db
Check for files: this is included in the header of the .mdf, primary data
file. When the database comes online, this information is populated into the
virtual sysfiles.
Sincerely,
Anthony Thomas
"johndoe@.driver.net" wrote:

> in the Enterprise Manager when one goes to attach a database it lets
> you choose an MDF / LDF file. It then verifies the validity of the
> database before attaching. (I also assume that it detects if the
> database was spanning multiple files). I am wondering if there is a
> sproc/sprocs that can be called to do this or is this done via
> proprietary knowledge of the format that the mdf/ldf files are stored
> in
>
|||So If i wanted to see all the files attached to a database I would need to
read the file myself and parse the header?
"AnthonyThomas" wrote:
[vbcol=seagreen]
> The attaching or the check on spanning multiple files?
> Attaching: sp_attach_db or sp_attach_single_file_db
> Check for files: this is included in the header of the .mdf, primary data
> file. When the database comes online, this information is populated into the
> virtual sysfiles.
> Sincerely,
>
> Anthony Thomas
>
> "johndoe@.driver.net" wrote:
|||Not too sure what the issue is.
If the database is online, then sp_helpdb <database name> will list out all
of the files used by the database.
If the database is detached and all you have is the primary data file, you
could try to use sp_attach_single_file_db and read the error messages as they
come up. This will tell you what the system is looking for.
However, if you or someone else has detached a database and you or someone
else didn't know what files belonged, shame on you. You should have checked
before you detached.
Sincerely,
Anthony Thomas
"johndoe@.community.nospam" wrote:
[vbcol=seagreen]
> So If i wanted to see all the files attached to a database I would need to
> read the file myself and parse the header?
> "AnthonyThomas" wrote:

Attach and ODBC Database in Enterprise Manger (I think)

I have created an SQL database and would like to attach an ODBC database so
I can query its data along with data from the SQL database. How can I
attached this table in the Enterprise manager? Or maybe my thinking is
wrong and can't be done this way, so how do i do it? Sotred Procedures?
Views? Please help...
Thank you in advance for any help for I am in a real bind,
MikeI think what you are saying is you want to connect an ODBC datasource to you
r
SQL database. Is this correct?
"Michael Kintner" wrote:

> I have created an SQL database and would like to attach an ODBC database s
o
> I can query its data along with data from the SQL database. How can I
> attached this table in the Enterprise manager? Or maybe my thinking is
> wrong and can't be done this way, so how do i do it? Sotred Procedures?
> Views? Please help...
> Thank you in advance for any help for I am in a real bind,
> Mike
>
>|||Use can use Enterprise Manager to create a Linked Server. In the EM,
expand your database instance, then expand the Security node and then
right click on Linked Servers to create a new linked server. Fill-in
the blanks and you're done.
In Query Analyzer, you can query you linked server like:
select * from <linked_server_name>.<database_name>.<dbo>.<table_name>
Easy.|||YEs this is correct, I have an AS400 system I would like connect to my SQL
server and run views between both systems on my SQL server.
"Lontae Jones" <LontaeJones@.discussions.microsoft.com> wrote in message
news:2A5BEF15-D324-43AB-81A9-954257D496DD@.microsoft.com...
>I think what you are saying is you want to connect an ODBC datasource to
>your
> SQL database. Is this correct?
>
>
> "Michael Kintner" wrote:
>

asp.net enterprise manager

Hi

has anyone used this tool to upload sql databases to a web host

i'm struggling

cheers!!!

Adrian

Hi

Use the Copy Database Wizard

|||This post shows detailed steps to move database to?shared host:
HOW-TO: Database from VWD to Shared Host