Thanks.

I was sure I'd tried that one, but what the.... it worked.

DavidB (3/10/2009)

---

The filelistonly function is so that you can see the contents of the backup file and then use that to build your restore statement. The restore syntax would be...

Transactional. OK.

I'll have a read up of that.

Perfect in theory, but Transaction only works on tables with indexes, which is why the GUID column is added by force to the...

Generally we don't.

Its the live enviornment. Yes, we've switched the dbadmin off again, but the supplier can't understand why the alter access is denied

I think they were just resizing nvarchar fields and the like.

Certainly had the rights for the database, but I personally didn't set these up.

Actually that's about what we found, when we fixed it.

The DTS had been written on one server, and the dbo seems to be different for that table (??)

When copied to...

So add it!

SOUNDEX doesn't cover, particularly, the typos angle that Bill seems to have concentrated on. Probably a lot better for the search results, given its sometimes 'strange' output.

Seriously though,...

I get your point, but doing the set doesn't work.

Sending the string from the code with '''' in does the trick though.

thanks

so, why is this failing?

cn_userlist 'public' , 'strsearch','','o''brien'

error:

Line 4: Incorrect syntax near 'brien'.

here's the sp.....

ALTER proc [dbo].[cn_userlist] @restrict varchar(100) , @view nvarchar(10),

@ffilter nvarchar(255),...

We've since worked out that it wasn't the SQL default, but the server default being still on US, even though the locale was on UK.

Had caused issues with installing .NET...

"Especially at work. You don't need a disaster like a hurricane, earthquake, or blizzard to disrupt operations. I worked in one place where a bagel burning in a toaster shut...

My starting point on these is always to use (classic ASP this)

on error resume next

...

if err.number 0 then response.write err.description

I'd be inclined to be more explicit on the final...

When you say it returns no data via asp, I assume you are using some error checking to make sure the returned data isn't actually an error (which would look...

not had the chance to, but will today!