Search results for query: *

i have the same problem. Are there any cumulative update for this bug.

i understand, and know the method. BSA(BacktoStoneAge) method. :))) Thanks a lot but this database is live. and it has millions of records and PrimaryKey tables and keys and indexes triggers. So i cant stop the engine. I can easily change the COLLATION with normal datatypes, i only have...

thanks:(

thanks ptheriault i know but in your example you just change the collation of the result. Table's Column COLLATION dont change. i want to change the TABLE STRUCTURE ALTER TABLE tbxxxx ALTER COLUMN sDefinition varchar(100) COLLATE Turkish_CI_AS NOT NULL no problem. ALTER TABLE tbxxxx...

Hi everyone? How can i change collation of userdefined datatype? When i try to change it Management Studio Query varcharUzun = varchar(100) --> userdefined data type.... ALTER TABLE tbxxxx ALTER COLUMN sDefinition varcharUzun COLLATE Turkish_CI_AS NOT NULL when i run the query it says...

Hi everyone. suppose that i have 3 dimensions as. ProductModel and Color and SalesFact table. i want to find the distinct count of ProductModel+Color. i mean. Year/ProductModel/Color/Sales --------------- 2006/010101 /White /1.0 2006/010101 /Black /2.0 2007/010101 /White /1.0 2006/010102...

Hi, I just want to uninstall COM1 or COM2 Commination Device. I can easily do it by right clicking COM2 and click COM2 from Device Manager. But i want to do it with VB Script. I can the read the properties with the code below. But i want to remove the port???? On Error Resume Next...

i execute it in Command_click event. i connect to SQL2000 and load data into XmlDocument Dim MyXML As XmlDocument Assume that i have xml in XML document like below. <ORDERS> <ORDER_DATE>8/3/2005</ORDER_DATE> <ORDER_NUMBER>124233</ORDER_NUMBER> </ORDERS> i just want to send it to...

i thougt it was easy question for ASP.NET developers... :(

Imports System.xml I create the xml document in ASP.NET VB by connecting SQLServer2000. The code above works fine. I have no problem about creating the XML Document. I load my data to MyXML... Now i just want to open this XML in visitors browser... or send it to visitor(Save as Page).... thanks

Hi All I have created XML File with XMLDocument in ASP.NET than i want send or show this file in browser to visitors. without saving it to disk. How can i do that? i want to show (MyXML) in explorer. or post it to customers? Dim dst As DataSet dst = ReturnDatasetFromSql(db, "Select *...

I also cant use turkish characters in this forum. xxx.sql example --------- insert into Table1 select 's', 'Çarsi ' 'Çarsi ' must be ---------------- Ç a r 's' = with point under the character. 'i' = without point over the character. :)

Hi everyone. i have a problem isql utility. My Server : SQLServer2000 xxx.sql example --------- insert into Table1 select 's', 'Çarsi ' For example this xxx.sql is my sql table. I have no problem when running isql queries like below. But when run this query i cant insert the characters like...

I had the same problem(maybe it is different) in In sql7 you cannot restore files larger than 2GB. it says (not enough space you have only 2.174.....bytes free). To restore 3GB MDF and 4GB LDF To solve this At first i create a empty DB with size of 3200MB MDF and 4200MB ldf... And then i...

Thank You very much. I found in sysservers that CEM srvID was 6. But it must be 0 in order to be local server name. This solved my problem. sp_dropserver 'CEM' sp_addserver 'CEM', 'local' Stop and Start SQL Server. thanks again.

SQL7 or SQL2000?

Hi every one. I have to SQLServers in my computer. First one SQL Server 7.0 (CEM) Second one SQL Server 2000 (CEM\SQL2) When use (select @@servername) in sql2000 Result : CEM\SQL2 But When use (select @@servername) in sql7 Result : NULL There is no problem when i connect Query Analy. Or...

As zhavic said...His query works. dont forget to add DESC to the inner query zhavic ------------------ SELECT TOP 1 salary FROM ( SELECT TOP 5 salary FROM tablename GROUP BY salary ORDER BY salary desc )...

The way that i use. You can delete fully or partly duplicated ------------------ Example table ------------------ Create table EG ( ID int, Value1 int, Value2 int ) declare @ID int declare @Value1 int declare @Value2 int declare @Count integer declare CursorDuplicates Cursor for SELECT...

Come on Ofcourse it works. ----------------------------- declare @ID int declare @Value1 int declare @Value2 int declare @Count integer declare CursorDuplicates Cursor for SELECT ID FROM EG open CursorDuplicates fetch next from CursorDuplicates into @ID , @Value1 , @Value2...