Viewing 13 posts - 1 through 13 (of 13 total)
I found this link that said renaming the database to a temporary name and then renaming it back to what it is now will fix the issue. Does anyone...
October 13, 2015 at 6:56 am
The instance has been restarted. Both before it was added to the always on group and after.
October 13, 2015 at 6:10 am
I had the same issue with one of my tables. My problem was caused by line breaks and tabs embedded in the cell. I found this after pasting...
May 5, 2015 at 5:30 am
I resolved the issue by uninstalling the GDR KB2977320, then installing the CU. The server currently has KB2977319 installed appears to be the QFE version of the same security...
April 21, 2015 at 12:46 pm
SP3 has a reported issue with the report builder. I'm not sure at this time if that would effect us, but I don't want to take the chance since...
April 21, 2015 at 12:41 pm
I recently came across comments when troubleshooting a program we have used for years that only used the month and day when dating the change. No year.
March 16, 2015 at 4:30 am
For Christmas, my 14 year old asked for the book "Learn to Program with Minecraft Plugins: Create Flaming Cows in Java" by Andy Hunt.
I was excited that he found a...
February 23, 2015 at 5:48 am
I had to use something similar to this in my auto restore process
DECLARE @Command VARCHAR(MAX)
DECLARE @FileCursor CURSOR
DECLARE @FileNameVARCHAR(1000)
SET @FileCursor = CURSOR FOR
SELECT filepath FROM DBA.dbo.DBA_ScriptList
OPEN @FileCursor
FETCH NEXT
FROM @FileCursor...
February 17, 2015 at 5:33 am
Ok, so I recreated the table defining the Project ID as UNIQUE, NOT NULL rather than as a primary key and everything works great now. There are no nulls...
April 9, 2013 at 5:57 am
No Duplicates
(0 row(s) affected)
Table '#PivotedSourceTable
The ProjectID field does not seem to be the issue. The PK_Test_ELE_761abed01e1455b5 field that shows up under the key folder (see original post screen shot)...
April 8, 2013 at 8:20 am
OK, but be gentel, I'm still new to SQL 🙂
As I mentioned before, Field1 AKA ProjectID is a primary key in the source. This query does not produce any...
April 5, 2013 at 9:08 am
CONSTRAINT_CATALOGdatabase1
CONSTRAINT_SCHEMAdbo
CONSTRAINT_NAMEPK__Test_ELE__761ABED021E4E699
TABLE_CATALOGdatabase1
TABLE_SCHEMAdbo
TABLE_NAMETest_ELEVATIONS
COLUMN_NAMEProjectID
ORDINAL_POSITION1
(*I dropped and recreated the table and when I did the numbers on the constrain_name changed, which is why its not matching my original post)
And thank you for the quick...
April 5, 2013 at 7:12 am
The projectID is a primary key in both the source and target . I double checked using your query and it produced no results.
When I delete the foreign key from...
April 5, 2013 at 6:58 am
Viewing 13 posts - 1 through 13 (of 13 total)