So, we come to 2 conclusions :

If I use Emptyfile, the data will be moved to another file in the same filegrp. So if I have 1.ndf, 2.ndf and 3.ndf...

Well, it all depends on the kind of database. There should be not hard and fast rule as to set the .ldf file, b'coz it all depends on your database...

He jsut misspelled the proc.

Its exec master..sp_databases

--Kishore

Hi Mike,

I used double single quotes as you mentioned and it worked fine.

Thanks.

--Kishore

I dont understand your solution can u send a modified code with what u are trying to suggest us.

You need to start all the services (sql sever and sql server agent) under domain account. Also mapped drives are not displayed when u are trying to restore. You need...

You could Visual Basic or .net applications to build applications to wor with SQl server.

However, Visual baisc is the most simplest and commonly used application builder with Sql server.

--Kishore

No. You will have separate triggers for separate tables.

Read Triggers in BOL for more info.

--Kishore

The table scripts that you have given seems incorrect.

I have corrected the scripts. Also I have written 2 triggers.

CREATE TABLE Company

(dpt_no int not null identity(1,1) primary key,

dpt_name char(20)...

Do you want triggers for insert/update and delete ?

Let me know your specs. so that I can help you out.

--Kishore

I would love to know more information about this. Any more ideas ?

Do you want to update the salary column in the sales_dpt table to be updated whene you insert / update the company table. If this is your need, then you...

Once your database is deleted, your .mdf and .ldf files get deletd from your server. I am not aware of any tools that can get your database back if you...

QA is Query Analyser, a tool which comes with SQL Server. You can write T-sql scripts using this tool.

Start -->Programs --->Microsoft Sql Server -->Query Analyser.

Connect using either Windows/SQL Authentication.

Then...

Restore the database from the backups.

If you dont have the backup, then your database is lost.

--Kishore