Yes this user should be able to run only sql jobs (any jobs; not only his own) and nothing else.

-lk

With sqlagentuserrole, I can't even see the jobs from any other user 🙁

Thanks Mark.

-LK

Is this true that it uses the cpu which has less load?

My bad.

It means object id can never be null.

Yes I need to use the same installation which I have in my named installation on the same m\c.

-lk

Thanks.

Can you tell me what is the correct way of reinitialization? I set up snapshot replication. Now I had to drop one artilce from replication. But even after reinitialization...

Awesome example Adi. Thanks

-lk

Yes Silverfox,

There is a book titled "MCTS Microsoft SQL Server 2005 Implementation and Maintenance Study Guide Exam 70-431 (2006)". Here TABLE 1 . 3

"Developer/Standard/Enterprise Edition Requirements" says that 32 bit...

I am installing sql server 2005.

Silverfox, sql server enterprise edition can be installed on windows xp as well.

I am a bit concerned here with my cpu. Can anyone reply...

Adi here is one twist according to BOL:

"Because the leaf level of a clustered index and the data pages are the same by definition, creating a clustered index and using...

Yes Paul. This helped.

-lk

this is resolved. Thanks

I have also verified that this information is not captured in the sql server errorlog.

-LK

Do you mean nchar(1) ---> 1 doesn't signifie one byte but one unicode character.

-lk