Ravi KP's Q&A profile

• SQL Server Page Restoring

  In SQL Server 2005 Book on Line, it mentioned that you can restore a database by pages instead of to restore the whole database. But, it also says "Page restore is supported only for read/write filegroups." If this is true, then how about most of the database files are not designed as filegroup (or just primary filegroup only)   Can they enjoy this convenience too Also, when you find a suspect page in suspect_pages table in msdb, how you find out in which log_backup file that contains this bad page Thanks, Charley Hi Kevin, Thanks so much for your quick response and excellent explanation. You also answered my next question about the the online restoring. Thanks, Charley ...Show All

• SQL Server Error: Value does not fall within the expected range. Error in buffer.DirectRow Method

  Hi I am trying to make a custom task. The custom task has one input, which i map to externalmetadata column in the task and one output. When i run the task it fails with this error ( I am putting the whole SSIS message) SSIS package "Package.dtsx" starting. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning. Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning. Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning. Information: 0x402090DC at Data Flow Task, Flat File Destination [1855]: The processing of file "C:\ole d ...Show All

• Visual Studio 2008 (Pre-release) How do I pass credentials in an IIS Hosted WCF Service

  How do I pass credentials in an IIS Hosted WCF Service Can I pass the credentials in the client code instead of the client config. What would that look like What do I do to get the Service to accept those credentials I am sorry. I am a beginner. Most of that went over my head. I have the following client code: // Open channel to the service Uri uri = new Uri("http://10.14.1.50/JOHN1/service.svc"); // ChannelFactory<HelloService> factory = new ChannelFactory<HelloService>(new WSHttpBinding(SecurityMode.None)); ChannelFactory<ICalculator> factory = new ChannelFactory<ICalculator>(new WSHttpBinding()); ICalculator p = factory.CreateChann ...Show All

• Visual Studio Visual Studio 2005 SP1

  Will I need to uninstall the beta SP1 for VS2005 before installing the final SP1 yes you would need to otherwise you will face problems. It's the same with any beta/CTP product, you must remove it before installing the RTM release. So remove it from control panel > add remove programs and select the "Show all updates" tick box ...Show All

• Visual C# scheduling a windows service to run at a particular time..

  Hi, i have created a Windows Service in C# .NET . it should start running automatically at 8.30 PM daily. how can i schedule this i think i can do this by adding this Service to Task Scheduler available in Windows 2000/NT etc. but i want to know whether i can do the same without using Schedulers ie setting some properties of the Service.. pls help me. Thanks in advance , sajitha jose I would use a simple console app that is scheduled to run through Scheduler. I'm very much against creating services just to create services. I think there is already too much stuff running on Windows as it is to have yet another idle service running. Create a console application that retrieves the data from the websites. Although I do ...Show All

• SQL Server Changes to data not replicated

  I have an application that uses web-based merge replication. My publisher is SQL 2005 and my subscriber is SQL 2005 Express. I control the replication with RMO code. If I make changes to the data in both databases using SQL Server Management Studio Express, my RMO code correctly syncs the two databases. However if I make changes to the data at the subscription through my application, these changes are not picked up by the replication process, even though the changes are present if you check the tables through Management Studio. What would cause these changes to not be recognized Any ideas would be appreciated. Merge replication uses triggers to track changes. First thing to check is if your updates ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .xnb file size

  Hi all, I assume I am doing something wrong with the importing of content, but I can't seem to figure this out. I have 3 .bmp images that are each around 30kb. I am importing them as Textures and using the Sprite processor. The resultant .xnb files are 250-300 kb =/ I am fairly sure the .xnb file doesn't have mipmap data in it. Any idea why these images are becoming so large Thanks Thanks you two, that really cleared this up. Just to make sure I understand completely, if I want an resultant image that usages DXT compression but does not have mipmap data, then I will need to write a custom processor I'm not that concerned about this, because you are right about the file just barely being larger now, ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GameComponent.Draw()... why?

  I'm a bit confused about the GameComponent class, and its intended use. It would seem that it would be perfect for inheriting particular subsystems. InputComponent, NetworkComponent, etc... but you wouldn't want to draw any subsystem. So what was the logic behind having a Draw method for GameComponent Did the cart come before the horse, so to speak, with the GraphicsComponent How exactly is GameComponent meant to be used I thought I'd get it straight from the horse's mouth... and I have no idea what's with all the horses in this post. (My suggestions are in third post, if anyone cares). Well, I posted an official suggestion, but, since you asked... I haven't really thought out the implications of my sugg ...Show All

