Batisse's Q&A profile

• SQL Server NEED HELP for GRANT rights to views?

  I want to grant rights (delete, select...) to all my views. the statement is eg.: grant delete on view1 to public I have more than 2000 views. Therefore I do not want to use the statement 2000 times. Is there a possibility to grant rights to all or a part of my views with one statement. thanks for help Elmar Not with one statment, but you can do one of two things. If this is just a one time thing, then just do something like: select 'grant select,delete on ' + name + ' to public' from sys.views (in 2000 from sysobjects where xtype = 'v') and then execute the result (copy it from the result pane): create view testView as select 'hi' as hi go create view testView2 as select 'hi' as hi go select 'grant se ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Writing raw texture data to file

  Im trying to write the raw texture data to a file. Im doing this by locking the rect of the texture and then using WriteFile to write it to an opened file. texture->LockRect(0,&pLockRect,NULL,D3DLOCK_READONLY); WriteFile(hFile,pLockRect.bits,Width*pLockedRect.pitch,&dwWritten,NULL); Is this the correct number of bytes to write When I have large textures to write WriteFile fails with ERROR_INVALID_BUFFER. Has anyone got any ideas It depends on the format of the surface you are locking. Take a look at the SDK docs (D3DLOCKED_RECT). It describes there the meaning of the "pitch" parameter. At a first look, I can see that you should use Height * Pitch instead of Width * Pitc ...Show All

• Visual C# Getting started with Business objects

  Hi guys, i m trying to get started with Business Objects, but i m a little bit lost here.. hope you guys can help me out. So far all the tutorials i read on the internet just show you how to make an "employee" or a "product" class, coding that is very simple, and i don’t have any problems using them and even binding them to Windows Forms using BindingLins<T>, etc... i ve been testing it out and it works fine. But right now i m trying to make something that have some relations, and i cant figure out how i am supposed to do it, what i m trying to do is a simple "Order" class that is related with a customer and some products... something like: Order Customer Products So, could you guys help me out with this ...Show All

• Windows Forms How to find out desktop resolution/size

  I need to anchor my window to the bottom right of the users desktop. I know there is Me .SetDesktopLocation(x, y) to set the window location but I need to know the desktop size, so I can then minus my window from these to pass in the correct x,y coordinates. Is this possible without the windows API these days Thanks!!!!!!!! Hi, Is there a way to restrict my form from going outside the screen.Because i have a modal window popping up which again will show outside my desktop screen(if parent screen outside the desktop...manually done by the user) becoz of which i cant close the modal nor the parent form. I have to forcefully close the application. Thanks amitha ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Anti-Piracy Security

  I have this scary feeling that people are going to eventually figure out how to use XNA Game Studio Express to right code that will take advantage of the 360 hardware and allow booting of pirated(non-stamped and signed) games. What steps has MS taken to avoid this And if or when this happens will the "rights" and options open to the amauter devs be limited(Limited library uses or such) I really am looking foward to developing for my beloved 360 but I don't want anyone to ruin the fun. Jim Perry wrote: Jon Dowsett wrote: Boot pirated copies of games....Sorry I wasn't really that clear now that I re-read it. Can you do that and still access Live I would think there would be some kind of validation. ...Show All

• SQL Server sql select command

  Hello,everyone,i have a problem:(about BOM caculation) The BOM is B--87700 has one outside service,and two children parts:z--877,and s--877 i have a table,this table which contains columns like this: part_id description price(unit price) quatity B--877 FD 82.36$(service price) 1 Z--877 Roughcast 2.36$ 4 S--877 the same 8.36$ 12 and i want to get a result of this: part_id description price B--877 FD (82.36+2.36*4+8.36*12)=192.12(just the result 192.12 is okay) how can i achieve this target How do I know that B--877 is the parent of the other two And are ...Show All

• Audio and Video Development HDi (I-HD) Developers Website/Resources

  If you are looking for resources for I-HD this is the thread to read. Please update with other resources and websites dedicated to dvd authors/developers. · DVD One Community Website (code snippets, and tutorials) - http://www.dvd1one.net · HD DVD / Randomness Blog (tutorials) - http://blogs.msdn.com/ptorr/ · MS Visual Studio (IDE) - http://msdn.microsoft.com/vstudio/ · Eclipse IDE (IDE) - http://www.eclipse.org/ · WikiPedia for HD-DVD (Definitions) - http://en.wikipedia.org/wiki/HD_DVD Know any other good resources, just add them to this thread. ...Show All

