Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: September 2010

Retrieving Report Names for SSRS Subscription Jobs

The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look at the jobs on the database server that Reporting Services is configured to use. At any rate, when the jobs are created, they are named with a very hard to… Read more

0 comments, 447 reads

Posted in BrianKMcDonald on 1 September 2010

Using WITH NOLOCK

A colleague of mine and I were recently talking about some scripts that they had seen containing the WITH NOLOCK hint. They asked me what it was and my basic answer is this…Using WITH NOLOCK will return records as they currently are stored regardless of if someone is updating them… Read more

0 comments, 242 reads

Posted in BrianKMcDonald on 1 September 2010