Help for sp_updatestats

Hi,
WEhen can I use this procedure? When its recommended and if its safe to use
it while online users are using the database.
Regards,aoxpsql,
This can consume large amounts of server resources, mainly disk IO. I
would prefer to run this at a time when the number of users is at a
minimum, say 3am? Try and run it when no other maintenance or overnight
batch jobs are running.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
aoxpsql wrote:
> Hi,
>
> WEhen can I use this procedure? When its recommended and if its safe to us
e
> it while online users are using the database.
> Regards,
>

Help for sp_updatestats

Hi,
WEhen can I use this procedure? When its recommended and if its safe to use
it while online users are using the database.
Regards,
aoxpsql,
This can consume large amounts of server resources, mainly disk IO. I
would prefer to run this at a time when the number of users is at a
minimum, say 3am? Try and run it when no other maintenance or overnight
batch jobs are running.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
aoxpsql wrote:
> Hi,
>
> WEhen can I use this procedure? When its recommended and if its safe to use
> it while online users are using the database.
> Regards,
>
sql

Help for sp_updatestats

Hi,
WEhen can I use this procedure? When its recommended and if its safe to use
it while online users are using the database.
Regards,> Hi !
> I want to use differnt logins for accessing database .
> User : for select queries
> Programmer : having full access to only to specific tables / and
> create/drop/alter rights for store procedures /functions/triggers
> Admin : having full access for all database objects .
> My main objective is to disable SA user for all the users of database ,and
> keep a audit of these users.
>
> I have already created these users and roles , Can u pls tell me what can
be
> area of attention while doing this ? what would be the impact while doing
> any activities , specially migration from one server to another , or
> transfering the data using DTS.
> Secondly , I want to implement transactional replication on production
> database , will it have any impact of logins and users of database ?
>
> Regards,
> Swati
>|||aoxpsql,
This can consume large amounts of server resources, mainly disk IO. I
would prefer to run this at a time when the number of users is at a
minimum, say 3am? Try and run it when no other maintenance or overnight
batch jobs are running.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
aoxpsql wrote:
> Hi,
>
> WEhen can I use this procedure? When its recommended and if its safe to use
> it while online users are using the database.
> Regards,
>

Help - Schema provided by Microsoft NOT ONLINE anymore

Hi
we are currently using a schema referring to
http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservice
for System.Web.Services.Protocol.SoapDocumentMethodAtrribute an
referring to
http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/creat
for Subscription.RequestNamespace from Reference.cs whil
programmatically creating a subscription
However, when we check for either of these URLs, they are no
available on Microsoft's site anymore. Can anyone possibly provid
some information on how to get to these schema files? :?
Many thanks in advance
MichaeWe have the same problem for these references:
System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/Cancel"& _
"Job",
RequestNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices",
ResponseNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices",
Use:=System.Web.Services.Description.SoapBindingUse.Literal,
ParameterStyle:=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)> _
This is from the system provided:
Public Function CancelJob(ByVal JobID As String) As Boolean
We are having the same problem with the Web References for function
ListJobs()
Have you had any luck with this?
"mhamach" wrote:
> Hi,
> we are currently using a schema referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices
> for System.Web.Services.Protocol.SoapDocumentMethodAtrribute and
> referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/create
>
> for Subscription.RequestNamespace from Reference.cs while
> programmatically creating a subscription.
> However, when we check for either of these URLs, they are not
> available on Microsoft's site anymore. Can anyone possibly provide
> some information on how to get to these schema files? :?
> Many thanks in advance!
> Michael
>|||I'm also experiencing the same problem.
Has anybody found a sollution to this?
"mhamach" wrote:
> Hi,
> we are currently using a schema referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices
> for System.Web.Services.Protocol.SoapDocumentMethodAtrribute and
> referring to
> http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/create
>
> for Subscription.RequestNamespace from Reference.cs while
> programmatically creating a subscription.
> However, when we check for either of these URLs, they are not
> available on Microsoft's site anymore. Can anyone possibly provide
> some information on how to get to these schema files? :?
> Many thanks in advance!
> Michael
>|||Is there anything at http://schemas.microsoft.com/sqlserver/ that helps
you?|||I could'nt find anything at http://schemas.microsoft.com/sqlserver/.
Is there any other way of rendering reports, other than using Reporting
Service.vb
"timseal" wrote:
> Is there anything at http://schemas.microsoft.com/sqlserver/ that helps
> you?
>