Answer Questions

• Potluri Create Assembly with Microsoft.Sharepoint.dll is possible or not?

     Hi,     In the SQL Server Project if i register my external dll[which contains   Microsoft.Sharepoint.dll]  is possible or Not possible. Because its gives the following error Warning: The Microsoft .Net frameworks assembly 'system.web, version=1.0.5000.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' you are registering is not fully tested in SQL Server hosted environment. Msg 65 ...Show All

• gracestoney Unable to uninstall SQL Server Express 2005 Tools

  I get an error message when trying to uninstall the SQL Server Express 2005 Tools.  It reports, The setup has encountered an unexpected exception in datastore.  The action is Write_CommitFlag.  The error is: Unable to write property into cache: flagCommit. XmlRW Error: Failure loading XmlRW.dll CheckAllProcedures() It is currently preventing me from installing the full Sept CPT because it needs to have the express compo ...Show All

• jpmv Why are rules deprecated?

  So here's the problem - we have a defined domain for a percentage number that will always be { 1 >= x >= 0 }. First thought is to create a User Defined Data Type named "percentage" and attach a rule to it to enforce this domain. Looking in the Books Online, however, shows that apparently, "CREATE RULE will be removed in a future version of MicrosoftSQL Server. Avoid using CREATE RULE in new development work, and plan to modify applic ...Show All

• luoqi sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks Management Studio Express doesn't run side-by-side with the full version of Management Studio.  If you have any version of Management Studio installed on your machine, Management Studio can't start. There is supposed to be a message box that pops up in that case explaining the proble ...Show All

• WesHoward Logging Issue

  We are running into a wierd problem where the "UseParentSetting" LoggingMode only works for the immediatelly called (child) package - the one right after the package that defines (enables) the log. So say you had three packages: Pkg1 enables logging and calls Pkg2, Pkg2 inherits the logging by setting LoggingMode=UseParentSetting and calls Pkg3, and finally Pkg3 inherits logging from Pkg2... In this scenerio Pkg3 would not ...Show All

• shelter sql 2000 tables export

  hi, i installed sql server 2005 express on my tests server, i need to move a database from my sql server 2000 to test how it works with 2005. i understood that the export/import option is not available in express version. but i still need to pass my database, other wise i cant check the power of the 2005 version. please tell me about other way to do! Moving database from SQLS2k5 to SQLS2k5Express may be not easy! I have obtained cus ...Show All

• taibo Problem with SSIS Transaction...Transaction Scope

  Hi, I am having some problem with SSIS transaction. Eventhought I tried to imitate the concept that Jamie presented at http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservices.asp . My workflow is as followed ********************************* For Each ADO.Record in Oracle (transaction=not supported) If (Certain_Field_Value = 'A') Lookup Data in SQL DB with values from Ora ...Show All

• Jace314 programmatically extend project tree

  Hi, I need to write an add-in, that when installed it will add a virtual folder to the project tree (in which I can later add other stuff). The problem is even more complicated since the project I want to extend is an SSIS project (SQL Server Integration Services), and it doesn't let you customize the project structure even from the project explorer itself (can't add folders). I appreciate any help on this. Thanks. ...Show All

• zatom idham Align image

  I have an image in a table cell in my report. Naturally not all images fit 100% in the cell which is why I'd like to align the images in the middle of the cell, horisontally and vertically. I've been unable to figure out how to do this in Reporting Services for SQL Server 2000. Am I missing something or is this simply not possible Does anyone know whether it can be done in 2005 I would but we're talking an entire column of images of varyi ...Show All

• lampher Cannot create new SQL database file.

  Hello, I'm using MS Visual C# 2005 Express, but I can't create a new local database file in the "Add -> New Item" dialog. The Studio doesn't create the database, but shows a file not found message. Any ideas Let's take these as two different problems; connecting to an existing database and creating a database. It's easy to start mixing up the behaivors and confuse the issue. Creating a DB ...Show All

• testing1 Select All column except one in SQL

  Hi, I have a table with 100 column i want to select 99 column except one without writting name of all the 99 columns in the select statement. Hi Prashant, I guess SSMS is the Sql Server Management Studio. This is the replaced Enterprise Manager of SQL Server 2000 for SQL2005. You can have a similar solution in SQL 2005 by using SSMS. Just go to table you want to list its columns. Open context menu, select "Script Table ...Show All

• Rocket Rick Groupings in Matrix Layout?

  Hello, I am trying to come up with a Matrix report using RS 2005 that looks like this one below. I have row data: question, columns data: Ethnicity and Gender, detail data: Gender average response and Ethnicity average reponse. I utlilized Report Wizard to create a report in a Matrix format , however I wasn't able to have Gender and Ethnicity column on the same line. The report wizard groups columns so Gender is a subset of Ethnicity ...Show All

• Veronica Smith W2K3SP1, IIS, Forced directory browsing

  My Reporting Services broke when installed W2K3SP1. Users can get into the report list but when they select a report the request is translated into a request for a directory listing from the Report Server. If I enbale directory browsing for the report server the directory list is returned. If disable directory browsing then a 403 error is returned. I am also getting this error with OWA services on my exchange server. Any ideas ...Show All

• hfrmobile Blanks in columns

  Quick Question I hope. Does having a lot of blanks in a column cause errors In 2 or 3 packages where I get 95% of the data in the Error Colomn I can find nothing wrong with the data at all it all either seems perfect or there is no data in the column in question usually I would have maybe 800 rows where data would have been inserted but in the other 40, 000 rows the column is blank Using the "Retain null values from the source as ...Show All

• Fiona Fung MSFT How to get correct element flow layout in report?

  Did anybody have problems with organizing report elements in free flow layout. I generate RDL from a template based on input parameters. The report consists of variable number of header text boxes, matrixes or tables, several footnotes, and several charts. Obviously it is impossible to predict where exactly (Top) each element will be positioned on a page. Problem is that if not specifying Top attribute result is hardly predictable. Matrix ...Show All