This query worked fine for me. Please confirm if you are connected to a SQL Server 2008 instance.

This is the query I use to get job information.

SELECT Convert(varchar(20),SERVERPROPERTY('ServerName')) AS ServerName,

j.name AS job_name,

CASE j.enabled WHEN 1 THEN 'Enabled' Else 'Disabled' END AS job_status,

CASE jh.run_status WHEN 0 THEN 'Error...

Senthil,

You get this error when you try to restore Transaction Log\ Differential backups without restoring the FULL backup of the database. First you restore the FULL backpup WITH NORECOVERY and...

Recreating the Maintenance Plan should always be the last option. Let us try all other options before getting to that conclusion 😉

To troubleshoot network related issues start with the below command (run it for some time from the app pointing to the DB server) and see if there are any "Request...

Add an output file to the job step. That will give more information about the job failure.

It is not recommended to run Profiler trace on a Production instance. Instead run a server side trace using as appropriate. An example here[/url]

UPDATE STATISTICS is a logged operation. However it should not make the transaction log to a huge size unless the table itself is too huge

and F8 to hide the Object Explorer window. I am not aware of any settings to change the size of a query window

Check if the "Casing for built-in function names" option (under Tools --> Text Editor --> Transact-SQL --> IntelliSense) is what you need

ranganathan.arumugham (10/22/2010)

How can we solve the issue of Error: Access is denied while writing output using sqlcmd in xp_cmdshell.

Exact ERROR: Sqlcmd: Error: Error occurred while opening or operating on file...

These articles should help you to decide it.

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

http://msdn.microsoft.com/en-us/library/ms191543.aspx

The below query will give you the list of jobs owned by the Service Account.

select a.name,b.name

from msdb..sysjobs a, master..syslogins b

where a.owner_sid=b.sid

and b.name='YourServiceAccountName'

The linked server can be scripted to a new query by right clicking on the linked server. You may execute this script on the destination instance.

Hope I understood your question...

Try using (local) or . (period) as the Server Name instead of LocalHost