Hi,

Check it if any blocks is availabe or not?

check it if any open transactions or not?

...

unrestricted growth

yes Mr Gail. But its does n't have correct information.

Thanks Dave

Regards

Balaji.G

Hi..

You have to check it C:\program files\microsoft sql server\90\eula

Eula --> English Users License Agreement.

Thanks & Regards

Balaji.G

Thanks for your reply

Balaji.G

Hi,

you just restore that mdf file, then you have to export those tables to access.

I...

Hi,

I'm sorry, control m jobs is not in sql server. Its a third party software like BMC.. I hope that control m jobs...

Hi,

Hi,

While Configure the secondary database settings.. You should select

either NoRecovery Mode/Standby mode. Because if you select norecovery mode,

sqlserver will understand to restore...

CREATE TABLE CSVTest

(ID INT,

FirstName VARCHAR(40),

LastName VARCHAR(40),

BirthDate SMALLDATETIME)

insert into csvtest values(1,'James','Smith','19750101')

go

insert into csvtest values(2,'Meggie','Smith','19790122')

go

insert into csvtest values(3,'Robert','Smith','20071101')

go

insert into csvtest values(4,'Alex','Smith','20040202')

select * from csvtest

1 James Smith 1975-01-01 00:00:00

2 Meggie Smith 1979-01-22 00:00:00

3 Robert Smith 2007-11-01 00:00:00

4 Alex Smith 2004-02-02 00:00:00

BULK

INSERT CSVTest

FROM 'c:\csvtest.txt'

WITH

(

FIELDTERMINATOR = ',',

ROWTERMINATOR...

hi renuka..

create table abc(id int identity(1,1),name varchar(50),dob datetime)

insert into abc values('Balaji', convert(nvarchar,getdate()-10974,103))

it store the data in dd-mm-yyyy format. but its not a datetime format.

Thanks & Regards

Balaji.G

I'm using sql 2005

Dear friend..

Thanks for for your wonderful solution..

With Regards

Balaji Gangadharan

hi..

while shrinking a database that time if kill that process.. if database is going to be crash or not..

reply pls

With Regards

BalajiG