Select emp_id, lname, fname,city, state

into #temp_employee_v3 from employeedetails

CREATE UNIQUE CLUSTERED INDEX IX_1 on #temp_employee_v3

(emp_id,lname, fname)

Make the emp_id as first column in index...

Export #1 database to Access and import to your new database.

What was the problem? Can you please share?

Check the following link

http://blog.sqlauthority.com/

In SQL Server 2005 the same automatic deletions based on the values for the 'Maximum job history log size (rows)' and 'Maximum job history rows per job' can be used...

sp_GetSchemaLock is a normal SQL Server internal sproc - it's used for data modifications to ensure atomicity. An sch-s lock is a schema stability lock - and it...

see the "XML Bulk Load Examples" topic in SQL Server 2005 Books Online.

If you datatype is money it will round off the 4th position after decimal.

do you have Sysadmin role granted?

Do you have outlook configured on your server?

Which table stores user login information?

You have to truncate the log first.

Backup Log YourDatabaseName With Truncate_Only

DBCC Shrinkfile('YourLogicalLogfileName',1000)

What is your XP Service Pack? Is it SP 2?

Can you please post more details?

select convert(char(10),getdate(),101)