Count on text fields

Hello, I works with the reporting services and is thereby reports to
providing. Now the question arises whether one can count into the
reporting services (in the report designer) also on text fields.
Super would be nice if me one help could.You need to clarify the question a little more.
Do you mean a SUM line, or just a text box that has a summation in it? etc
"TR" wrote:
> Hello, I works with the reporting services and is thereby reports to
> providing. Now the question arises whether one can count into the
> reporting services (in the report designer) also on text fields.
> Super would be nice if me one help could.
>

could not obtain information about...

This is a multi-part message in MIME format.
--=_NextPart_000_000A_01C3DE9A.B4361940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am getting the following message in my event logs since hitting = windows update and installing, among others SP4 for win2k.
"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan = 'Michaels Backup Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) - Status: = Failed - Invoked on: 2004-01-19 02:00:00 - Message: The job failed. = Unable to determine if the owner (MYSERVER\mylogin) of job DB Backup Job = for DB Maintenance Plan 'Michaels Backup Plan' has server access = (reason: Could not obtain information about Windows NT group/user = 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 8198))."
the only thing that changed was the updates, which can be significant = but I certainly didn't change anything related to my account. I have = recreated the plan with the same result.
I can open the LOGON section of SQLadmin and see my name there, I can = open it and close it but if I try to make any changes it says messages = similar to the above on.
KB articles suggested ading the everyone group to the pre2000 users = group but that sounds dangerous.
Help? what else can I look at. I am the sysop and should have all the = necessary rights
--=_NextPart_000_000A_01C3DE9A.B4361940
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I am getting the following message in my = event logs since hitting windows update and installing, among others SP4 = for win2k.
"SQL Server Scheduled Job 'DB Backup Job = for DB Maintenance Plan 'Michaels Backup Plan'' = (0x8E4169EC6E0A93468357CC016A8A9186) - Status: Failed - Invoked on: 2004-01-19 02:00:00 - Message: The job failed. Unable to determine if the owner (MYSERVER\mylogin) of job = DB Backup Job for DB Maintenance Plan 'Michaels Backup Plan' has server = access (reason: Could not obtain information about Windows NT group/user 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 8198))."
the only thing that changed was the = updates, which can be significant but I certainly didn't change anything related = to my account. I have recreated the plan with the same result.
I can open the LOGON section of SQLadmin = and see my name there, I can open it and close it but if I try to make any changes = it says messages similar to the above on.
KB articles suggested ading the everyone = group to the pre2000 users group but that sounds dangerous.
Help? what else can I look at. I am the = sysop and should have all the necessary rights
--=_NextPart_000_000A_01C3DE9A.B4361940--In message <eoafD3t3DHA.2556@.TK2MSFTNGP10.phx.gbl>, mmac <no@.thanks.com>
writes
>I am getting the following message in my event logs since hitting windows
>update and installing, among others SP4 for win2k.
>"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
>'Michaels Backup Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) -
>Status: Failed - Invoked on: 2004-01-19 02:00:00 - Message: The job
>failed. Unable to determine if the owner (MYSERVER\mylogin) of job DB
>Backup Job for DB Maintenance Plan 'Michaels Backup Plan' has server
>access (reason: Could not obtain information about Windows NT
>group/user 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 8198))."
>the only thing that changed was the updates, which can be significant but
> I certainly didn't change anything related to my account. I have recreated
>the plan with the same result.
>I can open the LOGON section of SQLadmin and see my name there, I
>can open it and close it but if I try to make any changes it says messages
>similar to the above on.
>KB articles suggested ading the everyone group to the pre2000 users
>group but that sounds dangerous.
>Help? what else can I look at. I am the sysop and should have all the
>necessary rights
I assume you have seen KB 241643, but have you tried the first
workaround "Change the job owner to a standard SQL Server user or system
administrator (sa)."? I have read this many times, and the second option
has never worked for me, so I go straight for option 1. I suspect there
may be other causes, perhaps network issues between SQL and the DC.
PRB: 8198 Error Message Returned from Job Owned by Windows NT
Authenticated User
http://support.microsoft.com?kbid=241643
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org|||"Darren Green" <darren.green@.reply-to-newsgroup-sqldts.com> wrote in message
news:7r2qD3R8WFEAFwOw@.sqldts.com...
> In message <eoafD3t3DHA.2556@.TK2MSFTNGP10.phx.gbl>, mmac <no@.thanks.com>
> writes
> >
> >I am getting the following message in my event logs since hitting windows
> >update and installing, among others SP4 for win2k.
> >
> >"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> >'Michaels Backup Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) -
> >Status: Failed - Invoked on: 2004-01-19 02:00:00 - Message: The job
> >failed. Unable to determine if the owner (MYSERVER\mylogin) of job DB
> >Backup Job for DB Maintenance Plan 'Michaels Backup Plan' has server
> >access (reason: Could not obtain information about Windows NT
> >group/user 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 8198))."
> >
> >the only thing that changed was the updates, which can be significant but
> > I certainly didn't change anything related to my account. I have
recreated
> >the plan with the same result.
> >
> >I can open the LOGON section of SQLadmin and see my name there, I
> >can open it and close it but if I try to make any changes it says
messages
> >similar to the above on.
> >
> >KB articles suggested ading the everyone group to the pre2000 users
> >group but that sounds dangerous.
> >
> >Help? what else can I look at. I am the sysop and should have all the
> >necessary rights
> I assume you have seen KB 241643, but have you tried the first
> workaround "Change the job owner to a standard SQL Server user or system
> administrator (sa)."? I have read this many times, and the second option
> has never worked for me, so I go straight for option 1. I suspect there
> may be other causes, perhaps network issues between SQL and the DC.
> PRB: 8198 Error Message Returned from Job Owned by Windows NT
> Authenticated User
> http://support.microsoft.com?kbid=241643
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>|||Lets try that again.
I saw the KB article and I couldn't make option 2 work either so that is
encouraging :-?
The DC and the SQL server are the same machine so comms shouldn't be an
issue.
I'll try creating a new backup plan under sa but could you tell me what a
"Standard Sql Server User " is?
"Darren Green" <darren.green@.reply-to-newsgroup-sqldts.com> wrote in message
news:7r2qD3R8WFEAFwOw@.sqldts.com...
> In message <eoafD3t3DHA.2556@.TK2MSFTNGP10.phx.gbl>, mmac <no@.thanks.com>
> writes
> >
> >I am getting the following message in my event logs since hitting windows
> >update and installing, among others SP4 for win2k.
> >
> >"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
> >'Michaels Backup Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) -
> >Status: Failed - Invoked on: 2004-01-19 02:00:00 - Message: The job
> >failed. Unable to determine if the owner (MYSERVER\mylogin) of job DB
> >Backup Job for DB Maintenance Plan 'Michaels Backup Plan' has server
> >access (reason: Could not obtain information about Windows NT
> >group/user 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 8198))."
> >
> >the only thing that changed was the updates, which can be significant but
> > I certainly didn't change anything related to my account. I have
recreated
> >the plan with the same result.
> >
> >I can open the LOGON section of SQLadmin and see my name there, I
> >can open it and close it but if I try to make any changes it says
messages
> >similar to the above on.
> >
> >KB articles suggested ading the everyone group to the pre2000 users
> >group but that sounds dangerous.
> >
> >Help? what else can I look at. I am the sysop and should have all the
> >necessary rights
> I assume you have seen KB 241643, but have you tried the first
> workaround "Change the job owner to a standard SQL Server user or system
> administrator (sa)."? I have read this many times, and the second option
> has never worked for me, so I go straight for option 1. I suspect there
> may be other causes, perhaps network issues between SQL and the DC.
> PRB: 8198 Error Message Returned from Job Owned by Windows NT
> Authenticated User
> http://support.microsoft.com?kbid=241643
>
> --
> Darren Green (SQL Server MVP)
> DTS - http://www.sqldts.com
> PASS - the definitive, global community for SQL Server professionals
> http://www.sqlpass.org
>|||In message <u1fxN$d4DHA.2612@.tk2msftngp13.phx.gbl>, mmac <no@.thanks.com>
writes
>Lets try that again.
>I saw the KB article and I couldn't make option 2 work either so that is
>encouraging :-?
>The DC and the SQL server are the same machine so comms shouldn't be an
>issue.
>I'll try creating a new backup plan under sa but could you tell me what a
>"Standard Sql Server User " is?
>
A standard SQL Server user, or SQL (Server) login, is what you use as
opposed to and integrated or NT authentication login. This option is
only available if the server is set to Mixed Mode security.
sa is a SQL login, but BUILTIN\Administrators is a integrated login.
Make sense?
Darren
>"Darren Green" <darren.green@.reply-to-newsgroup-sqldts.com> wrote in message
>news:7r2qD3R8WFEAFwOw@.sqldts.com...
>> In message <eoafD3t3DHA.2556@.TK2MSFTNGP10.phx.gbl>, mmac <no@.thanks.com>
>> writes
>> >
>> >I am getting the following message in my event logs since hitting windows
>> >update and installing, among others SP4 for win2k.
>> >
>> >"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan
>> >'Michaels Backup Plan'' (0x8E4169EC6E0A93468357CC016A8A9186) -
>> >Status: Failed - Invoked on: 2004-01-19 02:00:00 - Message: The job
>> >failed. Unable to determine if the owner (MYSERVER\mylogin) of job DB
>> >Backup Job for DB Maintenance Plan 'Michaels Backup Plan' has server
>> >access (reason: Could not obtain information about Windows NT
>> >group/user 'MYSERVER\mylogin'. [SQLSTATE 42000] (Error 8198))."
>> >
>> >the only thing that changed was the updates, which can be significant but
>> > I certainly didn't change anything related to my account. I have
>recreated
>> >the plan with the same result.
>> >
>> >I can open the LOGON section of SQLadmin and see my name there, I
>> >can open it and close it but if I try to make any changes it says
>messages
>> >similar to the above on.
>> >
>> >KB articles suggested ading the everyone group to the pre2000 users
>> >group but that sounds dangerous.
>> >
>> >Help? what else can I look at. I am the sysop and should have all the
>> >necessary rights
>> I assume you have seen KB 241643, but have you tried the first
>> workaround "Change the job owner to a standard SQL Server user or system
>> administrator (sa)."? I have read this many times, and the second option
>> has never worked for me, so I go straight for option 1. I suspect there
>> may be other causes, perhaps network issues between SQL and the DC.
>> PRB: 8198 Error Message Returned from Job Owned by Windows NT
>> Authenticated User
>> http://support.microsoft.com?kbid=241643
>>
>> --
>> Darren Green (SQL Server MVP)
>> DTS - http://www.sqldts.com
>> PASS - the definitive, global community for SQL Server professionals
>> http://www.sqlpass.org
>
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Could not continue scan with NOLOCK due to data movement. when delete a record

