Sean's Q&A profile

• SQL Server Copying a cube but using a different data source

  We have a cube that we've been using for a while. I need to make several more cubes with the exact same schema and roles and everything else...just with different data sources. The other data sources have the same schema as the database the original cube is using. I know that when you copy a cube and paste it, the data source is copied over too. And I've read that you can't change the data source of a cube. My question is what is the easiest way to create the new cubes Or do I have to create every new cube from scratch (pain in the butt) Thanks in advance for your advice. After you made a copy of your pro ...Show All

• SQL Server BOL Package example Errors

  Hi There Ok i realize this may not be exactly the correct place to post this, but i seem to get good advice here. I am trying to follow the SMO Tables DBCC Package Sample in BOL. I have copied the Microsoft.SqlServer.Smo.dll and Microsoft.SqlServer.SmoEnum.dll to my latest .NET Framework folder as specified in BOL example. Problem is when i try to run the package i get the following error: --------------------------------------------------------------------------------------- An error occured while compiling the script for the Script Task Error 30466: Namespace or type specified in the Imports 'Microsoft.SqlServer.Management.Common' cannot b ...Show All

• Visual C# 101 Samples for Visual Studio 2005

  Hi, I wonder if anybody can maybe help me. I recently downloaded the "101 Samples for Visual Studio 2005", from the following link http://lab.msdn.microsoft.com/vs2005/downloads/101samples/default.aspx I wanted to test and see how Datasets work in the new SQL Express. The application that I was testing is called "Reading and Writing Images from a Database", and is located in the Data Access folder. When I run the application, I can select a new picture and assign it to a group. When I click the INSERT button, the dataset is updated and the code that attempts to save the details. It uses the command <dataset>.AcceptChanges(). I have st ...Show All

• Visual Studio Problems installing Hotfix for Visual Studio.net 2003

  Hi all, I have just been sent the hotfix for the following problem: Reference KB 836454: Where it is impossible for you to download or check for updates with visual studio.net 2003. Now the problem is that when I try to install the windows installer patch, the installer starts but does not complete the installation. when i try executing the fix executable, i receive an error: " Only part of a ReadProcessMemory or WriteProcessMemory request was completed . " I have also tried repairing the installation via the visual studio cd but to no avail. Please help me out Thanks I have the same problem with VB. ...Show All

• SQL Server MS Reporting compatibility with XP

  Hi all, When i am accessing the reportingserver provided webservices from XP installed machine it showing authentication failed error. But if the same thing is running from 2003server no probs. Any one con comment on this ...Show All

• Visual Studio Express Editions Event Creation in VB .NET Beta 2 Express 2005

  Hi. Will anyone please tell me how to make my own events I have heard that it is possible, but I don't know either how or where you do it. Thanks, The Digital Pioneer I think we are ready to return to this now:   Digital-Pioneer wrote: Uh-huh. Well, as far as I'm concerned, Dim allOfTheAbove As String = "Clear as Mud" I did notice the following code: Public Sub DoSomething() RaiseMyFancyEvent( "Yippie" ) RaiseMyStandardEvent(EventArgs.Empty) End Sub   Is that saying that you are using a sub which raises the event That would not be very useful. I could just make a sub tha ...Show All

• Software Development for Windows Vista Using functions in objects passed to workflow

  I am trying to use datarow as an object passed to workflow as parameter. Have no problem using properties like DataColumns, but when trying to use build in is[ColumnName]Null the rule designer faults. Is it intended behavior and if it is, how am I suppose to evaluate int column if it is null Which build are you using Using the Beta 2.2 build I am able to create the following rule in the Rule Condition Editor without any issues: this.DataRow["fName"].ToString() == "John" Can you post an example of rule you are trying to create ...Show All

