Viewing 15 posts - 3,526 through 3,540 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2017 at 3:19 am
If they just need SELECT just GRANT them that:
USE msdb;
GO
GRANT SELECT ON sysmail_allitems TO [UserName];
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2017 at 3:06 am
Perhaps this helps:CREATE TABLE #Sample (X xml);
GO
INSERT INTO #Sample
VALUES (
'<session id="342338">
<properties dateModified="2015-02-27" manuscript="Test_1_0_0_0" engineVersion="2.0.0" cultureCode="en-US" cultureName="United States [english]" caption="Test"...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 13, 2017 at 2:56 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 10:14 am
A simple change would be:SELECT Contact, Role, SecretarysExpert
FROM (
SELECT ExpertID, Expert AS [Contact], 'Expert' AS [Role], '' AS [SecretarysExpert] FROM #tblExperts
UNION
SELECT E.ExpertID, Secretary...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 9:27 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 9:00 am
Thanks for your reply. But the snag is harder than that. 🙂
John may wear...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 8:13 am
I currently have the pleasure of doing a brief proof of concept around running SQL Server...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 7:37 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 5:53 am
I'm wondering if you seem to be over thinking this, as AD groups actually seem like a good solution to this.
Say you have following Schemas for the following...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 5:44 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 5:22 am
Not a question for help, we fixed the problem, but just wondered if anyone knows of any updates "recently" that caused problem with the Log on as Service permissions. Our...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 2:20 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 12, 2017 at 2:03 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2017 at 10:17 am
Just incase, to quote from Microsoft Docs:
ntext, text and image (Transact-SQL)
IMPORTANT! ntext, text, and image data types will be removed in a future version...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
July 11, 2017 at 10:13 am
Viewing 15 posts - 3,526 through 3,540 (of 5,109 total)