See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=13830&FORUM_ID=5&CAT_ID=1&Topic_Title=startup+procedure+listing&Forum_Title=Administration

You can try:

use master

select name from sysobjects where objectproperty(id, 'ExecIsStartup') = 1

I am more for turning it off and, if there's a particular need for it, using a scheduled profiler trace to gather the required successful login info. A trace...

You seem to want to empower the users with all security (but not system/server) admin abilities. Why not grant them SECURITYADMIN rather than SYSADMIN?

In Enterprise Manager try editing the job properties and changing the owner to sa.

Try:

SELECT ISNULL(basesoftwarename,N'') + ISNULL(basesoftwareversion,N'') AS Software from tblsware

IMHO, go to SQL2000 now. SQL7 to SQL2000 is a relatively pain-free exercise, and you'll learn quite a lot as you go. When Yukon comes along you'll be...

I agree. Turn it off. Enterprise Manager, right click on the server, Properties, Security tab, Audit Level.... change to failure.

You need to restart SQL Server.

Kevin,

I personally haven't had any problems with Remote QUERY Timeout set to zero on SQL 7.0 or SQL 2000. But I have had problems with Remote LOGIN Timeout set...

I often use textcopy.exe which ships with SQL Server.

I often use textcopy.exe which ships with SQL Server.

That's a good solution provided the existing data doesn't change. Also, from experience, you'll need some smarts in your summarization SP to look for days that may have been...

Parker77,

I suspect you want to automate the process rather than relying on the interactive wizard. Is that right?

I don't have a "script the lot" example, but a starting point...

You're out of luck sorry.

You'll need to restore the database somewhere else and extract the table you need, then move it into the live database.

I usually start with RPC:Completed and SQL:BatchCompleted, and get more detailed thereafter only if necessary.