p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: SQL Server 7


Message #1 by srobinson@g... on Tue, 18 Dec 2001 15:18:49
Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.
Message #2 by dmartin@z... on Tue, 18 Dec 2001 11:23:05 -0500
In the middle of the SQL Query Analuzer taskbar, there

is a combo box labeled: DB. Select your target database

from the list presented in the combobox. 



When you open SQA, it defaults to the master database.



Dallas





Quoting srobinson@g...:



> Hi All,

>

> I keep getting a stream of error messages when I 

attempt to execute a

> script in query analyzer on the remote server.

>

> The errors are:-

>

> 'cannot alter table blah blah because this table does 

not exist in DB'

>

> can anyone help?

>

> Cheers,

>

> Simon.





> $subst('Email.Unsub').

> 

Message #3 by "Simon Robinson" <srobinson@g...> on Tue, 18 Dec 2001 16:26:48 -0800
Hi Dallas,



The correct DB is already selected.



Simon.



-----Original Message-----

From: dmartin@z... [mailto:dmartin@z...] On Behalf Of

dmartin@z...

Sent: Tuesday, December 18, 2001 8:23 AM

To: ASP Databases

Subject: [asp_databases] Re: SQL Server 7



In the middle of the SQL Query Analuzer taskbar, there

is a combo box labeled: DB. Select your target database

from the list presented in the combobox. 



When you open SQA, it defaults to the master database.



Dallas





Quoting srobinson@g...:



> Hi All,

>

> I keep getting a stream of error messages when I 

attempt to execute a

> script in query analyzer on the remote server.

>

> The errors are:-

>

> 'cannot alter table blah blah because this table does 

not exist in DB'

>

> can anyone help?

>

> Cheers,

>

> Simon.





> $subst('Email.Unsub').

> 






$subst('Email.Unsub').



Message #4 by Sam Clohesy <sam@e...> on Tue, 18 Dec 2001 17:01:48 -0000
Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').

Message #5 by "Simon Robinson" <srobinson@g...> on Tue, 18 Dec 2001 17:16:44 -0800
Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').



Message #6 by Sam Clohesy <sam@e...> on Tue, 18 Dec 2001 17:56:04 -0000
You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').

Message #7 by "Simon Robinson" <srobinson@g...> on Wed, 19 Dec 2001 09:19:30 -0800
Hi Sam,



I still get the error



'cannot alter table blah blah because this table does not exist in DB'



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:56 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').



Message #8 by "Ken Schaefer" <ken@a...> on Wed, 19 Dec 2001 20:35:28 +1100
Is the table owned by dbo? or by a different user? 



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Simon Robinson" <srobinson@g...>

Subject: [asp_databases] RE: SQL Server 7





: Hi Sam,

: 

: I still get the error

: 

: 'cannot alter table blah blah because this table does not exist in DB'



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

.



Message #9 by "Simon Robinson" <srobinson@g...> on Wed, 19 Dec 2001 09:44:34 -0800
The table is owned by dbo. 



-----Original Message-----

From: Ken Schaefer [mailto:ken@a...] 

Sent: Wednesday, December 19, 2001 1:35 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Is the table owned by dbo? or by a different user? 



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Simon Robinson" <srobinson@g...>

Subject: [asp_databases] RE: SQL Server 7





: Hi Sam,

: 

: I still get the error

: 

: 'cannot alter table blah blah because this table does not exist in DB'



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

.








$subst('Email.Unsub').



Message #10 by "Simon Robinson" <srobinson@g...> on Wed, 19 Dec 2001 11:27:08 -0800
The owner is dbo.



Cheers,



Simon.



-----Original Message-----

From: Ken Schaefer [mailto:ken@a...] 

Sent: Wednesday, December 19, 2001 1:35 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Is the table owned by dbo? or by a different user? 



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Simon Robinson" <srobinson@g...>

Subject: [asp_databases] RE: SQL Server 7





: Hi Sam,

: 

: I still get the error

: 

: 'cannot alter table blah blah because this table does not exist in DB'



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

.








$subst('Email.Unsub').



Message #11 by Sam Clohesy <sam@e...> on Wed, 19 Dec 2001 12:48:17 -0000
Are you logged on as sa?



Have you checked the dbase does exist in the dbase?



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 17:20

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



I still get the error



'cannot alter table blah blah because this table does not exist in DB'



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:56 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').

Message #12 by "Simon Robinson" <srobinson@g...> on Wed, 19 Dec 2001 13:19:16 -0800
Hi Sam,



It is a db held on a shared server. The ISP will not allow me to log on

as sa.



The db does exist on the remote server.



The ISP is saying that the only way I can transfer the data is to import

on the remote server.



All good fun eh?



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 4:48 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Are you logged on as sa?



