Viewing 15 posts - 211 through 225 (of 1,081 total)
I have a problem with Database Mail. Thank you for help ...
SQL Server 2016 running on...
January 20, 2017 at 10:21 am
January 20, 2017 at 10:12 am
Location
19
SELECT CHARINDEX('A2,R1,T3,D1', '01,02,03,04,05,A1,A2,C1,C2,C3,D1,D2,
J1,J2,J3,K1,M1,M2,M3,N1,N2,N3,P1,P2,P3,R1,S1,S2,T1,T2,T3,W1,W2,W3') AS [Location]
Location
0
Why A2,R1,T3,D1 return 0? A2,R1,T3,D1 is Exists...
January 18, 2017 at 8:00 am
January 18, 2017 at 6:54 am
Back to basics, thanks for the question.
January 16, 2017 at 6:03 am
thanks for the question, trusty old gem used countless times.
November 30, 2016 at 6:48 am
Nice question, technically both:
1. INSERT dbo.TimeZoneOffsetTest (mytime) CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET)
and
2. INSERT dbo.TimeZoneOffsetTest (mytime) SELECT '20161015 08:15 2:00'
are invalid, option 1 contains an invalid sub-query SELECT. Remove...
November 2, 2016 at 12:58 am
Sounds like a bug, are you on the latest Service Pack for 2012?
October 11, 2016 at 11:55 pm
I'll admit, this one got me. :hehe:
Thanks for the question.
October 10, 2016 at 10:25 pm
Best to speak to your license partner, if Standard, you'll need to review the rules of licensing the host and additional vCores, or just the vCores of the VM by...
October 5, 2016 at 7:32 am
You license SQL per server, not database.
So yes, you can add more databases to an existing licensed instance.
....you say virtual...is this also Web, or STD or ENT?
It...
October 4, 2016 at 2:05 am
Thank you for the suggestion, although I've tried all variants, including yours, and it appears that it doesn't accept anything beyond a standalone name.
September 29, 2016 at 9:06 am
Viewing 15 posts - 211 through 225 (of 1,081 total)