Re: Raising property changed events

2011-03-23 Thread Stephen Price
I was going to use this an opportunity to vent about the msdn documentation and then discovered that the page on this particular method is better than what I usually get on msdn docs. http://msdn.microsoft.com/en-us/library/system.reflection.assembly.getexecutingassembly.aspx Assembly.GetExecutin

Re: Raising property changed events

2011-03-23 Thread djones147
Imo. This has been the problem with msdn since the inception of .net. The last usable msdn was '98. Where you could find examples on all methods with related BUG: documents linked. The xml autodoc and java suffer from the same problem, the developers are there to write code and not provide exa

Re: Raising property changed events

2011-03-23 Thread David Burstin
On 24 March 2011 00:54, wrote: > I haven't pressed F1 in visual studio since early 2001. It's a waste of > time installing the docs as google will give you better and more concise > information in half the time. Couldn't agree more. SQL Server documentation however is and always has been exc

RE: Raising property changed events

2011-03-23 Thread David Kean
If you come across pages where you think the docs need improvement, please use the Rating box in the top right. Given that there's something like 200,000+ pages on MSDN, the UE (doc guys) combine that with page views to focus on low rated, high viewed pages first. From: ozdotnet-boun...@ozdotne

RE: Raising property changed events

2011-03-23 Thread Trevor Andrew
David, I think that Stephen's original rant was not that this was one example of a page documentation needing improvement, but that the entire style of the documentation is so minimal as to be close to useless. Unless I'm getting to the wrong bits, very little of the documentation I reach i

Re: Raising property changed events

2011-03-23 Thread Grant Maw
Agree 100% with Stephen comments. For the amount of money and resources Microsoft must put into MSDN it is crazy that you get better, more useable results using a search engine written by their competitor, which often points to other sites like StackOverflow or ExpertsExchange rather than MSDN. MS

[OT] SQL Server 2005 Database Update Script to Create a table if the Database exists and the Table is missing

2011-03-23 Thread Conrad Lang
Hi All I realise this is a .NET forum but I'm sure we all deal with databases at some stage. Part of this is creating update scripts for the databases in our applications. If you know of a different group I should post my question to, please let me know. My scenario is as follows: - My softwa

Re: Raising property changed events

2011-03-23 Thread Stephen Price
Assuming around 200 people on the list, if we each take 1000 pages we should be able to tag them all with a "please provide examples" I get what you are saying we can post on the pages asking for improvement. Doesn't help you at that moment. It does show that documentation wasn't a priority. Someo

RE: [OT] SQL Server 2005 Database Update Script to Create a table if the Database exists and the Table is missing

2011-03-23 Thread Anthony Tjea
Try replacing your Create Table statement with the following. DECLARE @SQLString NVARCHAR(MAX) SET @SQLString = ' CREATE TABLE [MyTestDatabase].[dbo].[MyTestTable] ( Id INT IDENTITY(1,1), TestColumn VARCHAR(200),

RE: [OT] SQL Server 2005 Database Update Script to Create a table if the Database exists and the Table is missing

2011-03-23 Thread Anthony Tjea
And to resolve your other issues try the following. IF db_id('MyTestDatabase') IS NULL BEGIN PRINT 'Warning: Skipping update because the database does not exist.' END ELSE BEGIN IF OBJECT_ID ('MyTestDatabase.dbo.MyTestTable','U') IS NULL BEGIN PRINT 'Creating [MyTestD

RE: [OT] SQL Server Windows Authentication

2011-03-23 Thread Greg Keogh
Hi Greg L and others, I've spent many hours over the last couple of days trying to get SQL Server 2008 R2 Windows Authentication working over the LAN, with absolutely no success. I'm not experienced in this area, but I've tried every sensible trick I can think and nothing makes any difference.

Re: [OT] SQL Server 2005 Database Update Script to Create a table if the Database exists and the Table is missing

2011-03-23 Thread Conrad Lang
Hi Anthony Thanks. Just wondering though if this is a "known issue" in SQL server with this (sp_executesql) being the known workaround? On Thu, Mar 24, 2011 at 1:55 PM, Anthony Tjea wrote: > And to resolve your other issues try the following. > > > > IF db_id('MyTestDatabase') IS NULL > > BEGIN

RE: [OT] SQL Server 2005 Database Update Script to Create a table if the Database exists and the Table is missing

2011-03-23 Thread Anthony Tjea
Hi Conrad, SQL Server attempts to parse, compile and optimise your SQL statement before actually executing the statement . It is during the compilation step that your SQL statement fails (it does not follow the iterative logic of your IF blocks). Hence it detects that there is a problem becaus

RE: Raising property changed events

2011-03-23 Thread David Kean
First of all, I understand your points. I also get a little frustrated by documentation in certain areas of the product (VS Extensibility docs are frustrating me at the moment) - one of the reasons that I add Community comments to the bottom of the page when I see something missing. However, de

RE: [OT] SQL Server Windows Authentication - New Clue

2011-03-23 Thread Greg Keogh
Folks, wouldn't you know, but minutes after posting my hopeless situation I have found an important clue. I should have asked my cat. The Security Logins for the instance has a Login 'BUILTIN\Users'. If I add 'BUILTIN\Users' to Security Users for a particular database and give it the db_owner r