• Visual C++ Writing to Notepad

  I am looking for some code to write to notepad. This is a rough example: #include <windows.h> #include <stdio.h> void TypeAndSendToNotepad() { char szBuffer[256]; HWND hwndNotepad; HWND hwndEdit; gets(szBuffer); hwndNotepad = FindWindow("Notepad", (LPCTSTR)NULL); if(!hwndNotepad) return; hwndEdit = FindWindowEx(hwndNotepad, (HWND)NULL, "Edit", (LPCTSTR)NULL); if(!hwndEdit) return; for(int i = 0; i < lstrlen(szBuffer); i ++) { SendMessage(hwndEdit, WM_CHAR, (WPARAM)(TCHAR)szBuffer , (LPARAM)NULL); } SendMessage(hwndEdit, WM_CH ...Show All

• .NET Development Asyncronous Sockets support TCP Message Boundary?

  In The Name of God hello as u know tcp doesn't protect message boundries it means messages might be mixed into each other. in addition to that in TCP it's possible that a message would be delivered in diffrent times. so you must use a while loop to get the complete message. like this: int size_Total = 0; int size_Dataleft = 4; int size_Received = 0; byte[] size_Container = new byte[4]; while( size_Total < 4 ) { size_Received = sck_Socket.Receive(size_Container, size_Total, size_Dataleft, 0); if( size_Received == 0 ) return "Exi ...Show All

• Visual C++ Problem with _CrtSetReportHook on VC++ 2005

  Hello there! I have some a problem when i use _CrtSetReportHook( _CrtSetReportHook2 also has the same problem). as a parameter to _CrtSetReportHook i have a funtion: static int report(int reportType, char *message, int *returnValue); to dump the output data in a file. but when my program exits and the CRT Library attempts to call(automaticaly) the report() funtion i get an access violation at a file named stream.c at this line: /* * if the stream is not inuse, return it. */ if ( !inuse( (FILE *)__piob[ i ] ) ) { all of this cause of a call to fopen() in the report function. ...Show All

• Software Development for Windows Vista Methods for Generate Still Video filter in qedit.dll

  Has anyone cracked the "Generate Still Video" methods   It appears this is the default source filter when using RenderFile for bmp, jpg or other still image format.  I don't understand why the methods for this filter are not published.  If someone has data on this filter please pass it on.  Thanks. ...Show All

• Visual Studio Express Editions VBexpress download is the wrong size and incomplete

  I have downloaded several times. It always completes less than the indicated size and the iso always has errors so that SQL server Express cannot be installed from it. I have plenty of disk space. How can I get a full .iso file Moved thread to Installling and Registering VSEE instead. If the connection is unstable and unreliable you might consider using a download manager. These are a couple of free that does not seem to be too bad. http://www.freedownloadmanager.org http://www.freshdevices.com/freshdown.html   ...Show All

• .NET Development Error

  I'm getting an error when I load a project in VS 2005. What do I do "Package Load Failure  package 'Visual Studio Object Test Bench Package' has failed to load properly (GUID = {FDFFCCF0-5F63-404F-86AD-33693F544948}). Please contact package vendor for assistance. Application restart is recommended, due to possible enviornment corruption. Would you like to disable loading this package in the future You may use 'devenv /resetsippkgs' to re-enable package loading." Did you happen to have a beta version installed and then remove it   It sounds like maybe you had Team Studio or Team Edition and then reinstalled another version.&nb ...Show All

• Smart Device Development Performence issue with PPC 2003 Emulator

  Hi I faced a critical issue related with the performance of Pocket PC 2003 and Pocket PC 2002 Emulator. I created an EVC++ application (using EVC4.0 tool), which reads the SQL queries from the file (.sql extension), executes the queries and loads the records into database file. (SDF File for Pocket PC). I ran this application with database file of size 12 MB (Around 39K SQL Quries) on 2002 and 2003 emulator both. But I found that 2003 emulator takes around 25 minutes to load the records in DB file while 2002 emulator loads the all the records in just 52 seconds. Why the emulator performance is down drastically in the Pocket PC 2003 ...Show All

• SQL Server sp_send_dbmail & COM errors.

  I just started getting these errors on a few (not all) servers the other day. These servers have been running fine for a few months now... Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 476 Query execution failed: Error initializing COM Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. I can only find one thread regarding this error, specifically with dbmail and I am doing the same thing (executing a query and attaching the results). http://www.sqlservercentral.com/forums/shwmessage.aspx forumid=149&messageid=248650 T ...Show All