Viewing 15 posts - 1,291 through 1,305 (of 5,394 total)
Jack Corbett (3/7/2014)
March 9, 2014 at 4:40 pm
Thanks for recommending my script, Lowell. 🙂
January 29, 2014 at 11:35 am
Make sure two-factor authentication is not enabled:
http://support.google.com/accounts/bin/answer.py?hl=en&answer=185833
January 27, 2014 at 2:37 am
Probably it's just a permissions issue.
Take a look at this article http://www.sqlservercentral.com/articles/Linked+Servers/73794/
It's about setting up linked server with an out-of-process OLEDB provider, but it also contains a lot of information...
January 13, 2014 at 3:06 am
AFAIK there's no Server+CAL licensing for Dev edition.
You have to own a legitimate copy of the software for each developer using it.
January 13, 2014 at 2:54 am
What about UNPIVOT?
DECLARE @test-2 TABLE (
LoadTemp1 int,
LoadTemp2 int,
LoadTemp3 int,
LoadTemp4 int,
[TimeStamp] datetime
)
INSERT INTO @test-2 VALUES
(300, 200, 100, 320, '12-10-2013 13:30:29'),
(100, 250, 113, 340, '12-10-2013 14:20:12'),
(114, 339, 209, 345, '12-10-2013 14:45:01')
declare...
December 19, 2013 at 10:07 am
sgmunson (12/18/2013)
December 19, 2013 at 2:27 am
Bug filed.
Vote up please! 🙂
December 17, 2013 at 4:49 pm
sgmunson (12/16/2013)
Just curious about the impact of changing the following statement:
SET @someValue = REPLICATE(CAST('a' AS varchar(max)) , 60000)
to:
SET @someValue = CAST(REPLICATE('a' , 60000) AS varchar(max))
REPLICATE interprets arguments as non-MAX types...
December 16, 2013 at 9:31 am
Thanks guys.
Apparently, it's not limited to 850 codepage, but it happens with lots of collations.
I tested it with all possible collations and it fails with the following ones:
Albanian_BIN
Albanian_BIN2
Albanian_CI_AI
Albanian_CI_AI_WS
Albanian_CI_AI_KS
Albanian_CI_AI_KS_WS
Albanian_CI_AS
Albanian_CI_AS_WS
Albanian_CI_AS_KS
Albanian_CI_AS_KS_WS
Albanian_CS_AI
Albanian_CS_AI_WS
Albanian_CS_AI_KS
Albanian_CS_AI_KS_WS
Albanian_CS_AS
Albanian_CS_AS_WS
Albanian_CS_AS_KS
Albanian_CS_AS_KS_WS
Arabic_BIN
Arabic_BIN2
Arabic_CI_AI
Arabic_CI_AI_WS
Arabic_CI_AI_KS
Arabic_CI_AI_KS_WS
Arabic_CI_AS
Arabic_CI_AS_WS
Arabic_CI_AS_KS
Arabic_CI_AS_KS_WS
Arabic_CS_AI
Arabic_CS_AI_WS
Arabic_CS_AI_KS
Arabic_CS_AI_KS_WS
Arabic_CS_AS
Arabic_CS_AS_WS
Arabic_CS_AS_KS
Arabic_CS_AS_KS_WS
Chinese_PRC_BIN
Chinese_PRC_BIN2
Chinese_PRC_CI_AI
Chinese_PRC_CI_AI_WS
Chinese_PRC_CI_AI_KS
Chinese_PRC_CI_AI_KS_WS
Chinese_PRC_CI_AS
Chinese_PRC_CI_AS_WS
Chinese_PRC_CI_AS_KS
Chinese_PRC_CI_AS_KS_WS
Chinese_PRC_CS_AI
Chinese_PRC_CS_AI_WS
Chinese_PRC_CS_AI_KS
Chinese_PRC_CS_AI_KS_WS
Chinese_PRC_CS_AS
Chinese_PRC_CS_AS_WS
Chinese_PRC_CS_AS_KS
Chinese_PRC_CS_AS_KS_WS
Chinese_PRC_Stroke_BIN
Chinese_PRC_Stroke_BIN2
Chinese_PRC_Stroke_CI_AI
Chinese_PRC_Stroke_CI_AI_WS
Chinese_PRC_Stroke_CI_AI_KS
Chinese_PRC_Stroke_CI_AI_KS_WS
Chinese_PRC_Stroke_CI_AS
Chinese_PRC_Stroke_CI_AS_WS
Chinese_PRC_Stroke_CI_AS_KS
Chinese_PRC_Stroke_CI_AS_KS_WS
Chinese_PRC_Stroke_CS_AI
Chinese_PRC_Stroke_CS_AI_WS
Chinese_PRC_Stroke_CS_AI_KS
Chinese_PRC_Stroke_CS_AI_KS_WS
Chinese_PRC_Stroke_CS_AS
Chinese_PRC_Stroke_CS_AS_WS
Chinese_PRC_Stroke_CS_AS_KS
Chinese_PRC_Stroke_CS_AS_KS_WS
Chinese_Taiwan_Bopomofo_BIN
Chinese_Taiwan_Bopomofo_BIN2
Chinese_Taiwan_Bopomofo_CI_AI
Chinese_Taiwan_Bopomofo_CI_AI_WS
Chinese_Taiwan_Bopomofo_CI_AI_KS
Chinese_Taiwan_Bopomofo_CI_AI_KS_WS
Chinese_Taiwan_Bopomofo_CI_AS
Chinese_Taiwan_Bopomofo_CI_AS_WS
Chinese_Taiwan_Bopomofo_CI_AS_KS
Chinese_Taiwan_Bopomofo_CI_AS_KS_WS
Chinese_Taiwan_Bopomofo_CS_AI
Chinese_Taiwan_Bopomofo_CS_AI_WS
Chinese_Taiwan_Bopomofo_CS_AI_KS
Chinese_Taiwan_Bopomofo_CS_AI_KS_WS
Chinese_Taiwan_Bopomofo_CS_AS
Chinese_Taiwan_Bopomofo_CS_AS_WS
Chinese_Taiwan_Bopomofo_CS_AS_KS
Chinese_Taiwan_Bopomofo_CS_AS_KS_WS
Chinese_Taiwan_Stroke_BIN
Chinese_Taiwan_Stroke_BIN2
Chinese_Taiwan_Stroke_CI_AI
Chinese_Taiwan_Stroke_CI_AI_WS
Chinese_Taiwan_Stroke_CI_AI_KS
Chinese_Taiwan_Stroke_CI_AI_KS_WS
Chinese_Taiwan_Stroke_CI_AS
Chinese_Taiwan_Stroke_CI_AS_WS
Chinese_Taiwan_Stroke_CI_AS_KS
Chinese_Taiwan_Stroke_CI_AS_KS_WS
Chinese_Taiwan_Stroke_CS_AI
Chinese_Taiwan_Stroke_CS_AI_WS
Chinese_Taiwan_Stroke_CS_AI_KS
Chinese_Taiwan_Stroke_CS_AI_KS_WS
Chinese_Taiwan_Stroke_CS_AS
Chinese_Taiwan_Stroke_CS_AS_WS
Chinese_Taiwan_Stroke_CS_AS_KS
Chinese_Taiwan_Stroke_CS_AS_KS_WS
Croatian_BIN
Croatian_BIN2
Croatian_CI_AI
Croatian_CI_AI_WS
Croatian_CI_AI_KS
Croatian_CI_AI_KS_WS
Croatian_CI_AS
Croatian_CI_AS_WS
Croatian_CI_AS_KS
Croatian_CI_AS_KS_WS
Croatian_CS_AI
Croatian_CS_AI_WS
Croatian_CS_AI_KS
Croatian_CS_AI_KS_WS
Croatian_CS_AS
Croatian_CS_AS_WS
Croatian_CS_AS_KS
Croatian_CS_AS_KS_WS
Cyrillic_General_BIN
Cyrillic_General_BIN2
Cyrillic_General_CI_AI
Cyrillic_General_CI_AI_WS
Cyrillic_General_CI_AI_KS
Cyrillic_General_CI_AI_KS_WS
Cyrillic_General_CI_AS
Cyrillic_General_CI_AS_WS
Cyrillic_General_CI_AS_KS
Cyrillic_General_CI_AS_KS_WS
Cyrillic_General_CS_AI
Cyrillic_General_CS_AI_WS
Cyrillic_General_CS_AI_KS
Cyrillic_General_CS_AI_KS_WS
Cyrillic_General_CS_AS
Cyrillic_General_CS_AS_WS
Cyrillic_General_CS_AS_KS
Cyrillic_General_CS_AS_KS_WS
Czech_BIN
Czech_BIN2
Czech_CI_AI
Czech_CI_AI_WS
Czech_CI_AI_KS
Czech_CI_AI_KS_WS
Czech_CI_AS
Czech_CI_AS_WS
Czech_CI_AS_KS
Czech_CI_AS_KS_WS
Czech_CS_AI
Czech_CS_AI_WS
Czech_CS_AI_KS
Czech_CS_AI_KS_WS
Czech_CS_AS
Czech_CS_AS_WS
Czech_CS_AS_KS
Czech_CS_AS_KS_WS
Estonian_BIN
Estonian_BIN2
Estonian_CI_AI
Estonian_CI_AI_WS
Estonian_CI_AI_KS
Estonian_CI_AI_KS_WS
Estonian_CI_AS
Estonian_CI_AS_WS
Estonian_CI_AS_KS
Estonian_CI_AS_KS_WS
Estonian_CS_AI
Estonian_CS_AI_WS
Estonian_CS_AI_KS
Estonian_CS_AI_KS_WS
Estonian_CS_AS
Estonian_CS_AS_WS
Estonian_CS_AS_KS
Estonian_CS_AS_KS_WS
Greek_BIN
Greek_BIN2
Greek_CI_AI
Greek_CI_AI_WS
Greek_CI_AI_KS
Greek_CI_AI_KS_WS
Greek_CI_AS
Greek_CI_AS_WS
Greek_CI_AS_KS
Greek_CI_AS_KS_WS
Greek_CS_AI
Greek_CS_AI_WS
Greek_CS_AI_KS
Greek_CS_AI_KS_WS
Greek_CS_AS
Greek_CS_AS_WS
Greek_CS_AS_KS
Greek_CS_AS_KS_WS
Hebrew_BIN
Hebrew_BIN2
Hebrew_CI_AI
Hebrew_CI_AI_WS
Hebrew_CI_AI_KS
Hebrew_CI_AI_KS_WS
Hebrew_CI_AS
Hebrew_CI_AS_WS
Hebrew_CI_AS_KS
Hebrew_CI_AS_KS_WS
Hebrew_CS_AI
Hebrew_CS_AI_WS
Hebrew_CS_AI_KS
Hebrew_CS_AI_KS_WS
Hebrew_CS_AS
Hebrew_CS_AS_WS
Hebrew_CS_AS_KS
Hebrew_CS_AS_KS_WS
Hungarian_BIN
Hungarian_BIN2
Hungarian_CI_AI
Hungarian_CI_AI_WS
Hungarian_CI_AI_KS
Hungarian_CI_AI_KS_WS
Hungarian_CI_AS
Hungarian_CI_AS_WS
Hungarian_CI_AS_KS
Hungarian_CI_AS_KS_WS
Hungarian_CS_AI
Hungarian_CS_AI_WS
Hungarian_CS_AI_KS
Hungarian_CS_AI_KS_WS
Hungarian_CS_AS
Hungarian_CS_AS_WS
Hungarian_CS_AS_KS
Hungarian_CS_AS_KS_WS
Hungarian_Technical_BIN
Hungarian_Technical_BIN2
Hungarian_Technical_CI_AI
Hungarian_Technical_CI_AI_WS
Hungarian_Technical_CI_AI_KS
Hungarian_Technical_CI_AI_KS_WS
Hungarian_Technical_CI_AS
Hungarian_Technical_CI_AS_WS
Hungarian_Technical_CI_AS_KS
Hungarian_Technical_CI_AS_KS_WS
Hungarian_Technical_CS_AI
Hungarian_Technical_CS_AI_WS
Hungarian_Technical_CS_AI_KS
Hungarian_Technical_CS_AI_KS_WS
Hungarian_Technical_CS_AS
Hungarian_Technical_CS_AS_WS
Hungarian_Technical_CS_AS_KS
Hungarian_Technical_CS_AS_KS_WS
Japanese_BIN
Japanese_BIN2
Japanese_CI_AI
Japanese_CI_AI_WS
Japanese_CI_AI_KS
Japanese_CI_AI_KS_WS
Japanese_CI_AS
Japanese_CI_AS_WS
Japanese_CI_AS_KS
Japanese_CI_AS_KS_WS
Japanese_CS_AI
Japanese_CS_AI_WS
Japanese_CS_AI_KS
Japanese_CS_AI_KS_WS
Japanese_CS_AS
Japanese_CS_AS_WS
Japanese_CS_AS_KS
Japanese_CS_AS_KS_WS
Japanese_Unicode_BIN
Japanese_Unicode_BIN2
Japanese_Unicode_CI_AI
Japanese_Unicode_CI_AI_WS
Japanese_Unicode_CI_AI_KS
Japanese_Unicode_CI_AI_KS_WS
Japanese_Unicode_CI_AS
Japanese_Unicode_CI_AS_WS
Japanese_Unicode_CI_AS_KS
Japanese_Unicode_CI_AS_KS_WS
Japanese_Unicode_CS_AI
Japanese_Unicode_CS_AI_WS
Japanese_Unicode_CS_AI_KS
Japanese_Unicode_CS_AI_KS_WS
Japanese_Unicode_CS_AS
Japanese_Unicode_CS_AS_WS
Japanese_Unicode_CS_AS_KS
Japanese_Unicode_CS_AS_KS_WS
Korean_Wansung_BIN
Korean_Wansung_BIN2
Korean_Wansung_CI_AI
Korean_Wansung_CI_AI_WS
Korean_Wansung_CI_AI_KS
Korean_Wansung_CI_AI_KS_WS
Korean_Wansung_CI_AS
Korean_Wansung_CI_AS_WS
Korean_Wansung_CI_AS_KS
Korean_Wansung_CI_AS_KS_WS
Korean_Wansung_CS_AI
Korean_Wansung_CS_AI_WS
Korean_Wansung_CS_AI_KS
Korean_Wansung_CS_AI_KS_WS
Korean_Wansung_CS_AS
Korean_Wansung_CS_AS_WS
Korean_Wansung_CS_AS_KS
Korean_Wansung_CS_AS_KS_WS
Latvian_BIN
Latvian_BIN2
Latvian_CI_AI
Latvian_CI_AI_WS
Latvian_CI_AI_KS
Latvian_CI_AI_KS_WS
Latvian_CI_AS
Latvian_CI_AS_WS
Latvian_CI_AS_KS
Latvian_CI_AS_KS_WS
Latvian_CS_AI
Latvian_CS_AI_WS
Latvian_CS_AI_KS
Latvian_CS_AI_KS_WS
Latvian_CS_AS
Latvian_CS_AS_WS
Latvian_CS_AS_KS
Latvian_CS_AS_KS_WS
Lithuanian_BIN
Lithuanian_BIN2
Lithuanian_CI_AI
Lithuanian_CI_AI_WS
Lithuanian_CI_AI_KS
Lithuanian_CI_AI_KS_WS
Lithuanian_CI_AS
Lithuanian_CI_AS_WS
Lithuanian_CI_AS_KS
Lithuanian_CI_AS_KS_WS
Lithuanian_CS_AI
Lithuanian_CS_AI_WS
Lithuanian_CS_AI_KS
Lithuanian_CS_AI_KS_WS
Lithuanian_CS_AS
Lithuanian_CS_AS_WS
Lithuanian_CS_AS_KS
Lithuanian_CS_AS_KS_WS
Polish_BIN
Polish_BIN2
Polish_CI_AI
Polish_CI_AI_WS
Polish_CI_AI_KS
Polish_CI_AI_KS_WS
Polish_CI_AS
Polish_CI_AS_WS
Polish_CI_AS_KS
Polish_CI_AS_KS_WS
Polish_CS_AI
Polish_CS_AI_WS
Polish_CS_AI_KS
Polish_CS_AI_KS_WS
Polish_CS_AS
Polish_CS_AS_WS
Polish_CS_AS_KS
Polish_CS_AS_KS_WS
Romanian_BIN
Romanian_BIN2
Romanian_CI_AI
Romanian_CI_AI_WS
Romanian_CI_AI_KS
Romanian_CI_AI_KS_WS
Romanian_CI_AS
Romanian_CI_AS_WS
Romanian_CI_AS_KS
Romanian_CI_AS_KS_WS
Romanian_CS_AI
Romanian_CS_AI_WS
Romanian_CS_AI_KS
Romanian_CS_AI_KS_WS
Romanian_CS_AS
Romanian_CS_AS_WS
Romanian_CS_AS_KS
Romanian_CS_AS_KS_WS
Slovak_BIN
Slovak_BIN2
Slovak_CI_AI
Slovak_CI_AI_WS
Slovak_CI_AI_KS
Slovak_CI_AI_KS_WS
Slovak_CI_AS
Slovak_CI_AS_WS
Slovak_CI_AS_KS
Slovak_CI_AS_KS_WS
Slovak_CS_AI
Slovak_CS_AI_WS
Slovak_CS_AI_KS
Slovak_CS_AI_KS_WS
Slovak_CS_AS
Slovak_CS_AS_WS
Slovak_CS_AS_KS
Slovak_CS_AS_KS_WS
Slovenian_BIN
Slovenian_BIN2
Slovenian_CI_AI
Slovenian_CI_AI_WS
Slovenian_CI_AI_KS
Slovenian_CI_AI_KS_WS
Slovenian_CI_AS
Slovenian_CI_AS_WS
Slovenian_CI_AS_KS
Slovenian_CI_AS_KS_WS
Slovenian_CS_AI
Slovenian_CS_AI_WS
Slovenian_CS_AI_KS
Slovenian_CS_AI_KS_WS
Slovenian_CS_AS
Slovenian_CS_AS_WS
Slovenian_CS_AS_KS
Slovenian_CS_AS_KS_WS
Thai_BIN
Thai_BIN2
Thai_CI_AI
Thai_CI_AI_WS
Thai_CI_AI_KS
Thai_CI_AI_KS_WS
Thai_CI_AS
Thai_CI_AS_WS
Thai_CI_AS_KS
Thai_CI_AS_KS_WS
Thai_CS_AI
Thai_CS_AI_WS
Thai_CS_AI_KS
Thai_CS_AI_KS_WS
Thai_CS_AS
Thai_CS_AS_WS
Thai_CS_AS_KS
Thai_CS_AS_KS_WS
Turkish_BIN
Turkish_BIN2
Turkish_CI_AI
Turkish_CI_AI_WS
Turkish_CI_AI_KS
Turkish_CI_AI_KS_WS
Turkish_CI_AS
Turkish_CI_AS_WS
Turkish_CI_AS_KS
Turkish_CI_AS_KS_WS
Turkish_CS_AI
Turkish_CS_AI_WS
Turkish_CS_AI_KS
Turkish_CS_AI_KS_WS
Turkish_CS_AS
Turkish_CS_AS_WS
Turkish_CS_AS_KS
Turkish_CS_AS_KS_WS
Ukrainian_BIN
Ukrainian_BIN2
Ukrainian_CI_AI
Ukrainian_CI_AI_WS
Ukrainian_CI_AI_KS
Ukrainian_CI_AI_KS_WS
Ukrainian_CI_AS
Ukrainian_CI_AS_WS
Ukrainian_CI_AS_KS
Ukrainian_CI_AS_KS_WS
Ukrainian_CS_AI
Ukrainian_CS_AI_WS
Ukrainian_CS_AI_KS
Ukrainian_CS_AI_KS_WS
Ukrainian_CS_AS
Ukrainian_CS_AS_WS
Ukrainian_CS_AS_KS
Ukrainian_CS_AS_KS_WS
Vietnamese_BIN
Vietnamese_BIN2
Vietnamese_CI_AI
Vietnamese_CI_AI_WS
Vietnamese_CI_AI_KS
Vietnamese_CI_AI_KS_WS
Vietnamese_CI_AS
Vietnamese_CI_AS_WS
Vietnamese_CI_AS_KS
Vietnamese_CI_AS_KS_WS
Vietnamese_CS_AI
Vietnamese_CS_AI_WS
Vietnamese_CS_AI_KS
Vietnamese_CS_AI_KS_WS
Vietnamese_CS_AS
Vietnamese_CS_AS_WS
Vietnamese_CS_AS_KS
Vietnamese_CS_AS_KS_WS
SQL_1xCompat_CP850_CI_AS
SQL_AltDiction_CP850_CI_AI
SQL_AltDiction_CP850_CI_AS
SQL_AltDiction_CP850_CS_AS
SQL_AltDiction_Pref_CP850_CI_AS
SQL_AltDiction2_CP1253_CS_AS
SQL_Croatian_CP1250_CI_AS
SQL_Croatian_CP1250_CS_AS
SQL_Czech_CP1250_CI_AS
SQL_Czech_CP1250_CS_AS
SQL_Estonian_CP1257_CI_AS
SQL_Estonian_CP1257_CS_AS
SQL_Hungarian_CP1250_CI_AS
SQL_Hungarian_CP1250_CS_AS
SQL_Latin1_General_CP1250_CI_AS
SQL_Latin1_General_CP1250_CS_AS
SQL_Latin1_General_CP1251_CI_AS
SQL_Latin1_General_CP1251_CS_AS
SQL_Latin1_General_CP1253_CI_AI
SQL_Latin1_General_CP1253_CI_AS
SQL_Latin1_General_CP1253_CS_AS
SQL_Latin1_General_CP1254_CI_AS
SQL_Latin1_General_CP1254_CS_AS
SQL_Latin1_General_CP1255_CI_AS
SQL_Latin1_General_CP1255_CS_AS
SQL_Latin1_General_CP1256_CI_AS
SQL_Latin1_General_CP1256_CS_AS
SQL_Latin1_General_CP1257_CI_AS
SQL_Latin1_General_CP1257_CS_AS
SQL_Latin1_General_CP437_BIN
SQL_Latin1_General_CP437_BIN2
SQL_Latin1_General_CP437_CI_AI
SQL_Latin1_General_CP437_CI_AS
SQL_Latin1_General_CP437_CS_AS
SQL_Latin1_General_CP850_BIN
SQL_Latin1_General_CP850_BIN2
SQL_Latin1_General_CP850_CI_AI
SQL_Latin1_General_CP850_CI_AS
SQL_Latin1_General_CP850_CS_AS
SQL_Latin1_General_Pref_CP437_CI_AS
SQL_Latin1_General_Pref_CP850_CI_AS
SQL_Latvian_CP1257_CI_AS
SQL_Latvian_CP1257_CS_AS
SQL_Lithuanian_CP1257_CI_AS
SQL_Lithuanian_CP1257_CS_AS
SQL_MixDiction_CP1253_CS_AS
SQL_Polish_CP1250_CI_AS
SQL_Polish_CP1250_CS_AS
SQL_Romanian_CP1250_CI_AS
SQL_Romanian_CP1250_CS_AS
SQL_Scandinavian_CP850_CI_AS
SQL_Scandinavian_CP850_CS_AS
SQL_Scandinavian_Pref_CP850_CI_AS
SQL_Slovak_CP1250_CI_AS
SQL_Slovak_CP1250_CS_AS
SQL_Slovenian_CP1250_CI_AS
SQL_Slovenian_CP1250_CS_AS
SQL_Ukrainian_CP1251_CI_AS
SQL_Ukrainian_CP1251_CS_AS
With nvarchar(MAX) everything...
December 16, 2013 at 4:21 am
GilaMonster (12/4/2013)
In unrelated news, slightly belated drum rolls please..
Congrats Gail and thanks for all your help.
December 5, 2013 at 7:17 am
Thanks everyone, it works now!
December 5, 2013 at 2:27 am
Regional options are per-user, not system-wide.
Change regional options on the server while logged in as the SQL Server service account.
November 28, 2013 at 2:16 am
If this is in an AG topology you may have hit a bug. See here:
However, I wouldn't focus on the reseed itself unless you really can't accept gaps.
Gaps are...
November 28, 2013 at 2:13 am
Viewing 15 posts - 1,291 through 1,305 (of 5,394 total)