Another option for SQL 7.0/2000...

Log Explorer can be configured to save login session information to a table in a database which you specify. I believe it uses Trace functions...

Depending on what you trying to accomplish, I don't think SQL Server Profiler is the best choice of tools. If all you are only interested in is some statistics...

You can specify either hostname or IP address comma port number in Query Analzyer and Enterprise Manager.

Perhaps it's some type of firewall rule try either:

myserver.mydomain.com,myportnum

or ipaddress,myportnum

One method I regularly use -- I have a database called DBObjCopy on each server. When I need to do an ad hoc backup of a table I'll simply...

As far as getting the parameter names and datatypes you could just select from information_schema.parameters rather than query the system tables directly.

Expanding on the SQL job concept, rather than changing the table owner to a user other than dbo. You could give the user permission to execute only one job...

I posted a script which scripts out all remote/linked servers with all settings.

http://www.sqlservercentral.com/scripts/contributions/620.asp

Listing SQL Server databases in Activie Directory is only useful if applications are developed to take advantage of it. Microsoft White Paper "Integrating Applications with Windows 2000 and Active Directory"*...

If you don't have the $$, ICT Database Designer provides the same basic functionality as Viso, but it's free.

http://www.ict-computing.com/