How to troubleshoot Error 17204 and 17207 in SQL Server

http://support.microsoft.com/kb/2015754

Are you sure this encrypted data represent good data (not NULL value)? Please try it with another encrypted value.

First of all a Caution statement.

Caution:

ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new...

Nice Job David! But it would be good as an article. Many learners could be redirected there.

Looking at your post I am assure you can write good articles :-)....

Jeff Moden (12/23/2011)

---

Dev (12/23/2011)

---

Gail I agree to you on SEEK operation but I care about following.

Clustered indexes are not a good choice for the following attributes:

Columns that undergo...

I have some pretty old hardware and am still waiting for Santa to drop me an i7 Extreme, 12GB RAM laptop down the chimney so I can use all the...

David thanks for sharing your views here.

I agree that you can find Normalized Data Warehouse in Industry. I also agree that Oracle & SQL Server database can be used for...

hxkresl (12/24/2011)

---

Dev, I did this already.

I executed the stored procedure and then the query.

Will you kindly explain you initial point, so that I can understand where you were going with...

okbangas (12/24/2011)

---

In theory there is not difference between theory and practice, in practice there is. No offence intended, but Celco presents nice and valid theory, in practice it's not always...

All Features??? It’s pretty vague statement.

There are many tools perform good jobs...

Glad you are able to resolve it. Thanks for sharing the solution here.

Are SQL Server native tools not satisfying your requirements? Did you try Central Management Server?

Administering Multiple Servers Using Central Management Servers

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

GUI shows the progress by default.

Per BOL:

STATS [ =percentage ]

Displays a message each time another percentage completes, and is...

salum (12/24/2011)

---

Best practices for SQL Server service accounts

•Use a specific user account or domain account rather than a shared account for SQL Server services.

•Use a separate account for each service.

•Do...

Gail I agree to you on SEEK operation but I care about following.

Clustered indexes are not a good choice for the following attributes:

Columns that undergo frequent changes

This causes in the...