• SQL Server excel data problem

  I have a foreach loop that loops through each excel file and load data to a staging table. Lets say i have file A.xls and B.xls. When loading data from A.xls to the staging table data looks fine, however, loading data from B.xls one of the column did not convert data as string, instead it converted some of the number as 1.000e+7. In the advance editor, i've set the output as a Unicode string and my excel connection string is appended with IMEX=1. Sill, the data is converted correctly for some number, others it converted as x.xxxe+x. Anyway i can force the data to convert "as is" I've experienced a related problem. I wanted to import a column which is alternating in text and numeric values. Since ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. xna error

  on this .GameComponents.Add( this .graphics); i get this error Microsoft.Xna.Framework.Components.NoSuitableGraphicsDeviceException was unhandled Message="The values used in the attempt to create the GraphicsDevice were invalid." Source="Microsoft.Xna.Framework.Game" StackTrace: at Microsoft.Xna.Framework.Components.GraphicsComponent.CreateDevice(GraphicsDeviceInformation newInfo) at Microsoft.Xna.Framework.Components.GraphicsComponent.ChangeDevice(Boolean forceCreate) at Microsoft.Xna.Framework.Components.GraphicsComponent.OnGameChanging(Game previousGame) at Microsoft.Xna.Framework.GameComponentCollection.Parent(GameComponent gameComponent) at Microsoft.Xna.Framework.GameComponentCollection ...Show All

• SQL Server SQLServer 2005 Problem

  Hi! I want learn about ADO.NET, I'm trying to start a SQLServer 2005 Express with a example database for practicle with it, but i can't connect to configure the db. I'm tried dowloading a set of examples from Microsoft.com, but whe i execute some example aganist the db always get the same error: C:\DB\>sqlcmd -E -i OrderingServiceScript s\SetupOrderingServiceProgram.sql HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow re ...Show All

• Visual C# COM Interop Question

  I have a VC6 ATL COM Object that accepts a BSTR as an input parameter in one of it's methods. The COM Object expects an ascii buffer to be embedded in the body of this BSTR and uses a call to SysStringByteLen to dynamically create an appropriately sized single byte char array for holding the extracted contents based on the results obtained from interrogating the size prefix of the BSTR. The COM interop wrapper generated from this dll defines this parameter as a System.String that gets marshalled as UnmanagedType.BStr. I am trying to use this method from managed code (C#) but am having difficulty creating an ascii encoded string parameter from my binary data (a byte array). Is there anyway to do this in such a fashion that I can pass binary ...Show All

• Visual Studio Visual Studio Installer Hangs

  I am trying to install Visual Studio Professional (academic edition) on a Dell 9200 (Intel Centrino 2..1 GHZ 2 GB RAM) with Office 2003 installed. When I run setup I get the splash screen and I select "install visual studio". The buttons go grey, the setup.exe process sucks up about 98% of my cpu, and nothing happens. The DVD eventually stops spinning and the machine just sits there. Any suggestions> Mark Lewus mlewusAToptonline.net believe it or not some people have had to uninstall mcafee AV software as disabling it didnt help them! I really dont know what to suggest apart from hmm... trying to see if you can create an ISO of the discs and mounting it using a virtual cd tool then r ...Show All

• SQL Server Sorting Data having months

  Dear all, I have a field [Month] in my table AA.having Data like ( January,February,March,April etc.) I need to sort them by starting of month lets say as January February March How i can i do this Have no index and can't define a index on this field Thanks for ur time and Help Regards Mohd Sufian Dear William, Yes ur asnwer will sort the problem but this will make a headache for me for performance. As i have more then 300 users who will use that graph per sec basis. and have more then (500000++) records. Do u still suggest me to implement the query u have posted here. Regards Mohd sufian ...Show All

• Visual Studio Express Editions Variables in debug

  Hello When I'm debugging, for some reason, I can't see variables. Even though they are fully defined, I get error CXX0017 : symbol not found. What's the problem Are you debugging the release version of your code or have you put optimisation on for the debug version It is quite possible that this is being caused because the compiler/linker has optimised some of these variables out of your code. ...Show All