The only problem with doing this from SQL Server is that if the SQL Server service is the service that is not running then how is the email ever going...

That is correct.

Boyce\Codd normal form is also known as Strong Third Normal Form and is an enhancement on normal form.

The very article that the question uses as a reference artcile...

I see where the problem is.  The White Space only relates to white space in between tags.  So,

DECLARE @var XML

SET @var = '<root> <a>  <b>Data b</b> </a> </root>'

SELECT @var

The above...

I'm a bit confused.  (A) does give the correct answer but so does (B).

You don't need to perform any kind of convert function to preserve the white space.  If you...

Yeah, I'm aware it's going to be gone after the next release.

I'm currently working in a funny environment where most of the live SQL Servers are behind several firewalls and...

Thanks for the reply.  I guess I will just stick to using xp_readmail.  There's not much point writing a CLR procedure when xp_readmail will work - at least until SQL...

Nanda,

what part are you interested in knowing more about?

bcp is a command line utility that enables you to import or export sql server data to/from text files (or in the...

Tell me about it.

We've got a SQL Server 2005 testing environment and I've already being using that for this same XML solution.  The problem is that after using it in...

Thanks a lot.

That works perfectly.

That's perfect Remi. 

Exactly what I wanted.   I use the objectproperty function quite a bit and I didn't even think to look there...

I found the problem.  There is a permission called [View Definition].  I had to give my user [View Definition] permissions on every table in the database.

Now, a select * from...

I think I've found what the problem is.....

if the user does not have any permissions on the tables within the database, then information_schema.tables will not return any results.

I gave my...

Ok, so how do I give my user the rights to view all of the tables in the current database?

As it stands, my user can do:

use pubs

select * from information_schema.tables

The...

Ok, maybe I'm going about this the wrong way.

I want my user to be able to do a select * from information_schema.tables in a database so that the user can...

You could use two triggers, one insert and one update trigger.

Alternatively, check the deleted table if you want to see whether the record has been updated.

An update operation consists of...