David (11/12/2007)

---

Hi Andras,

The jobs are all other data related; I am distinguishing them from all other jobs by giving them a specific job category type. I did have a very,...

Have a look at http://msdn2.microsoft.com/en-us/library/ms178067.aspx and http://msdn2.microsoft.com/en-us/library/ms191303.aspx

Regards,

Andras

From sql this is not a very simple task. We use a parser to analyze store procedure text and then determine the referenced objects like stored procedures. But this is...

One way of doing this is to use the Service Broker in SQL Server 2005. Set up a queue in it, and a stored procedure on this queue. (see create...

The compact edition supports the information_schema, so you can...

Roy's link is the solution that you could use for the above. Just to include the solution here too:

On 2000 when you create the stored procedure in the master...

Yes you can do this for transactional and snapshot replication, but not for merge. You can read more about the cross version support of replications in Books Online in the...

A differential backup saves only the pages since the last full backup. If many pages have changed you can get a very large differential backup. If there was little user...

do a self join

select t1.key, t1.name, t2.name from mytable t1 join mytable t2 on t1.key=t2.key

where t1.name<t2.name -- to avoid duplicates

(the < is used instead of != to avoid duplicates)

Regards,

...

Is there such a reason?

you may want to read http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticesnotusingprimarykeysandclusteredindex/488/

Regards,

Andras

You can do this if you set the database to trustworthy and the assembly to unsafe:

ALTER DATABASE myDatabase SET TRUSTWORTHY ON

alter/create assembly .... WITH PERMISSION_SET = UNSAFE

(note that both of...

vbourdages (11/6/2007)

---

So I can ONLY see my process when I expect to see all the process...

So the Execute as 'dbo' don't work like it should... do you have an idea...

Your XML sample did not make it. (you need to escape the < with < )

Concerning accessing attributes you can do this with the @ sign like:

OPENXML(@iDoc, '//a:category', 1)

WITH (

...

Indexed views will persist the result of the view (as if it were a table). Assuming that the archive table is large, and the view is literally just the union...

Databases work with sets/bags. There is no guarantee that the order in which you insert data into a table is the order in which you will get it back. What...