When you ran a stored procedure on a remote heterogeneous data server, did you include full name of the stored procedure, such as [ServerName].[DBName].[Owneship].[StoredProcedure]?

You need sysadmin privilege to configure replication.

Our data in SQL Server may not be ordered based on the time to add them. If there is the ORDER clause in your queries, your retrieved data should be...

Here is my penny.

For the security: OPENQUERY is better.

For performance: I cannot see why necessarity of using OPENQUERY is faster than using linked server. Their only difference is the first...

Running out memory can be many reasons. We can run something like,

DBCC FREEPROCCACHE

Of course, the most efficient approach, but not allowable normally, is to reboot your server.

There are two main reasons for a database marked as suspect. Disk runs out of space and data corruption. Here are two links. Hopefully, they are helpful.

http://www.devx.com/vb2themax/Tip/18624

http://www.windowsitpro.com/Article/ArticleID/14047/14047.html

You did not mention how you restarted your server. If you turned off its power, or do something else without allowing your updates to rollback, your log file is damaged....

Could you failover your nodes? If not, your cluster is broken. You may have to rebuild your cluster.

Here is my penny.

In an active/passive cluster, SQL Server Services and SQLAgent Services on each node is set manually. You can add your script to sent alert when a service...

Did you check whether or not the database was set as autoshrink? If so, turn it off.

I would like to put my penny here.

NO_TRUNCATE means no truncate. No log is truncated in the process of log backup.

When a database is in the SIMPLE mode. No inactive...

By default, initial size of tempdb after restarting is 8 MB. However, if its size is set to different value, the initial size of tempdb after restarting will be the...

Here is one link.

http://www.databasejournal.com/features/mssql/article.php/3417651

More inputs will be welcome.

It seems that you did not post the most important part in your error message. A message with SQLSTATE 01000 is a warning one. To check its detail, you need to go...

The processes of saving/loading DTS packages can be easily carried out. What I would like to do are to schedule such saving/loading as scheduled jobs.

Thank you all for your kind inputs.