Hiccup in the  script...

select servername, serverproperty('productversion'), serverproperty('productlevel'), serverproperty('edition')

 from #t where ServerName like     @Match     and

                                                  ServerName not like @NotMatch1 and

                                                  ServerName not like @NotMatch2 group by ServerName order by...

Done...thank you Gail!!

Took me about 15 mins to work out where the Select should go...I really am not into scripting!!

Jaybee.

Getting there, what I need is:

ServerName     Version

--------------------------------------------------------------------

Server 1           Enterprise Edition

Server 2           Personal Edition

Server 3 etc....

Did that at the start - nothing.

Neither one.  The Login existed long before I joined this company a few months ago, and I only created the DB yesterday.

Here's the proof:

exec sp_adduser 'OurDomain\OurNTLocalGroup'

Server: Msg 15007, Level...

Hi John,

Didn't work.  Went into EM and deleted the  OurNTLocalGroup user.  No difference, it still says,

"Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line 33

The login 'OurDomain\OurNTLocalGroup' does...

Thanks for the help, a few newbie-to-replication questions though:

"Hi,

This means that your distribution agents were blocked somehow. Either by each other"

Do you mean the distribution agent at the other...

I am tempted to put a clustered index on the table but there's a time limit on all this; I'll wait for a code-based solution, or I'll try the Index...

Trying it now....31 minutes and counting.

I should add that this is ad hoc reporting, so no Stored Proc. The exe plan states that a table scan on tblcommunicationsSent is...

Perhaps some way to get distinct accountID's from a nested select?

Well, 'tblcommunicationsSent' has 5.5 million rows....

Thanks!  That worked perfectly, the From/InnerJoin/Where statements are static and don't change.  The functions and tables hold the correct data, and the result set was a perfect mathematic match.

There's...

Hi,

I didn't write the query, I just want it changed (or split across multiple queries) to extract the needed data.

You can leave the averaging question, I have that licked now.

For...

Dunning runs and CDR's???