• SQL Server Only show field on last page

  Hallo, i would like to show some fields only on the last page on the report. How can i achieve this (The field is in the body area) King regards, Christian Niehaves You cannot cross-reference items in different bands. Actually, I appologize for giving a wrong page number hack. Pseudo-events like these (setting a var in one band and reading it in another) were working (but were not supported) in RS 2000. In RS 2005, the expression execution order was changed. The net effect is that when reading the variable in the body section, you won't be able to "see" the changes made by the bands. This effectively means that there is no way that I know of to pass a page number to the body section. ...Show All

• SQL Server User credentials delegation from IIS on WinXP to SQL Server on Win2003SRV fails

  Problem: I am trying to create an asp.net website with integrated windows authentication to access SQL databases. IIS resides on WinXP and SQL Server on Win2000 SRV. Both are in the same NT Domain. IIS and SQL Server cannot reside on the same machine and a stand alone web server is ideal as the website needs to access multiple SQL Servers. IIS is set to Integrated Windows Authentication. The machine running IIS & the SQL Server are set to be "trusted for delegation" in active directory. The domain user accounts that will be accessing the databases are not marked as "Account is sensitive and cannot be delegated". The connection string that the web app uses to connect to SQL database is: "Data Source=PWSSQ ...Show All

• Visual C++ SP1 and WinSXS

  What will be placed in the WinSXS directory when SP1 is installed Will there be a new MSVCR80.dll and more importantly, will there be a policy file that redirects the binding of the original dll to the new dll I have googled for _USE_RTM_VERSION and searched the vc include directories and have come up empty. I have a large and complicated application. I am wondering if there is a way to make sure that the app always runs with a specific set of Microsoft supplied DLLs on client machines regardless of whether the SP DLLs are in the WinSXS directory or not. If I use _USE_RTM_VERSION, do I only have to compile the executable using that setting or must all the relevant dlls the app uses need to be rebuilt w ...Show All

• Windows Live Developer Forums The following message could not be delivered to all recipients:

  I need to submit a ticket to the Microsoft Messenger Team.  For some reason the majority of the bots out there are unable to connect to the Microsoft Network. The following message is displayed to the user: The following message could not be delivered to all recipients: It seems that on rare occasions people are able to get through.  This problem started surfacing around the second week in November. Any help in resolving this problem is greatly appreciated. Thanks in advance.   Isaac Encouragebot v1.0 EncourageBot@hotmail.com   My bots admirenature@hotmail.com & investwiser@hotmail.com are both facing the issue "message cannot be delivered" Is there anyone else other than me and Issac ha ...Show All

• SQL Server MSRS + Fit to Page

  Hi, I need to be able to fit a report onto one page of Landscape A4. I can set the page orientation to Landscape, but I cant find anyway of setting it to print on one page. If not, is there a way to have a 'Fit to' option where you specify the number of pages wide and the no. of pages long Can anyone help Cheers Hi I, too, am running into this same problem. Has anything new been done to provide a 'fit to page' option Or has anyone written code to get around this Any help would be greatly appreciated. Thanks ...Show All

• .NET Development Limit the number of entry in a database

  Hey everyone, I want to make a demo disk of the program I just built, how would I limit the number of entries one could place on the database. Thanks When doing your inserts, count the number of rows and throw an exception if 10. If you are using Stored Procs, this is very easy and can all be done with one call to the DB. If you are using inline SQL, you will need to make multiple calls to the DB. ...Show All

• Visual Studio How to un check out an exclusive checked out file?

  I opened an existing system from SourceSafe in Visual Studio 2003 yesterday. But today when I tried to open the system from SourceSafe in Visual Studio 2005 on the same computer and same account, I was prompted 2 files has been exclusive check out by another user. Then I tried to un check out the files in VSS, but I can't. How I can un check out the files Why just these 2 files were checked out exclusively I didn't do any special thing for these 2 files when I checked out the system. Thanks in advance. I am looking forward to the answer. Regards, wlh93 You can also login with the Admin account and you should be able to undo checkouts of any user, but it's best to check first with the user w ...Show All

• Windows Forms how to check empty row in datagridview

  Hi, for eg consider i've 4 rows in a datagrid view . i should be able to select and delete a row. it works fine. but when i select the last empty row (5th) i'm checking like this. if (dataGridView2[0, dataGridView2.CurrentCell.RowIndex].Value == System. DBNull .Value) return ; the above command works in datagridview mouseclick event. but if i select the empty row and use a delete button i need to check the same abov e condition it should get return. but it always deletes the the last row in the grid (here 4th) (i.e) always the rowindex is pointing to the lastrow with data in the grid. so how to check for an empty row....Please let me know some way. I need this . thanks venp--- if (!dat ...Show All