Apologies.  This was really quite simple so I should have worked it out before posting the question.  I created a data-driven subscription which picks up the email address from a...

If you make sure that no collation settings are specified in the scripts that create the databases then they will use the default collation for the model database on that SQL Server...

DTS can do this for you in several ways.  One way would be to write a simple query to select the data and then export it to a text file.  You...

Ok thanks.  I thought that was probably the case, but I wondered whether there was a workaround.

Paul

Thanks Greg that's useful. I just thought that there might be an option within DTS that would do this automatically.

Paul

Thanks both. Results match mine but your way is obviously a lot quicker and neater. More practice needed on joins for me I think!

Paul

Problem solved. App. was calling another sp which incorrectly included a GRANT statement (no GO between sp and GRANT). This meant that every time user connected sp was...

No there are no deny permissions anywhwere. I have dropped and recreated the sp (with sysadmin rights) but this has had no effect.

Here is the situation:

Windows 2000 user added to domain Global group. Global group added to Local group on SQL Server. Local group added to a user-created db role....

Yes, I see now. Sorry for my lack of understanding. The one thing this method doesn't do that Jonathan's does is pick up multiple occurrences of the string...

I've got it working using a cursor (again using authors table) but I'm not sure it's exactly what you meant (still needed PATINDEX):

DECLARE @au_id varchar(30)

DECLARE @TextPointer varbinary(16)

DECLARE @ReplaceStr varchar(8000)

DECLARE @SearchStr...

SELECT TOP 1 certainly improved performance. Couldn't get it working using @offset for WHILE condition.

As for David's point about updating variable for each iteration, I'm not sure how this...

Perfect. Thanks Jonathan.

Paul

I had a very similar problem with a stored procedure. The server with the problem was subject to a sudden power outage. After this it would not use...

Thanks Andy.

Paul