Have you checked the dbase does exist in the dbase?



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 17:20

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



I still get the error



'cannot alter table blah blah because this table does not exist in DB'



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:56 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').



Message #13 by Sam Clohesy <sam@e...> on Wed, 19 Dec 2001 13:22:05 -0000
What are you trying to do?



A large export of data? 



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 21:19

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



It is a db held on a shared server. The ISP will not allow me to log on

as sa.



The db does exist on the remote server.



The ISP is saying that the only way I can transfer the data is to import

on the remote server.



All good fun eh?



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 4:48 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Are you logged on as sa?



Have you checked the dbase does exist in the dbase?



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 17:20

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



I still get the error



'cannot alter table blah blah because this table does not exist in DB'



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:56 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').

Message #14 by "Simon Robinson" <srobinson@g...> on Wed, 19 Dec 2001 13:25:16 -0800
The whole db which is 105mb



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 5:22 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



What are you trying to do?



A large export of data? 



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 21:19

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



It is a db held on a shared server. The ISP will not allow me to log on

as sa.



The db does exist on the remote server.



The ISP is saying that the only way I can transfer the data is to import

on the remote server.



All good fun eh?



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 4:48 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Are you logged on as sa?



Have you checked the dbase does exist in the dbase?



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 17:20

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



I still get the error



'cannot alter table blah blah because this table does not exist in DB'



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:56 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').



Message #15 by Sam Clohesy <sam@e...> on Wed, 19 Dec 2001 13:26:54 -0000
So when you run the DTS wizard you get the dbase cannot be found error?



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 21:25

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





The whole db which is 105mb



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 5:22 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



What are you trying to do?



A large export of data? 



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 21:19

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



It is a db held on a shared server. The ISP will not allow me to log on

as sa.



The db does exist on the remote server.



The ISP is saying that the only way I can transfer the data is to import

on the remote server.



All good fun eh?



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 4:48 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Are you logged on as sa?



Have you checked the dbase does exist in the dbase?



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 17:20

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



I still get the error



'cannot alter table blah blah because this table does not exist in DB'



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:56 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').

Message #16 by David Cameron <dcameron@i...> on Thu, 20 Dec 2001 09:33:06 +1100
This message is in MIME format. Since your mail reader does not understand

this format, some or all of this message may not be legible.



------_=_NextPart_001_01C188DD.21323CD8

Content-Type: text/plain;

	charset="iso-8859-1"



run this:



use <insert db name>



SELECT name FROM sysobjects WHERE Type = 'u'



(obviously you insert your database name into the bit that says <insert db

name>)



Then check the resulting list of tables for the table you want to access. If

it isn't there either the table does not exist, or you have insufficient

access rights to see the table. If that is the case investigate why you

cannot see the table.



regards

David Cameron

nOw.b2b

dcameron@i...



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...]

Sent: Wednesday, 19 December 2001 11:27 PM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





So when you run the DTS wizard you get the dbase cannot be found error?



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 21:25

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





The whole db which is 105mb



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 5:22 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



What are you trying to do?



A large export of data? 



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 21:19

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



It is a db held on a shared server. The ISP will not allow me to log on

as sa.



The db does exist on the remote server.



The ISP is saying that the only way I can transfer the data is to import

on the remote server.



All good fun eh?



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Wednesday, December 19, 2001 4:48 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Are you logged on as sa?



Have you checked the dbase does exist in the dbase?



Thanks

Sam



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 17:20

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



I still get the error



'cannot alter table blah blah because this table does not exist in DB'



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:56 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



You don't need the brackets (Sorry they were confusing)



Something like:



use bmra

go

select * from tblMembers

where email = 'sam@e...'



Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: Simon Robinson [mailto:srobinson@g...]

Sent: 19 December 2001 01:17

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7





Hi Sam,



That returns a syntax error.



I am literally doing - 



<mydb>

go



-----Original Message-----

From: Sam Clohesy [mailto:sam@e...] 

Sent: Tuesday, December 18, 2001 9:02 AM

To: ASP Databases

Subject: [asp_databases] RE: SQL Server 7



Try putting 



<name of database>

go



before your query







Sam Clohesy

Project Manager

Tel: 0208 772 3958

E: samc@e...

W: http://www.etypemedia.co.uk





-----Original Message-----

From: srobinson@g... [mailto:srobinson@g...]

Sent: 18 December 2001 15:19

To: ASP Databases

Subject: [asp_databases] SQL Server 7





Hi All,



I keep getting a stream of error messages when I attempt to execute a 

script in query analyzer on the remote server.



The errors are:-



'cannot alter table blah blah because this table does not exist in DB'



can anyone help?



Cheers,



Simon.




$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').








$subst('Email.Unsub').






$subst('Email.Unsub').





  Return to Index