Chan Wai Yin (12/21/2009)

---

Hi,

We want to store native fonts for Chinese Macau Fonts and we use Chinese_PRC_90_CI_AS database collation according to MSDN. However as far as I know SQL Server...

Also, note that using the [ code ] tags can help us a lot by making it easier to read your code:

strSql="Select * from Tbl_Transaction where txt_StateCode="& txt_StateCode &" and...

For future reference, please note that this is a SQL Server 2008 forum, and in general, you will get better response to yoru SQL 2000 questions in the corresponding SQL...

Well, *I* can't figure out what you're asking...

skinothetis1 (12/16/2009)

---

...Barry, actually i wouldn't want to sound like a Greek fanatic of something but you have thousands of words that you don't know as Greek but they are actually...

There are lots of reasons, but in my experience, there are two (or three) biggies...

First is what nabha already mentioned: some instances are hidden and won't ever show up.

Second, is...

I think that this thread (http://www.sqlservercentral.com/Forums/Topic649184-386-1.aspx) explains the problem.

sbowell (12/13/2009)

---

...

I did have a play with Service Broker and couldn't get what I wanted out of it. I haven't a clue what BizTalk is or even how to use...

nagarajan.tiruppur (12/15/2009)

---

Hi

I have a SP ....

CREATE PROCEDURE

sp_GET_NEXT_SEQU (@TABLE_NAME char(25))

AS

DECLARE @LV_TEST numeric(9,0)

BEGIN TRANSACTION

SELECT @LV_TEST = SQ_COUNT FROM F_Sequ LOCK WHERE SQ_TABLE=@TABLE_NAME

UPDATE F_Sequ SET...

Two things, first in your SQL script:

DECLARE @xml XML

SELECT @xml = xml_data FROM #XmlImportTest

DECLARE @Pointer INT

EXECUTE sp_xml_preparedocument @Pointer OUTPUT,@xml

SELECT

[Status] = Table1.Column1.value('./../Status[1]', 'varchar(50)'),

PONumber = Table1.Column1.value('./../PONumber[1]', 'varchar(24)')

FROM @xml.nodes('/Response/PONumber') AS Table1(Column1)

You do not...

No something is wrong here. Without the CONNECT right, a Login cannot use any resources in the database. If they are getting in "some other way" then they...

The only way to do this that I can see would be to use "GRANT ALTER TO {user} WITH GRANT OPTION" which gives them the desired permissions, except on everything...

I think that what you want is something like "GRANT ALTER ANY PROCEDURE". Unfortunately that doesn't exist.

Glad I could help.

Well, while it's true that English has...

SSIS can do it.