There are few database files in my Data Folder of SQL Server directory. I want to delete those files, but when I try to delete them, system says that the files are being used. But those files are not associated with any database and are no longer showing in my Databases.

How can I delete those files because they are just occupying space on hard disk?

How can I make sure that a table called Table2 with a field called Field1 will only have the values as in Field1 that are also in another table called Table1 with a field called Field1? How can I force Table2 to contain the values as in Table1?

I am facing a problematic scenario with my database table. I have a database table which is parent and it has got some garbage values. Now, I want to drop this table. Is there any way that I can drop this table and recreate it without affecting its child tables?

I have attached the database in SQL Server 2005 using .mdf file. But as soon as it was attached, database went to suspected mode. I tried a set of statements to recover it to normal state but after running those queries, its status changed to emergency mode.

Can you please tell me that how can I recover my database from emergency mode to normal?

I have windows application having button on it. Behind that button a SQL query is written. Now when you press the button that query executes. Is there any way to see the query written behind the button, if source code is not available?

I am using Tivoli Productivity Centre Standard edition and for DB using DB-2 on windows 64 bit. I installed DB2 with Windows authentication parameters, now I want to change my server password for security reason but when I changed the password db2 connection failed. How can I fix it after change of password?

I want to work on Microsoft Office Access for personal use but I do not know how to work on the site.

I need a basic concept about the working procedure of the software.

This is now more important for me.

I create a report using PHP. I use MySQL database here.

But now I want to generate a PDF report from it. I have no idea how to create the PDF report.

How can I make that PDF?

Exactly I want a PDF report from MySQL data.

I have oracle 9i DB installed, is it possible to make a batch file scripts utility which first creates a user then imports dump file and then gives grants. With the help of this utility it is possible to switch within no time from primary db server to secondary server within no time. This utility can be helpful in such DB server environment which has got a backup or secondary server .

Awaiting your response,
Yousaf.

I want to use MS Access but do not understand what MS Access is.

Can you help me with what is MS Access?