The agent is a service, so you can monitor it using one of Windows resource kit utility SCLIST.EXE

you can use a batch file like:

sclist|find /i "SQLServerAgent"

IF %ERRORLEVEL% EQU 1 ECHO...

SQL 2005 (Yukon) now have a concept of schemas - . ie. objects not owned by dbo. It has also now a concept of synonyms. I believe schemas and synonyms are specified in...

sqlmaint.exe is run by the login running the services of SQLSERVERAGENT. Check the Windows Services and see who is running it.

More of the topic in:

http://www.nap.edu/readingroom/books/far/ch6.html

Without Codd's (http://www.wikipedia.org/wiki/Edgar_F._Codd)SQL, Ellison (http://www.wikipedia.org/wiki/Larry_Ellison) will not be flying his jets by now..

What do you think of his GRID computing?

...

Hi Paul,

Thanks for your idea. That might work...

However, I would be interested in col1 and not @string in your example.

declare @string table (col1 varchar(3))

declare @test-2 varchar(3)

insert into @string...

Thanks for all your replies. I use QA to run the test. I have a lot of SP's of this sort. I just realized this one day when the SP's...

In other words -- a tree walking ala Oracle syntax is required using the CONNECT BY...

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1168

says 'It can't be done?'...

So the correct answer is None of the above.

(The proposed solutions are all politically incorrect or non-ISO compliant.)

When you deliver an application for international usage (who doesn't?), the best approach...

Thank you Greg!

Great website as well!! I guess I will go with your solution.

Thank you also Andy.

Thanks Andy!

And I presume if it is disabled,

select * from sysobjects where name='d_delete' and xtype='tr' and status & 2048 = 1

what does the event log say?

If you run "tnsping ASTERIX" at the command prompt, what do you get? If you get an error,

check if your tnsnames.ora is ok.

A few topics...

1. Database Roles

2. Scripting Standards

3. Change Request Management

4. Source Control

No one should be able to modify the tables directly. Looks like everybody is sa or sysadmin.

You can...

The best book is BOL.

In SQL server 7, the code page must be set to 1256, the Arabic code page. In 2000, you can set the database collation to Arabic...

select name from sysobjects where type ='U'