To restore from a diff you need to restore the most recent FULL backup first, and then whichever diff backup (probably the most recent again) you need. The error you...

I think you may be taking the words "operating system error" a bit too literally. In effect the OS always opens every file - ie low level OS routines will...

The trigger as you have it (ie FOR INSERTED) is an after trigger and logically happens AFTER the update has been done, (but before the transaction has been committed).

The issue...

Two things I think you need to do

a) Get the trigger changed to properly handle multiple rows in one statement. Lots of examples are around..

b) Your code is presumably processing...

Depending on what language you are configured for the date represeneted by the string '2009-03-06' could be march 6th or 3rd June. Safest option by far is to leave out...

Alternative answer is :

2009-09-02 17:30:00.000 -- which is exactly what you will see if you are configured for a UK date format. ie the dateadds behave as described by...

That trigger will not work correctly with multiple rows. Common mistake of retrieving something from inserted into a variable - so you get one of them. There are lots iof...

I think you have probably turned on "include actual execution plkan" in SSMS

When on it returns an extra result set .. OR there is a trigger in there that fires...

Recheck permissions, both to the share and NTFS. The error message is unambiguous - it says access denied. Are you sure permissions have been granted to the right account (ie...

Firstly I would not use the view designer - understanding the underying SQL is almost always better,,

I thonk all you need in this case is to change the hjoin to...

I am still fairly convinced that we have a date formatting issue here. EG:

SET @FEEDDATE = Convert(varchar, '01/21/2009', 101)

asks to convert 01/21/2009 to VARCHAR, using style 101, and there...

I would check the settings for language and date first. There is a lot of date to string conversion going on, and my guess would be a language setting making...

DBCC SHOINKDATABASE will not allow a shrink below the original size, but DBCC SHRINKFILE will allow you to shrink to any desired size. (provided this size is larger than the...

SELECT AR.SectionID ,O.OptionScore,AR.QuestionID,AR.SubSectionID

FROM

AuditResults AR

...

drop index tablename.indexname

But I suspect there maybe more to your question! Is this index used to support a primary key or unique constraint?

Mike John