With the contents being various different sql commands and statements, I would opt for breaking the file out. 200MB seems somewhat large for a script file - unless it...

Here is script that I prefer to use than what you are using.

Run this and let me know if the filegroups show differently in it.

with tablesize as (

select so.Name as...

Is this a bulk load script or is the script file various different sql statements and commands?

Colts + 21

You're welcome.

I thought that was Dr. Pepper with a KISS of cherry?

A clustered index is the data for the...

This is good information from Jack and Jayakumar.

Without the tools mentioned by Jack and Jayakumar, you would only be able to restore the table as described in Jack's first post.

Nice editorial. I too have seen this apply to other areas beyond IT. From my experience, I think it is more prevalent in I.T. I also think...

That is a good blog entry on the topic. I would add that there are other scenarios where an SP may need to be decrypted. I ran into...

Yes good find indeed. I haven't seen that root cause for many moons.

crookj (1/26/2010)

---

CirquedeSQLeil (1/25/2010)

---

crookj (1/25/2010)

---

CirquedeSQLeil (1/23/2010)

---

D.Oc (1/23/2010)

---

CirquedeSQLeil (1/23/2010)

---

There's a lot more than just teeth that your lions...

Here's an article that seems like it would help:

http://cvakumar.com/msdynamics/?p=100

Thanks for the update.

Jeff Moden (1/25/2010)

---

WayneS (1/25/2010)

---

CirquedeSQLeil (1/25/2010)

---

Here is a thread that may help you find your solution. You will still need to look at the code and determine how to adapt...