DARSHAN GERA's Q&A profile

• SQL Server Copying a project. How?

  We recently migrated to SQL2005 and have moved all OLAP databases to the new server. I need to create new OLAP databases. In SQL2000, just a copy would do it, but I am having problem in 2005. I tried to script the database as 'create' or even created an empty one and try to change it by 'alter' from a valid DB, but no luck (XMLA file was modified to have the new names). Any pointers, suggestion would be appreciated. I know how to change the DataSource and DataView later, just need to know how to copy one!!!! Also please let me know what tool is used (Management Studio, Visual Studio, etc...) Thanks in advance! There is a special project in BIDS where you can reverse engineer a SSAS 2005 database. If yo ...Show All

• SQL Server how to generate as "enter" function in SQLSERVER?

  For example: select 'sp_refreshview ''' + [name] +''' go ' from Sysobjects where xtype='v' order by [name] I want the result is follow: sp_refreshview 'lt.trxdetai' go sp_refreshview 'ps_account' go thanks Modify your statement to add char(13) as shown below select 'sp_refreshview ''' + [name] + '''' + char ( 13 )+ 'go ' from Sysobjects where xtype = 'v' order by [name] Regards, sam ...Show All

• Visual Studio VS 2003 devenv.exe as a scheduled task hangs during clean step after vs2005 install

  Ok, Hope this is the right place. We have a large solution 70+ projects and we automate the build process via scheduled tasks. Now several machines (all dual core), after having vs.net 2005 installed, fail to complete this process. I've narrowed it down to the clean step. To reproduce this I have scheduled a batch file as a different user (we use to build) and all it does is clean. When I run the task, devenv.exe hangs and spins one cpu to 100% at the end when it should exit. NOTE: This is not the 2005 version of devenv that runs, rather 2k3. and test is a dir containing the sln and projects. Here are the contents of the batch file. ---------------------- CALL "C:\Program Files\Microsoft Visual Studio .NE ...Show All

• Connected Services Framework Microsoft Connected Services Framework 3.0 BTS WSE Adapter

  1. Where do we get the Microsoft Connected Services Framework 3.0 BTS WSE Adapter from 2. Is it freely available I downloaded CSF through MSDN subscription but could not find BTS WES adapter there. You mean is it available as a spearate download or part of CSF If its a part of CSF, could you share the the csf installation path where i can find it. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectX Questions... Problems with .lib and ddraw.h

  Hi, ... ... ... I use the Visual Studio 2005 Standard Edition, Visual C++ 2005... I've done some Windows programming and been using the GDI to make some graphics so far, it works well... But can anybody tell me how to Clear the screen after using the GDIs to draw some polygons... You see, the screen then becomes full of polygons, and that's what was wanted, but then, finally, how about Clearing the Screen completely and then start to draw some other, say, triangles instead... So, What is the exact Command to Clear that Window that the polygons were drawn in... ... ... ... OK, Now, here's the problems... I've finally started to get into Direct3D and DirectX... So, I've read and Understood all the materials about how to creat ...Show All

• Smart Device Development directshow issue

  Hi, I am using directshow graphs in my application for accessing the embedded camera(PPC and SPs). I am not using a graphmanager; I contrust the graph manually, by adding the required filters. An overview of my Graph: To the VideoCapture filter, I connect the SmartTee. The Render Output pin of the SmartTee is connected to the VideoRenderer; The Capture Output Pin of the SmartTee is connected to the input pin of my custom NULLRenderer filter. In this filter, I register a custom app callback function in which I perform my image processing operations on the frames received. Ok. Now the problem I am facing is changing the camera / viewfinder properties. In varying lighting conditions, I need to be able to adjust the properties like ...Show All

• Microsoft ISV Community Center Forums Question about ADO and Access

  Hi, I've been searching the net for the last 3 hours for a good example of querying access database from excel and then manipulating the recordset, this isn't as easy as I expected. Can anyone offer an idea (I'm not even sure how to open the database). Thank you all (and sorry for the silly question), Raphael The below is from the Office Help System, you don't need to worry about the Pivot Table bit. Once you have the recordset you can work with it from there. This example creates a new PivotTable cache using an ADO connection to Microsoft Jet, and then it creates a new PivotTable report based on the cache, at cell A3 on the active worksheet. Dim cnnConn As ADODB.Connection Dim r ...Show All

• Visual Studio Events in DSL Elements

  Hi, I started by making a simple DSL solution and customizing property values (i.e define a combo box to display possible values for a property and another "customization" to open a form where I collect several data). Now I would like to define a type for a property, something like "Collection" where I can save the data I collect on a form. I didn’t understant the info on MSDN about "Domain Type Descriptor" and "Property Paths" . Any example How do I handle the mouse click and double click events on a DSL Element Thanks, DevDiver Thanks Herru, The second question is now working. Tks again Concernig the first one, I have done that. The thing is: ...Show All

• Visual Basic Can't find solution ANYWHERE

  Sorry, but I'm about to rip my hair out... I have 3 machines..1.serverbox with xp pro and sqlexpress...2 laptop1 with xp pro visual studio 2005....3 Laptop2 with xp Home edition. I wrote an application in visual basic 2005 (Laptop1) that connects to an SQLserver on an xp pro box. I used Network Wizard to set up my home network on 3 machines. serverbox, laptop1 and laptop2 I set up user1 in sqlexpress with the db1 access...and password. conn.ConnectionString = "Provider=SQLOLEDB;Data Source=" & logServer.Text & ";Initial Catalog=" & logDatabase.Text & ";User ID=" & logUsername.Text & ";Password=" & logPassword.Text The application I wrote is on my ...Show All

• Visual Studio 2008 (Pre-release) Successive Async Call problem

  Hello all, Just a question about best practices. I'm developping a Windows Application that discuss with some services. I have a method that can take a long. So i put this method OneWay. The problem is when the user on Windows application call more that one times this method (multi click on button) the server doesn't reponse to me. I think it lost the call and don't notify via callback mechanisme my client. What is the solution to don't have this problem Do i pool the client demand Thanks a lot for your help, Nicolas Hello, May I suggest the following 1) Are you sure the calls are lost on the server side Can you put simple trace statements to see how many calls you receive on the service side in re ...Show All

• .NET Development Always inherit from MarshalByRefObject?

  When using .NET remoting, it's obvious you must have some way of passing object values and refrerences to the remote server; but should you apply one of these practices always as a matter of course public class Password : MarshalByRefObject { ... } [ Serializable ()] public class Password { ... } I have noticed that the .NET framework inherits most (if not all) of it's objects from MarshallByRefObject. I seem to find myself now doing the same. Also, when is it best to use Serializable() instead of MarshallByRefObject When using .NET remoting, it's obvious you must have some way of passing objects/refrerences to the remote server With my understanding, the objects/referen ...Show All

• SQL Server Problem writing data after upgrading

  Hello, I was using for years an application that had an MSDE database. Recently. I've upgraded my computer to Windows Vista, so I had to upgrade MSDE to SQL Express . I've managed to attach the old MSDE database of the application to SQL Express, and I am able to retrieve my data from within the application . My problem is that I can not write or update data from within the application anymore. However, If I open a table in SQL Management Studio Express I can write/ update data with no problem. The company that build the application I was using doesnt exist any more so I cant take any support from them. The only thing I know for a fact is that the application is connecting to the database using the sa user. Any ide ...Show All

• SQL Server Newbie question: INSTEAD OF triggers

  Hi, I’m familiar with Firebird and PostgreSQL DBMSs, and now I'm exploring SQL Server Express 2005. In other products you have both BEFORE and AFTER events arround INSERT, DELETE, UPDATE. I'm not sure if I understood well INSTEAD OF triggers, but these would be equivalent to BEFORE triggers Can you give me an example on when I'd use INSTEAD OF triggers Thank you, Guillermo hi Guillermo, Jens already answered... just a side note... INSTEAD OF triggers are not BEFORE triggers as they actually are triggered instead of the DML operation they are designed to catch.. so you have to manually perform the actual DML operation against the base table.. SQL Server does not support BEFORE triggers, while other ...Show All

• SQL Server Reporting Services Keeping format when deploying to the Report Manager

  Hi, I am trying to place text boxes in the header of a matrix in order to give each row group(i.e. each drill-down area in my matrix a header). This can be done in Reporting Services 2005. However when I deploy this report to the corresponding url(Report Manager) it seems to be losing its formatting and not displaying correctly. The textboxes placed in the matrix header seem to go all over the place. I do get a warning when I deploy the report -> [rsOverlappingReportItems]. Some renderers do not support overlapping report items. How can this be rectified Hi Ashleys, Sorry of the slow reply over keen spam filter kicked in . Colmns will work in an identical way to rows , where you ca ...Show All

• .NET Development Obfuscation and debug

  I'm using the Obfuscator supplied by Visual Studio. How can I ensure I will be able to debug the Obfuscated assembly Is the map file along with the obfuscated assembly enough Should I build a non obfuscated version for debug instead Depending on the obfuscation level it could almost be impossible to debug obfuscated assemblies. When you obfuscate the assemblies, your source code no longer matches the assembly and most likely the method & attribute names are changed. The map file will help you to understand the stack trace from an exception as otherwise they will just show method a -> b -> c. I suppose if this is what you mean by debugging. ...Show All