Viewing 15 posts - 2,491 through 2,505 (of 9,725 total)
jonathanm 4432 (7/15/2015)
July 15, 2015 at 10:47 am
Okay, first you need to set up DBMail (if you haven't already).
Then you need to add some stuff to your proc.
ALTER PROCEDURE [dbo].[tho_daily_tracking_sp]
@emails VARCHAR(xxxx) = NULL
--You need...
July 15, 2015 at 9:07 am
Yes, this can be done. Give me about 5 minutes and I'll post the solution.
July 15, 2015 at 8:55 am
Eirikur Eiriksson (7/14/2015)
Brandie Tarvin (7/14/2015)
Lynn Pettis (7/14/2015)
Eirikur Eiriksson (7/14/2015)
Lynn Pettis (7/14/2015)
Cannot create a row of size 8071 which is...
July 14, 2015 at 11:50 am
Lynn Pettis (7/14/2015)
Eirikur Eiriksson (7/14/2015)
Lynn Pettis (7/14/2015)
Cannot create a row of size 8071 which is greater than the allowable...
July 14, 2015 at 11:20 am
You know, I wondered about Silver Spoon in the past. Why (s)he was asking certain questions when I thought (s)he had more info at her/his fingertips. But I never noticed...
July 14, 2015 at 10:34 am
WayneS (7/14/2015)
Brandie Tarvin (7/14/2015)
Steve Jones - SSC Editor (7/13/2015)
Brandie Tarvin (7/11/2015)
July 14, 2015 at 9:12 am
Lynn Pettis (7/14/2015)
Cannot create a row of size 8071 which is greater than the allowable maximum row size of...
July 14, 2015 at 9:11 am
JimmyJones (7/14/2015)
Hi,You are in the good place, just choose 'Remove' and eventually you will have the usual 'Select Features' window to choose which component do you want to remove.
Ah....
July 14, 2015 at 8:20 am
GilaMonster (7/14/2015)
Please note you don't need to reinit a subscription unless something has occurred to change the subscriber or it's been offline for longer than the...
July 14, 2015 at 8:18 am
There is a way to kill all the users attached to a specific database, but it wouldn't close the query windows and it would kill other users unless you told...
July 14, 2015 at 7:36 am
You have several options.
To eliminate the separate INSERT clauses, you could just use a UNION ALL like below:
INSERT INTO #SummaryResults
(ColumnID
,ColumnName
,SentDate
,DataResult)
SELECT
4
,13
,1
,CONVERT(VARCHAR,COUNT(*))...
July 14, 2015 at 7:33 am
Steve Jones - SSC Editor (7/13/2015)
Brandie Tarvin (7/11/2015)
Usually...
July 14, 2015 at 4:25 am
GilaMonster (7/13/2015)
Yes, yes, yes, yes!!!!!!!!Congratulations. You have complied with the requirements prescribed for your degree, and are cordially invited to the graduation ceremony
YAY!
What is the degree in?
July 13, 2015 at 4:25 am
SQLRNNR (7/11/2015)
Brandie Tarvin (7/11/2015)
Usually the call for speakers...
July 13, 2015 at 4:24 am
Viewing 15 posts - 2,491 through 2,505 (of 9,725 total)