On the box itself, you can get a command-line interface by using osql.exe (isql.exe doesn't come part of MSDE). Alternately, you can access the box using Query Analyzer as you...

Another option is to set an IPSec policy and block TCP 1433 coming in to that one IP.

If you go with IP Filtering from the network properties, you end...

Rights are additive with the exception of if there is a DENY in there. DENY is a trump. For instance, if you have a user who is a member of...

Within the same database, ownership chains work so long as you don't switch owners. For instance, if View1 refers to Table1 and they have the same owner, the ownership chain...

If you're still listening on the standard port (TCP 1433), this article should be all you need. Otherwise, modify the port # based on what you are using:

http://support.microsoft.com/default.aspx?scid=kb;en-us;287932

K. Brian Kelley

http://www.truthsolutions.com/

Author:...

Like Antares and Andy, I've been on this site for a while and have a large number of posts (though the number pales in comparison to theirs). I've not had...

If you right-click on the job, you'll get a pop-up menu. Select View Job History. This should give you a list of all the times the job has run, how...

Check the created job under SQL Server Agent and verify the schedule.

In EM:

Management | SQL Server Agent | Jobs

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance...

See my post above for setting the password after you've got it installed. This is something you will want to do, learning purposes or not.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish...

Are you on SP2 or SP3? If not, the following article might apply:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306401

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

I wouldn't turn a folder off by default. The reason is that if you do, then a virus that gets put in that folder will be undetected.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start...

If you have the memory configuration for SQL Server set to dynamic, it will continue to expand to use as much memory as possible. Remember, it's going to try and...

Just a clarification:

SQL Spida (SQL Snake, etc) and the worm before it hit blank sa passwords.

SQL Slammer goes after the SQL Server listener service on UDP/1434. It doesn't care about...

If you already have MSDE installed, use any of the client tools to connect to it (isql, osql, isqlw) and execute the following query:

EXEC sp_password @loginame = 'sa', @new =...

Yes. You can use SQL Profiler to do this. Profiler gives you the ability to capture all the events going to your SQL Server. You can filter the events as...