[OT] Domain groups ineffective

2011-03-23 Thread Greg Keogh
Oh well, here's another unbelievable and utterly incomprehensible problem on my new domain. It seems that all new groups I create have no effect upon permissions. I created a Global Security Domain group called 'Software Developers' and put myself into it. On my workstation I assign the group t

RE: [OT] Domain groups ineffective

2011-03-23 Thread Ken Schaefer
Did you logoff and log back on? The groups in your security token are populated when you logon. Cheers Ken From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Thursday, 24 March 2011 11:59 AM To: 'ozDotNet' Subject: [OT] Domain groups ineffec

RE: [OT] Domain groups ineffective

2011-03-23 Thread Greg Keogh
Did you logoff and log back on? The groups in your security token are populated when you logon. Reboots and re-logins have no effect. I can assign an old group (containing me) to a folder and it gives me permissions immediately as you'd expect. If I do the same with a new group there is no eff

RE: [OT] Domain groups ineffective

2011-03-23 Thread Jorke Odolphi
For the folders that you've applied permissions to, run icacls to display the effective permissions - this might show up an account/group that is applied you're not aware of. From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh Sent: Thursday, 24 M

RE: [OT] Domain groups ineffective

2011-03-23 Thread Ken Schaefer
Can you run: whoami /groups from a command line. That will give you a list of all the groups that is in your current security token. Compare that to the icacls list that Jorke's command gives. Also, have you changed any UAC settings on your machine? Cheers Ken From: ozdotnet-boun...@ozdotnet

RE: [OT] SQL Server Windows Authentication - New Clue

2011-03-23 Thread Greg Low (GregLow.com)
You need to create a login for the YourDomain\SQLAdmins group and assign it permissions in the databases via the "User Mappings" tab. HTH, Greg From: Greg Keogh [mailto:g...@mira.net] Sent: Thursday, 24 March 2011 2:30 PM To: g...@greglow.com; 'ozDotNet' Subject: RE: [OT] SQL Server Wi

compile VB6 dll to work on Windows 7 32bit

2011-03-23 Thread Simon Kuldin
Hi there everyone, One of my co-workers is having an issue where some DLL's they've developed in VB6 on Vista, does not work when deployed on Windows 7. Any ideas what the issue may be? Simon Kuldin | Senior Technical Consultant | PRISM Suite 3, 214 Bay St Brighton, VIC 3186, Austr

Re: compile VB6 dll to work on Windows 7 32bit

2011-03-23 Thread David Connors
On Thu, Mar 24, 2011 at 3:11 PM, Simon Kuldin wrote: > Hi there everyone, > > > > One of my co-workers is having an issue where some DLL’s they’ve developed > in VB6 on Vista, does not work when deployed on Windows 7. > > > > Any ideas what the issue may be? > Is the VB runtime installed on the

RE: compile VB6 dll to work on Windows 7 32bit

2011-03-23 Thread Simon Kuldin
I believe so yes. Simon Kuldin | Senior Technical Consultant | PRISM Suite 3, 214 Bay St Brighton, VIC 3186, Australia P: +61 3 9596 8633 M: 0408 310 957 W: www.prism-solutions.com.au prism-v5.jpg People. Responsive. Innovative. Simple. Met

Re: compile VB6 dll to work on Windows 7 32bit

2011-03-23 Thread David Connors
On Thu, Mar 24, 2011 at 3:27 PM, Simon Kuldin wrote: > I believe so yes. > What's the actual error? -- *David Connors* | da...@codify.com | www.codify.com Software Engineer Codify Pty Ltd Phone: +61 (7) 3210 6268 | Facsimile: +61 (7) 3210 6269 | Mobile: +61 417 189 363 V-Card: https://www.cod

RE: [OT] Domain groups ineffective

2011-03-23 Thread Greg Keogh
Chaps, the output of whoami /groups is very enlightening. It shows I'm in the groups I created a few weeks ago, but the groups I made today and yesterday are not listed despite and fact that (I think) I'm in them. How is this possible? What now? Greg

Re: Raising property changed events

2011-03-23 Thread Stephen Price
Thanks David. I feel much happier about my rant now. I don't usually do them, but really happy to know that it's not fallen on deaf ears. Passing it up the chain is the best thing I could hope for, short of the documentation actually being improved. :) On Thu, Mar 24, 2011 at 11:28 AM, David Kean w

Re: [OT] SQL Server 2005 Database Update Script to Create a table if the Database exists and the Table is missing

2011-03-23 Thread Conrad Lang
Oh, I suspected that might be the case. Thanks again for your help and explanations. Cheers, Conrad On Thu, Mar 24, 2011 at 2:26 PM, Anthony Tjea wrote: > Hi Conrad, > > > > SQL Server attempts to parse, compile and optimise your SQL statement > before actually executing the statement . > > > >

[OT] Domain groups not refreshed

2011-03-23 Thread Greg Keogh
Folks, I have determined that my Win7 workstation is "blind" to domain group changes on the DC. If I create a group, or change the membership of a group on the DC, then these changes are never seen on the workstation. As an experiment, I moved my workstation back to WORKGROUP and then rejoined