Error 601
Severity Level 12
Message Text
Could not continue scan with NOLOCK due to data movement.
My client always hit this error when he tried to delete a record from
table. The table contains about 1 million records. the table has a
unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
(col_a),
non-unique index idx_3 on col_c. An update trigger on table also.
When he execute
delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
the 601 error.
but if he execute
delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
delete this one record.
We execute dbcc checktable(table_a) and no error reported.
I read posts that saying it is because read-uncommitted or nolock
hint, but we do not has this options and we did not execute select
statement.
Any idea why this happens, we are afraid that the table is not healthy/
waiting to corruption. Is there anything we can do to narrow down
where the cause is and to provent it happen again?
and it is MS SQL 2000 with SP4
thanks in advance
-rockdaleDoes this KB article apply?
http://support.microsoft.com/kb/815008
Linchi
"rockdale" wrote:
> Error 601
> Severity Level 12
> Message Text
> Could not continue scan with NOLOCK due to data movement.
> My client always hit this error when he tried to delete a record from
> table. The table contains about 1 million records. the table has a
> unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> (col_a),
> non-unique index idx_3 on col_c. An update trigger on table also.
> When he execute
> delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> the 601 error.
> but if he execute
> delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> delete this one record.
> We execute dbcc checktable(table_a) and no error reported.
> I read posts that saying it is because read-uncommitted or nolock
> hint, but we do not has this options and we did not execute select
> statement.
> Any idea why this happens, we are afraid that the table is not healthy/
> waiting to corruption. Is there anything we can do to narrow down
> where the cause is and to provent it happen again?
> and it is MS SQL 2000 with SP4
> thanks in advance
> -rockdale
>|||NOPE.
The database is SQL2K with SP4.
They did not execute any select statement, not mention Read Uncommited
option.
They execute the delete statement using one where condition and get
the error.
They execute the delete statement using another where condition and
no error occured.
I even execute the DBCC TRACEON (9134, -1) as the article you
mentioned, I still getting the same error. I can not restart the sql
server, it is a production server.
Thanks
On Oct 19, 11:46 am, Linchi Shea
<LinchiS...@.discussions.microsoft.com> wrote:
> Does this KB article apply?http://support.microsoft.com/kb/815008
> Linchi
>
> "rockdale" wrote:
> > Error 601
> > Severity Level 12
> > Message Text
> > Could not continue scan with NOLOCK due to data movement.
> > My client always hit this error when he tried to delete a record from
> > table. The table contains about 1 million records. the table has a
> > unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> > (col_a),
> > non-unique index idx_3 on col_c. An update trigger on table also.
> > When he execute
> > delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> > the 601 error.
> > but if he execute
> > delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> > delete this one record.
> > We execute dbcc checktable(table_a) and no error reported.
> > I read posts that saying it is because read-uncommitted or nolock
> > hint, but we do not has this options and we did not execute select
> > statement.
> > Any idea why this happens, we are afraid that the table is not healthy/
> > waiting to corruption. Is there anything we can do to narrow down
> > where the cause is and to provent it happen again?
> > and it is MS SQL 2000 with SP4
> > thanks in advance
> > -rockdale- Hide quoted text -
> - Show quoted text -|||Look for a DELETE trigger on the table.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"rockdale" <rockdale.green@.gmail.com> wrote in message
news:1192807669.901836.228930@.i38g2000prf.googlegroups.com...
> Error 601
> Severity Level 12
> Message Text
> Could not continue scan with NOLOCK due to data movement.
> My client always hit this error when he tried to delete a record from
> table. The table contains about 1 million records. the table has a
> unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> (col_a),
> non-unique index idx_3 on col_c. An update trigger on table also.
> When he execute
> delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> the 601 error.
> but if he execute
> delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> delete this one record.
> We execute dbcc checktable(table_a) and no error reported.
> I read posts that saying it is because read-uncommitted or nolock
> hint, but we do not has this options and we did not execute select
> statement.
> Any idea why this happens, we are afraid that the table is not healthy/
> waiting to corruption. Is there anything we can do to narrow down
> where the cause is and to provent it happen again?
> and it is MS SQL 2000 with SP4
> thanks in advance
> -rockdale
>|||They have a n update trigger in the table basically update the
lastedUpdateDateTime field. The Trigger is for Update only, so I do
not think delete will trigger this trigger.
On Oct 19, 1:30 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Look for a DELETE trigger on the table.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
> "rockdale" <rockdale.gr...@.gmail.com> wrote in message
> news:1192807669.901836.228930@.i38g2000prf.googlegroups.com...
>
> > Error 601
> > Severity Level 12
> > Message Text
> > Could not continue scan with NOLOCK due to data movement.
> > My client always hit this error when he tried to delete a record from
> > table. The table contains about 1 million records. the table has a
> > unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> > (col_a),
> > non-unique index idx_3 on col_c. An update trigger on table also.
> > When he execute
> > delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> > the 601 error.
> > but if he execute
> > delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> > delete this one record.
> > We execute dbcc checktable(table_a) and no error reported.
> > I read posts that saying it is because read-uncommitted or nolock
> > hint, but we do not has this options and we did not execute select
> > statement.
> > Any idea why this happens, we are afraid that the table is not healthy/
> > waiting to corruption. Is there anything we can do to narrow down
> > where the cause is and to provent it happen again?
> > and it is MS SQL 2000 with SP4
> > thanks in advance
> > -rockdale- Hide quoted text -
> - Show quoted text -|||I just delete the trigger and I still getting the same error.
More Info on index:
They have a UNIQUE NONCLUSTERED Constraints on table_a
(col_a, col_b, col_c)
an INDEX on table_a
(col_c)
an INDEX on table_a
(col_a)
Might these indices problems?
thanks
On Oct 19, 1:30 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Look for a DELETE trigger on the table.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
> "rockdale" <rockdale.gr...@.gmail.com> wrote in message
> news:1192807669.901836.228930@.i38g2000prf.googlegroups.com...
>
> > Error 601
> > Severity Level 12
> > Message Text
> > Could not continue scan with NOLOCK due to data movement.
> > My client always hit this error when he tried to delete a record from
> > table. The table contains about 1 million records. the table has a
> > unique index idx_1 on (col_a, col_b, col_c). non-unique index idx_2 on
> > (col_a),
> > non-unique index idx_3 on col_c. An update trigger on table also.
> > When he execute
> > delete from table_a where col_a = @.parm1 and col_c = @.parm3. he gets
> > the 601 error.
> > but if he execute
> > delete from table_a where col_a = @.parm1 and col_b = @.parm2. he can
> > delete this one record.
> > We execute dbcc checktable(table_a) and no error reported.
> > I read posts that saying it is because read-uncommitted or nolock
> > hint, but we do not has this options and we did not execute select
> > statement.
> > Any idea why this happens, we are afraid that the table is not healthy/
> > waiting to corruption. Is there anything we can do to narrow down
> > where the cause is and to provent it happen again?
> > and it is MS SQL 2000 with SP4
> > thanks in advance
> > -rockdale- Hide quoted text -
> - Show quoted text -

Could not Bulk insert beacuse file could not be opened

I am trying to insert data into a table from a text file using bulk insert
..it works fine on localhost but gives the following error when i run it on a
network.
"Could not bulk insert because file 'E:\far\farextracts\DEGREE.txt' could
not be opened. Operating system error code 5(Access is denied.)."
any Suggestions or Solutions...
Thanks
It this file open by any chance? Does the SQL Server agent account have
rights to access this file?
"MMSqlserver" <sqlservermn@.discussions.microsoft.com> wrote in message
news:AD0F8466-F5F9-4043-BFE3-CF8BC4D9D021@.microsoft.com...
>I am trying to insert data into a table from a text file using bulk insert
> .it works fine on localhost but gives the following error when i run it on
> a
> network.
> "Could not bulk insert because file 'E:\far\farextracts\DEGREE.txt' could
> not be opened. Operating system error code 5(Access is denied.)."
> any Suggestions or Solutions...
> Thanks