Did you check whether or not your replication works? Replication can hold the logs so that you cannot truncate them.

Did you check whether or not your replication works? Replication can hold the logs so that you cannot truncate them.

It is saved in msdb. What I would like to know is how to retrieve the date the packages were modified.

Here are my two cents.

You can check your errorlog to check whether or not you can catch any activities.

Whether or not you need to shrink tempdb depends on your...

What MS Access version do you use? Please check the compatibility of provider to the version of MS access.

I would like to say, it would not help. As far as I know, only putting objects (or files) in different physical drives or raid would help.

You may try to start from the stored procedure, sp_msforeachdb

What if we enforce two instances to have the same port number? That is what I mean in my original post, "have to". I know it is a stupid question....

Here is my cent. Check your error log. It may be the roll back/forward. If so, you may not have other choice.

temporay tables should be removed when a session is disconnected for local temporary table or the last connect is disconnected for global table. If you use a user table as...

I would like to say it is an error in your stored procedure. The error can be either syntax error or logical error.

I would not like to say the server would be happy. But it should be ok. You need to do some baby-sitting work after replacing the system databases, such as...

I guess it is a built-in data type issue (bug). After running update statistics against each table, did it happen again if you try to run sp_updatestats?

You may miss the parameter, @provider = 'provider', in executing your sp_addlinkedserver procedure.

In my memory, you should use MSDASQL for linking SQL 2000, and SQLOLEDB for SQL 2005. Please double...

Thank you for your input. The article you introduced is for transferring all logins on a server. What I would like to do is to transfer logins only related to...