Hi,

I did it that way.. this time it worked and showed the new file path properly. But when I restarted the SQL server I got the following error.

"Database DB_NAME'...

Actualy I DONT WANT to change the filenames.

I want to change the location of my MDF & LDF files....

(in someother folder.....)

Fine..Last 2 fields of all the tables are common fields (Createddate and Isdeleted). thought I will keep that uniformity. Now I can' drop the tables..because system is live and I...

Dear All,

I got the solution from microsoft website. Actualy it's a bug in SQL Server 2005 itself.This error won't occur if we update the value...

Thank you somuch

Thanks...will try the same.

Thank you so much. I will try the same n revert back...

Whats native restoration process..? Can you explain in detail pls..

Thanks,

Santhu.

1. Each SQL Instance sit on a different machine and you

have different IP addresses.

2. There a single public IP and that redirects traffic to the...

Is thi problem solved..?

I am in need of same functionality...Want list out records of an SP into temp table....columns will be dynamic as well.

pls help..

Exec GetNav_Data @TableName = 'SERVICETAX'

Exec GetNav_Data @TableName = 'TDSNATUREOFDEDN'

Exec GetNav_Data @TableName = 'VendorDetails'

Exec GetNav_Data @TableName = 'PaymentMethodCDD'

All the above commands will return me different type of records...(diff columns and values)....

That's the problem..

We cant define the table straucture like that..It is depended on the parameter we pass.Number of fields and it's data types will vary as per the parameter passed.

Is...

We use Identity column as 'CODE' s...(cost code, branch code, etc.)

I was against it, but manager insisted to use identity column for this.

Thats y IDENTITY column has become the key...

Thank you.....

Infact I wanted to avoid that..At present I do that valdation only when error comes...So there's no way to achieve this..rite.?

Thank you.

Infact, wot had happend is, I was not in this project initialy. So developers created tables and procedures left & right and made it completely a mess. It was...