Changing permissions on a folder is done from within Windows. You can use the Windows Explorer and open the properties of the folder. Use the security tab to add accounts...

It looks like the folder 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\IPE_OCT_120_log' doesn't exist or the SQL service account doesn't have read/write access to that folder.

To get a list of users without a lead, you'll have to change the INNER JOIN to a LEFT OUTER JOIN. You'll also need to change the join-criteria to accept...

Take a look at the following links to get a file list:

http://www.patrickkeisler.com/2012/11/how-to-use-xpdirtree-to-list-all-files.html

Uses a undocumented feature that could be changed/removed by Microsoft without notice!!

http://oakdome.com/programming/SQL_FileListing.php

Uses the XP_CMDSHELL extended stored procedure and could...

Add a new first step to the job to check if the table exisits and only create it if it doesn't exist yet.

Change the command to read the trace from...

And what is the error message when the steps fail?

If you can't find the error message, execute the command "select * from ::fn_trace_gettable('C:BWP_test\T.trc', default)" from a SSMS query window...

nivedita talukdar (6/23/2013)As suggested I'm using this:

USE AdventureWorks;

GO

SELECT * INTO temp_trc

FROM fn_trace_gettable('c:\temp\mytrace.trc', default);

GO

But this doesn't copy or load all the .trc files...instead just does it for the first file and...

When restoring a backup, the default setting will be to place the data- and log-files to the same location as from the database the backup was taken from. So if...

Take a look at the name of the database under option "Default database" in the properties of the LOGIN. This database is probably deleted or offline or the user doesn't...

If you have setup the trace using rollover files including a max number of files to use, you will have to read the first file before the rollover reaches the...

Please forgive me if you take it personally. I didn't mean to offend you, just making a warning sign about...

You can use the various [dbo].[backup%] tables in the MSDB database to see when backups are made and all other info about the backups.

You can use the [dbo].[sysjobhistory] table to...

You need to build some logic into the Agent jobstep to check if the trace is allready running. If the trace definition doesn't exist you need to create and start...

Because SQLCMD is a commandprompt utility it can be used to automate actions. Consider a scenario in which you need to execute 50 different scriptfiles to update an application database.

-...

The default trace template "Standard (default)" cannot be used to replay the actions. You should create a new trace and select the "TSQL_Replay" trace template.