problem with bcp using format file

The running of my bcp (with queryout) is aborting, with the message below. A
t
first I identified that it happened only with column with NULL value, but no
w
I realize this occurrence happened in other field without NULL value.
Anyone has suggestions ? Thanks a lot
My format file has the following contents : 8.0 (version) 2 (number of
columns)
1 SQLCHAR 0 20 "\t" 1 numeroaj Latin1_General_CI_AS
2 SQLCHAR 0 54 "\r\n" 2 acervoespecializada Latin1_General_CI_AS
My bad run :
D:\Users\sql>bcp "SELECT numeroaj, acervoespecializada from
Siga.dbo.vwHerancaJa
cente" queryout C:\dts\hjacente.txt -f d:\users\sql\pgm3.fmt -Smyserver
-Umyuser -Pmypwd
SQLState = S1000, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Erro de E/S ao ler o arquivo no
forma
to BCP ==> Translating... Error of I/O when read the format filewhere do you run this bcp statement, on the client or on the server itself.
"d:\" must be local to where ever you run the bcp statement.
-oj
"Adalberto Andrade" <Adalberto Andrade@.discussions.microsoft.com> wrote in
message news:014C3C25-592D-4A88-A320-325C52D49D2A@.microsoft.com...
> The running of my bcp (with queryout) is aborting, with the message below.
> At
> first I identified that it happened only with column with NULL value, but
> now
> I realize this occurrence happened in other field without NULL value.
> Anyone has suggestions ? Thanks a lot
> My format file has the following contents : 8.0 (version) 2 (number of
> columns)
> 1 SQLCHAR 0 20 "\t" 1 numeroaj Latin1_General_CI_AS
> 2 SQLCHAR 0 54 "\r\n" 2 acervoespecializada
> Latin1_General_CI_AS
> My bad run :
> D:\Users\sql>bcp "SELECT numeroaj, acervoespecializada from
> Siga.dbo.vwHerancaJa
> cente" queryout C:\dts\hjacente.txt -f d:\users\sql\pgm3.fmt -Smyserver
> -Umyuser -Pmypwd
> SQLState = S1000, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Erro de E/S ao ler o arquivo no
> forma
> to BCP ==> Translating... Error of I/O when read the format file|||Hi oj,
On the client. And "d:\" is a local drive (in my machine). With
others columns it worked OK.
Thanks
Adalberto Andrade
"oj" wrote:

> where do you run this bcp statement, on the client or on the server itself
.
> "d:\" must be local to where ever you run the bcp statement.
> --
> -oj
>
> "Adalberto Andrade" <Adalberto Andrade@.discussions.microsoft.com> wrote in
> message news:014C3C25-592D-4A88-A320-325C52D49D2A@.microsoft.com...
>
>|||Adalberto,
Please check to see if there is a carriage return at the
end of your format file and that there are no extra tabs
or anything else in it. Also be sure the format file
is not open in an editor when you run the command.
The error message mentions the format file, not the
data file, so I think the problem is with the format file.
Steve Kass
Drew University
Adalberto Andrade wrote:
>Hi oj,
> On the client. And "d:\" is a local drive (in my machine). With
>others columns it worked OK.
>
> Thanks
> Adalberto Andrade
>
>
>"oj" wrote:
>
>|||Steve,
I made a complete revision of all components of my environment.
Things like : cr (carriage return), opened format file and others wrongs
caracters inside of format file are not the problem. I am thankful for yours
suggestions,but the problem continue. Now I substituted the third column of
my output file and the bcp utility started the copy, but the generated file
has mixed data with stranger caracters. This new column has valids datas and
also null values in some registers and it is the great difference between th
e
others columns (first e second ones). Without this third column everything
work 100% OK. I already try to change the value of prefix length (field of
the format file) to -1 or 2 with the hope to solve it, but the output
generated file continue with stranger and mixed caracters (like ASCII
caracters). I really don't have any idea of what I can do to put it to work.
I am not sure, but perhaps I will need to make other configuration in my
format file, but exactly what ? Do you have other help for me ?
Thanks again
Adalberto Andrade
"Steve Kass" wrote:

