Yah.

BOL says in Remarks to CREATE LOGIN :" A combination of CHECK_POLICY = OFF and CHECK_EXPIRATION = ON is not supported." See

http://msdn2.microsoft.com/en-us/library/ms189751.aspx

It would  be nice if they would mention...

Hi,

You may want to post a couple of your VB lines that call an SP including your concurrency settings, I mean, CursorType and LockType. Also, are you getting any error...

BOL says:

 If no server is specified, bcp connects to the default instance of SQL Server on the local computer. This option is required when executing bcp from a remote computer...

Hi,

It is probably because you are trying to run BCP not from the command prompt but from SQL Server. For example if you logged to SQL Server with SQL authentication...

I had an elegant solution once (not mine) when a DBA (THE DBA) created ONE job with MANY steps, each step corresponded each database. This job contained ActiveX script that...

I am not sure. I used BOL articles:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_trace_1nci.asp

and a couple of ones it refers to:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ta-tz_8h49.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ta-tz_1c4p.asp

The last one lists events so you can use only events that you...

Hi,

Use a workstation if you don't have servers!

Install Personal Edition or Developer Edition, select the appropriate collation, play with SP4 and uninstall whatever number of times you want!

Personal Edition is licensed as...

It Depends!

Actually it depends on application owner preference and application DRP (Disaster recovery Plan) requirements for each database. And also on recovery models of databases. And where to put...

I would change. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_runsetup_6nz9.asp

Read Unattened Installation Considerations for installing SP4 at

http://download.microsoft.com/download/1/b/d/1bdf5b78-584e-4de0-b36f-c44e06b0d2a3/ReadmeSql2k32sp4.htm#_unattended_installations

it says:

".......You must generate a separate setup.iss file for each combination of system configuration and installation settings...

Steve,

They have the expression in Russia that what is important is your participation not your result!

Thanks for sharing with us. Actually I liked 70-300 and 70-100 before it with the...

Either run a trace to audit log ins and log outs or create application functionality for particular application.

You do not have to download BOL. See the same article at

http://msdn2.microsoft.com/en-us/library/ms188388.aspx

It is on MSDN2 website as different from MSDN that we used to use.

Yelena

Is there a requirement that SQL Server should be 7?

Ask your developers. You can move 7 databases to SQL Server 2000, they are upgraded automatically with you are attaching 7...

I answered correctly because I think I already read about it somewhere. But I think that Stored Procedure that incorporates CREATE LOGIN statement would be much more appropriate for System...

Hi,

There are some things. I am not sure if it was fixed in SQL Server 2000, but in SQL Server 7 several years ago the job could not be executed...