Viewing 15 posts - 16 through 30 (of 82 total)
Actually I made a mistake in my syntax. I had not enclosed the id number in quotes.
Here is the correct syntax:
SELECT *
FROM RayStationPatientDB_Breast_4014.dbo.RS_Patient_6
WHERE PatientID_6_660 = '577735';
The output was empty,...
March 24, 2016 at 2:05 pm
Hello --
I used the following syntax to complete the query:
SELECT *
FROM RayStationPatientDB_Breast_4014.dbo.RS_Patient_6
WHERE PatientID_6_660 = 577735;
The output was as follows:
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the...
March 24, 2016 at 1:51 pm
Hello --
I am still not making any progress on this issue. The syntax that I entered is the following:
SELECT *
FROM databasename.schema_name.RS_Patient_6
WHERE PatientID_6_660 = 577735
The output I am getting is the...
March 24, 2016 at 1:35 pm
Hello --
Thank-you for your reply. At the risk of looking like an idiot, the syntax that I used was the following:
select * from RS_Patient_6
where localhost\RAYCLINICAL.PatientID_6_660 = '<patient id>'
The output that...
March 24, 2016 at 11:00 am
Hello --
Thank-you for your reply. I had initially tried opening the csv file in Excel, and that was where I encountered the large gaps that were hindering my reading the...
March 8, 2016 at 6:33 am
Hello --
I experimented with the DATEADD options, and I am also doing a six month, and one year check of the database.
March 3, 2016 at 1:24 pm
Thanks Lowell --
I added the lines you suggested, and I am getting the information in question.
March 3, 2016 at 1:23 pm
Sorry about that. Yes, I did confirm there was enough space.
January 11, 2016 at 12:00 pm
Hello --
Yes, I did confirm there was enough space on the drive for the backups.
January 11, 2016 at 9:51 am
Hello --
Thank-you for your reply. The jobs in question are run as SQL Scheduled jobs, and the "Log to Table" option is set to Yes in the command syntax listed...
October 20, 2015 at 1:09 pm
Hello --
I am using Ola Hallegren's soltuion. I did further investigating over the weekend, and I found that if I rename the existing job, and then run the maintenancesolutions.sql script
after...
June 29, 2015 at 6:28 am
Hello -–
I did a check of the hardware involved in this situation: server nics, and switches, and there was nothing to indicate the problem
was hardware related.
I had another question...
June 27, 2015 at 5:32 am
Hello --
I ran Performance Monitor last night, and generated a blg file. The report included the following information:
Domain network adapter: Bytes received/sec - 33,111.117
...
June 23, 2015 at 7:51 am
Hello --
Thank-you for your reply. I checked the volume in question, and it does have the value suggested in your posting. The problem appears to be more than just one...
June 17, 2015 at 7:11 am
Hello --
Thanks for your reply. I had a follow-up question: How much time would be added to a given backup job if the crc and checksum options were added to...
December 24, 2014 at 10:18 am
Viewing 15 posts - 16 through 30 (of 82 total)