It's not allowing to install default instance as it is getting conflict with named instance... while at the time of installation of default instance it getting failed with permission issue...

Bhuvanesh

thanks i have checked the services, its showing SQL server(MSSQLSERVER) but in stopped state. But i dont understand how it connecting to the exisiting named instance as default if the...

I just want to import data from oracle to sql server.....

i got an error on this... can you just me to rectify this error...

TITLE: SQL Server Import and Export Wizard

------------------------------

Could...

Thanks for your reply. Is there any other way to do this... Else can you suggest me some sites from where i can get good suggestions regarding this?

Regards,

RSK...

Here is an article about index fragmentation

http://msdn.microsoft.com/en-us/library/ms189858(SQL.90).aspx

You can use DBCC CHECKTABLE command to check index of that tables...

Here is an script to reindex all tables in Database

Script...

You transfer logins and passwords from SQL Server 7.0 to SQL Server 7.0.

You transfer logins and passwords from SQL Server 7.0 to SQL Server 2000.

You transfer logins and passwords between...

Mak

Check whether your test server has enough drive space. If yes then copy the Backup file from production and paste it in test server and then restore it.

If your script...