If you have a primary key set on that table then a clustered index will be created .The other columns which are widely used in the queries and which are...

Use IDENT_CURRENT(Table Name) function to know the recent identity value of that table.

Pls post the detailed error description.

In that case, why cant you prefer backup and restore.

In SQL 2005, is there a way that I...

You can change the log restoration time.No need to...

Check the server properties and use mixed mode of authentication.(assuming u are connecting through sql login).

Also check the protocols are enabled or not?

There are many ways of writing this.

Here's a sample one:

declare @abc int

select @abc=max(statut) from MyTable

select top 1 * from MyTable where statut !=@abc order by...

Use sp_change_users_login 'Report'

You will get the list of orphan users in that database.

SQL Server logs will have this info...

Moving a clustered index means your table is moved.After moving a clustered index you can see sp_help 'tablename' will show that the table is on new filegroup.No need of moving...

If the table has a clustered index the data would have been ordered .Yours is a Heap and so the data is not ordered.

when i have changed filegroup to "Primary"...

Backup location is by default in the installation path.You can change it to...

No,we cannot find it.

If you have a datetime column in that table and if it has getdate() as default you may track this.

Or go through "Database Snapshots"

Create a junction table having two columns(they are the primary keys in the two tables) as foreign keys to those tables.

It maybe due to:

1)You are not restoring the recent full backup.Check the date of the recent fullbackup.

2)Someone have performed a fullbackup of that database after you have done.So the next...