Server Network Utility is not present on the Start Menu for MSDE. Don't know why Microsoft didn't do that. Look for svrnetcn.exe. That's the Server Network Utility. You can configure...

They can interrogate the services themselves. The display names:

SQL Server 2000 default instances run under:

 MSSQLSERVER

SQL Server 2005 default instances run under:

 SQL Server (MSSQLServer) 

SQL Server 2000 Named Instances:

...

The default TCP ports aren't the same... SQL Server is 1433 and MySQL is 3306. But yes, they can run together. If you are limited on memory you may have...

What it likely means is some process had temporarily grabbed 1433 when the server restarted. As a result, SQL Server wasn't able to fully setup listening on 1433. The restart...

The only issue with that level of permissions is db_ddladmin has access to create and alter any objects within the database.

Also, when using a client to connect to SQL Server, use the comma (,) and not the colon ( to distinguish port, if you...

You should be seeing a local address of 0.0.0.0:1433 and listening, unless this is a virtual node on a cluster, in which case you'd see the IP address for the...

Yes, indeed. This is something which I try to get developers to understand sitting in an infrastructure architect position. If you don't design security in at the start, retrofitting security...

Are you able to make a connection to the SQL Server using <server name>,<port number>? When you run a netstat -an on the SQL Server, do you see it listening...

Hrm. I just ran a test. Is the user the owner of the table? If not, I'm getting the following error when I run the test:

Server: Msg 8104, Level...

Are you specifying the owner? If the user does not own the table or view which BULK INSERT is being executed against and the owner isn't specified, BULK INSERT will...

All xp_sqlmaint does is call the sqlmaint.exe utility and passed the string to it on the command line. Since sqlmaint.exe is a console application, it handles command line parameters like...

Two that will cost but are decent:

http://www.microsoftelearning.com

Microsoft eLearning has courses which are relatively inexpensive that introduces you to SQL Server 2005. They used to be free,...

No database is. The record of backups can be found in msdb. However, no database controls backups on any other database.

1500K = 1500 * 1024 = 1,536,000 posts. Remi, how do you have time for anything else (including sleep)? Yes, yes, I know...