Latin1_General_BIN vs Latin1_General_BIN2 in Script

Hi John
No, with Latin1_General_CI_AS I not have problems, but I dont test with
others Collations and the problem is in db not in the tables.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Does the same thing happen with Latin1_General_CI_AS? Does this happen with
> a subset of the tables etc?
> John
> "sqlextreme" wrote:
Hi
How are you generating this script?
John
"sqlextreme" wrote:
[vbcol=seagreen]
> Hi John
> No, with Latin1_General_CI_AS I not have problems, but I dont test with
> others Collations and the problem is in db not in the tables.
> "John Bell" wrote:
|||In Management Studio-> Select de Name db -> Tasks -> generate scripts -> db
and etc. for all objects
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> How are you generating this script?
> John
> "sqlextreme" wrote:
|||Hi
I have no problems generating a script for the following database:
CREATE DATABASE BIN_DB
COLLATE LATIN1_GENERAL_BIN2
USE BIN_DB
GO
CREATE TABLE tbl1 ( id int not null identity, col1 varchar(10) )
GO
CREATE TABLE [dbo].[tbl2](
[id] [int] IDENTITY(1,1) NOT NULL,
[col1] [varchar](10) COLLATE LATIN1_GENERAL_BIN2 NULL
)
GO
USE TEMPDB
GO
John
"sqlextreme" wrote:
[vbcol=seagreen]
> In Management Studio-> Select de Name db -> Tasks -> generate scripts -> db
> and etc. for all objects
> "John Bell" wrote:
|||Is strange, if you make script for all objects this is the result:
Generate Script Progress
- Determining objects in database 'BIN_DB' that will be scripted. (Error)
Messages
* Exception has been thrown by the target of an invocation. (mscorlib)
ADDITIONAL INFORMATION:
There is already an open DataReader associated with this Command which must
be closed first. (System.Data)
but, if you make script by next and next for all objects this is the result:
Generate Script Progress
- Determining objects in database 'BIN_DB' that will be scripted. (Success)
- dbo.tbl1 (Success)
- dbo.tbl2 (Success)
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I have no problems generating a script for the following database:
> CREATE DATABASE BIN_DB
> COLLATE LATIN1_GENERAL_BIN2
> USE BIN_DB
> GO
> CREATE TABLE tbl1 ( id int not null identity, col1 varchar(10) )
> GO
> CREATE TABLE [dbo].[tbl2](
> [id] [int] IDENTITY(1,1) NOT NULL,
> [col1] [varchar](10) COLLATE LATIN1_GENERAL_BIN2 NULL
> )
> GO
> USE TEMPDB
> GO
> John
> "sqlextreme" wrote:
|||Hi
It does seem like this is a bug, selecting "Script all objects in the
selected database" will also produce the error on my system. There seems to
be a few similar errors logged on connect such as
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127175
although that is closed and supposed to be fixed before the version I am
using (9.00.2047.00).
John
"sqlextreme" wrote:
[vbcol=seagreen]
> Is strange, if you make script for all objects this is the result:
> Generate Script Progress
> - Determining objects in database 'BIN_DB' that will be scripted. (Error)
> Messages
> * Exception has been thrown by the target of an invocation. (mscorlib)
> --
> ADDITIONAL INFORMATION:
> There is already an open DataReader associated with this Command which must
> be closed first. (System.Data)
> but, if you make script by next and next for all objects this is the result:
> Generate Script Progress
> - Determining objects in database 'BIN_DB' that will be scripted. (Success)
> - dbo.tbl1 (Success)
> - dbo.tbl2 (Success)
>
>
>
>
> "John Bell" wrote:
|||..I installed a new instance of SQL Server 2005 with Latin1_General_BIN2 and
later I created a db with Latin1_General_BIN2 and I could not create script.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> It does seem like this is a bug, selecting "Script all objects in the
> selected database" will also produce the error on my system. There seems to
> be a few similar errors logged on connect such as
> https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127175
> although that is closed and supposed to be fixed before the version I am
> using (9.00.2047.00).
> John
> "sqlextreme" wrote:
|||Hi
I have logged this at
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=248724 where you can vote for the issue.
John
"sqlextreme" wrote:
[vbcol=seagreen]
> .I installed a new instance of SQL Server 2005 with Latin1_General_BIN2 and
> later I created a db with Latin1_General_BIN2 and I could not create script.
> "John Bell" wrote:
|||Hi,
Ok, thank for your help.
Cristián
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I have logged this at
> https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=248724 where you can vote for the issue.
> John
> "sqlextreme" wrote:
sql