|
 |
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').
|
|
|
View Cart
