There may be more than 100 list of values that i may need to replace. I am reluctant to use Nested replace as its a big list. I was thinking...

SELECT DB_NAME(database_id) AS DatabaseName,

Name AS Logical_Name, (size*8)/1024.0 SizeMB, cast((size*8)/1024.0/1000 as decimal(9,3)) SizeGB

FROM sys.master_files

order by 1

Yes but not much. I worked most on DTS. I didnt use FTP task till now in SSIS. If you can brief me how to use FTP TASK for my...

I havent used FTP Task till now. Can you please let me know how i can do this with the FTP Task?

Got it!!!

Thank you so much Lynn.

I have dates in Julian YYDDD format. The sql below is not fetching the correct output. I have data prior > and < 2000

select dateadd(dd, (04126 - ((04126/1000) * 1000))...

Thank you so much Lowell. That worked.

But i have another problem here, Julian date 04126 is getting converted to 1904-05-05 00:00:00.000 instead of 2004-05-05. Can you please let me know...

Thanks for the reply. Here is what is my situation.

we dont have enough space on server A so i would like to point the backup job to create the backup...

You need to have a shared network drive on serverB. use this drive to store your backup.

-- how do i create a shared network drive on server B (sorry...

Yes i would take a full backup and then start the Tlog backup process soon after i switch the database to full. can you please let me know if it...

Yes the DBCC DBREINDEX updates the statistics automatically. I have tested this.

Thanks Michael for your help

Thanks for your reply. I will try that

Here are the steps to change the service account password.

a)      Login onto the server with the User account that is used by the...

Try changing the time the job runs and see if it helps. one of my jobs that is scheduled used to run for hours (and it wouldnt stop) and i...

you can find this stored procedure in msdb database. this is a system stored procedure