There is an option in the Maintenance Plan Wizard that will allow you to specify backup retention.  Setting this option will remove old files for you.

You will not need to use a temp table.  This will work:

CREATE TABLE T1A (TextColumn varchar(1000))

CREATE TABLE T2A (TextColumn varchar(1000))

INSERT INTO T1A

SELECT 'This is a text' UNION ALL

SELECT 'And this...

Hasan,

You should create a new post for your question.  It is more likely to get answered in its own post since it is a new question.

What you are seeing is normal.  When you have 2GB allocated to SQL Server, it will allocate most of it for the buffer pool, but it will also reserve around...

If this is a scheduled job, there should be more information in the job history.  Check there and in the SQL and application logs for error messages.  What account is...

I guess I got away from what he'd originally stated about the stored procedure running for more than 30 seconds.  Yelena is correct, look at the stored procedure code.  If...

It looks like those counters have more to do with activity.  Watching them could over a period of time could tell you how active your network card is.  You may...

A timeout expired error could be a number of things, network included.  The error means just what it says, there is a timeout occuring either in the database, session, or...

In order to compare 2 database backups, you must restore both of them.  Enterprise manager will not compare databases for you.  There many third party tools that will do this...

If the Unique Identifier column does not allow nulls, you need to insert a value. 

Insert into DirectoryHierarchy(directoryId,ParentDN,RDN,Type)

select NEWID() as DirectoryID, ParentDN, (FirstName + ' ' + LastName) as RDN,...

Has this plan ever worked before?  This looks like a permissions problem.  Do you have your SQL Server service running under the system account or a local or domain account...

I would recommend creating the index, but not removing the BEGIN TRAN keyword.  As Colins stated, transactions are best made small and quick.  I do not feel that removing the...

Yes, however, if you wish to overwrite your backup file each day, you will need to set your RETAINDAYS to zero or 1.

You need to set the ExpireDate/RetainDays.  From Backup in BOL:

If EXPIREDATE or RETAINDAYS is not specified, expiration is determined by the media retention configuration setting of sp_configure. These options only prevent...

SQL Server is telling you that you have a physical inconsistancy in your data file.  You must restore from backup (or rebuild in your case).  Read TORN_PAGE_DETECTION in BOL.  There...