Suppose We have Following Situation

SERVER 1

1. Take Full Backup of Main Server. Date 2010-03-01

2. Take Differential Backup of Main Server. Date 2010-03-02

3. Take Differential Backup of Main Server. Date 2010-03-03

SERVER...

I Want a Backup copy of that portion of data which is change since last any type of backup(full or differential).what is the name of this type backup? may be...

Why U need For Store Tempdb In Memory???

If U want to work with temp table which must be placed in memory for fast access.u can use table variable instead of...

Thanks for Your Reply.............

Here we define some table and rules.

Suppose I Have An Item Table Which Is As Follows.........

M Item

Item IDItem Name Sale...

Most Welcome To You

select * from sys.syslogins

Hope this query give you your desire result.

it contain all log in name role associated with log in name,

try it

Yes

You are right.

thanks for update me.

select * from information_schema.columns where column_name='your search column name'

Place Your search column name in condition and find your desire result.

oh

I mistake in read .

combined these 100 query in a single stored procedure.

and execute only one stored procedure from your application.

Your Statement Is

select @tablename = (select Name from Sysobjects where Name like 'queue%' and type = 'U')

set @0=0

set @execstring = 'Update ' + @tablename +

'set xcheckout = ' + @0

You...

Click On Topic Option in Right Upper Coordinate of your windows and select subscribe topic and choose your desire method of subscription.

YOU CAN TAKE INFORMATION BY THESE QUERYs

select * from information_schema.tables where table_type='base table'

select * from information_schema.columns where column_name='field name'

select * from information_schema.KEY_COLUMN_USAGE where column_name='field name'

Arrange These according your need

DBCC DBREINDEX

Example :-

Rebuild all of the indexes on the authors table with 80% fill factor.

DBCC DBREINDEX (authors, '', 80)

thank for reply

Copy File One Place to other take more time. and some time it corrupted due to network problem.send this file using ftp is also painful work.we can not...