subhasam's Q&A profile
SQL Server File size limit / offline cache
Hi, I have 2 questions: Is there any way of getting around the 128MB file size limit when creating and adding SSEv databases to VS2005 Currently I get the following error when trying to connect to a database:"The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only...". This after I altered the app.config file to "...Max Database Size=600;..." Have anyone tried to use SSEv to cache data with the use of the Smart Application Offline Building Block Is there a provider I can use for doing this Thanks in advance! A SQLEv database can be up to 4GB in size. You control the maximum size of the database throug ...Show All
Software Development for Windows Vista User data and common data in Vista
Does anyone know where to find Vista-guidelines for saving user data and common data on hard disc and in registry I cant find the information I need. ...Show All
Visual Studio 2008 (Pre-release) Calliing *TypeRef.Load() in a for-each loop causes a DataReader already open exception
I have the following logical model in my database: CategoryTypes (ID, Name) Categories (ID, Name, Description, CategoryTypeID (FK)) Favorites (ID, Title, Description, URL) FavoriteCategories (CategoryID (FK), FavoriteID(FK)) After creating the model project i hand edited the csdl and ssdl files to add assocation and navigation elements. Below is my csdl and ssdl file: csdl < Schema Namespace = " PersonalModel " Alias = " Self " xmlns = " http://schemas.microsoft.com/ado/2006/04/edm " > < EntityType Name = " Categories " Key = " CategoryID " > < Property Name = " CategoryID " Type = " Int32 " Nullable = " false " /&g ...Show All
SQL Server getting row before in table
Im using following code to get a row from database, but how do I get the row before this row SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE getMessage @username varchar ( 24 ), @ID int AS BEGIN SELECT Message FROM Messages WHERE Username = @username AND ID = @ID END GO And another question how do you get the row after the row Thank you. Paul. Thank you. Thats was ment to be 2 separate questions, i guess i just have to delete one of the lines i dont need. ...Show All
Visual Studio Team System TFS Team Project Limits, after SP1 and otherwise
Having read Bill Essary's excellent article on how TFS scales in terms of numbers of team projects, I'm curious about two variants on what was discussed there and am hoping that someone from Microsoft might be able to provide some additional insight: 1. How does application of SP1 to both TFS and clients affect his recommendations For example, do any of the " performance and scale improvements " address this area 2. Can Team Project permissions affect how much project metadata is cached by TF clients For example, if I remove "[SERVER]\Team Foundation Valid Users" in the security settings for all team projects on a server (say over 80 total), keep them entitled only to the less than 10 or so associated with each pr ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Extracting the transformation matrix for a subobject in a mesh
I have an x-file containing some objects objects. I would like to load this as a mesh and then extract the transformation matrix for some of these subobjects. If I have designed a model (in 3ds max) with a box located at 0,0,0 and another located at 1,2,3 and neither one is rotated or scaled, then the xfile consists of the two boxes and each has a transformation matrix. The first has the identity matrix as its transformation and the second one has a translation to 1,2,3 as its matrix. How can I extract those two matrices without writing code to parse the xfile I need this to build a mechanical model onto which I plcae a number of connector pads. Later I want to design other objects and mount them on those connectors. For example i ...Show All
Windows Forms MeasureString() and DrawPath
MeasureString works fine (mroe or less) on drawString, but when i try to use it on outlined text using GraphicsPath and DrawPath, the returned size is way off. Searched around online, seems a few people have had this problem but there is no solution (that i have found) Any ideas Sometimes i really wonder about myself. I have spent the last couple hours, trying to sort this out, i've come up with splendidly complex ways of getting a box roughly the right size. Only to see that in my drawpath method i was multiplying the text font to draw by 2. whoops ...Show All
Software Development for Windows Vista Checking For Audio In An MPEG
Hi all, I have an application that I'm writing that creates multimedia playlists for a proprietary audio/video playback device. In these playlists, the application has to know if a video being added contains audio or not because there's a pretty ugly bug in the device if it tries to play audio that isn't there. I'm using .NET 1.1 and DirectX.AudioVideoPlayback 1.0.2902.0 I read somewhere on the web that you can try setting the video.audio.volume property. Apparently, it will throw an exception if there's no audio in the loaded video. However, this seems to only work sometimes with our videos. Some videos report correctly using this method, others do not (it reports the same each time a video is tested...it's not a random proble ...Show All
SQL Server trigger- get row number from inserted/deleted
I need to add the row number or record number to the 'inserted' and 'deleted' tables in a trigger. Among other things, I have tried- SELECT 1 as rowId, i.* INTO #ins FROM inserted i if @@ROWCOUNT > 1 --if multiple rows, set row number begin SELECT @pkWhere = coalesce(@pkWhere + ' and ', ' where ') + PKF.colName + ' <= i.' + PKF.colName FROM #primaryKeyFields PKF set @strSQL = 'update #ins set rowId = (Select Count(*) From #ins i' + @pkWhere + ')' exec (@strSql) end -the above sets rowId for every record to the total instead of sequential. Keep in mind that this code is used to create a trigger for any table, hence I cannot specify any column names literally. This SHOULD be simple... right ...Show All
SQL Server PDF files with images get unexpectedly large in SQL Server 2000 Reporting Services
When using quite small JPEGS (~ 800 KB) in a report the exported PDF is a few megabytes of size. Am I missing something (e.g. some kind of compression) Can anyone give me a hint on this one Thanks, Neno There is a known bug in 2000 (which I know wasn't fixed in the SP2 beta -- don't know about SP2 RTM, though) in the PDF renderer -- It causes images of any type to be converted to bitmaps, then rendered. I bet this is what you're running into. ...Show All
SQL Server Unable to use SQL Express wizards to export, import
I am using SQL Server v8.0 Enterprise Manager and I have been trying to export a database and a table. But no matter how many times I try I keep getting error messages. It just wont let me make a backup of anything. Ideally I would like to make a backup of a table from within a database. Then restore it but use a different file name so I can have a sandbox with which to test something out. When using the Export wizard the destination server is local using Windows authentication. Here is the error I typically see: Error Source: Microsoft OLE DB Provider for SQL Server Error Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Context: Error during initialization of the provider. I only have one bo ...Show All
SQL Server Database connection problem
Hi I have installed a named instance of SQL Server 2005 Express (.\SQLEXPRESS) and successfully restored a database that is running on SQL 2000 on another machine. I am trying to connect via ADO to the database and have used a DSNless connection and a system DSN to connect to the database and get the error "Data source name not found and no default driver specified". However, when testing the system DSN connection, the test completes successfully. The SQL express service is running under the Local System account, SQL Express is configured to use Windows authentication and the user connecting to the database is a local administrator. Any assistance would be appreciated. Alex Hemantgiri, This ...Show All
.NET Development File.AppendText and StreamWriter constructor
Hello, What's the difference between new StreamWriter(filename, true ) and File.AppendText(filename) Both return a StreamWriter instance which appends text. Thanks, Roee. I guess its just easier to use the File class since you dont need to make an instance of it. http://msdn2.microsoft.com/en-us/library/ms404278.aspx http://msdn2.microsoft.com/en-us/library/system.io.file.appendtext.aspx I guess the advantage of the StreamWriter is that you can use another stream to writer to (The underlying stream). ...Show All
Game Technologies: DirectX, XNA, XACT, etc. How did you start out in the world of programming?
I apologize if this is inapropriate, but I just wanted to ask something. For those of you who have proffesional experience in game programming, what was it like for you to start out And what is some wise advice that a begginer (or pre-intermediate, if you will) like me could use, and hopefully avoid making mistakes in the future regarding my career As a programmer, I see technology, programs, and games that are so impressive, I don't know how I could ever surmount to something like that. I mean, I can barely use something as easy as XNA. Or does it just feel like that when you're a begginer, and later in life you'll be laughing at how "hard" you thought it was I just want some advice from a proffesional programmer, and I wanna kno ...Show All
.NET Development Windbg / SOS Callstack
I'm unable to get source code file and line number information for the call stack functions reported by !clrstack in .Net 2.0. I've seen examples of this working in the 1.1 framework. Does it work in 2.0 If so, what's the trick Thanks for any pointers. The following article should be helpful in using SOS within Windbg. http://msdn.microsoft.com/msdnmag/issues/03/06/Bugslayer/default.aspx Hope that helps, Stephen ...Show All