Hi,

1. You should see Microsoft SQL SERVER 7.0 in Start-Programs

2. VERSION 7 in registry

3. open EM, click Microsoft SQL Server, right click in the right part of the window, open...

Hi,

try to check client tools of your users. Only EM from sql 2000 client tools can register named instance od SQL server.

Hi,

try stored ptocedure sp_dbfixedrolepermission

Hi,

try to exec simple query from Server A to Server B and reverse

(on ServerB: select * from ServerA.master.dbo.sysobjects,

on ServerA: select * from ServerB.master.dbo.sysobjects)

So you can check where is problem...

Hi,

yes, it's true. When you execute SQL profiler, you execute sql profiler procedures. Only sysadmin can execute profiler procedures (sp_trace_setstatus...).

Hi,

you can create a table with the same structure, initialized empty from existing one with

select * into TAB2 from TAB1 where 1=2  

but identity column will be also created

There is 0 in your result set.  And that is problem. You cannot use 0 in your query cast(cast({A} as varchar) as datetime)

try: select cast(cast(0 as varchar) as datetime)

and you'll get error.

hi,

try to set "Use Remote Collation" property of your linked server.

Hi,

i think you have problem with your data. Try query

select [service date] from [errormode detailed]

and check int value from [service date]. I hope you'll find int value which isn't in right format.

Job is running locally.