Folder security property...

Right click on the folder->Properties->Security->Edit->Add...

Looks like your SQL Server service account has no permission to delete.

The script you posted is...

I think you are restoring wrong TLOG backup file. See the difference in the file names in the BACKUP and RESTORE commands.

In BACKUP command it is mydb.TRN. In RESTORE it...

I would not answere these questions, becuase there are many candidates who apply for jobs with FAKE experience in their resume.

They get anwers for all the possible interview questions from...

Welcome.

Happy to know that it is working.

Don't forget to DENY CREATE and DROP as well.

Try this.

EXCLUDE those packages and rebuild the project.

USE TSQLFundamentals2008;

SELECT CAST (AVG (LineItems)AS DECIMAL (8,4))

AS AvgLineItems FROM

(SELECT orderid, CAST (COUNT (productid)AS DECIMAL (8,4))

AS LineItems

FROM Sales.OrderDetails

GROUP BY orderid)AS AvgCount

Becuase it is returned by AVG function (SELECT AVG (LineItems)AS AvgLineItems).

Use CAST in the outer SELECT.

Thanks for posting the solution. It will help others.

Instead of REVOKE, use DENY.

If the user is sysadmin server role member, you cant stop them.

mark.jr1 (12/8/2011)

---

We had an error regarding tempdb. Looks like there is enough space, but when I checked there are 9 data files in the primary file group. Primary datafile is...

Check whether remote connection is enabled or not.

Link to sample databases http://msftdbprodsamples.codeplex.com/releases/view/4004

If you have not done it already, download AdventureWorks Analytical database...