Answer Questions

• Efren Active Directory 1000 rows limitation

  we are using select distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber from OpenQuery( ADSI, 'SELECT telephonenumber, distinguishedname, employeeid, sn, middlename, givenname, displayname, samaccountname, mail, cn, telephonenumber FROM ''LDAP://DC=domain,DC=xxx,DC=xxx'' WHERE objectCategory = ''Person'' AND objectClass= ''user'' But it only returns 1000 rows which i read all ...Show All

• adamt using EXEC to execute a formula stored in a string

  Hopefully someone will have run into this before...  Basically, I have a table with a column that stores mathematical formulas in string format.  When my UDF is executed, it needs to select an appropriate formula from this table and evaluate it using values that are stored in local variables.  Look at the example below: Suppose I have a string named @vcFormula that contains the following: "@dVar1 + @dVar2 / @dVar2" ...Show All

• Cheval Failed Install of SQL Server 2005 SP1 CTP

  Hello, We are attempting to install the CTP for SQL Server 2005 SP1 and receive the following error message in the log: The following exception occurred: Unable to install Windows Installer MSP file  Date: 03/24/2006 14:19:40.562  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 856 This is then followed by this failure with the Database Services: Product: Database S ...Show All

• Emre Serialize and deserialize problem in SQL CLR

  Hi, I have tried deserialize a class in sqlclr but i have an exception thrown, then i tried the class in windows programming it's work normally. what hapen with that can anyone help to resolve the problem Hi, Tutnik, At least can you give some code for the class you are deserializing, and the exception information Regards, Dong Xie ...Show All

• jeveret More installation issues.

  Hey everyone, I just downloaded the express edition and tried to install it. I passed all the sys reqs and it seemed to be going well, but it said that "An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'." The full installation log is below. Microsoft SQL Server 2005 9.00.1399.06 ========================= ...Show All

• Ashok Debnath xml data source, not sure why i'm losing data

  i'm trying to load data into a sql database using an xml data source. here's the file location: http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml the xsd (generated by visual studio) is below. All outputs generate 0 rows inserted into an OLE DB destination, and there are no errors thrown.. What am i missing Thanks! < xml version="1.0" encoding="utf-8" > <xs:schema xmlns:tns="http://www.ec ...Show All

• rpreston Wierd results with != operator

  Hi all, I have a table - customer with a Column state_code varchar(5) and another valid( smallint) select count(1) from customer where state_code != 'U' -- for unknown and valid= 0 -- for valid Returns different counts each time, even when the data in the table is NOT Changing. something with != operator Thanks for your help ! Sri Hi Adam, select @@version returns ...Show All

• elargento Cube structure to be "redone" everytime on changing Data Source in Analysis Services2005. Why?

  Hi Folks, I have a strange discovery. This use to work fine with AS 2000. Here's the problem : I have a AS 2005 cube "Cube1", existing with all the functionality. I want to test some things - so I did cube "Save As" tstCube1. Now tstCube1 is my test cube. I changed the data source in tstCube1 to a "new" SQL database ( this new database is exactly the same schema structure as compared to the schema that origina ...Show All

• David Pugh MSFT Memory configuration for SQL 2005 x64 bits

  Hi I understand that I do not need to use /PAE on Windows Server 2003 x64bits as it is not supported. I also do not need to use awe enable under SQL Server 2005x64 bits because 64bit SQL doesn't need to use the AWE api to address the larger memory space. When I do a sp_configure, AWE indicates that it is disabled but is that OK Do I still need to set a max and a min memory for SQL Server Is there any pro/cons if I do that Please ...Show All

• APMaio Creating relationships between 2 databases

  Is it possible to create relationships and enforce constrains thereof between two fields with the same data type from 2 different databases ( i.e. 2 different .mdf files ) altogether, attached to an instance of SQL Server 2005 Express This would help overcome the limitation of the 4GB database size it imposes, by splitting the info required into different databases, rather than just different tables. All the relationships could be then created ...Show All

• AlmCoder NS 2.0 SP1 Install Problem

  What could cause the NS 2.0 SP1 installer to think that a qualified version of SQL Server 2000 is not installed and available   I'm trying to install NS 2.0 SP1.  The current config is: - Windows 2003 Server (Standard Edition) with SP1 - SQL Server 2000 (Developer Edition) with SP4 - Analysis Services 2000 (Developer Edition) with SP4 - Reporting Services 2000 (Developer Edition) with SP2 - Windows Sharepoint Services 2.0 with SP2 - Of ...Show All

• JoyceMR sql server 2000

  This is my last attemp at trying to install sql server installed, which its been quite reluctant too, as I've spent the last 2 hours with no progress. I've downloaded MSDE2000A.exe from http://www.microsoft.com/downloads/details.aspx FamilyId=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en Installed it in the default directory. "C:\MSDERelA" And ran setup which returned this error "A strong SA password is required for securit ...Show All

• nzmike Data Trasformation Services

  Hello All, Can anyone tell me.. is that I can't create DTS if i'm using 4 field for Primary Key Can you explain a little more Seems like you are using DTS to move data from one place to anotehr You have a table with 4 columns in the primary key what is that DTS is not letting you do Thanks Euan, :D Sorry babe!!! Yups.. I want to move data from tableA to tableB.. but in the same database.. I ...Show All

• Tim Schmidt How can I detect which version of sqlServer I am connected to using smo?

  Hi, I have a quick app to do few scripts and generate sps.However some stuff which is new to sql 2005 dont work in sql 2000 as not supported. Basically. I choose a server from a combobox and connect to the database. now at this point i need to know if I am running a sql 2005 server or 2000 . Is there a call I can make is SMO to achieve this thanks a lot in advance Ye, thats right, look at th ...Show All

• GNX How can I get the actual line number from inside flatfile sources for each record?

  hi all, maybe this is not a serious problem, but I tried for days to come toi a solution without success. My Problem: I have have several flatfile sources I need to import into a sql-server 2005 DB. It is very important for me to have the original line number from inside the source file for each record. The rowcount transform doesn't fit in for this task, because it accumulates all rows until the end of the dataflow. I tried s ...Show All