Hi;
is there a way to interact with every detail row that is about to print?;
for acumulating values or perform special validations
TIAIf I understand you correctly, you could use ReportItems![fieldname].value.
fieldname would be the name of the textbox(es) you are interested in
interacting with.
"Willo" wrote:
> Hi;
> is there a way to interact with every detail row that is about to print?;
> for acumulating values or perform special validations
> TIA
>
>|||let me try to clarify my problem...
lets say i have table1 with accounts
--
TABLE1
accountid balance
1 10000
2 20000
and table2 with debits and credits
--
TABLE2
accountid debit credit
1 450
1 300
1 50
2 1000
2 3450
and table3 with account names
--
TABLE3
accountid accountname accountnumber
1 AAAAAAAA 3243223432
2 BBBBBBBBB 9832798273
i need an output like this
---
account
3243223432 AAAAAAAAA initial balance debit credit
final balance
10000
450 10450
10450
300 10150
10150
50 10100
account
9832798273 BBBBBBBBB initial balance debit credit
final balance
20000 1000
21000
21000
3450 17550
"honus" <honus@.discussions.microsoft.com> wrote in message
news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> If I understand you correctly, you could use
> ReportItems![fieldname].value.
> fieldname would be the name of the textbox(es) you are interested in
> interacting with.
> "Willo" wrote:
>> Hi;
>> is there a way to interact with every detail row that is about to print?;
>> for acumulating values or perform special validations
>> TIA
>>|||using a conditional statement and ReportItems! should work out for you. Name
your textboxes in tables 1 and 2 for easier referencing.
Or change your SQL to do this for you, which would probably be the easiest
way.
--
I am living proof that 95% of programmers are idiots.
"Willo" wrote:
> let me try to clarify my problem...
> lets say i have table1 with accounts
> --
> TABLE1
> accountid balance
> 1 10000
> 2 20000
> and table2 with debits and credits
> --
> TABLE2
> accountid debit credit
> 1 450
> 1 300
> 1 50
> 2 1000
> 2 3450
> and table3 with account names
> --
> TABLE3
> accountid accountname accountnumber
> 1 AAAAAAAA 3243223432
> 2 BBBBBBBBB 9832798273
>
> i need an output like this
> ---
> account
> 3243223432 AAAAAAAAA initial balance debit credit
> final balance
> 10000
> 450 10450
> 10450
> 300 10150
> 10150
> 50 10100
> account
> 9832798273 BBBBBBBBB initial balance debit credit
> final balance
> 20000 1000
> 21000
> 21000
> 3450 17550
>
>
>
>
> "honus" <honus@.discussions.microsoft.com> wrote in message
> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> > If I understand you correctly, you could use
> > ReportItems![fieldname].value.
> > fieldname would be the name of the textbox(es) you are interested in
> > interacting with.
> >
> > "Willo" wrote:
> >
> >> Hi;
> >>
> >> is there a way to interact with every detail row that is about to print?;
> >> for acumulating values or perform special validations
> >>
> >> TIA
> >>
> >>
> >>
>
>|||im trying to do it in sql but i think i cant be done on a single SELECT
statment.
On RS, all i need is to define a variable, initializing it with INITIAL
BALANCE for each account, suming each debit and subtrating each credit and
print th FINAL BALANCE for each record.
It is a simple task on most of other report tools, but i dont know how to do
it on RS... im very frustrated with this tool!
"honus" <honus@.discussions.microsoft.com> wrote in message
news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
> using a conditional statement and ReportItems! should work out for you.
> Name
> your textboxes in tables 1 and 2 for easier referencing.
> Or change your SQL to do this for you, which would probably be the easiest
> way.
> --
> I am living proof that 95% of programmers are idiots.
>
> "Willo" wrote:
>> let me try to clarify my problem...
>> lets say i have table1 with accounts
>> --
>> TABLE1
>> accountid balance
>> 1 10000
>> 2 20000
>> and table2 with debits and credits
>> --
>> TABLE2
>> accountid debit credit
>> 1 450
>> 1 300
>> 1 50
>> 2 1000
>> 2 3450
>> and table3 with account names
>> --
>> TABLE3
>> accountid accountname accountnumber
>> 1 AAAAAAAA 3243223432
>> 2 BBBBBBBBB 9832798273
>>
>> i need an output like this
>> ---
>> account
>> 3243223432 AAAAAAAAA initial balance debit credit
>> final balance
>> 10000
>> 450 10450
>> 10450
>> 300 10150
>> 10150
>> 50 10100
>> account
>> 9832798273 BBBBBBBBB initial balance debit credit
>> final balance
>> 20000
>> 1000
>> 21000
>> 21000
>> 3450 17550
>>
>>
>>
>>
>> "honus" <honus@.discussions.microsoft.com> wrote in message
>> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
>> > If I understand you correctly, you could use
>> > ReportItems![fieldname].value.
>> > fieldname would be the name of the textbox(es) you are interested in
>> > interacting with.
>> >
>> > "Willo" wrote:
>> >
>> >> Hi;
>> >>
>> >> is there a way to interact with every detail row that is about to
>> >> print?;
>> >> for acumulating values or perform special validations
>> >>
>> >> TIA
>> >>
>> >>
>> >>
>>|||Why not it can be done using sql, I created your 3 tables and wrote a query
to retrieve the final balance as well using calculated field.
Amarnath, MCTS
"Willo" wrote:
> im trying to do it in sql but i think i cant be done on a single SELECT
> statment.
> On RS, all i need is to define a variable, initializing it with INITIAL
> BALANCE for each account, suming each debit and subtrating each credit and
> print th FINAL BALANCE for each record.
> It is a simple task on most of other report tools, but i dont know how to do
> it on RS... im very frustrated with this tool!
>
>
> "honus" <honus@.discussions.microsoft.com> wrote in message
> news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
> > using a conditional statement and ReportItems! should work out for you.
> > Name
> > your textboxes in tables 1 and 2 for easier referencing.
> >
> > Or change your SQL to do this for you, which would probably be the easiest
> > way.
> > --
> > I am living proof that 95% of programmers are idiots.
> >
> >
> > "Willo" wrote:
> >
> >> let me try to clarify my problem...
> >>
> >> lets say i have table1 with accounts
> >> --
> >> TABLE1
> >> accountid balance
> >> 1 10000
> >> 2 20000
> >>
> >> and table2 with debits and credits
> >> --
> >> TABLE2
> >> accountid debit credit
> >> 1 450
> >> 1 300
> >> 1 50
> >> 2 1000
> >> 2 3450
> >>
> >> and table3 with account names
> >> --
> >> TABLE3
> >> accountid accountname accountnumber
> >> 1 AAAAAAAA 3243223432
> >> 2 BBBBBBBBB 9832798273
> >>
> >>
> >> i need an output like this
> >> ---
> >> account
> >> 3243223432 AAAAAAAAA initial balance debit credit
> >> final balance
> >> 10000
> >> 450 10450
> >> 10450
> >> 300 10150
> >> 10150
> >> 50 10100
> >>
> >> account
> >> 9832798273 BBBBBBBBB initial balance debit credit
> >> final balance
> >> 20000
> >> 1000
> >> 21000
> >> 21000
> >> 3450 17550
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >> "honus" <honus@.discussions.microsoft.com> wrote in message
> >> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> >> > If I understand you correctly, you could use
> >> > ReportItems![fieldname].value.
> >> > fieldname would be the name of the textbox(es) you are interested in
> >> > interacting with.
> >> >
> >> > "Willo" wrote:
> >> >
> >> >> Hi;
> >> >>
> >> >> is there a way to interact with every detail row that is about to
> >> >> print?;
> >> >> for acumulating values or perform special validations
> >> >>
> >> >> TIA
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||maybe im just plain idiot, could you show me how you did it?
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:B8EA7478-B492-4D96-B1D5-73F24693268A@.microsoft.com...
> Why not it can be done using sql, I created your 3 tables and wrote a
> query
> to retrieve the final balance as well using calculated field.
> Amarnath, MCTS
> "Willo" wrote:
>> im trying to do it in sql but i think i cant be done on a single SELECT
>> statment.
>> On RS, all i need is to define a variable, initializing it with INITIAL
>> BALANCE for each account, suming each debit and subtrating each credit
>> and
>> print th FINAL BALANCE for each record.
>> It is a simple task on most of other report tools, but i dont know how to
>> do
>> it on RS... im very frustrated with this tool!
>>
>>
>> "honus" <honus@.discussions.microsoft.com> wrote in message
>> news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
>> > using a conditional statement and ReportItems! should work out for you.
>> > Name
>> > your textboxes in tables 1 and 2 for easier referencing.
>> >
>> > Or change your SQL to do this for you, which would probably be the
>> > easiest
>> > way.
>> > --
>> > I am living proof that 95% of programmers are idiots.
>> >
>> >
>> > "Willo" wrote:
>> >
>> >> let me try to clarify my problem...
>> >>
>> >> lets say i have table1 with accounts
>> >> --
>> >> TABLE1
>> >> accountid balance
>> >> 1 10000
>> >> 2 20000
>> >>
>> >> and table2 with debits and credits
>> >> --
>> >> TABLE2
>> >> accountid debit credit
>> >> 1 450
>> >> 1 300
>> >> 1 50
>> >> 2 1000
>> >> 2 3450
>> >>
>> >> and table3 with account names
>> >> --
>> >> TABLE3
>> >> accountid accountname accountnumber
>> >> 1 AAAAAAAA 3243223432
>> >> 2 BBBBBBBBB 9832798273
>> >>
>> >>
>> >> i need an output like this
>> >> ---
>> >> account
>> >> 3243223432 AAAAAAAAA initial balance debit credit
>> >> final balance
>> >> 10000
>> >> 450 10450
>> >> 10450
>> >> 300 10150
>> >> 10150
>> >> 50 10100
>> >>
>> >> account
>> >> 9832798273 BBBBBBBBB initial balance debit credit
>> >> final balance
>> >> 20000
>> >> 1000
>> >> 21000
>> >> 21000
>> >> 3450 17550
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> "honus" <honus@.discussions.microsoft.com> wrote in message
>> >> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
>> >> > If I understand you correctly, you could use
>> >> > ReportItems![fieldname].value.
>> >> > fieldname would be the name of the textbox(es) you are interested in
>> >> > interacting with.
>> >> >
>> >> > "Willo" wrote:
>> >> >
>> >> >> Hi;
>> >> >>
>> >> >> is there a way to interact with every detail row that is about to
>> >> >> print?;
>> >> >> for acumulating values or perform special validations
>> >> >>
>> >> >> TIA
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||hey it is pretty simple, fortunately you have exact link between tables. So
join them and create a query by selecting the required columns and a
calculated column of (balance +debit - credit) will give you Final balance.
If this is what you want, do it and let me know whether it works.
Amarnath, MCTS
"Willo" wrote:
> maybe im just plain idiot, could you show me how you did it?
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:B8EA7478-B492-4D96-B1D5-73F24693268A@.microsoft.com...
> > Why not it can be done using sql, I created your 3 tables and wrote a
> > query
> > to retrieve the final balance as well using calculated field.
> >
> > Amarnath, MCTS
> >
> > "Willo" wrote:
> >
> >> im trying to do it in sql but i think i cant be done on a single SELECT
> >> statment.
> >>
> >> On RS, all i need is to define a variable, initializing it with INITIAL
> >> BALANCE for each account, suming each debit and subtrating each credit
> >> and
> >> print th FINAL BALANCE for each record.
> >>
> >> It is a simple task on most of other report tools, but i dont know how to
> >> do
> >> it on RS... im very frustrated with this tool!
> >>
> >>
> >>
> >>
> >> "honus" <honus@.discussions.microsoft.com> wrote in message
> >> news:36EE88E4-29A6-44CD-AAB0-0642DC7B0958@.microsoft.com...
> >> > using a conditional statement and ReportItems! should work out for you.
> >> > Name
> >> > your textboxes in tables 1 and 2 for easier referencing.
> >> >
> >> > Or change your SQL to do this for you, which would probably be the
> >> > easiest
> >> > way.
> >> > --
> >> > I am living proof that 95% of programmers are idiots.
> >> >
> >> >
> >> > "Willo" wrote:
> >> >
> >> >> let me try to clarify my problem...
> >> >>
> >> >> lets say i have table1 with accounts
> >> >> --
> >> >> TABLE1
> >> >> accountid balance
> >> >> 1 10000
> >> >> 2 20000
> >> >>
> >> >> and table2 with debits and credits
> >> >> --
> >> >> TABLE2
> >> >> accountid debit credit
> >> >> 1 450
> >> >> 1 300
> >> >> 1 50
> >> >> 2 1000
> >> >> 2 3450
> >> >>
> >> >> and table3 with account names
> >> >> --
> >> >> TABLE3
> >> >> accountid accountname accountnumber
> >> >> 1 AAAAAAAA 3243223432
> >> >> 2 BBBBBBBBB 9832798273
> >> >>
> >> >>
> >> >> i need an output like this
> >> >> ---
> >> >> account
> >> >> 3243223432 AAAAAAAAA initial balance debit credit
> >> >> final balance
> >> >> 10000
> >> >> 450 10450
> >> >> 10450
> >> >> 300 10150
> >> >> 10150
> >> >> 50 10100
> >> >>
> >> >> account
> >> >> 9832798273 BBBBBBBBB initial balance debit credit
> >> >> final balance
> >> >> 20000
> >> >> 1000
> >> >> 21000
> >> >> 21000
> >> >> 3450 17550
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "honus" <honus@.discussions.microsoft.com> wrote in message
> >> >> news:A47B82AB-EA96-4D42-B412-FAEFE83B8ADA@.microsoft.com...
> >> >> > If I understand you correctly, you could use
> >> >> > ReportItems![fieldname].value.
> >> >> > fieldname would be the name of the textbox(es) you are interested in
> >> >> > interacting with.
> >> >> >
> >> >> > "Willo" wrote:
> >> >> >
> >> >> >> Hi;
> >> >> >>
> >> >> >> is there a way to interact with every detail row that is about to
> >> >> >> print?;
> >> >> >> for acumulating values or perform special validations
> >> >> >>
> >> >> >> TIA
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
Showing posts with label perform. Show all posts
Showing posts with label perform. Show all posts
Friday, March 9, 2012
Wednesday, March 7, 2012
Integrity Check From Maintenance Plan Fails - Error 22029
Hello,
I created a Maintenance plan and the only thing I have it do is perform an
Integrity Check on the database. It's been running successfully for 2 years.
I recently Added Replication to this server, having the data from this
server replicated onto a backup server. During that setup, I had to let
SQLServer Agent run as a different user than the system Administrator for
some reason. So I changed it to run as a different Windows User that has
Administrator privileges.
The command for the check is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
Now the Integrity Check won't run.
The user is set as a user on the Server with Admin privileges with Access to
the database in question.
Since I'm trying to let it do the minor repair, could it be that Agent
running as a different user doesn't get the exclusive access it needs?
Thanks for any help.
John
Specify a report file for the job and check for the specific errors in the report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:E77351D7-DA36-43B4-9C61-C31FCF1EBA99@.microsoft.com...
> Hello,
> I created a Maintenance plan and the only thing I have it do is perform an
> Integrity Check on the database. It's been running successfully for 2 years.
> I recently Added Replication to this server, having the data from this
> server replicated onto a backup server. During that setup, I had to let
> SQLServer Agent run as a different user than the system Administrator for
> some reason. So I changed it to run as a different Windows User that has
> Administrator privileges.
> The command for the check is:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
> Now the Integrity Check won't run.
> The user is set as a user on the Server with Admin privileges with Access to
> the database in question.
> Since I'm trying to let it do the minor repair, could it be that Agent
> running as a different user doesn't get the exclusive access it needs?
> Thanks for any help.
> John
I created a Maintenance plan and the only thing I have it do is perform an
Integrity Check on the database. It's been running successfully for 2 years.
I recently Added Replication to this server, having the data from this
server replicated onto a backup server. During that setup, I had to let
SQLServer Agent run as a different user than the system Administrator for
some reason. So I changed it to run as a different Windows User that has
Administrator privileges.
The command for the check is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
Now the Integrity Check won't run.
The user is set as a user on the Server with Admin privileges with Access to
the database in question.
Since I'm trying to let it do the minor repair, could it be that Agent
running as a different user doesn't get the exclusive access it needs?
Thanks for any help.
John
Specify a report file for the job and check for the specific errors in the report file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:E77351D7-DA36-43B4-9C61-C31FCF1EBA99@.microsoft.com...
> Hello,
> I created a Maintenance plan and the only thing I have it do is perform an
> Integrity Check on the database. It's been running successfully for 2 years.
> I recently Added Replication to this server, having the data from this
> server replicated onto a backup server. During that setup, I had to let
> SQLServer Agent run as a different user than the system Administrator for
> some reason. So I changed it to run as a different Windows User that has
> Administrator privileges.
> The command for the check is:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
> Now the Integrity Check won't run.
> The user is set as a user on the Server with Admin privileges with Access to
> the database in question.
> Since I'm trying to let it do the minor repair, could it be that Agent
> running as a different user doesn't get the exclusive access it needs?
> Thanks for any help.
> John
Integrity Check From Maintenance Plan Fails - Error 22029
Hello,
I created a Maintenance plan and the only thing I have it do is perform an
Integrity Check on the database. It's been running successfully for 2 years
.
I recently Added Replication to this server, having the data from this
server replicated onto a backup server. During that setup, I had to let
SQLServer Agent run as a different user than the system Administrator for
some reason. So I changed it to run as a different Windows User that has
Administrator privileges.
The command for the check is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
Now the Integrity Check won't run.
The user is set as a user on the Server with Admin privileges with Access to
the database in question.
Since I'm trying to let it do the minor repair, could it be that Agent
running as a different user doesn't get the exclusive access it needs?
Thanks for any help.
JohnSpecify a report file for the job and check for the specific errors in the r
eport file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:E77351D7-DA36-43B4-9C61-C31FCF1EBA99@.microsoft.com...
> Hello,
> I created a Maintenance plan and the only thing I have it do is perform an
> Integrity Check on the database. It's been running successfully for 2 yea
rs.
> I recently Added Replication to this server, having the data from this
> server replicated onto a backup server. During that setup, I had to let
> SQLServer Agent run as a different user than the system Administrator for
> some reason. So I changed it to run as a different Windows User that has
> Administrator privileges.
> The command for the check is:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
> Now the Integrity Check won't run.
> The user is set as a user on the Server with Admin privileges with Access
to
> the database in question.
> Since I'm trying to let it do the minor repair, could it be that Agent
> running as a different user doesn't get the exclusive access it needs?
> Thanks for any help.
> John
I created a Maintenance plan and the only thing I have it do is perform an
Integrity Check on the database. It's been running successfully for 2 years
.
I recently Added Replication to this server, having the data from this
server replicated onto a backup server. During that setup, I had to let
SQLServer Agent run as a different user than the system Administrator for
some reason. So I changed it to run as a different Windows User that has
Administrator privileges.
The command for the check is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
Now the Integrity Check won't run.
The user is set as a user on the Server with Admin privileges with Access to
the database in question.
Since I'm trying to let it do the minor repair, could it be that Agent
running as a different user doesn't get the exclusive access it needs?
Thanks for any help.
JohnSpecify a report file for the job and check for the specific errors in the r
eport file.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:E77351D7-DA36-43B4-9C61-C31FCF1EBA99@.microsoft.com...
> Hello,
> I created a Maintenance plan and the only thing I have it do is perform an
> Integrity Check on the database. It's been running successfully for 2 yea
rs.
> I recently Added Replication to this server, having the data from this
> server replicated onto a backup server. During that setup, I had to let
> SQLServer Agent run as a different user than the system Administrator for
> some reason. So I changed it to run as a different Windows User that has
> Administrator privileges.
> The command for the check is:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
> Now the Integrity Check won't run.
> The user is set as a user on the Server with Admin privileges with Access
to
> the database in question.
> Since I'm trying to let it do the minor repair, could it be that Agent
> running as a different user doesn't get the exclusive access it needs?
> Thanks for any help.
> John
Integrity Check From Maintenance Plan Fails - Error 22029
Hello,
I created a Maintenance plan and the only thing I have it do is perform an
Integrity Check on the database. It's been running successfully for 2 years.
I recently Added Replication to this server, having the data from this
server replicated onto a backup server. During that setup, I had to let
SQLServer Agent run as a different user than the system Administrator for
some reason. So I changed it to run as a different Windows User that has
Administrator privileges.
The command for the check is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
Now the Integrity Check won't run.
The user is set as a user on the Server with Admin privileges with Access to
the database in question.
Since I'm trying to let it do the minor repair, could it be that Agent
running as a different user doesn't get the exclusive access it needs?
Thanks for any help.
JohnSpecify a report file for the job and check for the specific errors in the report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:E77351D7-DA36-43B4-9C61-C31FCF1EBA99@.microsoft.com...
> Hello,
> I created a Maintenance plan and the only thing I have it do is perform an
> Integrity Check on the database. It's been running successfully for 2 years.
> I recently Added Replication to this server, having the data from this
> server replicated onto a backup server. During that setup, I had to let
> SQLServer Agent run as a different user than the system Administrator for
> some reason. So I changed it to run as a different Windows User that has
> Administrator privileges.
> The command for the check is:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
> Now the Integrity Check won't run.
> The user is set as a user on the Server with Admin privileges with Access to
> the database in question.
> Since I'm trying to let it do the minor repair, could it be that Agent
> running as a different user doesn't get the exclusive access it needs?
> Thanks for any help.
> John
I created a Maintenance plan and the only thing I have it do is perform an
Integrity Check on the database. It's been running successfully for 2 years.
I recently Added Replication to this server, having the data from this
server replicated onto a backup server. During that setup, I had to let
SQLServer Agent run as a different user than the system Administrator for
some reason. So I changed it to run as a different Windows User that has
Administrator privileges.
The command for the check is:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID
D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
Now the Integrity Check won't run.
The user is set as a user on the Server with Admin privileges with Access to
the database in question.
Since I'm trying to let it do the minor repair, could it be that Agent
running as a different user doesn't get the exclusive access it needs?
Thanks for any help.
JohnSpecify a report file for the job and check for the specific errors in the report file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"John Manion" <JohnManion@.discussions.microsoft.com> wrote in message
news:E77351D7-DA36-43B4-9C61-C31FCF1EBA99@.microsoft.com...
> Hello,
> I created a Maintenance plan and the only thing I have it do is perform an
> Integrity Check on the database. It's been running successfully for 2 years.
> I recently Added Replication to this server, having the data from this
> server replicated onto a backup server. During that setup, I had to let
> SQLServer Agent run as a different user than the system Administrator for
> some reason. So I changed it to run as a different Windows User that has
> Administrator privileges.
> The command for the check is:
> EXECUTE master.dbo.xp_sqlmaint N'-PlanID
> D2A9902D-1F5F-4FCB-8819-62609F141FD5 -WriteHistory -CkDBRepair '
> Now the Integrity Check won't run.
> The user is set as a user on the Server with Admin privileges with Access to
> the database in question.
> Since I'm trying to let it do the minor repair, could it be that Agent
> running as a different user doesn't get the exclusive access it needs?
> Thanks for any help.
> John
Friday, February 24, 2012
Integration services
Hi all.
I'm playing about with SQL Integration Services and am in need of some help.
I'm trying to perform a transformation from one of our old systems. At the
time it was decided to store some data into a varchar(6000) column. Yep, a
long string of text. The text actually represents a data structure in
itself.
What I'm trying to do is take this one field and turn the data into several
rows on a data set. For example...
I'd like to turn this
Item1~Data1,Item2~Data2,Item3~Data3
Into this
Item1~Data1
Item2~Date2
Item3~Data3
Does anyone have any suggestions
Colin.See if this helps:
http://groups.google.com/group/micr...br />
db9a9b3d
Anith|||I gave up and decided to use the fn_spit function (from the MS Website)
similar the info in your link. I combined that with a cross apply to split
the data in sql before SSIS gets it's hands on it.
Regards
Colin.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:uRdg91MVGHA.1304@.tk2msftngp13.phx.gbl...
> See if this helps:
> http://groups.google.com/group/micr... />
11db9a9b3d
> --
> Anith
>
I'm playing about with SQL Integration Services and am in need of some help.
I'm trying to perform a transformation from one of our old systems. At the
time it was decided to store some data into a varchar(6000) column. Yep, a
long string of text. The text actually represents a data structure in
itself.
What I'm trying to do is take this one field and turn the data into several
rows on a data set. For example...
I'd like to turn this
Item1~Data1,Item2~Data2,Item3~Data3
Into this
Item1~Data1
Item2~Date2
Item3~Data3
Does anyone have any suggestions
Colin.See if this helps:
http://groups.google.com/group/micr...br />
db9a9b3d
Anith|||I gave up and decided to use the fn_spit function (from the MS Website)
similar the info in your link. I combined that with a cross apply to split
the data in sql before SSIS gets it's hands on it.
Regards
Colin.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:uRdg91MVGHA.1304@.tk2msftngp13.phx.gbl...
> See if this helps:
> http://groups.google.com/group/micr... />
11db9a9b3d
> --
> Anith
>
Subscribe to:
Posts (Atom)