I found it out totally by accident. I was typing fast and managed to slip and hit the shift when I hit the enter key. I saw what happened and...

Is there more to the error message than just [SQLSTATE 01000]?

Everything I've seen on Microsoft's site indicates there should be more to the error message.

Basically, the SQLSTATE 01000 indicates an...

It appears my attempt to help you irritated you instead. That was not my intent.

You never said you checked the BOL or I would not have posted that suggestion.

I...

You can't use a database when it's being restored.

That said, if it's been restoring for a while - it's possible the restore was done incorrectly.

You didn't give enough information...

First, I don't get that on ANY of my jobs.

Second, I did find out information about that in the BOL. Use the Index tab and enter SQLSTATE. Then select the...

I tried my suggestion and it worked just fine. I do have a different collation, but here's what I ran:

First I checked the amount of records....

SELECT  *

FROM MyTable

WHERE  mycolumn >= '2004-03-31 00:00:00' AND...

The conversion shouldn't be causing any problems since it's converting it to dd/mm/yyyy (103 format). And the dates you are comparing it to are also strings (they are between the...

To clarify what I said....when I have a user who is 'hogging' up the system with a query; I KILL it. But I tell them first and have them send...

If you are 'snapshotting' the .mdf/.ldf files, this usually isn't a good thing. I suggest trying to restore one of the 'snapshots' to see if it really works.

There are two...

Then why use BETWEEN? Change it to:

SELECT  *

FROM MyTable

WHERE     TimeStamp >= '29/03/2004' AND TimeStamp <= '05/04/2004'

ORDER BY TimeStamp

Or sticking with BETWEEN, maybe you could do this:

SELECT  *

FROM MyTable

WHERE  CONVERT(VARCHAR(10),TimeStamp,103) BETWEEN '29/03/2004' AND '05/04/2004'

ORDER...

Yes, you can run DBCC INDEXDEFRAG. Look it up in the Books OnLine. This is a three step process, first it compresses the index, then it defrags/repages it, then it...

Do you have the owner's manual for the phone? That should tell you how to do what you want.

If you don't have the owner's manual, who made the phone? Go...

It's a VIEW.

Refer to the Books OnLine (BOL), use the Index tab and enter INFORMATION_SCHEMA. You'll see a whole list of these views.

-SQLBill

Here's a SELECT that shows two other ways to do what you want. One uses DATEADD and DATEDIFF, the other uses one CONVERT.

SELECT DATEADD(HOUR,0,DATEADD(DAY,DATEDIFF(DAY,0,GETDATE()),0)),

       CONVERT(VARCHAR(10), GETDATE(), 121) + '...

You could use the undocumented stored procedure 'sp_msforeachdb'.

From The Guru's Guide to Transact-SQL by Ken Henderson:

Procedure:

sp_msforeachdb

@command1

@replacechar = '?'

[,@command2]

[,@command3]

[,@precommand]

[,@postcommand]

Purpose:

Executes upto three commands for every database on the system. @replacechar will be replaced...