This could be done using a batch file and calling out to SQLCMD. However, you would have to get that installed on each client's desktop.

You could also use a...

I believe SQL Server will no longer be available - or, at least it will have problems.

Not that I have had multiple files on separate LUNs where I lost one...

Sergiy (5/12/2011)

---

You may wish to use sp_makewebtask to build an HTML file from your query.

Then you may send that file as a message body.

Not sure if xp_smtp_sendmail can do this,...

The real issue here is that moving the criteria for TableA to the ON clause for the join changes what you are asking SQL Server.

In the first query, you are...

Tara-1044200 (5/10/2011)

---

I would like to explain the problem in another way..

Lets say the account(windows) i am using which is in problem is "OBBEAVER\SQLBAY2" and sql agent service run with this...

Do you have auto create statistics enabled? Is Auto Update Statistics enabled? And finally, is Auto Update Statistics asynchronously enabled?

I'm thinking that maybe the system is running into...

It really does not sound like a problem with the database. I would be leaning toward an issue with the way the VM's have been created. You could...

Yes - sorry, missed that part. Looking further at the message, do you have the maintenance plan setup to create a report?

This is configured using the little button next...

Syed Jahanzaib Bin hassan (5/10/2011)

---

First shrink the database to release the space for Operating System at free work hours and truncate the size of log ,then this process will release...

Yes - it is possible. How you go about setting it up depends on how the domains are configured. If the domains are fully trusted - there shouldn't...

That option is one of the settings that is used to generate an execution plan. So, if you have it on for one connection and off for a different...

I will say it again - look at the maintenance plan history and not the job history for better information about the error.

Right-click on the maintenance plan and View History.

Well, first I do not know of any way to prevent ODBC connections to a database system and still allow an application to connect.

With that said, just because a user...

That looks like the job history - check the maintenance plan history instead. It should show you why that specific task failed.

Now, not sure why you would perform rolling...

This is the code I use to track backups and restores:

Select r.command

, s.text

, r.start_time

...