Here is my input.

I do not think we have a clear cut on your questions.

Generally speaking, when there are many users and objects are huge, we may need to use...

Here is a link discussing this issue recently on this forum.

http://www.sqlservercentral.com/Forums/Topic444033-110-1.aspx#bm447199

Sure, you can. You need to use the virtual IP address for SQL instance. To find it, you can go to the cluster administrator on the cluster.

I agree with donpolix. Just try to avoid all of them run at the same time. It may produce a lot of performance issues.

Here is my input.

It is really a case-by-case issue. In a very small company, a DBA may take care of everything.

Generally speaking, a DBA should be out of it....

This server is relative old. For some reasons, its name was modified by someone. As a result, any job created before this rename could not not be modified without some...

Create a connection in your DTS package designer. Then, use it to connect to the server.

Here are my inputs

1) To calculate these fields dynamically while displaying them on the User interface and not save in DB (while making reports, again calculate these fields dynamically and...

The error message did not show you have any permission issue but the validation of your stored procedure name. You may check it.

Here are my cents.

Error during initialization for the provider comes from one of many sources.

Incorrect login/password

Incorrect database name

Incorrect ODBC version

...

These are what are in my mind. Did you check them?

Check the login security of the account. Then, you may try to stop the SQL State Polling.

From EM, click Tools\Options. You can find it there.

Did you try to use MS Access or other reporting services?

Here is my cent if it is possible for you.

Backup your database, and restore it in a different name, then see whether or not the error is gone.

It is most likely a data type mismatch issue. You may check the data types in your application and SQL Server.

Here is a link, wishing them helpful.

http://msdn2.microsoft.com/en-us/library/aa937592(SQL.80).aspx

Here are my two cents.

1) Will the trigger of table 'B' be executed while I am updating the Table 'A'? Does this avoid recursive action ?

It depends which column fires...