Viewing 15 posts - 3,496 through 3,510 (of 9,399 total)
EL Jerry (3/25/2016)
djj (3/25/2016)
Grumpy DBA (3/25/2016)
Revenant (3/25/2016)
DonlSimpson (3/25/2016)
Grumpy DBA (3/25/2016)
djj (3/25/2016)
DynamicsEquilibrium
Homeostasis
Biology
Balneology
Shower
Cap
Baseball
March 26, 2016 at 9:20 pm
Jeff Moden (3/26/2016)
diamondgm (3/26/2016)
JBrosch (3/26/2016)
March 26, 2016 at 9:19 pm
You have to pass @attach_query_result_as_file = 1 and can also pass @query_attachment_filename to set the name of the file if you want an attachment.
To send in the body, I use...
March 26, 2016 at 6:19 pm
I must use mixed-mode authentication in my environment on all SQL Servers. There's a password for all sa logins and they're them all disabled. Given how much damage...
March 26, 2016 at 8:24 am
If you have SQL Server installed on a server, then the DBA has to give you permission to it. They'll also probably have to be the one to created...
March 24, 2016 at 5:16 pm
SQLRNNR (3/24/2016)
Ed Wagner (3/24/2016)
GilaMonster (3/24/2016)
ChrisM@Work (3/24/2016)
Grant Fritchey (3/24/2016)
Steve Jones - SSC Editor (3/24/2016)
WayneS (3/24/2016)
ChrisM@Work (3/24/2016)
Stage fright can hit anyone I suppose.
Yes it does... even those that speak frequently. I...
March 24, 2016 at 5:03 pm
Hugo Kornelis (3/24/2016)
Luis Cazares (3/24/2016)
Ed Wagner (3/24/2016)
djj (3/24/2016)
Ed Wagner (3/24/2016)
Luis Cazares (3/24/2016)
TomThomson (3/24/2016)
djj (3/24/2016)
H2
O
O2
Breathe
Respiration
Perspiration
Inspiration
Poetry
Fluid
March 24, 2016 at 4:58 pm
Okay, I see two possible solutions.
There is the option to create a view in a centralized database that does a SELECT against the dbo.RS_Patient_6 table in each one of these...
March 24, 2016 at 4:58 pm
kaplan71 (3/24/2016)
Here is the correct syntax:
SELECT *
FROM RayStationPatientDB_Breast_4014.dbo.RS_Patient_6
WHERE PatientID_6_660 = '577735';
The output was...
March 24, 2016 at 2:27 pm
Hugo Kornelis (3/24/2016)
Grant Fritchey (3/24/2016)
I too am very interested to hear what the full story is on this one.
My money at this point is on an interview question. Either taken...
March 24, 2016 at 2:22 pm
kaplan71 (3/24/2016)
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...
March 24, 2016 at 1:57 pm
kaplan71 (3/24/2016)
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...
March 24, 2016 at 1:44 pm
mw112009 (3/22/2016)
Looking at the attached ( in one of the previous posts ) image it is clear that SQLSERVER is running as a...
March 24, 2016 at 1:39 pm
Oops. Sorry - bit by the bug.
March 24, 2016 at 1:32 pm
Please don't duplicate posts. It just fragments replies and makes it difficult to follow.
There are a bunch of replies at http://www.sqlservercentral.com/Forums/Topic1770956-2799-1.aspx
March 24, 2016 at 1:31 pm
Viewing 15 posts - 3,496 through 3,510 (of 9,399 total)