David

Never give a user db_owner access - not if it's your job on the line when it goes wrong.

First, I would question why an application user needs to create...

Anyone who doesn't need it.  And I would think that includes everybody except DBAs and developers.

John

Daniela

You can use the following T-SQL to generate the T-SQL to disconnect the logins.  Or, if you want to do it all in one batch, you can use a cursor.

John

create...

Tony

How about:

select colname where colname <> dbo.uf_stripnonalpha(colname)

from table

John

That would be easier.  But bear in mind that any indexes you have on colname would not be used.

John

Tony

How about creating a view (indexed if necessary) that shows the name column with all non-alphabetic characters stripped from the end?  Then you can do a select distinct against the view.

John

I would guess that, since the task starts but appears to abort in the middle, the process is either running out of disk space resource somewhere or being interrupted by...

Grant

I would consider the following:

(1) Set OutputVerboseLevel=0, unless you need to do any debugging.  The default is 2 and this is probably wasting resources logging error messages and progress reports.

(2)...

Have you tried deleting the article that corresponds to the table with the new column and recreating it?  After that you will probably need to repeat steps 2 and 3...

Steve

The temp table (if prefixed by # rather than ##) is only visible to the connection that created it and is dropped when that connection ends.  If you run the...

Fintan

Not sure what you're asking here.  If you're wondering how to save the results of a query to an Excel spreadsheet, then what I would do is create a view...

Norry

I think that's about the size of it.

John

Graeme

I see.  In that case I would get all users off before the daily update, then create the new subscription after the update.

John

Norry

When I say "on trust", I mean that Microsoft just trusts you to enter the right information in the licensing box.

I think I'm right in saying that if you want...

Graeme

Yes, that option is disabled on my publication as well.  Don't know whether that's because you can only enable that when you create the publication.

Have you tried restoring the database...