-- one more test data row

INSERT INTO MyTestTable (ID, Col1) SELECT 4, 'a longer string value1 / a much much much much longer string value2 / whatever / whatever /...

Actually I would never have seen this except that it was posted here ... I only check a limited number of threads as I don't have the time for all...

Definitely go to a local user group. In particular, get a good mentor to help you learn. With the sheer volume of what you have to learn, a...

Great, glad it helped!

Btw, use DBCC commands such as those above to do file shrinks and other such db maintenance tasks, not the SSMS gui, which can be flaky for...

Are you absolutely sure it's file #2? SQL verifies a file before restoring it.

Check the backup file contents just to be sure:

RESTORE FILELISTONLY

FROM DISK = 'F:\For restore\Lss_backup_2013_10_13_000010_4544977\Lss_backup_2013_10_18_000012_9335308.dif'

Edit: Corrected backup...

T.Ashish (10/17/2013)

Jeff Moden (10/17/2013)

Thank...

Also, you need to review the SQL log from when the error first occurred. Sometimes when errors occur SQL gets stopped and restarted, which causes a log switch. ...

Or just:

ORDER BY 1

I often avoid using the column names at all in UNIONed queries, as the names somehow seem to

change a lot 🙂 :

The CROSS APPLY and SUBSTRING below should do what you need. Let us know if you need some clarification for getting it into an UPDATE statement.

DECLARE @leading_trailing_chars_to_eliminate varchar(10)

SET @leading_trailing_chars_to_eliminate...

You'll need to format the hours separately, as below, since style "114" will only handle up to 23 hours:

SELECT

CAST(DATEDIFF(ms, ActualStartTime, EndTime) / 3600000 AS varchar(3)) +

...

I think the code below is a reasonable interpretation, but whether it's correct or not is far from certain:

ALTER TABLE [Lkup].[ReceiptReasonCodes]

ADD [IsValidSap] [bit] NULL

I should have mentioned that. I was thinking...

You can't directly restrict sa (sysadmin) accounts from any activity in SQL Server. You would have to use a trigger to prevent sa activity.

For only non-sa, you could try:

DENY...

Use LEFT OUTER JOIN, but don't cast datetimes in any data table to dates to do comparisons; instead, use a range check.

Here's a sample join for the tables you've described:

SELECT...

Be aware that a global temp table means the code must be single-threaded, as simultaneous executions of the code would stomp on each other.