😀

Stefan Krzywicki (5/12/2011)

---

Just got a job req email for a .Net position. Some strange requirements though.

"Strong analytical skills as well as demons ratable code maintenance/bug-fix experience are required."

Is demon rating...

Not all developers are evil which is why I was compelled to post...that sentiment had started to shine through a bit too brightly and it was unwarranted 🙂

<my_take>

Best options in...

Sorry...that I do not have info on. I did find this though:

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/ffd1787b-5c5a-4824-b049-925a604bcb61/%5B/url%5D

It has some links to other articles but nothing that seemed like it had a concrete solution.

Total guess here...but...

sturner (5/12/2011)

---

opc.three (5/12/2011)

---

sturner (5/12/2011)

---

opc.three (5/12/2011)

---

sturner (5/12/2011)

---

Yes, that is a hack way of masking the...

sturner (5/12/2011)

---

opc.three (5/12/2011)

---

sturner (5/12/2011)

---

Yes, that is a hack way of masking the underlying issue,...

Maybe I missed the intent of your question...I thought you wanted to purge the database and its (physical) data files from the server...but now I am thinking that you just...

First detach the file:

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

Then you should be able to delete the data and log files.

sturner (5/12/2011)

---

Yes, that is a hack way of masking the underlying issue, but it...

Any version greater than 2000...from the Remarks section in this article http://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependency.aspx

On all supported versions of SQL Server (Microsoft SQL Server 7.0, Microsoft SQL Server 2000, and SQL Server 2005)...

Not to hijack the thread or anything...but what is your list of specific exceptions?

Can you detach them?

sandeep1188 (5/3/2011)

---

Thanks Everyone for the quick Response , Is there a way to import data into Sql Server Table from an excel File use BCP Utility, Bulk Copy or Bulk...

Can you detach them? That should allow you to delete them.

What have you tried?

Bummer but it looks like it can't be done directly using SSIS...it needs some pre-processing:

http://www.sqlservercentral.com/Forums/FindPost888553.aspx