Maintenance Plan does not work with calculated columns

Hello Group!
According to to KB article 301292
(http://support.microsoft.com/?kbid=301292), I have to set ARITHABORT,
CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING, and
ANSI_WARNINGS to ON and NUMERIC_ROUNDABORT to OFF to be able to run DBCC
commands on tables with Indexes On Computed Columns.
.
It seems that this applies to Maintenance Plans as well. Is there a way to
fix that? How can I set those to the Connection SQL Agent is using?
I would not like to have to run a lot of script. All the ease in the
maintenance would go away...
Thanks,
Giovanni BassiThe only real fix that I know of right now is to create your own scheduled
job with your own DBCC's. That way you can do it any way you like.
--
Andrew J. Kelly
SQL Server MVP
"Giovanni Bassi" <gbassi@.coair.com> wrote in message
news:%23gHqrpTrDHA.2616@.TK2MSFTNGP09.phx.gbl...
> Hello Group!
> According to to KB article 301292
> (http://support.microsoft.com/?kbid=301292), I have to set ARITHABORT,
> CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING, and
> ANSI_WARNINGS to ON and NUMERIC_ROUNDABORT to OFF to be able to run DBCC
> commands on tables with Indexes On Computed Columns.
> .
> It seems that this applies to Maintenance Plans as well. Is there a way to
> fix that? How can I set those to the Connection SQL Agent is using?
> I would not like to have to run a lot of script. All the ease in the
> maintenance would go away...
> Thanks,
> Giovanni Bassi
>|||That's the problem, Andrew. Then I loose all the ease of the maintenance
plans...
Microsoft should had thought of that...
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23Zla7yTrDHA.2480@.TK2MSFTNGP10.phx.gbl...
> The only real fix that I know of right now is to create your own scheduled
> job with your own DBCC's. That way you can do it any way you like.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "Giovanni Bassi" <gbassi@.coair.com> wrote in message
> news:%23gHqrpTrDHA.2616@.TK2MSFTNGP09.phx.gbl...
> > Hello Group!
> >
> > According to to KB article 301292
> > (http://support.microsoft.com/?kbid=301292), I have to set ARITHABORT,
> > CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING,
and
> > ANSI_WARNINGS to ON and NUMERIC_ROUNDABORT to OFF to be able to run DBCC
> > commands on tables with Indexes On Computed Columns.
> > .
> > It seems that this applies to Maintenance Plans as well. Is there a way
to
> > fix that? How can I set those to the Connection SQL Agent is using?
> > I would not like to have to run a lot of script. All the ease in the
> > maintenance would go away...
> >
> > Thanks,
> >
> > Giovanni Bassi
> >
> >
>|||Usually when something is easy it looses flexibility. It really only takes
a few lines of code to replace what the MP does.
--
Andrew J. Kelly
SQL Server MVP
"Giovanni Bassi" <gbassi@.coair.com> wrote in message
news:eJEC%23qcrDHA.976@.tk2msftngp13.phx.gbl...
> That's the problem, Andrew. Then I loose all the ease of the maintenance
> plans...
> Microsoft should had thought of that...
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23Zla7yTrDHA.2480@.TK2MSFTNGP10.phx.gbl...
> > The only real fix that I know of right now is to create your own
scheduled
> > job with your own DBCC's. That way you can do it any way you like.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "Giovanni Bassi" <gbassi@.coair.com> wrote in message
> > news:%23gHqrpTrDHA.2616@.TK2MSFTNGP09.phx.gbl...
> > > Hello Group!
> > >
> > > According to to KB article 301292
> > > (http://support.microsoft.com/?kbid=301292), I have to set ARITHABORT,
> > > CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING,
> and
> > > ANSI_WARNINGS to ON and NUMERIC_ROUNDABORT to OFF to be able to run
DBCC
> > > commands on tables with Indexes On Computed Columns.
> > > .
> > > It seems that this applies to Maintenance Plans as well. Is there a
way
> to
> > > fix that? How can I set those to the Connection SQL Agent is using?
> > > I would not like to have to run a lot of script. All the ease in the
> > > maintenance would go away...
> > >
> > > Thanks,
> > >
> > > Giovanni Bassi
> > >
> > >
> >
> >
>

main page blank after new install ?

Hi,
I installed reporting services on 2003 (IIS6, front page ext, asp.net, no
vb.net). When connecting to http://server im directed to
http://server/Reports/Pages/Folder.aspx . The main form header shows HOME /
MY SUBSCRIPTIONS / HELP but the main page is blank.
Anyone know why and how to sort ?
Thanks
Scottim just wondering if its because i didnt install VB.net 03 so the report
designer is not available.|||on the hosting server i enter http://localhost and get the Report Manager
with all the options.
From a client i get a blank home page. I assume because nothing is setup yet
which is fine.

Mailing Result Set Rows

In the thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1071904&SiteID=1 mike.groh stated that you would define the result set as a data set variable through an execute sql task. He then pushed the variable out as a dataset type. (ds = CType(Dts.Variables("Email_CurrentDataset").Value, DataSet)

How would this type of object be declared as a user variable? Is it of type object? What is the logic behind converting a result set to a data set?

Specifically I am having problems with converting / casting the result set to a data set in that I am getting an error stating that it cannot convert the com object to a data.dataset class...

Imports ADODB

Imports System

Imports System.Xml

Imports System.Collections

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports Microsoft.SqlServer.Dts

Imports Microsoft.SqlServer.Dts.DtsClient

PublicClass ScriptMain

PublicSub Main()

Dim ds As DataSet

Dim dr As DataRow

Dim str AsString

Dim dtm AsString

Dim s AsString

Try

ds = CType(Dts.Variables("resultSet").Value, DataSet) ' <-- Error on converting

Dts.TaskResult = Dts.Results.Success

Catch ex As Exception

Dts.TaskResult = Dts.Results.Failure

EndTry

Here's the code to convert an ADO resultset to an ADO.NET dataset.

Code Snippet

Dim oledbAdapter As New OleDb.OleDbDataAdapter
Dim dataTable As New System.Data.DataTable

oledbAdapter.Fill(dataTable, Me.Variables.resultset)

Mail Configuration question

I have created a subscription to send a mail...and I get a link for the
report as below...
http://ServerName/reportserver?%.....
But the name is not getting resolved and my Admin says I need to use the
full qualified domain name(fqdn), Please let me know where I have to make
change in reporting services so the email link I get will have the fqdn of
the server like below instead of just the servername...
http://ServerName.xyz.com/reportserver?%.....
Thanks.What message do you get when you click the link? Are you passing
parameters? When you access the report server... do you use fqdn or
servername/reports
Ranga wrote:
> I have created a subscription to send a mail...and I get a link for the
> report as below...
> http://ServerName/reportserver?%.....
> But the name is not getting resolved and my Admin says I need to use the
> full qualified domain name(fqdn), Please let me know where I have to make
> change in reporting services so the email link I get will have the fqdn of
> the server like below instead of just the servername...
> http://ServerName.xyz.com/reportserver?%.....
> Thanks.|||I have choosen the parametere in the subscription properties, so I do not
pass any paraneters..
here is the message I get...
Bad Gateway
The following error occurred:
[code=DNS_HOST_NOT_FOUND] The host name was not found during the DNS lookup.
Contact your system administrator if the problem is not found by retrying the
URL.
If I change the link to use the fqdn it works .
Thanks.
"zomer" wrote:
> What message do you get when you click the link? Are you passing
> parameters? When you access the report server... do you use fqdn or
> servername/reports
>
> Ranga wrote:
> > I have created a subscription to send a mail...and I get a link for the
> > report as below...
> > http://ServerName/reportserver?%.....
> >
> > But the name is not getting resolved and my Admin says I need to use the
> > full qualified domain name(fqdn), Please let me know where I have to make
> > change in reporting services so the email link I get will have the fqdn of
> > the server like below instead of just the servername...
> >
> > http://ServerName.xyz.com/reportserver?%.....
> >
> > Thanks.
>

Machine name works and FQDN fails

Short version:
http://machinename/reports works as does http://machinename/reportserver
http://FQDN/reports repeatedly requests authentication and then fails.
Longer version:
Everything was working perfectly. I attempted to change to Sharepoint
integrated mode from native (after giving up on this - different thread) I
switched back to native mode.
Everything works when I access using machine name, but the FQDN now causes a
repeated request for authentication (does not matter which server or desktop
the request comes from or which user account) the request fails.
This worked before my adventure into sharepoint integration without a
request for authentication, but I can't figure out what I changed
(I broke it and can't fix it) - Please help.
--
Fredrick A. Zilz
Director IT
InterHealth N.I.I am using networkservice account as the webservice identity of my
application pools. So I just needed to update my SPN for the HTTP service on
my Report server
setspn -A HTTP/host.domain.com domain\machinename
--
Fredrick A. Zilz
Director IT
InterHealth N.I.
"Fred Zilz" wrote:
> Short version:
> http://machinename/reports works as does http://machinename/reportserver
> http://FQDN/reports repeatedly requests authentication and then fails.
> Longer version:
> Everything was working perfectly. I attempted to change to Sharepoint
> integrated mode from native (after giving up on this - different thread) I
> switched back to native mode.
> Everything works when I access using machine name, but the FQDN now causes a
> repeated request for authentication (does not matter which server or desktop
> the request comes from or which user account) the request fails.
> This worked before my adventure into sharepoint integration without a
> request for authentication, but I can't figure out what I changed
> (I broke it and can't fix it) - Please help.
> --
> Fredrick A. Zilz
> Director IT
> InterHealth N.I.