You welcome

Your Proliant DL385 should have HP System Tools installed on it. If it doesn’t, go to HP web site and download it. Then run Array Configuration Utility and...

With RAID 1, when you have a HD failure, the other HD continues to function as a single drive until the failed drive is replaced. What you need to do...

Under database\security\users go to Securables. Add stored procedure you need and grant execute permmision for the user.

try this one

declare @Start_time datetime

declare @End_TIme datetime

declare @Time varchar (12)

declare @minutes int

declare @seconds int

set @Start_time = '4/29/2011 11:23:44 AM'

set @End_Time = '4/29/2011 1:27:31 PM'

--counting only minutes

set @minutes = datediff(mi, @Start_time,...

Try this

CREATE TABLE [dbo].[Test_1](

[String1] [nchar](100) NULL,

[String2] [nchar](100) NULL

) ON [PRIMARY]

insert into dbo.Test_1

select 'P:\SQL Database Backups\Transaction Logs\',

'\AdventureWorks_TransLog_201105021530.trn'

select LEFT(string1, LEN(string1) - 1) + LTRIM(string2)

from Test_1

Make sure that you are using domain user account with access to the path specified. Don’t use Local System account.