i couldn't get your one example to work, because the data was malformed in your pasted example; it was missing two tags, so it was not valid xml; it was...

Ok the light came on with Marks' wildcard solution, thank you!

thanks, arthur, but that's kind of what's confusing me;

if i don't use the namespace, i get the desired results for the second item but not ht efirst; if i use...

nareshmsbi13 (5/8/2013)

---

I have execute my stored procedure using a select statement like

Exec SP where select * from view,wt is the finall out put of this query can some...

myself, specifically,...

db042188 (5/8/2013)

---

thx. How 'bout 64 bit ssis pkgs. Do they run with excel. I think you would know if you are running 64 bit ssis by seeing...

no it will not step on the existing drivers/installation, it forces a side by side install instead, so both the 32 bit and the 64 bit are installed and available...

there is a very similar issue when adding linked servers for Excel;

I tripped over this before , where Office 32 bit was installed on my server, and you get in...

ok here's a slightly modified version, showing exactly your problem, with a text field that must be converted;

i had to generate fake data, and assume a table structure, because you...

agreed, but if he auto generates an overlapping...

i f he's inserting into a constraint, and one of the new generated values happens to be the same as an existing value, i'd expect an error;

for example, just based...

yeah the server roles would need to be scripted as a separate step;

this is what I have saved in my snippets for doing exactly that, if it helps;

SELECT 'EXEC...

your xml was not well formed, so i couldn't use it as an example to show you:

you will have to convert(xml,YourTEXTColumn) to use this logic;

here's a couple of ways:

DECLARE @xml...

I'd recommend using MicroSoft's sp_help_revlogin instead; it simply produces a script you can run in a few seconds;

there's different versions, depending on SQL 2000 vs 2005 and up,...

for the filename stuff, somewhere abovee your code, you need to construct the filename:

declare @attachmentfilename varchar(100)

SET @attachmentfilename = REPLACE(CONVERT(VARCHAR,GETDATE(),101),'/','')

-- formats 05/07/2013 and removes slashes to 05072013

+ 'Attachement.xml'

...