That's ORACLE syntax. This website is for Microsoft's SQL Server which uses Transact-SQL as its language.

Also, please post in an appropriate forum...the "Question of the Day" forum is specifically...

I agree, we need better information from you. But since you ARE posting on a SQL Server forum, I'm guessing your database files grew too large.

Basic question: are you...

You normally can't repair pages without the database being online.

Do you have a backup of the database?

-SQLBill

Did you change the owner of the database before you dropped the login? Refer to the BOL for syntax for sp_changedbowner.

How did you drop/remove the login? Did you...

How about:

SELECT ListName

FROM #tblParent p

JOIN #tblChild c

ON p.id = c.ParentId

WHERE c.CategoryCode = 'A'

AND c.CategoryCode = 'B'

GROUP BY c.ParentId

-SQLBill

Finally, if the top chart is what appears in the database....provide us a chart of how you WANT the data to be returned and maybe we can fix your query.

-SQLBill

Also, is the Age column an integer or varchar/char column? If it is varchar or char (or nvarchar or nchar), you need to enclose that value in single quotes also.

-SQLBill

Two comments:

1. I agree with Keith, the rows are not duplicates, so DISTINCT won't eliminate one. If ANY column in a row is different, then it's a different row. ...

If that's true, attach_single_file_db won't work. He's pretty much out of luck unless he can get a new backup after the database has been shrunk.

-SQLBill

I don't know that one. Sorry.

-SQLBill

In Enterprise Manager, go to Management > Jobs.

Find your backup job, right click on it, select Job History. Check the box for expanding job steps. Find where it fails and...

Maybe: (I haven't tried this......)

SELECT INTO ##mytable

FROM (EXEC sp_spaceused

-SQLBill

Let me clear up a misunderstanding.......

sp_revokedbaccess just removes the user from the DATABASE, not from SQL Server.

sp_droplogin removes them from SQL Server.

You need to use sp_droplogin.

However, this WILL FAIL if...

It's probably the only way if you are using backups. Another possibility....take the original database offline (either by detaching it or stopping SQL Server services). Copy JUST the .mdf....

Dionisis,

The problem is that you are converting a 'full' DATETIME to SMALLDATETIME.

Try this:

SELECT

CONVERT (SMALLDATETIME, CONVERT (VARCHAR, BIRTHDATE,103),103))

FROM CANDIDATES

There's no need to convert to DATETIME and then to SMALLDATETIME. It's...