Shawn Melton (12/11/2014)

---

You might ensure the physical file has the correct ACL. I have at times had to do this to ensure the ACL matches up on each individual file....

I tried again and here are the results.

This is not a production box so I can blow it away if necessary.

ALTER DATABASE Staging SET ONLINE;

Msg 5120, Level 16, State 101,...

I appreciate the information.

Thank you.

You are right. I meant to say SP3 which was released on 12 SEPT 2014.

I will probably no go for the in-place upgrade so it will not matter.

Thanks.

Ed Wagner (10/1/2014)

---

I know you've seen this before, but I guess is merits posting. Lynn has a page of date calculations that can be used to get you to...

That's awesome. Thank you so much.

So how would I do it if I select the column from the table?

Welsh Corgi (9/29/2014)

---

ChrisM@Work (9/29/2014)

---

We're using OPENQUERY & linked server to run ad-hoc queries against a DB2 database. We discovered quite early on that DB2 (or possibly the driver) will balk...

ChrisM@Work (9/29/2014)

---

We're using OPENQUERY & linked server to run ad-hoc queries against a DB2 database. We discovered quite early on that DB2 (or possibly the driver) will balk at almost...

I have views that use aliases to load the tables about 200 tables not in this case.

I wrote the package two years ago and it has been working fine.

It is...

Thanks Lynn.

If I run DBCC CHECKDB I get the following error:

Msg 7928, Level 16, State 1, Line 1

The database snapshot for online checks could not be created. Either the reason is...

Yes I can query the tables.

It turns out that it is not the maintenance plan.

BACKUP DATABASE [CommercialLinesWDB] TO DISK = N'D:\Backups\Full\User\CommercialLinesWDB\CommercialLinesWDB_backup_2014_09_18_101705_9244712.bak'

Returns the following:

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.

Msg...

I narrowed it down to 1 Database.

It does not create a report. It just fails.

Using a maintenance plan is the lazy way to go.

I have a 2005 Server that I...