Hi,

Did you refresh the enterprise manager gui.

Check. If restore is successfull then there should not be issues with the database . just refresh.

declare @table1 TABLE (

GLID INT,

GL_NAME VARCHAR(100),

AMOUNT MONEY,

PERIOD TINYINT,

YEAR_SI INT

)

INSERT INTO @TABLE1

select 1000,'Sales',20000,1,2005

union all

select 1000,'Sales',10000,2,2005

union all

select 1001,'Cost',50000,1,2005

union all

select 1001,'Cost',50000,2,2005

declare @table2 TABLE (

[Description] varchar(100),

period1 int,

period2 int,

year_to_Date as period1+ period2

)

insert into...

INSERT INTO DATABASE1.dbo.TABLE1( COL1,COL2,COL3)

SELECT COL1,COL2,COL3 FROM DATABASE2.dbo.table2

do mean , sum of all database size ?

2) After scheduled or manaul LOG Backup and  Upon a manual (or scheduled) SHRINKFILE

Can you do lilke this move the data to excel sheet, copy all data and while pasting select paste special and select transpose..

Ha.. and mine

|

Taking backups of transaction depends on how frequently database is modified.

According my Implementation.

1. Weekly Once take a full back.

2. Daily night take  differential backups and 

3. Every 4 hours schedule for...

Hi,

Can you provide some more explination

Hoping to solve the problem,

declare @tblusers table( uid int ,uname varchar(25) )

insert into @tblusers

select 1, 'Sanket'

UNION ALL

select 2, 'Sachin '

UNION ALL

select 3, 'Kishan'

UNION ALL

select 4, 'Sanket'

UNION ALL

select 5, 'Ram'

UNION...

Any other interview questions... please....

the best solution implement this is to pass xml input to stored procedure. and that is the best way. take all the data grid value and construct the xml and...

Hi,

This should work.

select top 1 * from x

Will you please able to paste the query or part of the query ?

I do understand the problem,

suppose if 100 columns are there in a table and your application makes changes to only one or two columns, you will be updating all...