Hello,

I also think that the ODBC source must be declared as System DSN.

There is also an error in your second T-SQL command:

EXEC sp_addlinkedsrvlogin

@rmtsrvname = '24sunix_se',

@userself = 'false',      <<<<<<<<-----must...

Yes, it's posible. You have to define a "Linked server". SQL Server Enterprise Manager-> <Your server> -> Security -> Linked Servers

You can use a working ODBC defined connection as the...

YEEESS! I've found the solution for my problem.

The problem was the level of compatibility of the database. It was set to Level 65 (because this database was started in SQL...

It is a user database.

select suser_sname():  sa

select user_name():     dbo

SURPRISE!

I've created a new database in the same server and there I have no problems!. I...

Product: SQL Server Standard Edition

Product Version: 8.00.878 (SP3)

No no, I can open the window for creating a new one, but when I click 'check syntax' or try to save, the same error appears!

Yes, the link appears, and I can click it, showing an empty list of UDF's.I can also rigth-click it to access the option for creating a new one...

I don't have any UDF, so in Enterprise Manager I can't see any UDF...

Still not working.

Thanks for responding.

It doesn't work. In fact, I tried to create the most simple UDF:

create function calc ( @i int)

returns int

as

RETURN(@i)

end

and it is still not working!

I'm sure I'm doing the things right, so I...

The problem appears when I want to create the function, I can't create it,  and I'm doing it as SA user.

Thank you very much, Antares686.

I updated my sql server to level 878 and the problem was solved. Now BE services run. Thanks for the links. (I hope no new problems arise)

I...

Thanks for the ideas. I'm still waiting for an email response from Veritas.

I don't really know how to uninstall the hotfix. Can you help me? How can i do it?

Thanks in...

Take a look at http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

JC