Viewing 15 posts - 3,106 through 3,120 (of 7,191 total)
You don't normally need to consider the LSN. Just to be safe, it's probably best to retain log backups to an hour, say, before the full backup starts. ...
August 4, 2015 at 9:09 am
(1) No, because if your full backup fails, you'll be left with nothing
(2) Yes, that should work. I usually keep 48 hours of transaction logs, though - it gives...
August 4, 2015 at 5:33 am
Something like this?
create view vw_main
as
select colA1, colA2, colA3, colA4, colA5, colB2
from tableA A inner join tableB B
on (A.ColA1 = ColB1 AND colA4 = 'case') OR colA4 = 'ifelse'
John
July 23, 2015 at 7:36 am
Fred
The answer's in the error message. You've created the column NOT NULL (which it has to be to form part of a primary key constraint) and therefore you have...
July 23, 2015 at 5:33 am
peter-757102 (7/23/2015)
John Mitchell-245523 (7/23/2015)
peter-757102 (7/23/2015)
July 23, 2015 at 4:59 am
peter-757102 (7/23/2015)
July 23, 2015 at 4:20 am
Are you asking how to connect to the remote server? Use Windows authentication, assuming SQL Server runs under a domain account in the same domain as the remote server...
July 20, 2015 at 10:05 am
Al.Pacca (7/15/2015)
Then created the new Database vehicles_new
Yes, although you don't actually need to create the database first - you can just run the RESTORE if the database you're restoring...
July 15, 2015 at 8:43 am
Welcome to the forums! You're trying to restore the new database with the same file names as the existing one, which obviously isn't allowed. Use the WITH MOVE...
July 15, 2015 at 2:28 am
OK, for the former, use DATEDIFF. For the latter, look at the CREATE TABLE documentation. Search on that page for "computed_column_expression". Please post back if there's anything...
July 14, 2015 at 4:39 am
I would advise you to calculate the time difference in minutes. You can display it as hh:mm in your presentation layer. That said, what is it specifically you...
July 14, 2015 at 4:13 am
Something like this? (Not tested because no table DDL or sample data.)
CREATE TABLE #BeginDates (
DateNo tinyint
SentDate datetime
)
INSERT INTO #BeginDates VALUES
(1, @SentDate2BeginNew)
,(2, @SentDate3BeginNew)
,(3, @SentDate4BeginNew)
,(4, @SentDate5BeginNew)
,(5, @SentDate6BeginNew)
INSERT INTO #SummaryResults (
ColumnID
,ColumnName
,SentDate
,DataResult
)
SELECT
4
,13
,b.DateNo
,CONVERT(VARCHAR,COUNT(*))
FROM #BeginDates...
July 14, 2015 at 2:30 am
No, the timeout is set within the package, not by the sp_start_job stored procedure. How long before it times out - is it long enough for you to run...
July 13, 2015 at 9:54 am
What's happening when it times out - is it being blocked? What is the blocking process doing?
John
July 13, 2015 at 9:44 am
Viewing 15 posts - 3,106 through 3,120 (of 7,191 total)