Appreciate your help, but still got the same error when I tried to add maxval-minval to the 1st select.
I would have to add all columns to the group by ...

Thanks, but that just changes the value of the @@servername.

I uninstalled and installed SQL put in the correct instance name and am now good.

Thanks for your help

Susan

I have to follow a naming convention -

If I was able to connect to the SQL Server using the @@servername, it wouldn't be a problem.

But it only lets me...

I did read that article and it's just about the sp_addserver which changes the @@servername.

I didn't see a solution in there to change the serverproperty(servername).

I'm thinking I may have to...

Were you ever able to figure out how to let them VIEW (only) the procs?

We have migrated from SQL 2000 to SQL2008 they both have the datareader role but in...

In the article properties of the publication there is an option to 'do not delete replication'. Although I found in the past, you need to script out the publication and...

We are using the Idera SQL Diagnostic tool for various things.

One of them is to put the servers in 'Maintenance mode' prior to going into our maintenance window.

We have a...

Very nice. It was the compatibility level.

Thanks all for your help!

Susan

Yes, I took your advise and am doing the following -

USE msdb ;

GO

declare @dbname nvarchar(255)

set @dbname= (select +'P3_Lash_['+@@servername+']_Get_Blocking')

EXEC dbo.sp_update_jobstep

@job_name = @dbname,

@step_id...

Putrid Chicken (named by my ex for the way it looked the next day, but trust me its good)

4 chicken breast

2 can large cream of mushroom soup

4 cups of brocoli

1/2...

I once worked for a company that paid for you and your spouse to spend the weekend at Lake Tahoe @ the Embassey suites. He then hosted a huge party...

Originally born in Swindon UK, move to germany, Ireland then came to America and have been living in the silicon valley since... I'm a 44 year old 'female' DBA and...

I have been using this site for many years and do appreciate all the help I get. Thanks for your comments and help.

Susan

Great, thanks for the info

Susan

 As stated in my previous post below... I need to export the data from SQL Server so I can import it into a 3rd party software....

I was...