Actually the Name property is read-only. The second line will fail. See BOL

Server.Name Property :

Public ReadOnly Property Name() As String

Other lines...

Hi,

1. It is not recommended to alter system tables

2. You would probably want to rename the job anyway for the future suppportability. You would not want different jobs to be...

Paul,

Per your description it does look like locking, if it is only once in a while. maybe some other process accesses the table at the same time. Do use Current...

Chris,

I did not turn on C2, that is why I said Default Configuration. I just selected this event in Profiler and then changed the password. The record went into the trace....

Paul,

Could you clarify the following statement: "if I run select statements in QA all other tables respond - this table hangs. " It hangs in Query Analyzer all the times or...

Can someone confirm that we need -c startup parameter to get it started on through Service Control Manager?

I think I just used -m for single-user mode when I needed to...

The question was "Is there a way to determine the last time that a SQL Server 2000 login's password was changed?"

The so called "correct" answer was "No,...

Now, this is a correct way of doing that:  Since the question was to add SQL statements for something that is being run through ADODB toward MS ACCESS  I...

Frank,

Yes, you are right. I  was not looking for the theoretical books in my initial request because it was not for me.

But I myself and someone else I know will...

Hello,

Thanks to all for the advices, highly appreciated.

I myself read  "Inside Microsoft SQL Server 7" by Ron Soukup and Kalen Delaney when it...

Mauro,

Do I understand correctly that by  N'@MachineName@\ASPNET' you mean ASPNET account on SQL Server machine this time? I am afraid it may not work. Reasons: SQL Server works with SIDs...

Oh, well. It is there. Mode, I mean. Why I did not see it? Is it the time to change the monitor or finally pay attention to what one is...

Greg,

I think your questions may be answered by the Book Online article "Full-Text Search Recommendations" that is accessed by the Index -> Full-Text Catalogs ->Best Practices. Here is what they...

ASPNET account is a Local account. Local accounts could not be accessed from another computer.

Please, run your ASP.NET application in the security context of the domain account to get around...

Just tested this Win32_LoggedOnUser thing. Works well, shows me ALL sessions, not only interactive logon, but again, how you may be sure those people are using SA login from the...