Yes you can. It can be something like

exec xp_cmdShell 'del @File /Q'

/Q= Quiet mode, do not ask if ok to delete on global wildcard

There is no such rule as to whether CHECKDB or REBUILD should run first. Based on your requirements, those jobs can run in any order.

You cannot edit the Mail Content of the one sent by the Native Maintenance Task.

You can create your own SSIS Package and include Mail Task, in which you can...

You can use the Profiler tool to capture this information.

In "Event Selection" click "Show All events" and select "Audit Login Failed".

In-place upgrade is usually the better option. However, ensure to have good backups.

If the drive "Z" is still available, try to copy the contents of the DVD to the location specified in the error message

It can be achieved using the same logic. Here is an example

EXEC SP_MSFOREACHDB @COMMAND1 ='use [?]

if db_name()like ''%temp%''

begin

exec sp_helpfile

end

'

As seen in Wikipedia

The only known difference between .cmd and .bat file processing is that in a .cmd file the ERRORLEVEL variable changes even on a successful command that...

You can create a stored procedure for this code and use sp_MSforeachdb to execute it against each database.

Example:

EXEC SP_MSFOREACHDB @COMMAND1 ='SELECT DB_NAME(),DATABASEPROPERTYEX([?],'IsAutoClose''

I feel VARCHAR would suite this.

You may find the "Finding Specific Events Within a Trace" section in this article useful.

Check if the remote connections are enabled or not.

This article explains how to configure it.

Any FULL backup operation will complete in such a way that when it is restored the Database will be in a consistent state.

This article by Paul Randal explains it...

$partacu$ (7/24/2010)

---

Hi all,

When I try to start the SQL server using the following command I continuosly get login error from application logins in the command prompt:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe -m

This...

In sysprocesses, one SPID can have multiple OS threads (KPID). Yes, the SPID for which one of the threads is consuming more CPU is the cause for CPU spike.

You...