What about the rest of the columns? Do you still want all of those? You're grouping by all the columns and some of those columns have different values so you'll...

This should get you started..

declare @strSQL varchar(max)

declare @viewName varchar(255)

declare listViews cursor for

select name from sys.views

open listViews

fetch next from listViews into @viewName

while @@fetch_status = 0

begin

set @strSQL = 'select top 1 *...

I neglected to mention that all our replications are set up with a SQL Server login. I think you may be on to something there...

I always thought that the Agent Job owner was the owner of the distribution. There's the agent security agent but I'm not sure that's the owner.

something along the lines of...

Declare @assignTo nvarchar(4000)

select @assignTo = Coalesce(@assignTo + ', ', '') + CAST(Name as nvarchar(250))

from

table2 ...

The only thing I'd recommend is what I would do.. find someone else that CAN get information about the publication and see what the differences are between my account and...

Do you own the publications you're trying to get information on?

For XML Path is not supported in sql 2000.

That Parsename always sneaks up on me..

Take a look at this article by Jeff Moden.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

My co-worker and I were discussing this yesterday for deparmental low-volume databases and came to the same conclusion about the virtualization needing to align with the actual hardware of the...

Booyah, Lowell! You hit it. I forgot to define the size of my stored proc variables.

Good catch!

Nevermind. I misread the query.

If your custom phrase is static you can use:

select letter from @test1 order by (case letter when 'd' then 1 when 'c' then 2 when 'b' then 3 when 'a'...

Something like this maybe?

select letter from

(select 'a' letter

union

select 'b' letter

union

select 'c' letter

union

select 'd' letter

union

select 'e' letter)source

order by (case letter when 'd' then 1when 'c' then 2 when 'b'...