goody71 (7/17/2012)

---

I'm moving our DB from 2000 to 2008.

I'm also developing a .NET App and plan to use this 'starting over' point to fix the schema of our DB. ...

brian.stewart 98697 (7/17/2012)

---

I have been experience difficulty converting an access DB to one that can be viewed in SQL Server 2012. This task should be simple right? However...

I noticed that too and forgot to mention it. I...

I like that you set the DB to SIMPLE recovery before rebuilding indexes but I am wondering why you are freeing proc cache and dropping clean buffers? If you're restoring...

What you are running into is a broken Ownership Chain. By default Ownership Chains cannot continue across database boundaries. Your initial assertion about only granting permissions to the VIEW being...

Daxesh Patel (7/17/2012)

---

Ok, instead of "restart" I "stopped" and then "started" sql service

and now I am not able to connect from my local machine.

Not sure about diffrence between "restart" and...

Excellent, thanks for confirming that the SID did not change. That is useful info. So to recap, after renaming an AD account that was part of an AD group setup...

I would recommend a slightly different approach. Setup an Event Handler at the Package level for the OnPreExecute Event and add a Script Task to the Event Handler that will...

Considerations for Switching from the Full or Bulk-Logged Recovery Model

In the article they show the ALTER DATABASE commands...

Shrinking to 0 is not a good approach no matter what your situation. Growing a log file...

lawson2305 (7/16/2012)

---

it is the standard shrink command it does not give me the option to define what I shrink from what I can tell. This is the code it...

You do not have to install the Maintenance package he provides but it is turnkey so if you're having trouble with backups and checkdb...

Maxime.Gagne (7/16/2012)

---

I found the issue, I'm a bit ashamed of this beginner's mistake.

The connection string of the OLEDB Component of the Index Rebuild Task had been hardcoded to our...

lawson2305 (7/16/2012)

---

I do have a full maintenance plan run every Sunday. So I retract my statement before I run a log backup appended everyday but Sunday 2AM.

in the plan...

lawson2305 (7/16/2012)

---

opc.three (7/16/2012)

---

I assume you have autogrow enabled on your log file. Check the default trace to see when it grew, that can help establishing a timeframe of when the...