Did you check to see if the DNS server was down at the time it failed?

-SQLBill

Not quite like this (nothing is like SQL Server). But a strictly 'forum' site for computer professionals is http://www.tek-tips.com. It is a free-site and covers a lot of different...

They are dropped from my production systems.

-SQLBill

Have you checked the Windows Event Viewer Logs? Usually when a Windows Authenticated user cannot connect, it is:

1. the login is SQL Server Authentication - which doesn't apply in...

Check out the BOL for information on the commands.

INNER JOIN means that there must be a match in BOTH tables.

TableL ...

Maybe:

SELECT MyDateField

FROM MyTableName

WHERE MyDateField > (SELECT MIN(MyDateField)

FROM MyTableName)

...

Stop the Agent service. As long as that is running, jobs can and will run. Also, what login did you use to put the database in single user...

SELECT INTO creates a NEW table, but you have to give it a table name. You are using the SAME table name, so that won't work.

Let's step through this:

DROP TABLE...

quote: as well as it is displaying some warnings

What warnings are you getting?

-SQLBill

Where are you doing your restore from? Over a network? From a tape? From disk?

-SQLBill

How slow is slow? How long did your backup take?

-SQLBill

The detach/attach should have set your database into a recovered mode.

Lesson learned: always determine which backups you need to restore before you do the restore.

-SQLBill

Craig,

As an example of why you would use TSQL....I have some users that need to use Crystal Reports to query my database. I created a stored procedure (TSQL) that...

Software add-on can be almost anything. For one example, my users need a specific report. If I can't find a reporting software that does the job and is cost...

Which version and edition of SQL Server do you have? (Edition = Standard, Enterprise, Developer, MSDE, etc; Version = Service Pack level).

-SQLBill