Answer Questions

• DaniMaia How to create XML documents over 8000 bytes?

  I have a script transform object that is creating XML to be inserted into a SQL 2005 database. It seems only an N_TEXT can be inserted, but N_TEXT is read-only in the script task.  The only way I've found to make this work is to have the script transform produce the XML into a DT_STR(8000) string, then convert that to N_TEXT in a Data Conversion task so it can be inserted. Now I have a problem in that my XML has exceeded the 8000 byte DT_ ...Show All

• BigAlz restore database from CTP edition to developer edition

  hi there, i m currently using visual studio 2005 beta 2 with SQL server 2005 Developer Edition CTP developing application. i now considering to switch my project to use visual studio 2005 professional edition and SQL server 2005 Developer edition. however i was afraid that my database cannot be restore into SQL server 2005 Developer edition anyway, can it be restore if i switch This worked for me ...Show All

• TylerAKAsection8 Newb Question: Why is only one out of four processors slammed?

  Hi, I have a quad proc 3Ghz Proliant DL580 G3 with HT disabled, using 8GB memory. I'm running W2K3 Enterprise and SQL2K Enterprise. Here's how I have the SQL server's processors tab configured: SMP Environment: Checked only 1, 2, and 3. Reserved 0 for Windows and other apps. Max Worker Threads: 255 Boost SQL Server Priority on Windows: Disabled Use Windows NT Fibers: Disabled Parallel Execution of Queries: Use all availab ...Show All

• AnandaKumar.S Authentication Issues

  Current Setup: Windows 2003 Server SQL Server 2000 w/ SP3 Windows Sharepoint Servics Problem: I have created a group on our Domain (INT) called Domain Users. Inside this group I have added individual users that need to be there. On the SQL Server when I try to add INT\Domain Users I get an error stateing that the user does not exist. Next I tried typing in INT and selecting the browse button. The window opens up listing all Domain users and grou ...Show All

• Annuzzer Cannot access Calculations tab, BI Studio hangs up after installing SP1 and Hot fix.

  Dear All, I have installed SQL Server 2005 SP1 and Hot fix, and after that I cannot access calculations tab in BI Studio. any suggestions! Thanks 1399 is RTM while so 2153 must be Sp1 (although I can't directly confirm the sp1 version). Yes, you can just copy the latest version over. The important thing is to have consistent version numbers between these two dlls. I've seen this ...Show All

• Robert Simpson Partition Scheme

  Hello everybody, how can I verify a partition scheme in SQL Server 2005 (June edition) SELECT p .* FROM sys.partitions p , sys.objects o WHERE o . name = 'mytable' AND o . object_id = p . object_id GO this always returns only one partition thank you Eckard BTW, there is some confusion about terminology.   A partition != a partition scheme.  The query above looks at a tab ...Show All

• Aaron Carlson missing notifications

  Hello, We are building a simple distributed application around the service broker where each queue is serviced from a windows service. We have a windows service running constantly as a "listener" on an event queue for each of what we call "request" queues. When a message is received by the request, the listener service instantiates a reader to process the request. As we are in development, things get out of sync at tim ...Show All

• OlgaD having a contractor develop SSIS packages and security issues

  Hi Guys, I will have a constractor for 3 months developing ssis packages for me. Obviously, his Windows account will be deleted when he leaves. My question his. under which securoty context should he develop packages so they will still work and still be accessible after his departure. Assuming we do not want to use any password to either have his packages running or have his packages accessible by other developers from the developm ...Show All

• Maximilian Haru Raditya Problem with ODBC Source

  I'm having trouble using a Progress database as a source.  I have an OpenLink driver installed and a System DSN set up.  I can successfully test the connection.  I added this DSN to the connection manager and added it to a DataReader Source.  I then added the SQLCommand property.  I was able to map columns and such, so I believe the SQLCommand was successfully parsed.  However, when I try to save the DataR ...Show All

• CraigAP WebServices with IIS or SQL?

  Hello there. I want to ask when I should make webservices with visual studio.net and when with Sql Server. How should I take that decision any scenario examples Thanks    I recommend reading the following technical article on MSDN http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/sql2005websvc.asp that discusses usage scenarios for SQL 2005 native web service. There is also a section in SQL 200 ...Show All

• thrantir How to convert a SQL 2000 DB

  I would like to move a SQL 2000 DB to SQL 2005 Enterprise Edition.  My SQL 2000 DB already has a few users in it.  When I do a full-backup in 2000 and restore into 2005, the users are not accesible.  I can't drop those users in 2005 as these users own a few objects.  Is there a simple method that allows us to take a full backup of 2000 and migrate to 2005     If not, any relevant tips are greatly appreciated.&n ...Show All

• MichaelChesapeake Restore from snapshot

  Hello, Is there someone who alreadry tried to restore from a snapshot generated from a mirrored dabase Actually I am looking for the steps that I need to go through to do that. Do I have to stop the mirror before the restore Can I only restore from the snap if the local database is the 'principal' meaning that I have to generate a manual failover Thanks in advance for your help. Jerome Many thanks Mark Jerome ...Show All

• Wamplerj1978 Drillthrough action

  Hi, Is there any way in AS2005, I can specify a cube action which will bring up an HTML page displaying the Drillthrough MDX for the cell that I just initiated the action on Also, will this MDX work across all cube partitions (no need for FIRSTROWSET clause) Thanks, JGP Drillthrough actions return a DRILLTHROUGH statement to client application (e.g. cube browser) which in turn executes the stat ...Show All

• Trombino access SQL2005 MOBILE database in a VS2003 mobile app

  It is possible to access a Sql Server 2005 Mobile database in a VS2003 application (compact framework) Thanks Robson I’m not quite sure about your scenario. Are you trying to make existing applications which are designed to use SQL CE 2.0 to work with SQL Mobile without recompilation If so, that is not possible. If you have access to the source code of VS 2003 applications created with NETCF V1 (there’s no NETCF 1.1 or ...Show All

• ingmiguelmejia SQL Mobile Server Tools install on SQL 2000 SP4

  I am trying to install SQL Mobile Server Tools (beta 1) on my SQL Server 2000 SP4 server.  I have already installed the SP4 Replication Components upgrade and my existing SQL-CE databases replicate ok, however when trying to run the SQL Mobile Server Tools (beta 1) install it fails the System Configuration Check with the following error: "You must first install the Replication Components for SQL Server SP 3a or higher or the SQL Server 200 ...Show All