Have you checked the default log file location where these files get created? Also, run select * from sys.traces and see under the path dispalyed in output of above query(path...

Make use of the following function:

IF IS_SRVROLEMEMBER ('sysadmin','loginname') = 1

print 'User''s login is a member of the sysadmin role'

else

print 'User''s login is not a...

Try scheduling job at some other time. Do one thing capture ping IP address results at the time when the ftp job executes so as to check whether there is...

Thanks guys, keep your views and points coming in. I also found one good link for information on licensing in Virtual envt.

http://www.microsoft.com/sql/howtobuy/virtualization.mspx

Hope someone find it useful too.

MJ

Make use of Datediff function and its input parameters like dd for day, mm for month etc.

MJ

Thanks Jerry. I will follow ur advice.

MJ

Have you tried running the code from query analyzer? Does it delete the files when ran from query analyzer?

MJ

Is agent account having enough privileges on backup folder namely Read/Write.

MJ

Check this out:

http://vyaskn.tripod.com/fn_get_sql.htm

MJ

Have you run DBCC UPDATEUSAGE ('DatabaseName') WITH Count_Rows after that?

MJ

You can't change the instance name.

HTH

MJ

In 2005 you have an advantage of checking it through DMVs too:

Query sys.dm_os_memory_clerks

This DMV will help to know how much memory SQL Server has allocated through AWE.

SELECT

SUM(awe_allocated_kb) /...

Thanks a ton Jerry.

MJ

Addition to what rajesh provided you:

Alter PROCEDURE create_DBFolders

AS

BEGIN

--Declare Variables

DECLARE @DBname VARCHAR(300)

DECLARE @Path VARCHAR(300)

DECLARE @backup VARCHAR(300)

--Get Directory Names

CREATE TABLE #DIR_NAMES ( DIRNAME VARCHAR(300))

INSERT INTO #DIR_NAMES exec xp_cmdshell...

It would be helpful if you turn on profiler and catch the code running against your server for temp tables creation and .....

MJ