Mosesm's Q&A profile

• SQL Server Configuration Order

  I am trying to use the SQL Agent to specify the connection properties of the connection manager that supports all of the other SQL Configurations in my packages. It would appear that configuration files specified in the SQL agent job are applied after the other configurations. I have the same package I want to use under different configurations on the same machine. This package is also portable across to other machines. so cannot have any location information embedded in the package. Does anyone have a solution for this Phil, There are valid reasons for the order in whch configs are applied and I read a blog psot on it once except that I can't remember where. I think parent package configs are de ...Show All

• SQL Server Eventhandlers for DataFlow task events

  Does anyone know how to create an eventhandler for a dataflow task specific events (OnPipelinePostEndOfRowset, OnPipelineRowsSent, etc.) These events are available for logging via the standard logging infrastructure, but there seems to no eventhandler for them. The reason I'm interested is that parsing information logged by these events using builtin log providers is not easy (eg., the number of rows sent gets burried somewhere in the message column (i'm using sql provider). I'd like to capture this information and record it cleanly in a custom ssis metadata database i'm building. Any ideas are welcome. Thanks. -alex Jamie Thomson wrote: Perhaps you could raise a request at Connect t ...Show All

• Visual C++ error LNK2001

  Hi, (I saw the post on same subject but it seems to be a little different. so I'll use some word from that post!) There is a project earlier written in VC++ 6.0.  I opened the same project in VS. NET 2005 and I am trying to compile.  The code compiles properly (with couple of warnings) but while linking I am getting unresolved external symbol errors like this: The linker seems to have problem with seeing .obj from files in program (which are in the debug directory). It doesn't seem that the /Zl switch or the /NODEFAULTLIB  are on. 1>Linking... 1>Utm.obj : error LNK2001: unresolved external symbol _RTC_Shutdown 1>Zone.obj : error LNK2001: unresolved external symbol _RTC_Shutdown 1>Zones.obj ...Show All

• .NET Development [C# 2.0] ControlState

  Hi, Where is stored the control state Memory, Page, Browser ... Thx. Thank you for you reply. I readed in msdn that ControlState object is stored in a html hidden element like the ViewState. But the controlstate is always enable even if the viewstate is disabled. ...Show All

• Windows Networking Development UDP client and server application program on the same machine in Windows 2000 OS

  Hi all, I have some trouble in running UDP client and server application program on same machine in Windows 2000 OS. I observerd that every time client is not able to receive the data send by the server if both server and client are running on same machine Almost half the time no data is received by client and for rest client is working fine receiving all the data send by the server. Same server and client programs are working on different machines everytime successfully . I am using the port no 8888 for both client and server . Any clues on this Regards Nitin Jain ...Show All

• Visual Basic Culture date format and system dat format conflicting

  my VB.net 2005 Application is My .Application.ChangeCulture( "en-GB" ) the problem is, my OS dateformat may be will not be matching my application culture. e.g. 7 april 2007 at my application = 2 July at my OS my prblem is: when I send 07-02-2007 to my database it will save depends on my OS format then when I retrieve the value it will be 02-07-2007, it changed from april to july I'm using MS ACCESS2003. I'm using Insert statment insert into tbl1 (testdate) values ('"& date.now &"') so, how can I know what is the culture of the database ...Show All

• SQL Server SQL Server time zone?

  I don't know what is going on, here's the error message, could someone please answer thanks Server Error in '/' Application. might it be possible that it was corrupted when the db was corrupted I didn't change anything so don't know how it would be changed unless it became corrupted in someway. Is there a way to check on this ...Show All

• Visual Studio Express Editions Where do I start, Classic-C++ or .NET style?

  Hey there everybody. I wanted to learn Visual C++, completely in and out. But now I can't decide where to start. Do I start learning : i) The Classic style, Visual C++ 6.0 using the windows.h header an' all, OR ii) Do I start with the .NET Eventually, I wanna learn both. But can anyone tell me which would be the better way to start I know the generic C++ completely (I've worked on Turbo-C++, which means I don't know the windows core libraries). I have several questions, I'll just organize them into a list : Note : I refer to programs written in C++ using the windows.h header as Classic-style C++, and those C++ programs using .NET as C++ .NET, or simply .NET 1) Where do I start, Classic or .NET 2) Which is of higher prior ...Show All

• Visual Studio Express Editions Database connectivity using VBE

  Hello everyone; Hopefully you can help me with this little problem. I am working on a form that access a 2003 Access Database, and I am trying to get used to the new coding within VBE. However, my problem is this: I think I have the data connection set up, and I realize that there is a new way to include SQL into the code, just not sure how to get it to go to the database. I read that you need to use a "Rows" feature, but not understanding how to accomplish this. here's the code that I have so far, but I am at a loss as to where to go next Any thoughts I'm trying to have 5 fields saved to a database as listed below: Private Sub cmdSubmit_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Trouble creating my effect object

  I have the following code: CompiledEffect compiledEffect = Effect.CompileEffectFromFile("Shaders\\simple.fx", null, null, CompilerOptions.Debug | CompilerOptions.SkipOptimization, TargetPlatform.Windows); m_effect = new Effect(m_graphics.GraphicsDevice, compiledEffect.GetShaderCode(), CompilerOptions.None, null); Unfortunately, on the second line, I get an exception. Microsoft.Xna.Framework.Graphics.InvalidCallException was unhandled Message="External component has thrown an exception." Source="Microsoft.Xna.Framework" ErrorCode=-2147467259 StackTrace: at Microsoft.Xna.Framework.Graphics.Effect.CreateEffectFromCode(GraphicsDevice graphicsDevice, Int32[] effectCode, CompilerOptions options, EffectPool p ...Show All

• SQL Server Probem installing SQl server 2005

  hi, I was trying to install sql server 2005 in my pc (xp prof. sp 2). I downloaded this file from Microsoft site. After Unpacking the content of the file and checking the integrity of that package it’s showing it’s finished the installation. Now if I press the finish, it’s showing cannot open package it’s may be corrupted. I downloaded 3 times and still same thing. I tried in server 2003 too but no luck. I really don’t understand this. Can anyone plz help me thanks Sandipan ...Show All

• SQL Server SQL 2005 Configuration Manager permissions

  I can't seem to find the documentation on how to delegate control for SQL server configuration Manger 2005. I have DBA that need access to the tool from a remote machine without admin access on the boxes. Does anyone know how to delegated control and what permissions are needed to set up remote access for my DBA to user the 2005 configuration manager The only article that I was able to find is the following on WMI http://msdn2.microsoft.com/en-us/library/ms188690.aspx . Any help is greatly appreciated. Thanks, Satay. What I'm really looking for is what permissions to give that user or group. We run everything in least privileged mode and I need a way to delegate the tool with ...Show All

• Microsoft ISV Community Center Forums How do you create a flashing cell

  I have been trying to use macros, very little success. My first macro question is how do you get it to run besides using F5 everytime I am also trying to create a flashing cell when there has been any text entered into that cell Please any help is greatly appreciated. i'm not quite sure if one can make a flashing cell, but if what you want is to highlight (by changing color of txt or background) the cell when certain text is entered, try using Conditional Formatting. Format --> Conditional Formatting ...Show All

• Visual Basic Problem with a class library (ActiveX)

  I am using Visual Basic 2005 Express Edition and I'm having a problem with an ActiveX control that I want to use for my programs. To use it's functions in the library I created an instance 'Dim MPQControl As New MPQCONTROLLib.MpqControl'. After that I tested it by just using a random function. So I used 'MPQControl.AboutBox()' (AboutBox is the box that tells you about the control (author, etc.)). So I went on debugging, and clicked the MenuItem in the MenuStrip that I created so when you click it the AboutBox comes up. When I clicked it I have gotten this error: COMException was unhandled Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Image: This happens for every function. I am stumped. If anyone wants the sam ...Show All

• SQL Server Can a non-admin user generate a create database script?

  I am trying to generate the create database script using SMO. The issue is the user account which connects to SQL server is not SA, SMO fails to generate the "Create Database" script with error User ZZZ\User1 does not have permission to run DBCC SHOWFILESTATS. Is it possible to generate a "Create database" script using SMO when you are connecting to the SQL server using NON-ADMIN account The user login is a part of db_Datareader role on the database. I tried following grant permission to the concerned account at server level Grant view any database, grant view any definition and grant view server state. Still it fails. Any idea Thanks Adamus for your reply. I am sorry, I ...Show All