for my project purpose

hi ,can any help with code or query

GOOD MORNING ..MORNING I LEARNED NEW TOPIC THANKS..

Editor: Removed material copied from another source.

hey learned a lot from this Thanks...!

hey ..

this is the one way to take Backup of Single table

select * into <NewTableName> from <OldTableName>

the problem is yet to be not solved

CREATE PROCEDURE usp_MyDiskFreeSpace

@DriveCBenchmark int = 1024,

@OtherDataDriveBenchmark int = 2048

AS

IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id = object_id(N'[tempdb]..[#disk_free_space]'))

DROP TABLE #disk_free_space

CREATE TABLE #diskfreespace

(

DriveLetter CHAR(1) NOT NULL,

FreeMB INTEGER NOT NULL)

DECLARE @DiskFreeSpace...

Hi Singh,

Thanks for the reply.i knew the database mail profile.but i want the logic of code.

i knew the job also.already i wrote code for this but this code...

got knowledge of incremental data loading thanks for the post

Thanks for sharing the qunts

Hey,

Can you please share your approach to users.it will be very useful to the all sql developers and users

oh....what a answer...i selected onlyxxxxxxxxxxxxxxxxxxx........But my answer was wrong

Hi steveb.

thanks for reply ...i have a small doubt in which file i want to save the ssis package...

SELECT name, recovery_model_desc from sys.databases

Nice question

I am much afraid by seeing the question

post this type questions