Answer Questions

• marina B. How to restore SQL 2005 DB to SQL 2000

  Hello, I'm tring to restor a DB from sql 2005 (which is located on my local computer) into sql 2000 (which is located  on the server) and I am getting this type of message: TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: Too many backu ...Show All

• Whatisid What is up with Defaults in 2005????

  To keep inline with BOL, I have gone away from the CREATE DEFAULT and sp_binddefault when using defaults, and have gone to using what BOL suggests and specifying the default on the column definition when adding a column. However, I cannot find anywhere how to REMOVE a default when applied in this manner. I need to delete a column via T-SQL and according to BOL it says a column cannot be deleted when it is associated with a default that is defin ...Show All

• Ian Cummings Flat file - row delimiter problem

  Hi, I'm trying to design this package where i take data from a source and need to transform it into a flatfile with some extra static information. I use a SQL script like this (ex.): SELECT ' BS0220131264202400000130001' + cast ( wa . perf_applicant_number as nvarchar )+ '000000000' + wa . perf_firstname + ' ' + wa . perf_lastname + CHAR ( 13 )+ 'BS0220131264202400000330001' + REPLICATE ( '0' ,( 15 - LEN ( wa ...Show All

• Kurt Brockett Sql Server 2005 Notification-based Cache Invalidation

  I'm trying to set enable SQL cache invalidation on a webpage, specifically on a a datasource that fills a GridView.  The website http://beta.asp.net/QUICKSTART/aspnet/doc/caching/SQLInvalidation.aspx  makes it sound so very simple, and I have attempted to do all that it says, yet something just isn't right.  The site says that the following needs to be done. Queries must explicitly include column names in the SELECT state ...Show All

• Matthew_M81 the SQL server is Challenging me....:-)

  Hi everyone, I had an old VisualStudio.Net version thet started going nuts, so I thought its time to install the beta 2 version. then started the problems .... when trying to uninstalling the SQL server, the computer shouted it's impossible. so I uninstalled the SQL tools first and then the uninstalation succeded. (it wasn't recommended by the operating system) after removing everything I wanted to install the new SQL server that comes ...Show All

• Srini111 problems creating report (parent child hierarchy)

  hello, im working with as/rs 2005 and need help in creating a report. my cube has a parent child hierarchy in "category". structur is as follows: A a 1 2 b B C f g 10 11 12 I like to have a function or something, that gives me the unique names of a ...Show All

• FlorinV SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• Only One Tom RAPI fails on CeMountDBVol (WinMobile 5)

  My PC app uses RAPI to install files to a CEDB database on Windows Mobile devices. Works for PPC 2002, 2003 devices, ActiveSync v3.8 and 4.1 On Windows Mobile 5.0 devices with AS 4.1, RAPI fails on CeMountDBVol with an ERROR_INVALID_PARAMETER. What needs to be done to correct this I have read about RAPI Security policy, but this case doesn't seem to apply. I am loading RAPI DLL dynamically. ex: bResult = (*pCeMountDBVo ...Show All

• hYam Impact of "Rows per batch" on OLE DB Destination?

  OLE DB Destination has a "Rows per batch" parameter. Are there best practices/guidelines around what it should be set to (for better performance etc) For example, if each row is of size 100 bytes, how does performance change when I set a batchsize of 0, 100, 1000, 10,000 etc I guess the default value for this parameter is zero. Does that mean, internally it is implemented as: For each row: begin transaction insert row commit tran ...Show All

• SFogli Improving Cursor Performance

  Hello Can we use rowsets in sql server triggers and stored procedures for improving cursor performance. Any other solution in this context is welcome Chikuu Hi, Can you use FAST_FORWARD instead of SCROLL while you are declaring the cursor Using Fast_Forward option will increase the performance. Also you use user defined functions ( dbo . NIMP and the other two ) returning rowsets. You sh ...Show All

• AbirB LIKE % question

  Hello, I'm working on a project where I have a drop-down menu (collectionlist) of different words, which are part of a title which is located in my database. The bolded line is where I'm having my problems. I'm not sure how to place the LIKE statement. I will give you a quick example of what I would like to do: In the CollectionList, there is the word head. In my database, there is the title, head with earrings . I would like t ...Show All

• Kim Hansen Show DefaultEvents.OnProgress in a TreeView Control

  Hello, i try to show the progress of my DTS-Package in a Windows.Forms TreeView control. The nodes are collected, but not visible in my treeview. Any Ideas Using .NET 2.0, VS 2005, SQL 2005 ENT + DEV. Regards Ralf private void toolStripButtonExecute_Click(object sender, EventArgs e) { HelpClassDts helpClassDts = new HelpClassDts(treeViewStatus); treeViewStatus.Nodes.Clear(); helpClassDts.PackagePath = dataTable ...Show All

• FlávioOliveira load CatalogItem array in treeview

  Hi, i would like to load my array 'items' in a treeview CatalogItem[] items = rs.ListChildren("/", true); is there anyway that automatically does the layout or do i have to check what the type is of everey object so I can indent correctly. thanks I'm really looking for this one :). I'm trying to do it manually but I can't find a way to get the reports in the right structure. I'll show what I want to ...Show All

• Don Collins Can we create two servicess in a same database?

  Hi, I tried creating two services in a same queue but i couldnt see them working properly. Now i got a primary doubt that can i create two services which communicate with each other in a same database Please help me.... here is the script which i used to create the services /************************************Scipt *********************************/ /********************** Sender Queue and Service ***********************/ CREA ...Show All

• BZM return an id while doing an insert\update to a table

  Hi people, i Have a small issue. I need to be able to retrive an id number of a new row to a table using the the insert into command. I was able to do this in sql 2000 but the same sql does not work now in 2005. here is the code "Set NoCount On; select user_id from users insert into users (username) values('" & CurrentUser & "')" This used to work in sql2000, I am woundering if anyone could help me or ...Show All