Roman Nurik's Q&A profile

• SQL Server shrinking a file

  I am trying to use the command DBCC SHRINKFILE to shrink a database. the command seems to be executing just fine, but the database does not shrink. I don't see any error messages under messages. The .mdf file is currently about 7GB, which of which only about 1 GB is actually being used . I want to shrink the .mdf to about a 2GB. Why does the DBCC shrinkfile command not working before Shrink you should truncate... read about this in BOL DBCC SHRINKDATABASE ( gpx11sep , 20 , TRUNCATEONLY ) bascically you need to give Truncateonly option. this can work with DBCC Shrinkfile also. But it is not recommended to shrink data file. It will burden your server.. Madhu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Hows It Going?

  Hey Guys, I'm not really much of a Game Maker myself, but I like to look at other people's progress. Hows it going Are you guys working on any games Got any screen shots Share them, please. :) Jim Perry wrote: You didn't pimp your site George I guess you figured the URL in your signature was enough. If you look back through all of my posts here you'll see I tend not to mention my own site. I guess I just don't feel it's polite, plenty of other community sites worth mentioning anyway. People will find me without me pointing it out if the contents there and useful if what I figure. lol, but thanks for the slick publicity just now ;) the release party was awesome by the way Jim. wish you could have been there. totally worth ...Show All

• Visual Studio 2008 (Pre-release) LINQ vs. 2.0 SQL Server Projects vs. SQL Scripts

  Good Day, At present, most of my orgs DB scripting is kept on the SQL server in the form of stored procs. This has proved a management and versioning pain. Hence, SQL server projects may be a way to move the scripts out of the SQL server. A few questions though... What is the performance difference between running SQL server project queries and running SQL queries via traditional ADO.net methods What is the performance difference between the emerging LINQ technology and SQL Server Project queries Please give hard numbers. Thanks for your time, Johnathan Howdy, As VS 2008 just went to RTM, I wanted to reactivate this issue. I realize that it is not a trivial question, b ...Show All

• Windows Forms how to share a folder with read only permission

  Hello I have to share a folder with read only permission while installing an application. Any idea how to do it. I tried write a Installer class and used NET SHARE command. But it is sharing the folder with full permission. Please help Matt Try the directory class in the frameworks. Be sure to read the general directory class for more info, but you can start the the SetAccessPermisssions method : http://msdn2.microsoft.com/en-us/library/system.io.directory.setaccesscontrol.aspx ...Show All

• Visual Basic Saved and used again?

  How do i do this I want to play the file selected by the user from the list box. Which is saved to My.Computer.FileSystem.SpecialDirectories.CurrentUserApplicationData. sUserSelected not sure if this is right or not. The way I have it is not working, I've also tried using & instead of + but no luck. Dim sUserSelected as String Player.URL = "C:\" + sUserSelected + "\ThemeTune.mp3" how exactly do you mean "have it saved" saved to file if so, yes it would be the similar to the code you have posted. I think you are trying to make like an MRU - Most recently used - type system correct so whatever they played last, that file path would be saved then once application is loaded again, t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How do I create a force feedback device?

  Hello, I have just started on a new school project where I have a chair with 3 servo motors attached. So my question is, what program(s) do I use to get the wanted signals from the game. And how can i send this info to the servomotors The information only have to go one way, and the arctitecture I think I have to use is: game --> directx --> driver --> motors If this is right I need to create a direct x function that handles force feedback, a driver so windows and the game can reckognice my chair with the motors. I appriciate all answers and suggested tools. If you can make your chair a USB HID device then you don't need to write any drivers. The drivers built-in into Windows will let you use D ...Show All

• Windows Forms keeping string values secure in a winforms app

  My app communicates with a web service using some keys that were supplied by the web service provider. Each WS call incurs a charge to myself, so I need to keep these keys secure within the application. I know that some obfuscators may help with this, but as far as I know, none that have this functionality are free. I have also thought about having my own web service that can retrieve the keys (I can then move my authentication code out to the web service and return the keys after a valid login). I believe that this is liable to snooping though. I don't think I can symmetrically encrypt the keys as this will require an encryption key and this will then be hard-coded in the source code and available to Reflector. So, I cannot think of a way ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vector2 Type Converter

  I have created a very simple TypeConverter that allows for Designer Support of Vector2's. It is only a simple one and doesn't do anything special. I have created a landing page on my site that has the link to the file and some more details. http://www.kinlan.co.uk/2006/09/xna-vector2-type-converter.html Is there any planned support in Future releases so that we don't have to keep making them Should I put it through Connect as a Feature Request Kind Regards Paul Kinlan It would be great if you could file this as a feature request, and more importantly, anyone else who thinks this is important vote on it. We're obviously already aware that type converters for the standard framework types would be a good thing, but i ...Show All

