You tell me. Is it returning the results you expected? If it is, then your requirement has changed, because you said you only...

Here you go. Obviously it doesn't return any rows for your sample data, but if it did, you could join back to A if you need the student name.

John

SELECT

B.StudentID

FROM

B

JOIN

TblData...

Join @tblData to TableB, group by StudentID, and return those rows having count(*) equal to the number of rows in @tblData. Without full DDL and sample data, I can't...

No, it doesn't. It means that backup tasks were the only activity that was written to...

Only if you had a particular trace flag enabled at the time the deadlocks occurred.

http://www.sqlservercentral.com/articles/deadlocks/74829/%5B/url%5D

John

If you don't have any monitoring system set up that captures those events, then you can't do it. It may be worth looking in the default trace, but I'm...

Beware that if you have more than one data file in your database, your query will fail.

John

I can't find it documented anywhere, and I don't know whether there are any exceptions, but it looks like you need to build your parameter value in advance. Probably...

Well, you certainly need to lose the first and last quotation marks in the @Directory line. Even then, you might still not be allowed to concatenate in place, so...

There are utilities that enable you to mount a backup file as a database without actually restoring it. So you could back up your live database, then mount the...

SQL Server will attempt to resolve all objects except those that it can determine will NEVER be necessary to return results when it parses the query. Otherwise it will attempt...

DJ

What have you tried already? Have you read the "CAST and CONVERT" topic in Books Online?

John

Kev

That's curious. Are you sure they were user databases you moved and not system databases? I would expect absence of user database files to lead to the database...

You have collation differences between your four databases. You need to put a [font="Courier New"]COLLATE collation_name[/font] clause after every column specification that does not have the collation you want...

Interesting. The explanation ought to cite deferred name resolution as the reason it's possible to create stored procedures referencing non-existent tables. The paragraph from BOL quoted is not...