In which drive you installed SQL Server?

You can install SP2 without SP1....

What you mean by link?

If u want to query a particular table from second db when u r in first then use db_name.schema.object_name

You can use

select * from sysconstraints

sp_fkeys 'Tbl_name'

sp_Pkeys 'Tbl_name'

SELECT @@Version -->OS Service Pack

select SERVERPROPERTY('ProductLevel')--> SQL Server Service Pack

Install SQL Server developer edition in another machine and use it for development ..SIMPLE 😀

I hope your are using SQL Server version lower than SQL Server 2005 probably SQL Server 2000.Please post under that....

U tried using script?

Use select * from sysprocesses.

U can also use sp_who2 stored procedures which is an undocumented one.

Definitely applications,jobs , scheduled task everything will get affected..

Please post in appropriate sections so that your problems will get solved quickly 😀

Try creating using script..

check the permission of that particular file...it will be in a read only state ..

What exactly is your problem??

Are you trying to attach a SQL Server 2008 .mdf file to SQL Server 2008.am i right?

I hope error 5 is related to permission and security.Check whether u have proper permissions

Which version and edition of sql server you are using ?

Check whether your .mdf and .ldf files are there ...

Do as free_mascot said...

CI for case Insensitive and AS accent sensitive

Which version and Edition of SQL Server you are using??