0
votes
0answers
32 views

I am trying to implement Scott Chamberlain's code in SQL Server 2008 R2 . Getting Assembly not present errors

I am trying to use Scott Chamberlain's code, here: http://dba.stackexchange.com/a/17466/45380 I was able to compile it and create the DLL, but now when I try to run SQL CREATE ASSEMBLY I get: Msg ...
0
votes
0answers
35 views

Error on job - need to troubleshoot

Need Suggestions: One of our Production Servers contains a job (Daily run) which gets the Data from another Server and dump into local DB. From last couple of days, it is failing with the reason ...
0
votes
0answers
293 views

SQL Timeout to Principle Server Error

I am seeing a timeout to the Pricincipel SQL server (2008 R2) The exact error I am seeing is this: Timeout expired. The timeout period elapsed prior to completion of the operation or the server ...
0
votes
2answers
39 views

MySQL foreign key error

I need to update rows in a child table,but I am getting following error while I run the code, Company Table CREATE TABLE `company` ( `Company_id` int(11) NOT NULL AUTO_INCREMENT, `Company_name` ...
0
votes
1answer
61 views

“Table or view does not exist” on synonym

I have a database and a USER administrating it. Then I have an additional USER_APP to whom I granted CRUD access to all tables in my oracle data modeler (and then applied these via generated script ) ...
2
votes
2answers
127 views

MySQL #1064 error on line 2 [closed]

I'm quite new on learning SQL and I seem to be running into an issue with the following code: CREATE TABLE `read` (`order` NOT NULL UNIQUE AUTO_INCREMENT, `title` VARCHAR(50) NOT NULL, `url` ...
-1
votes
1answer
82 views

Why is this mysql query wrong? [closed]

I try to run the following sql query in mysql SET @rank:=0; WITH TEMP ( SELECT @rank := @rank + 1 AS ROW_ID , UUID() as RANDOM_VALUE,D.* FROM house_information_new D ORDER BY ...
4
votes
0answers
732 views

Receiving error Error: 18059, Severity: 20, State: 1 in the SQL Logs

I'm using SQL Server 2008 Sp3 Lately I'm having errors in the SQL Logs: Error: 18059, Severity: 20, State: 1. The connection has been dropped because the principal that opened it ...
2
votes
2answers
276 views

Execution plan flips Filter and Execute Scalar when using the PK, causes cast to fail

I have some data tables that where imported in from a flat file source so everything is varchar(max) except FileRecordID which is a int that hold the row number the data came from in the flat file ...
3
votes
1answer
2k views

Atypical problem with ORA-01445

I have problem with following query Q1: SELECT ADDRESS.STREET FROM MYSALES.MYADDRESS ADDRESS INNER JOIN MYSALES.MYCOUNTRY MCOUNTRY ON MCOUNTRY.MYCOUNTRY_ID = ADDRESS.MYCOUNTRY_ID INNER JOIN ...