Search results for query: *

Well I found the answer - I hope this helps someone... SET theTree.modify('replace value of (/tree[1]/branch[1]/@name) with sql:variable("@x")')

Hi I'm trying to insert an xml node containing a dynamically generated value in SQL Server 2005. Here's what I've got so far: declare @x nvarchar(100) set @x = 'abc123' UPDATE tbl_tree SET theTree.modify('replace value of (/tree[1]/branch[1]/@name) with @x') This doesn't work of course...

Thanks for your help Marc. Much appreciated.

Thanks Chris for taking the time to answer a noobs question. I understand the process much better now. Cheers, James

Marc Thanks for your reply. If it's impossible to do this without creating new accounts, then I don't understand why Exchange happily lets any use have numerous 'alias' email addresses and forwards them correctly to his/her mailbox. It seems that incoming mail (johnsmith@domain.com...

silentsam33 Thanks for your reply. In the Secuity tab, only a list of AD users is listed, so I am unable to select the appropriate email addresses. There is only one ADUC user called John Smith whose primary email address is johnsmith@domain.com. He does, however (in the same single account)...

Hi I have 3 interfaces on a PIX 515: 'inside', 'finance', 'sales' where the security priority (highest to lowest) is inside > finance > sales I'm using PDM and am not very comfortable with the command-line just yet so please keep your explanation simple! In the access list, there are 3...

I'm looking at the email address tab under AD > Users > John Smith > Properties and I've got johnsmith@domain.com set as Primary and the other 4 email address listed below it. I can't see where I would go to edit the mail send rights for these addresses. Should I be looking elsewhere? Many...

Hi We're using Exchange 2003 / Outlook 2003 via RPC over HTTPS. Could someone give me a bit of guidance in doing what I think should be something fairly simple... John Smith has default email address: johnsmith@domain.com He also other address such as certs@domain.com and orders@domain.com...

Hello all We are looking into creating a web-based interface that will allow us to create an Exchange 2003 account dynamically. The server is running Windows 2003. The idea is that a new user creates an email address, the system checks to see if it's valid/available for the and of so...

any thoughts? Thanks

Hello Here's a simplified diagram of our network: I'd like to be able to administer the switches remotely via ssh/http. Could I make each switch publicly visible and connect to them individually or should I connect to just a single master switch and user cluster management? If I use the...

I've been racking my brains for several days over this problem so I hope someone might be able to give me a nudge in the right direction. I have a simple sql 2000 table as below ID - StartDate - EndDate (table_1) 1 - 01/02/03 - 05/02/03 2 - 17/04/04 - 24/05/04 ... I need to look at ID=1...