Luke L (4/5/2010)

---

GSquared (4/5/2010) I'm looking forward to the next installers, which will be either flash drives or something you download. BIOSes need to be able to fire up...

Kit G (4/5/2010)

---

lmu92 (4/5/2010)

---

Wasn't Windows 3.11 "just"...

Considering that that bug has already been fixed, I'm not too worried about it.

So far as I know, SQL 2005 doesn't do built-in encryption on image data types. I could be wrong, but I don't think it does.

You'll need to look up the "query", "nodes", and "value" functions in Books Online. Those are the starting point for using SQL 2005/2008 XQuery.

Those allow you to query XML,...

The main advantage to multiple databases is the ability to scale out.

If you find that there's enough traffic to overload the server, you can move the busiest databases to another...

The answer is...

Try this:

SELECT Car.value('(/cars/@model)[1]', 'varchar(100)'),

Quantity.Node.query('.').value('(/quantity/@shop_location)[1]',

...

I'd do multiple databases. Makes it easier to scale the whole thing out, plus lots of other advantages.

On the need for a single place to keep procs, would it...

GilaMonster (4/2/2010)

---

I dunno, that could give the impression that failed inserts/updates don't roll back (insert 10 rows, row...

Lynn Pettis (4/2/2010)

---

GilaMonster (4/2/2010)

---

GSquared (4/2/2010)

---

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself...

Lynn Pettis (4/2/2010)

---

GSquared (4/2/2010)

---

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself or...

GilaMonster (4/2/2010)

---

GSquared (4/2/2010)

---

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself or as...

You can grant the right to create procedures specifically.

Would look like this:

GRANT CREATE PROCEDURE TO bob;

Saying "they don't participate in transactions" could be misleading. If you insert into a temp or permanent table from a table variable (either by itself or as part of...