The most important question should be here about data synchronization. If it is designed to work as a disconnected client, what tools are provided for synchronization with the server databases?...

I am interested in the answer too.

I know the cluster with 2005 where IIS is not installed.

I normally too tell that IIS is a prerequisite because I don't want to do additional installations later. I ask...

Hi,

I don't know what is VDI logs but the very simple VB script can monitor the size of the file. This is the example of how to get a file...

IIS is not required. Some Web-related features may not be installed if IIS is not installed, but if you are planning this server only as a database server, it is...

SQLClient is part of the extended .NET Framework, installs as a prerequisite when SQL Server setup is ran or you can install it independently. Does not mean, you have SQL Server Client...

Did you add this account to SQL Server? Maybe it has to be added to the individual servers? Make sure what machine you are on. Recently we could not find...

Do you need to detect a server or a client?

for the server, look in the Services if there is SQL Server (MSSQLSERVER) service. In the Registry it will be as...

Hi,

did you use local or domain Windows account? Cluster can not access local accounts, you should be running on the Domain user account.

Adam,

What a good question!

I got it right, but I wonder: the message is Level 16. BOL says in "Database Engine Error Severities" that the correct answer happens with severity 19...

We do have exception handling in SQL 2005, so the handled Exception should be a correct answer provided a constraint is defined that Amount can not be less then Calling...

I would use Database Mail to send emails, or if you say you have Exchange, you may use SQL Mail. You may use email procedures run upon some events that...

Hans,

Your log is OK, Michael already explained to you that your telnet worked, so port 1433 that is indicated in the log is open and named pipes probably work. Check...

I have one project on Oracle and Linux where I am supposed to be a technical lead. This is a third-party application with vendor's support , so my actual knowledge...

Steve,

If you are going to London, could you bring me a signed picture of the Queen? This is talking about women in IT.