Viewing 14 posts - 46 through 59 (of 59 total)
I don't think that the Local System account is part of the Everyone group.
The Local Sytem account is not a "regular user" and has no user profile; therefore it cannot see mapped drives. If your...
February 17, 2006 at 2:00 am
You can avoid losing unsaved queries by clearing the checkbox "Do not prompt for unsaved files on closure" in the QA options
February 15, 2006 at 4:50 am
Re. Excel and NULL values, this might be of use: http://www.sqldts.com/default.aspx?254
February 15, 2006 at 2:08 am
I agree with Mark that there seems to be some confusion between DRI and cascading RI
February 15, 2006 at 1:51 am
Is your customer's db in a different domain? If so, you may have an account impersonation issue
February 13, 2006 at 2:02 am
This "simple" example of an uppercase stored proc is a very good choice for another reason: testing just one string will not be enough. A company with users in more...
February 12, 2006 at 6:52 am
I work for a large company that does managed services for clients mainly in the UK
Most of my studies these days are to keep my Microsoft certifications (MCSD, MCDBA) up...
January 30, 2006 at 11:08 am
If you are formatting HTML, try using § instead of §. See http://www.fileformat.info/info/unicode/char/00a7/index.htm
Also, check out BOL topic "Generate SQL Script", about saving a Query Analyzer script as unicode
January 25, 2006 at 7:44 am
My first real exposure to databases was around 2002 as a programmer on a project using VB6 with SQL Server 7. I was very much at the GUI end of...
January 25, 2006 at 2:46 am
Thanks for a helpful article - and all the replies with other utilities and work-rounds. My favourite text editor is Notepad2.
I would like to make a suggestion: although it is nice to...
January 11, 2006 at 2:12 am
Thanks for starting this collection! Here are some of my favourites:
If you're not aware that you have a problem, how can you call for help?
Eternity is really long, especially near...
January 9, 2006 at 10:35 am
I often fall for this kind of problem too! It is one of the reasons I am now much more cautious with outer joins. I now also try much harder...
January 9, 2006 at 4:21 am
Getting a single view of people is also a problem for oursourcing companies, especially when they manage only part of the customer's estate.
We spend a lot of time and effort to...
January 5, 2006 at 3:52 am
I have not done this myself, but perhaps these links may help to get you started:
How to automate Visio with Visual Basic .NET
I think you will have to do...
January 4, 2006 at 2:09 am