Viewing 15 posts - 3,106 through 3,120 (of 7,187 total)
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
That's covered in the link in my previous post.
John
July 13, 2015 at 9:42 am
I've a feeling you need to restore the resource database on the development server as well. Make sure you make a copy of the existing resource database before you...
July 13, 2015 at 9:27 am
In your WHERE clause, you're comparing the values in the date column to the value returned by the subquery. If that subquery returns more than one value, you'll get...
July 13, 2015 at 8:51 am
You either need an extra job step in the remote jobs so that they tell you when you've finished, or you need to poll msdb on the remote servers to...
July 13, 2015 at 8:45 am
Viewing 15 posts - 3,106 through 3,120 (of 7,187 total)