also see "registering servers" In Books Online, and check out "How to register a server (Enterprise Manager)

try add a new group, then highlight the group name, right click and select "New SQL Server Registration" and then you're away

hope this helps

Paul

is the database in use ?

hi,

that's fine, so say OK, and the install will continue, allowing you to install the client tools .

hope this helps

Paul

hi,

if your server is case-sensitive then your where clause will only find rows that match "DEFAULT". If your server is case-insensitive then use one of the solutions from the...

hi, if you look in Books Online , synonyms is to do with English Query. Have a look and see if this helps !

Paul

hi Terry,

can you not just set the maintenance job to log directly to the windows event log (on the notifications tab, set it to write to the event log on...

Terry,

Is someone changing a database recovery mode an "error" as far as SQL is concerned? It's obviously a mistake on someones part, but i don't think you can raise...

hi again,

this also might benefit from being posted in another forum, maybe SQL Server 7.0/2000 T-SQL.

Paul

hi,

do you have a particular table in mind ? if so post the DDL and i'm sure someone can help you out

Thanks

Paul

hi Harry,

the select to replace the words is quite straightforward :-

select replace(replace(lower(T1.T1A), lower(T2.T2A),""), "  ", " ")

from table1 T1, table2 T2

where lower(T1.T1A) like "%" + lower(T2.T2A) + "%"

i've used table1...

hi,

can you let us know what the criteria for setting the flag to 1 or 0 is ? Then we'll probably be able to help . it looks like...

JK,

It's something i found in a system stored procedure years ago, and it was used to format output. I'm not sure what it does exactly, i just know that it's...

hi,

 try using convert(char(1),0x0a) instead of Char(13).

select 'A' + convert(char(1),0x0a) + 'B'

returns :-

----

A

B

hope this helps

Paul

I agree, where they are stored depends on several factors, and that isn't one of the answers.