OMG, how can someone who has been working with SQL Server for over 9 years still behave like an entry level DBA/Developer??

Whose turn with the silver spoon??

First entry when I used BING on the phrase encryptbykey sql server 2008.

http://msdn.microsoft.com/en-us/library/ms174361.aspx

EDIT: Sorry, same link you posted except you link is broken. It went nowhere when I...

Also remember that a reorg only touches the leaf pages. It does not touch the higher nodes of the index.

is250sp (7/15/2014)

---

This is only my 2nd package so any help would be much appreciated. It's a very simple package consisting of a single Data Flow Task. Within the...

SSIS issues are one of the harder to debug on a forum. For many of us not having the actually SSIS package(s), the underlying tables, and other database objects...

Or you may need to find where the original database and data came from and recreate it from scratch.

Welcome back, Steve.

Not really using it. Most of the columns returned by me are just for FYI. You should adjust the code as needed for your application.

Restarting SQL Server would still...

Updates wouldn't...

Do the errors in the windows event logs provide more information?

Love those problems that go like this:

OP: I have a problem (explains problem)

<< some time passes with no responses >>

OP: Never mine, I solved it.

Well, that nice. How did...

Well, I am glad you solved your problem. Etiquette, however, says that you should post your solution to your problem as it may help others with a similar problem.

Just curious, how did you change the service account?

Tammy-274861 (7/12/2014)

---

Hi Lynn and autoexcrement!

@autoexcrement, thank you so much for your time in helping me!!! 😀

@Lynn, yes, I saw your explanation, and regarding the 46 days it does make sense...