You will need to create a new field to replace the existing data using an expression.

=DateAdd(DateInterval.Hour, -6, now() )

** Replace now() with your datetime field from you're dataset

For a quick fix you could just use the DATEADD function in SSRS.

Caution: This will also be applied to all users and be weary of daylight savings

If it is currently in the cache then use the query below (replacing the check with your SP name).

SELECT UseCounts ,

Objtype...

In that past I see this for 2 reasons

1 - "SET" option differ in SSMS than the default connection to the server i.e. ARITHMETIC ABORT (check server setting and your...

Hi

I'm sorry but i have to agree with Gail on this. The links provided are a good read and an excellent place to start.

In addition Brent Ozar has a video...

Nice write up. This is a common issue in a number of SQL installation.

If you do find you have missing SPNs, MS have a nice GUI app that generates the...

Try this

;WITH Missing (missnum, maxid)

AS

(

SELECT

1 AS missnum, (select max(RegisterNo )

FROM

dbo.studentMaster)

UNION ALL

SELECT

missnum + 1, maxid

FROM

Missing

WHERE

missnum < maxid

)

SELECT...

Within veritas are you performing a verification?

I am not familiar with the product but I would guess that would fail and report any errors?

In the past (as we dont use...

Have you checked that the DNS/AD settings are correct.

I also found an issue when the SQL server have an old DNS server as the primary.

Hi, have you tried this blog?

http://sqlblogcasts.com/blogs/steveh/archive/2010/04/21/interesting-ssms-issue-with-waittype-of-preemptive-os-lookupaccountsid.aspx

Hi Steve

You prob know, but CU5 is out for SP1.

Cheers

JL

Personally I would use powershell.

@AllenWhite did a greate article [/url]a few years back.

Other options would be to use SQLPing (not on my work laptop so can not verify you get...

Simply, well deserved!!!

One other option is to use SSIS on a daily base, that way you can select the tables to copy from PROD to DEV.

Do you mean a schedule or the query behind the reports?

If the command is in progress, then you should be able to run sp_who2 and kill the process.

If the query...