Recent posts

Getting data base name using SQL Plus?

I want to know the database name and I am using SQL *Plus command prompt of Oracle. Also, how can I figure it out that which user created that database? How can I achieve this using SQL *PLUS command prompt?



Read more
nadeemrao Written on 08/09/2011 in Question

Copying schema of table to another table?

I have a situation in which I have to copy the schema of a table to another table in Oracle. I do not want to copy the data of that table. How can I copy the structure of a table without copying the data?



Read more
nadeemrao Written on 08/09/2011 in Question

Creating database relationships while designing tables?

I want to create database relationships like one to one, one to many and many to many relationship.

I am using SQL Server 2008 R2. Can anyone please tell me that how can I implement one-to-one, one-to-many and many-to-many relationships while designing tables?

 



Read more
nadeemrao Written on 08/09/2011 in Question

Installing anti virus Kaspersky instead of AVG

I bought a Kaspersky Antivirus but before I could start to install it, a message appeared saying I have to remove the other existing Antivirus on my computer. The existing Antivirus according to the message is "AVG 8". But I couldn't find the software, I tried overwriting this AVG...



Read more
Daniel Vettori Written on 08/09/2011 in Question

Deleting Data files from Data folder of SQL Server?

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...



Read more
nadeemrao Written on 08/09/2011 in Question

System Error Code 791 of MCFG

I have encountered a system error code 791 displaying as "ERROR_BAD_MCFG_TABLE" and/or as the hexidecimal value 0x317. Besides the message also associated with this error code is "The resources required for this device conflict with the MCFG table." How to resolve?



Read more
Daniel Vettori Written on 08/09/2011 in Question

Tables’ fields having same values?

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...



Read more
nadeemrao Written on 08/09/2011 in Question

Error LP5 while unpacking program.

I have been trying to run a program from a flash drive with the Ceedo software on my Windows Xp computer. I would like to be able to take this program with me. I haven't been able to get it to run yet. Can you help me out.



Read more
Daniel Vettori Written on 08/09/2011 in Question

Deleting parent table without affecting child tables?

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...



Read more
nadeemrao Written on 08/09/2011 in Question

Attaching .mdf file with database changes mode of database?

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...



Read more
nadeemrao Written on 08/09/2011 in Question