• SharePoint Products and Technologies Can't search within PDF files

  I've installed the Adobe Ifilter 6.0 and can now search to list posted pdf files in multiple sites by querying the pdf name. I can search content within Word files, but still cannot search content within these pdf files. Is there something else I need to configure to see content within these pdf files I can't seem to find any clues to what needs to be tweaked. Thanks. What version of Windows are you using we discovered that when we upgraded our system to Windows 2003 64 bit, the adobe iflilter stopped working. We are attempting to work with MS and Adobe, but have received minimal support so far. ...Show All

• Visual C# Buiding a Resource String File

  Hi, I'm a bit new to C#, comming from a delphi environment, but have been through quite a numerous amount of tutorials and have learnt a good amount. But for now, i have the issue of trying to figure out how to make a resource string file in C# and use it. Second Question - How do i use ansi strings in C#.  Such as 32 for space and 13 for enter and the such Hello All. Netmaster0000: I'm sorry but I have no idea about Borland C# Builder. You might try and see if you can find any user forums or newsgroups on the Web, and post this question there. As this is an MSDN forum, I would imagine that most folks around here use VS in one form or another. Do you mind if I ask why you are using Borland I only ask because, if poss ...Show All

• .NET Development ODBCCommand.ExecuteReader causes application to unload

  Hi I have found the weirdest thing. We have a requrement to connect to a Scada Experion data source to extract data. We currently use a VB6 app and have just started porting it to dot net. We are using the ODBCConnection class to read in the data. Establishing the connection is very expensive so we currently hold it open, using the same connection to access the database every 60 seconds for days or weeks on end. When the app detects a connection failure, it closes the connection and creates a new one. We have tried to replicate this functionality in Dot Net. We wrote a provider class that creates, monitors and maintains the connection. Utilising Connection Pooling, which has to be enabled at the driver level, is not an option due to ...Show All

• Visual Studio Express Editions TableAdapter Query based on a form field

  I'n new in VB 2005 Express and i want to do something like cascade listboxes (2 listboxes). The 1st listbox contain colour from a Colour Database Table with one 'id' The 2nd listbox contain car from a Car Database Table with a field called 'colour_id' that have de number from 'id's Colour Database Table. I think you see whaty i whant When i select on the 1st listbox one colour, the 2nd listbox is updated with all of the cars with the 'colour_id' from Car Database Tabe = 'id' from Colour Database Table ------> That's the easy part. The part with lots of problems is to build the Query from the designer way. I'm doing like this: 1. In the Car DataSet, I click: "New" - "Query" - "Use SQL statments" - "SQL ...Show All

• SQL Server Hyperlink in the report description

  Is it possible to add a hyperlink in the report description property Thanks in advance ...Show All

• Visual Studio 2008 (Pre-release) can XBAP XAML reference isoloated storate

  is it possible to have an XBAP app reference an isolated storage path using an URL in XAML the concept is that on app load, it would download common textures into isolated storage, then loosely loaded XAML files would reference those textures in isolated storage. embedded resources won't work Thanks, casey I know of no special support we placed in WPF for this. You likely could get a stream from the Isolated Storage apis and pass that to XamlReader.Load(someStream)... Let us know if that works for you... Thanks, Rob Relyea Program Manager, WPF Team http://rrelyea.spaces.live.com ...Show All

• .NET Development GDI+

  I am not sure if its a right place for this thread, sorry, move it if needed and was possible. I am using Drawing namespace and learning GDI+. I want to draw some shapes and paths on the screen. The problem is that a window is always needed to create graphics object. It is just like a prison for the shapes. What is the solution I want my shapes to be seen on the desktop and on the wallpaper for example, not in a window. Thanks. I solved the problem by giving user32.lib to linker. But GetDestopWindow() is not what I want. It really paints desktop, but I want an invisible layer (window) on the desktop to be painted. ...Show All