So are you saying that if you go to the SQL Server instance on which the jobs run and run the following two queries, the first will return results but...

RESTORE LOG MyStandbyDB

FROM DISK = '\\MyServer\MyShare\MyFolder\MyFile.bak'

WITH RECOVERY

John

Any constraints, triggers and indexes on a table are removed when you drop the table.

John

Although if the package fails, the job step will fail. However, the package won't necessarily fail just because one or more components in it do. That will depend...

Yes, or better still, use a computed column. Then it's always up to date and it doesn't take up any space in the database.

John

Sorry - sense of humour failure! But my point is still valid - don't do this unless you know why you're doing it. And if they insist, make...

I disagree. The person doing the ordering may not know what...

If it were my database, I'd have char(1) with a check constraint so that only values of H, W and M are allowed. The meanings of those values would...

You could try changing NULLS to 'NULL's in your query, something like this (assuming it's not a numeric column):

COALESCE(MyColumn,'NULL')

Alternatively, you could put a Derived Column transformation in your data flow...

I'm not sure I'd have been so quick to change the collation of the column without understanding the implications of doing so. If it's just one piece of code...

It's as it says in the error message. When you use GROUP BY, every column in the SELECT list must either contain an aggregate function (eg MAX, MIN, COUNT)...

Maximum size and autogrowth are separate properties. The autogrowth just means what it will grow by if there's space to do so. And yes, default values for properties...

I would guess that the 10GB limit is a limit of SQL Server Express Edition, not a property of the database itself. Therefore, although the database property shows unlimited...

Search your stored procedures to see whether any of them are doing the inserts, deletes and/or truncates. Then run a trace against the database, capturing the table name or...

When choosing between detach-attach and backup-restore, bear in mind that if there's a lot of free space in your database or log files, it could take a long time to...