> Adalberto,
> Please check to see if there is a carriage return at the
> end of your format file and that there are no extra tabs
> or anything else in it. Also be sure the format file
> is not open in an editor when you run the command.
> The error message mentions the format file, not the
> data file, so I think the problem is with the format file.
> Steve Kass
> Drew University
> Adalberto Andrade wrote:
>
>|||Adalberto,
I am not sure what the problem is, but here are three separate
suggestions.
1. Try to use bcp without a format file, since TAB and NEWLINE
are the defaults for bcp. If this creates a Unicode file, you will need
to change the format file to say SQLNCHAR instead of SQLCHAR,
and you will also need to put the Unicode two-byte signature into
the beginning of the file yourself, since bcp does not do this for you.
2. Be sure the format file is saved as ASCII, not Unicode, then try
again with the format file.
3. Verify the data lengths and types of the output,
3A. Run this and provide the output.
select top 1
numeroaj, acervoespecializada
into CheckTypesTable
from Siga.dbo.vwHerancaJacente
select * from CheckTypesTable
3B. In Query Analyzer, refresh the current database
and for [CheckTypesTable] choose "Script Table To
New Window" to verify the data types of these columns
and provide the output.
3C. After doing this, you can DROP the table CheckTypesTable.
It might help if you post the definition of Siga.dbo.vwHerancaJa.
(If it is a view, also post CREATE TABLE statements from the
tables it uses for the columns numeroaj and acervoespecializada
(and the third column, since at one point you mention three columns.
Also, when you have three columns, what is your query?)
SK
Adalberto Andrade wrote:
>Steve,
> I made a complete revision of all components of my environment.
>Things like : cr (carriage return), opened format file and others wrongs
>caracters inside of format file are not the problem. I am thankful for your
s
>suggestions,but the problem continue. Now I substituted the third column of
>my output file and the bcp utility started the copy, but the generated file
>has mixed data with stranger caracters. This new column has valids datas an
d
>also null values in some registers and it is the great difference between t
he
>others columns (first e second ones). Without this third column everything
>work 100% OK. I already try to change the value of prefix length (field of
>the format file) to -1 or 2 with the hope to solve it, but the output
>generated file continue with stranger and mixed caracters (like ASCII
>caracters). I really don't have any idea of what I can do to put it to work
.
>I am not sure, but perhaps I will need to make other configuration in my
>format file, but exactly what ? Do you have other help for me ?
>
> Thanks again
>Adalberto Andrade
>"Steve Kass" wrote:
>
>|||Steve,
Forgive me for delay in my reply. I was very busy. Let 's go. Really
you are correct. When I ran the bcp utility in the prompt without my format
file, it show the message explaining that happened a truncate. In true there
was a difference between the data length of one column and your value define
d
for this size in the format file. Summarizing, the problem is over and your
suggesntions 1 and 3 were very helpful.
Thanks a lot
Adalberto
Andrade
Rio de Janeiro's
City Hall
"Steve Kass" wrote:

> Adalberto,
> I am not sure what the problem is, but here are three separate
> suggestions.
> 1. Try to use bcp without a format file, since TAB and NEWLINE
> are the defaults for bcp. If this creates a Unicode file, you will need
> to change the format file to say SQLNCHAR instead of SQLCHAR,
> and you will also need to put the Unicode two-byte signature into
> the beginning of the file yourself, since bcp does not do this for you.
> 2. Be sure the format file is saved as ASCII, not Unicode, then try
> again with the format file.
> 3. Verify the data lengths and types of the output,
> 3A. Run this and provide the output.
> select top 1
> numeroaj, acervoespecializada
> into CheckTypesTable
> from Siga.dbo.vwHerancaJacente
> select * from CheckTypesTable
> 3B. In Query Analyzer, refresh the current database
> and for [CheckTypesTable] choose "Script Table To
> New Window" to verify the data types of these columns
> and provide the output.
> 3C. After doing this, you can DROP the table CheckTypesTable.
>
> It might help if you post the definition of Siga.dbo.vwHerancaJa.
> (If it is a view, also post CREATE TABLE statements from the
> tables it uses for the columns numeroaj and acervoespecializada
> (and the third column, since at one point you mention three columns.
> Also, when you have three columns, what is your query?)
> SK
> Adalberto Andrade wrote:
>
>

Problem with added data from external gathering software to SQL DB

Hello
Im used SQL server 2000 with Services pack 3
i have problem if external program "gathercoda" want adding records to sql
db.
error message:
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data, Start
to read the metrics
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_CODA"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
"RDS_LINUX_FILESYSTEMS"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
"RDS_LINUX_DISKSIZES"
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data, 117
matched metrics available
2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL records are up to date with 86400 second summarization
2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
UPTIME records are up to date with 3600 second summarization
2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
APPLICATION records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
TRANSACTIONS records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
GLOBAL records are up to date with 3600 second summarization
2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
Matched collections: CODA:GLOBAL and CODA:GLOBAL
2005/06/30 13:53:23 (6):(2648) server_where_gathercoda_gathering_data,
Validating metrics for GLOBAL::CODA
2005/06/30 13:53:23 (3):(2648) SQLTables reports SQL_SUCCESS, Table
RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9):(2648) Building Indexes on RDS_GLOBAL_CODA
2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
00:00:00)
2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data, Read
14 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; SELECT
permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (5):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (2):(2648) Cannot use bulk append; SELECT permission
denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (2):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; Operation
invalid at this time
2005/06/30 13:53:23 (5):(2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (1):(2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation invalid
at this time
2005/06/30 13:53:23 (1):(2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (3):(2648) SQLTables reports SQL_SUCCESS, Table
RDS_GLOBAL_CODA exists
2005/06/30 13:53:23 (9):(2648) Building Indexes on RDS_GLOBAL_CODA
2005/06/30 13:53:23 (9):(2648) Exception attempting to close ignored;
SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; SELECT
permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (5):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (2):(2648) Cannot use bulk append; SELECT permission
denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
The cursor was not declared.
2005/06/30 13:53:23 (2):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
Server]
2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
SELECT permission denied on column 'GBL_MEM_UTIL' of object
'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
2005/06/30 13:53:23 (9):(2648) Error -1;
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; Operation
invalid at this time
2005/06/30 13:53:23 (5):(2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (E):(2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
2005/06/30 13:53:23 (1):(2648) Error -1;
State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
03:00:00)
2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data, Read
11 intervals of 1 instances from GLOBAL
2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (E):(2648) server_where_gathercoda_gathering_data
TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
GLOBAL Sent 0 records to DB
2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
RDS_GLOBAL_CODA records are up to date with 86400 second summarization
2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
2005/06/30 13:53:23 (4):(2648) server_where_gathercoda_gathering_data,
Collected 0 records for RDS_GLOBAL_CODA
2005/06/30 13:53:23 (1):(2648) server_where_gathercoda_gathering_data,
Collected 0 records in 0: 0: 2
2005/06/30 13:53:23 (E):(2648) GatherCODA Exception: Memory access violation
2005/06/30 13:53:23 (6):(2648) End of Program
can u help me please> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
This looks like a permissions problem. Check to ensure that the account
being used to run this process has the needed permissions on the objects and
columns used. See GRANT in the SQL Server Books Online.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"DoDo" <DoDo@.discussions.microsoft.com> wrote in message
news:8A74281F-A0F8-4437-A06F-E23BC8F2D1E1@.microsoft.com...
> Hello
> Im used SQL server 2000 with Services pack 3
> i have problem if external program "gathercoda" want adding records to sql
> db.
> error message:
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Start
> to read the metrics
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec ->
> "RDS_GLOBAL_HOUR_CODA"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data, 117
> matched metrics available
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6):(2648) server_where_gathercoda_gathering_data,
> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3):(2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9):(2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
> 00:00:00)
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
> Read
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2):(2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA',
> database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1):(2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation
> invalid
> at this time
> 2005/06/30 13:53:23 (1):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3):(2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9):(2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close ignored;
> SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2):(2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA',
> database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close
> RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of
> object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E):(2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
> 03:00:00)
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
> Read
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (E):(2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (4):(2648) server_where_gathercoda_gathering_data,
> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1):(2648) server_where_gathercoda_gathering_data,
> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E):(2648) GatherCODA Exception: Memory access
> violation
> 2005/06/30 13:53:23 (6):(2648) End of Program
>
> can u help me please
>|||It seems that someone has messed up the permissions for the user that this application runs as. You
should contact the vendor of the application to see what permissions is required so you can set them
properly.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DoDo" <DoDo@.discussions.microsoft.com> wrote in message
news:8A74281F-A0F8-4437-A06F-E23BC8F2D1E1@.microsoft.com...
> Hello
> Im used SQL server 2000 with Services pack 3
> i have problem if external program "gathercoda" want adding records to sql
> db.
> error message:
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data, Start
> to read the metrics
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 86400 sec -> "RDS-GLOBAL"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "RDS-GLOBAL-HOUR"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "APPLICATION" @. 3600 sec -> "APPLICATION"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SCOPE" "TRANSACTION" @. 3600 sec -> "TRANSACTIONS"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "GLOBAL"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 86400 sec -> "RDS_GLOBAL_CODA"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "RDS_GLOBAL_HOUR_CODA"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "CODA" "GLOBAL" @. 3600 sec -> "UPTIME"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "PSDOWNT" "PSDOWNT" @. 0 sec -> "RDS_PSDOWNT"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "SYSDOWNT" "SYSDOWNT" @. 0 sec -> "RDS-SYSDOWNT"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LVOLUMES" @. 0 sec ->
> "RDS_LINUX_FILESYSTEMS"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> Building Collection for "LVOLUMES" "LINUXDISKSIZE" @. 0 sec ->
> "RDS_LINUX_DISKSIZES"
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data, 117
> matched metrics available
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL records are up to date with 86400 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_HOUR records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:GLOBAL and SCOPE:GLOBAL
> 2005/06/30 13:53:22 (5):(2648) server_where_gathercoda_gathering_data,
> UPTIME records are up to date with 3600 second summarization
> 2005/06/30 13:53:22 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:APPLICATION and SCOPE:APPLICATION
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> APPLICATION records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: SCOPE:TRANSACTION and SCOPE:TRANSACTION
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> TRANSACTIONS records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> GLOBAL records are up to date with 3600 second summarization
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Matched collections: CODA:GLOBAL and CODA:GLOBAL
> 2005/06/30 13:53:23 (6):(2648) server_where_gathercoda_gathering_data,
> Validating metrics for GLOBAL::CODA
> 2005/06/30 13:53:23 (3):(2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9):(2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/06/05 01:00:00 to 06/20/05
> 00:00:00)
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data, Read
> 14 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2):(2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (1):(2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed - trying again; Operation invalid
> at this time
> 2005/06/30 13:53:23 (1):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (3):(2648) SQLTables reports SQL_SUCCESS, Table
> RDS_GLOBAL_CODA exists
> 2005/06/30 13:53:23 (9):(2648) Building Indexes on RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close ignored;
> SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; SELECT
> permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (2):(2648) Cannot use bulk append; SELECT permission
> denied on column 'GBL_SWAP_SPACE_UTIL' of object 'RDS_GLOBAL_CODA', database
> 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> The cursor was not declared.
> 2005/06/30 13:53:23 (2):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:37000,Native:16945,Origin:[Microsoft][ODBC SQL Server Driver][SQL
> Server]
> 2005/06/30 13:53:23 (9):(2648) Exception attempting to close RDS_GLOBAL_CODA
> ignored; SELECT permission denied on column 'GBL_SWAP_SPACE_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> SELECT permission denied on column 'GBL_MEM_UTIL' of object
> 'RDS_GLOBAL_CODA', database 'Reporter', owner 'dbo'.
> 2005/06/30 13:53:23 (9):(2648) Error -1;
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> State:42000,Native:230,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
> 2005/06/30 13:53:23 (5):(2648) Error opening RDS_GLOBAL_CODA; Operation
> invalid at this time
> 2005/06/30 13:53:23 (5):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (E):(2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Operation invalid at this time
> 2005/06/30 13:53:23 (1):(2648) Error -1;
> State:S1011,Native:0,Origin:[Microsoft][ODBC Driver Manager]
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (9):(2648) server_where_gathercoda_gathering_data,
> Prepare to read 1 instances from GLOBAL (06/20/05 00:00:00 to 06/29/05
> 03:00:00)
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data, Read
> 11 intervals of 1 instances from GLOBAL
> 2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (E):(2648) server_where_gathercoda_gathering_data
> TransferRecord() of RDS_GLOBAL_CODA failed; Memory access violation
> 2005/06/30 13:53:23 (2):(2648) server_where_gathercoda_gathering_data,
> GLOBAL Sent 0 records to DB
> 2005/06/30 13:53:23 (5):(2648) server_where_gathercoda_gathering_data,
> RDS_GLOBAL_CODA records are up to date with 86400 second summarization
> 2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) Exception 0xc0000005
> 2005/06/30 13:53:23 (1):(2648) -> Exception 0xc0000005
> 2005/06/30 13:53:23 (4):(2648) server_where_gathercoda_gathering_data,
> Collected 0 records for RDS_GLOBAL_CODA
> 2005/06/30 13:53:23 (1):(2648) server_where_gathercoda_gathering_data,
> Collected 0 records in 0: 0: 2
> 2005/06/30 13:53:23 (E):(2648) GatherCODA Exception: Memory access violation
> 2005/06/30 13:53:23 (6):(2648) End of Program
>
> can u help me please
>sql

Problem with a publication. Please help !

Dear friend:
I got this error message inmediatly after to create a suscription for a
publication.
Violation of PRIMARY KEY constraint 'PK__@.snapshot_seqnos__6B318B07'. Cannot
insert duplicate key in object '#6A3D66CE'.
Last Command = call sp_MSget_repl_commands(19, ?, 0, 7500000)
What should I do ? I drop the publication, but when I configure it again, I
got the same result.
Thanks in advance.
Hi Salvador,
This is a known issue which has been fixed in SQL2000 sp4, and here is the
download link from the microsoft web site:
http://www.microsoft.com/sql/downloads/2000/sp4.mspx
HTH
-Raymond
"Salvador De los Reyes" wrote:

> Dear friend:
> I got this error message inmediatly after to create a suscription for a
> publication.
> Violation of PRIMARY KEY constraint 'PK__@.snapshot_seqnos__6B318B07'. Cannot
> insert duplicate key in object '#6A3D66CE'.
> Last Command = call sp_MSget_repl_commands(19, ?, 0, 7500000)
> What should I do ? I drop the publication, but when I configure it again, I
> got the same result.
> Thanks in advance.
>
>
|||Perfect ! Thks
"Raymond Mak [MSFT]" <RaymondMakMSFT@.discussions.microsoft.com> escribi en
el mensaje news:B17ACDF1-BBD0-45BD-ADDA-5D2C79A8C432@.microsoft.com...[vbcol=seagreen]
> Hi Salvador,
> This is a known issue which has been fixed in SQL2000 sp4, and here is the
> download link from the microsoft web site:
> http://www.microsoft.com/sql/downloads/2000/sp4.mspx
> HTH
> -Raymond
> "Salvador De los Reyes" wrote:
|||Hi,
I have seen your email in www.codecomments.com, you said "This
problem is a bug", with sp4 sql server it is solucionated.
Last command{call sp_MSget_repl_commands(46, ?, 0, 7500000)}
Error Message Violation of PRIMARY KEY constraint
'PK__@.snapshot_seqnos__053E7DEC'. Cannot insert duplicate key in object
'#1685152A'.
Error details Violation of PRIMARY KEY constraint
'PK__@.snapshot_seqnos__053E7DEC'. Cannot insert duplicate key in object
'#1685152A'.
(Source: SQLA01 (Data source); Error number: 2627)
but, How the replication worked before sp4?
In my case, only appears the error when I select related tables, why?
Thanks,
Jose Luis
*** Sent via Developersdex http://www.codecomments.com ***

problem with a clustered index?

This is a multi-part message in MIME format.
--=_NextPart_000_0052_01C4758A.B87F1790
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
Hello,
I have a table with about 5 milion records, and the performance is = un-acceptable (more than 45 seconds for a query). The table was imported = from a text file. I have defined a primary key (two varchar(20) = columns). Then I checked and the database has created a clustered index = on these columns. But I suspect that something is wrong with the index: = When I run a select query, the rows are returned in an arbitrary order, = and not in the order defined by the index. Is it possible that something = is wrong with the index? If yes, how can I fix that?
thanks, David
--=_NextPart_000_0052_01C4758A.B87F1790
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello,
I have a table with about 5 milion = records, and the performance is un-acceptable (more than 45 seconds for a query). The = table was imported from a text file. I have defined a primary key (two varchar(20) = columns). Then I checked and the database has created a clustered index = on these columns. But I suspect that something is wrong with the index: When I = run a select query, the rows are returned in an arbitrary order, and not = in the order defined by the index. Is it possible that something is wrong with = the index? If yes, how can I fix that?
thanks, = David
--=_NextPart_000_0052_01C4758A.B87F1790--This is a multi-part message in MIME format.
--=_NextPart_000_000B_01C4758B.8E928F10
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
David
Did you spesify ORDER BY clause when you run SELECT statement.
What is your search criteria in the query?
"David" <dboaz@.bgumail.bgu.ac.il> wrote in message =news:um00pGXdEHA.3148@.TK2MSFTNGP10.phx.gbl...
Hello,
I have a table with about 5 milion records, and the performance is =un-acceptable (more than 45 seconds for a query). The table was imported =from a text file. I have defined a primary key (two varchar(20) =columns). Then I checked and the database has created a clustered index =on these columns. But I suspect that something is wrong with the index: =When I run a select query, the rows are returned in an arbitrary order, =and not in the order defined by the index. Is it possible that something =is wrong with the index? If yes, how can I fix that?
thanks, David
--=_NextPart_000_000B_01C4758B.8E928F10
Content-Type: text/html;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

David
Did you spesify ORDER BY clause when =you run SELECT statement.
What is your search criteria in the query?
"David" =wrote in message news:um00pGXdEHA.3148=@.TK2MSFTNGP10.phx.gbl...
Hello,
I have a table with about 5 milion =records, and the performance is un-acceptable (more than 45 seconds for a query). =The table was imported from a text file. I have defined a primary key (two =varchar(20) columns). Then I checked and the database has created a clustered =index on these columns. But I suspect that something is wrong with the index: =When I run a select query, the rows are returned in an arbitrary order, =and not in the order defined by the index. Is it possible that something is =wrong with the index? If yes, how can I fix that?
thanks, David

---

--=_NextPart_000_000B_01C4758B.8E928F10--|||A clustered index does not determine the sort order of a query result, so
there is no reason to suspect any integrity problem. Use an ORDER BY clause
in your SELECT statement to fix the order of the returned rows.
Did you check the query plan to see what indexes are being used? Could you
post the query and a CREATE TABLE statement for the table to give us an idea
of what optimizations might be possible.
--
David Portas
SQL Server MVP
--|||> When I run a select query, the rows are returned in an arbitrary order
A table is an unordered set of rows. What were you expecting? If you want
a defined order, use an ORDER BY clause.
I don't know where everyone gets the idea that the existence of a clustered
index means that is the order all SELECT queries will return the data. This
is NOT TRUE! It does happen more often that way, but it is not a law. The
plan will return the rows in the best way it sees fit, you could run the
query 10 times and it *could* return the rows 10 different ways. Usually
doesn't, but could.
I'll repeat: if you want a specific order, use an ORDER BY clause.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Try a DBCC DBREINDEX or DBCC INDEXDEFRAG depending upon
your preference, then update the statistics.
It sometimes happends when you do a bulk insert that the
statistics need re-doing (in my opinion).
Peter
>--Original Message--
>Hello,
>I have a table with about 5 milion records, and the
performance is un-acceptable (more than 45 seconds for a
query). The table was imported from a text file. I have
defined a primary key (two varchar(20) columns). Then I
checked and the database has created a clustered index on
these columns. But I suspect that something is wrong with
the index: When I run a select query, the rows are
returned in an arbitrary order, and not in the order
defined by the index. Is it possible that something is
wrong with the index? If yes, how can I fix that?
>thanks, David

Problem with "Compile Error"

I got some problem about message "Compile Error, In Query expression "
Someone help me please
Best Regard
My E-mail = paiboonm@.cuel.co.thoooooooommmmmmmmmmmmmmm

oooooooommmmmmmmmmmmmmm

oooooooommmmmmmmmmmmmmm

Nope not getting anything on the telepathic channel...

maybe if you post your code and the actual error message

Problem while using xp_sendmail

Hi,
When I use xp_sendmail on my local machine, using parameters like
Exec master.dbo.xp_sendmail @.recipients = 'my email id' , @.message = '
some message', @.subject = ' some subject ', then it works fine and I get
the mail in my mailbox ...
But when I use the same stuff on any other SQL server (on same network), I
get the error --
xp_sendmail: Procedure expects parameter @.user, which was not supplied.
I've searched in BOL, there is no parameter called @.user for xp_sendmail.
What and where is the problem ?
regards
KP
XP_Sendmail has a parameter for set_user, perhaps thewrong message is being
sent ( but not likely)
Check to make sure no one has placed an xp_sendmail in your local
database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:1616F7CF-3D68-4FAB-A5BD-5B1979494336@.microsoft.com...
> Hi,
> When I use xp_sendmail on my local machine, using parameters like
> Exec master.dbo.xp_sendmail @.recipients = 'my email id' , @.message = '
> some message', @.subject = ' some subject ', then it works fine and I
> get
> the mail in my mailbox ...
> But when I use the same stuff on any other SQL server (on same network), I
> get the error --
> xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> I've searched in BOL, there is no parameter called @.user for xp_sendmail.
> What and where is the problem ?
> regards
> KP
|||So there is a possibility of having 'different' version of xp_sendmail on
other machine (where it does not work). How can I replace a DLL file? Will
simple overwriting help? Pls advice.
"Wayne Snyder" wrote:

> XP_Sendmail has a parameter for set_user, perhaps thewrong message is being
> sent ( but not likely)
> Check to make sure no one has placed an xp_sendmail in your local
> database...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
> wrote in message news:1616F7CF-3D68-4FAB-A5BD-5B1979494336@.microsoft.com...
>
>

Problem while using xp_sendmail

Hi,
When I use xp_sendmail on my local machine, using parameters like
Exec master.dbo.xp_sendmail @.recipients = 'my email id' , @.message = '
some message', @.subject = ' some subject ', then it works fine and I get
the mail in my mailbox ...
But when I use the same stuff on any other SQL server (on same network), I
get the error --
xp_sendmail: Procedure expects parameter @.user, which was not supplied.
I've searched in BOL, there is no parameter called @.user for xp_sendmail.
What and where is the problem ?
regards
KPXP_Sendmail has a parameter for set_user, perhaps thewrong message is being
sent ( but not likely)
Check to make sure no one has placed an xp_sendmail in your local
database...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:1616F7CF-3D68-4FAB-A5BD-5B1979494336@.microsoft.com...
> Hi,
> When I use xp_sendmail on my local machine, using parameters like
> Exec master.dbo.xp_sendmail @.recipients = 'my email id' , @.message = '
> some message', @.subject = ' some subject ', then it works fine and I
> get
> the mail in my mailbox ...
> But when I use the same stuff on any other SQL server (on same network), I
> get the error --
> xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> I've searched in BOL, there is no parameter called @.user for xp_sendmail.
> What and where is the problem ?
> regards
> KP|||So there is a possibility of having 'different' version of xp_sendmail on
other machine (where it does not work). How can I replace a DLL file? Will
simple overwriting help? Pls advice.
"Wayne Snyder" wrote:

> XP_Sendmail has a parameter for set_user, perhaps thewrong message is bein
g
> sent ( but not likely)
> Check to make sure no one has placed an xp_sendmail in your local
> database...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.co
m>
> wrote in message news:1616F7CF-3D68-4FAB-A5BD-5B1979494336@.microsoft.com..
.
>
>

Problem while using xp_sendmail

Hi,
When I use xp_sendmail on my local machine, using parameters like
Exec master.dbo.xp_sendmail @.recipients = 'my email id' , @.message = '
some message', @.subject = ' some subject ', then it works fine and I get
the mail in my mailbox ...
But when I use the same stuff on any other SQL server (on same network), I
get the error --
xp_sendmail: Procedure expects parameter @.user, which was not supplied.
I've searched in BOL, there is no parameter called @.user for xp_sendmail.
What and where is the problem ?
regards
KPXP_Sendmail has a parameter for set_user, perhaps thewrong message is being
sent ( but not likely)
Check to make sure no one has placed an xp_sendmail in your local
database...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:1616F7CF-3D68-4FAB-A5BD-5B1979494336@.microsoft.com...
> Hi,
> When I use xp_sendmail on my local machine, using parameters like
> Exec master.dbo.xp_sendmail @.recipients = 'my email id' , @.message = '
> some message', @.subject = ' some subject ', then it works fine and I
> get
> the mail in my mailbox ...
> But when I use the same stuff on any other SQL server (on same network), I
> get the error --
> xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> I've searched in BOL, there is no parameter called @.user for xp_sendmail.
> What and where is the problem ?
> regards
> KP|||So there is a possibility of having 'different' version of xp_sendmail on
other machine (where it does not work). How can I replace a DLL file? Will
simple overwriting help? Pls advice.
"Wayne Snyder" wrote:
> XP_Sendmail has a parameter for set_user, perhaps thewrong message is being
> sent ( but not likely)
> Check to make sure no one has placed an xp_sendmail in your local
> database...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
> wrote in message news:1616F7CF-3D68-4FAB-A5BD-5B1979494336@.microsoft.com...
> > Hi,
> >
> > When I use xp_sendmail on my local machine, using parameters like
> > Exec master.dbo.xp_sendmail @.recipients = 'my email id' , @.message = '
> > some message', @.subject = ' some subject ', then it works fine and I
> > get
> > the mail in my mailbox ...
> >
> > But when I use the same stuff on any other SQL server (on same network), I
> > get the error --
> > xp_sendmail: Procedure expects parameter @.user, which was not supplied.
> >
> > I've searched in BOL, there is no parameter called @.user for xp_sendmail.
> >
> > What and where is the problem ?
> >
> > regards
> > KP
>
>

Problem viewing the site after uploading

HI,

I have upladed my application to my remote server but then I get an error message. I am a beginner so any help would be appreciated and if possible explain the solution to me in a simpler format. Here is the error message:

Server Error in '/' Application.

---

Anerror has occurred while establishing a connection to the server. Whenconnecting to SQL Server 2005, this failure may be caused by the factthat under the default settings SQL Server does not allow remoteconnections. (provider: SQL Network Interfaces, error: 26 - ErrorLocating Server/Instance Specified)

Description:Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by thefact that under the default settings SQL Server does not allow remoteconnections. (provider: SQL Network Interfaces, error: 26 - ErrorLocating Server/Instance Specified)

Source Error:

The source code that generated this unhandled exception can only beshown when compiled in debug mode. To enable this, please follow one ofthe below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@. Page Language="C#" Debug="true" %
or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration
Note that this second technique will cause all files within a givenapplication to be compiled in debug mode. The first technique willcause only that particular file to be compiled in debug mode.

Important:Running applications in debug mode does incur a memory/performanceoverhead. You should make sure that an application has debuggingdisabled before deploying into production scenario.

Thanks in advance.

In sql 2005 you have to enable remoteconnection to access the DB from other machine. To enable Remote connection in SQL 20005 follow these steps

Under SQL2005 program menu follow configuration Tools =>SQL Server Surface Area Configuration => Select Server Surface Area Configuration for Services and Connections.

It will lead to a window with a treeview select Remote connections.Then Select Local and Remote Connections.

Thats it, now you can connect your SQL Server without any problem

Hope this will help you

problem using SQL Server 2005 database from C# application through

Hi all.
I dont know if it is right group but maybe you guys be able to show me
a right direction. And im sorry, if i crossposted this message to
several groups.
Ok ,the problem is following:
We have a large ATL COM dll, which is used as common interface for our
database and it is used by many different applications (like Notes, VB6
apps etc). We wrote it a few years ago using VC6++(if it matters) and
everything worked just fine. This spring we updated our developement
tools to VS2005 and i updated VC6 project to VS2005. After few days of
work i got it compiled. NOW the real problem.
Our new C# applications use same COM dll through interop dll and once
again, everything works just fine EXCEPT, C# applications cannot use
SQLServer 2005 database through interop dll!!! This is the only
combination which does not work (C# -> interop dll -> ATL-COM dll -> SQL
Server 2005).
All other tests passed normally, like:
C# app -> interop dll -> ATL-COM dll -> ms access db.
normal C++ app -> ATL-COM dll -> SQL Server 2005 db.
normal C++ app -> ATL-COM dll -> ms access db.
but this one does NOT!!!!
C# -> interop dll -> ATL-COM dll -> SQL Server 2005
Although database object is correctly created in C# app and even
connection to SQL Server 2005 established successfully, every call to
get data from database failes to exception (seems like the exception
type differs randomly, like ArgumentException etc.). Sometimes DLL COM
returns database error like "specified object does not exist").
Can you guys tell me whats going on!!!
Im running out of ideas cause EXACTLY same dll works with other
databases and other programs that C# can use SAME dll with SQL2005 and
no problems...
thanks
Asko.
Roger Wolter[MSFT] wrote:
> Definitely a long shot but C# strings are always Unicode and your VC6 dll
> might not be expecting unicode.
>
Thank you for your response.
Our ATL DLL is definitely unicode cause we have alot of international
data in db and thus it cannot be the cause to my problem.
Asko.

Problem using EXEC() to run DBCC DBREINDEX

I am trying to run DBCC DBREINDEX using EXEC(), code is below.
Based upon the error message at the bottom, the @.currenttable variable
receives the value 1 but when @.currenttable is referenece in the DBCC
statement, the value isn't there. Can anyone tell me what I'm doing wrong?
declare @.sqltest varchar(40), @.currenttable int
set @.currenttable = (select table_id from Table_Space where table_id = 1)
set @.sqltest = 'DBCC DBREINDEX(''@.currenttable'','''',75)'
print @.currenttable
print @.sqltest
EXEC(@.sqltest)
Below is the message I get:
1
DBCC DBREINDEX('@.currenttable','',75)
Server: Msg 2501, Level 16, State 1, Line 1
Could not find a table or object named '@.currenttable'. Check sysobjects.nosurfdj,
DBCC DBREINDEX expects a table name and there is not table named
'@.currenttable'.
declare @.sqltest varchar(40), @.currenttable int
declare @.tn sysname
set @.tn = (select table_name from Table_Space where table_id = 1)
set @.sqltest = 'DBCC DBREINDEX(''' + @.tn + ''','''',75)'
print @.currenttable
print @.sqltest
EXEC(@.sqltest)
go
AMB
"nosurfdj" wrote:

> I am trying to run DBCC DBREINDEX using EXEC(), code is below.
> Based upon the error message at the bottom, the @.currenttable variable
> receives the value 1 but when @.currenttable is referenece in the DBCC
> statement, the value isn't there. Can anyone tell me what I'm doing wrong
?
> declare @.sqltest varchar(40), @.currenttable int
> set @.currenttable = (select table_id from Table_Space where table_id = 1)
> set @.sqltest = 'DBCC DBREINDEX(''@.currenttable'','''',75)'
> print @.currenttable
> print @.sqltest
> EXEC(@.sqltest)
> Below is the message I get:
> 1
> DBCC DBREINDEX('@.currenttable','',75)
> Server: Msg 2501, Level 16, State 1, Line 1
> Could not find a table or object named '@.currenttable'. Check sysobjects.
>|||Quote problems around ''@.currenttable''.
Try:
'DBCC DBREINDEX(' + @.currenttable + ','''',75)'
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"nosurfdj" <nosurfdj@.discussions.microsoft.com> wrote in message news:2406FBD3-FD2A-4F69-8A
8E-F446DC1473BF@.microsoft.com...
>I am trying to run DBCC DBREINDEX using EXEC(), code is below.
> Based upon the error message at the bottom, the @.currenttable variable
> receives the value 1 but when @.currenttable is referenece in the DBCC
> statement, the value isn't there. Can anyone tell me what I'm doing wrong
?
>
> declare @.sqltest varchar(40), @.currenttable int
> set @.currenttable = (select table_id from Table_Space where table_id = 1)
> set @.sqltest = 'DBCC DBREINDEX(''@.currenttable'','''',75)'
> print @.currenttable
> print @.sqltest
> EXEC(@.sqltest)
>
> Below is the message I get:
> 1
> DBCC DBREINDEX('@.currenttable','',75)
> Server: Msg 2501, Level 16, State 1, Line 1
> Could not find a table or object named '@.currenttable'. Check sysobjects.
>|||I knew it was going to be something simple.
Thanks for your help-that did it.
"Alejandro Mesa" wrote:
> nosurfdj,
> DBCC DBREINDEX expects a table name and there is not table named
> '@.currenttable'.
> declare @.sqltest varchar(40), @.currenttable int
> declare @.tn sysname
> set @.tn = (select table_name from Table_Space where table_id = 1)
> set @.sqltest = 'DBCC DBREINDEX(''' + @.tn + ''','''',75)'
> print @.currenttable
> print @.sqltest
> EXEC(@.sqltest)
> go
>
> AMB
> "nosurfdj" wrote:
>