Lynn Pettis (3/23/2012)

---

GilaMonster (3/23/2012)

---

You say that like it should be obvious it's a bad idea. I got so much flak from...

Even for a small group, a primary key on that won't necessarily help. What happens if "John Smith" comes in as "Johnny Smith"? The unique constraint on the...

jcb (3/23/2012)

---

Gary,

.Net is expected to work integrated with SQL Server.

You can try this link:

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

I just tested the example code and it worked, listing all servers/instances in my network.

Note a instance...

I've got databases in the same situation. Whatever your rebuild/restore methodology is, it'll be better than "repair allow data loss".

And definitely look into the various snapshot isolation strategies available,...

As far as the corrupted database goes, I think restoring from backups is your best bet. Assuming you have regular log backups and can do point-in-time recovery, of course.

This kind of error is precisely why NoLock is recommended AGAINST by serious database professionals. Devs love it, because it makes them feel like they just discovered a magical...

So, since Google is the counterpart...

All things considered, I'm probably a unicycle with a turbojet strapped to it. Very Wile E Coyote type vehicle.

I've used their data. Worked just fine for a direct mail marketing company that I worked for.

You should just Google that.

Yes. Verify connection to the domain listed, and verify the user/group listed.

If you do all your DDL through scripts, and store them in source control with time-stamps, you can actually return a database object to any particular point-in-time for its schema,...

SSIS can definitely do that. It's the tool I'd use for it.

That makes sense.

Here's what I'd do in that case:

Use OpenRowset, with the Bulk operator, and have them define format files for each file type they want to use. Adding...

So far as I know, that's the same in the registries of all of those. I could be wrong, but it will be easy for you to check.

I'm on...