Answer Questions

• Sukirman_J LOB is written into wrong filegroup

  Hi there! I've a table with a nvarchar(max) column on Filegroup2. While inserting a lot of big datas (Word documents, each 2.5MB), the primary filegroup is growing - but the Filegroup2 remains still on its creation size. Is that a bug By the way, i ve dropped the table and recreated on the other filegroup, after that i've restartet the SQL 2005 Service. Someone experience Thanks, Torsten It would ...Show All

• vvatclor Custom source adapter UI

  I am currently writing a custom source adapter that extracts data from a JD Edwards OneWorld system. In the custom user interface of the source component I need to allow the user to set a query (a custom property), and then refresh a list of output columns that will be extracted based upon that query (similar to the list shown in the advanced editor). My question is, can I apply the custom property change to the component and build my output ...Show All

• Sanguin Developers my problem in detail

  How I can rectify divide by zero exception in stored procedure Thanks for ur suggestion, but I already solved it by case method it goes too much bigger but it gives satisfied results well, ur answer giving very well theoritical concept, Thank u once again, Next I will send u another query, if i have Thank U chandra ji once again, i was already using same ideas which u send. But Its very well felling inside me, Thanks once aga ...Show All

• oldboy67 problem copying database from sql server 2000 to sql server 2005

  Hi, I have right now sql server 2000 instance installed on a server (serverone) which is accessed on all nodes through an ODBC connection. Now we have upgraded our server to windows server 2005 which will be on other machine servertwo. I have right now installed sql server 2005 in servertwo. Wish to copy the database from serverone to servertwo. Once it is copied and everything is working fine. I want to uninstal sql server 2000 from serve ...Show All

• Steve_j_maas SQL Management Studio missing Log Shipping Monitor, and Taskpad View

  Are this features still somewhere and if yes how can i access them which where in SQL2000 Enterprise Manager thx in advance Thomas Related to Taskpad, I attempted this with a sql2000 instance and was unable to use the report icon.  The report icon is grayed out.  Any idea why   Bad install or unsupport on sql 2000   Thanks. There aren't any reports for SQL Server 2000 servers defined ...Show All

• Rati Passing parameter to a dts

  I don't understand how to pass a parameter to a dts package from another. In SQL 2000 you can map a variable with a variable of the package you will call. How can I do this For example in the current package execution (package1) I have a variable1 = 5 and when some step complete I call package2 with the value of variable1 in variable2 of package2. I need help with this. Thanks in advance. Yes I try to do ...Show All

• Suman_g Automated backups in SQL Express?

  I've realize that the SQL Agent service is no longer available now that i've upgraded from MSDE 2000 to SQL Server Express. I would like to find out the easiest way I could go about creating an automated backup solution for SQL Server Express.  Previously I created Jobs in the SQL Agent Service using SQL DMO which is not longer possible. Has anyone any suggestions that would be easy to setup or any samples that I could use   Maybe usi ...Show All

• Willbur4u CLR Enabled

  Can anyone tell me what this means and how to fix it I created a stored procedure in VS2005 and did a build. When I went to SQL Server there was the stored procedure but when I run it I get the error.... Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option I changed the 'clr enabled' property to 1 using sp_configure but I still get this error. Thanks Mike I only have 1 instance of SQLEXPR ...Show All

• Colin Meek - Microsoft Printing report produces .25 inch horizontal offset

  When I print my report to the printer it is not centered correctly.  It is offset around .25" (or more) to the right.  I have my page setup as 8.5" x 11".  I have all my margins set to 0.5".  My body is exactly 7.5" x 5".  When I export to pdf everything is centered.  When I view the report in the 'print preview' type view it is centered.  However, when I actually print it is offset.  I measured the output ...Show All

• Gavin Jin - MSFT Problem with valid owner

  I have just downloaded the MS SQL Server Management Studio Express, and are following a tutorial on www.learnvisualstudio.net Now I am having trouble with some owner information. The message says : "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTORIZATION statement to set the database ow ...Show All

• Arshadje BUG (Microsoft SQL Server 2005 JDBC Driver)

  Could you pls send me url to exist bug, if you guys already have it. Here is exception stack trace. 2006-03-13 20:22:59,859 DEBUG [org.hibernate.jdbc.AbstractBatcher] closing statement 2006-03-13 20:22:59,859 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not execute query [SELECT ...........................................here is my query............................... ...Show All

• JensN Conditional calculated member

  Hi there, I have a newbe MDX question. Im trying to make a calculated member that contains a different calculation depending on a value of an attribute. something like: "CASE WHEN Attribute X = "string A" THEN calculation X ELSE calculation Z"  I tried the IFF and the CASE statement, but with negative results Any Suggestions I am using MS AS 2005 RTM. A more efficient way to achieve this in AS ...Show All

• HankHuf Datareader Query Timeout

  Hello, I am running a query via a ado.net data flow source. It works great for a small number of rows, but if I try to execute a long running query it times out with a communication error. I have looked through the doc and every property sheet that I can find in my package, but I can't find anywhere that a timeout is specified. Any help on finding this would be appriciated. The query is running against DB2 on z/os and I know it is timing ou ...Show All

• prasannav Multiple tasks in the same assembly

  Hello, All the SSIS tasks (and components come to mention it) exist in their own assembly file. Is there anything that stops us from putting multiple tasks into one assembly Assuming you can do that, is there a reason why this perhaps should not be done Thanks Jamie Actually, the percent sampling and row sampling transforms are in the same DLL.  There is nothing to stop you from having multiple tasks or multiple components in the s ...Show All

• vsnk Using CLR Stored Procedure for Data Driven Subscription

  This is a stumper: I have a .NET stored procedure that returns email addresses, and I want to use it for a data driven subscription (DDS) for a report. The 'email' field returned is not exposed to the DDS wizards so if I set 'exec myCLR_SP' as the query for the data the 'email' field is not in the drop down list of available query derived values. So my question: Is their anyway to imform the DDS wizard that the myCLR_SP returns a field called 'e ...Show All