As much fun as it sounds, you could migrate the data into a new database with the appropriate filegroups etc.

Editing sysaltfiles directly is protected and shouldn't be done.

Shadab Shah (2/20/2014)

---

Hello Experts ,

I notice one more thing, That if i used N in the SP and not while calling , ???? gets inserted.

CREATE TABLE #TBL1 (Property nvarchar(255))

ALTER...

Manure

I can see memory issues causing (memory dumps) blocking logins. I haven't seen it actually change a login to be expired. I guess it's not much of a...

I have 5 clients using the same piece of software from a 3rd party vendor. This vendor has rolled out CLR procedures to each of the clients. In...

Do you have a backup of the database from before those files were deleted from disk?

Kind of necessary to share :hehe:

Igor Micev (2/21/2014)

---

The question is trivial.

To ensure myself, I read this reference http://technet.microsoft.com/en-us/library/ms186388.aspx and I didn't see any correlation of the model's read_only property to the same for the restoring...

Woohoo - that's a win then. 😎

ChrisM@Work (2/21/2014)

---

rodjkidd (2/21/2014)

---

ChrisM@Work (2/21/2014)

---

SQLRNNR (2/20/2014)

---

You...

dwain.c (2/20/2014)

---

SQLRNNR (2/20/2014)

---

Yes, I have been told that many times. They always want...

Yes, I have been told that many times. They always want things to...

The most likely for that is Label3.Text has a value that is not a DateTime value.

Well done Dwain!!

pietlinden (2/20/2014)

---

Good thing, because I was just starting to think about it and try to figure out a solution (Good learning exercise, but if you have actual work to do,...