Hello Bill,

Please, connect to the link here, select the edition you would like to install and click a link for your edition for system requirements.

http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx

SQL Server 2005 System...

Rudy and  Sushila,

I would put it this way: ..Information has to be attended to...

The question is: in what format? 50 years ago there was no server concept, but there was...

Hi John,

Thanks so much for your reply. This query works great for the point of time. I also do need the MAX number of connections and the current number of...

I use cliconfg utility to configure aliases for both Named Pipes and TCP/IP. You may even do it from inside ODBC administrator. Then you can test both protocols by clicking Test Connection...

Hi,

Thanks all for the ideas and links, I checked these and forwarded to the developer. I also tested and told him that if he uses a dynamic string with the whole...

Yes, that exactly what I mean. One of the developers would like to pass several similar values as many as the user selects and then say:  where something in (value1,value2,value3...)...

I answered correctly, but decided to verify my choice in BOL. The Permissions topic says before listing permissions:

"The following describes the general conventions that are followed for naming permissions:"

So is...

Very good article and reviews!

Something like that?

sp_MSForEachDB @command1='PRINT''[?]''', @command2='USE [?] EXEC sp_spaceused'

Greg,

You can use Visual Studio Team Systems 2005 as a high-tech solution or you can use Visual Notepad for your code and store it in the file system. The key...

I usually get a good help for MS ACCESS on the website http://www.accessmonster.com

They have forums like us here where you can ask questions or just search the forums. I...

There could be 2 approaches:

1. Application has to check that the values that are to be inserted / updated are different from any of the existent rows, something like this:

If...

Hi,

to fix an event log:

http://www.microsoft.com/technet/prodtechnol/winxppro/support/logfilesbad.mspx

Fix Corrupt Event Log Files

One of the administrative tools in Microsoft Management Console, Event Viewer maintains logs about program, security, and...

It is you who runs a query from Query Analyzer, but it is someone else who is trying to connect from the website! And this person (he/she/it) most probably IUSR_ServerName...

Please, post the exact error message. Sometimes people say that login failed when the message is "SQL Server does not exist or access denied" which means that the app can...