NP.. Good to know it worked!

YouTube may have some videos. But for this topic the duration of the video may be of few seconds 😉

Click on SSMS --> Help --> About. The first row in the screen mentions about the SSMS version.

Ensure the following

1. Excel file is on the server where you trying to import

2. Excel file does not have any spaces in it

3. Excel file has column names (first row)

4....

Use Perfmon instead. Here are some references.

http://knol.google.com/k/sql-server-performance-monitoring-with-perfmon#

http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

http://searchsqlserver.techtarget.com/SQL-Server-PerfMon-counters-for-tracking-Windows-memory

What is the version of SQL Server 2005. It seems to have resolved in SP1. Read on here[/url]

Check if the SQL Agent service account has privileges on the batch file's folder. Check if the sqlcmd's folder is present in the Server's environment variable. If not try using...

Right click on an existing job and select "Script job as". This will create the script for you. You may use this script as an example and do the changes...

From the error message it is clear SSMS is still running on SQL Server 2005 SP2. Please upgrade the client components to SP3

How big is model database Transaction Log file?

If you have space on the other drive please take the transaction log backup using

BACKUP LOG model TO DISK ='[DriveName]:\Filename

Then issue DBCC...

Use SQL Server Configuration Manager to change the service account password. It will take care of the rest. You may find this discussion useful.

In SQL Server 2008 a new feature has been added to ignore databases which are not online in Maintenance Plans. More details here.

ASAIK, there is no such provision in SQL...

Check if executing this query on the source server helps

ALTER SERVICE MASTER KEY FORCE REGENERATE

More information on this command here

Googling gave me with many options. Here are two of them

http://www.dotnetfunda.com/articles/article27.aspx

http://support.microsoft.com/kb/316549

Well done SSC! Kudos to all who have contributed to this site and helped innumerable people