Viewing 15 posts - 1 through 15 (of 58 total)
If you are installing from a network share make sure the NT account running the SQL Server service has read permissions to that share. SQL EE SP3 on a cluster...
March 30, 2004 at 11:55 am
Terminal Servers in admin mode rocks! Very handy for use on all internal servers for admins. Cut and Paste comes in handy for complex strings via keyboard...
October 14, 2003 at 10:45 am
Another item to consider is licensing. With standard edition you pay for each instance while with Enterprise edition you pay per active physical node so you can run multiple...
October 3, 2003 at 11:50 am
Is this a SQL 7 box you are viewing with EM? The SQL 7 tools don't show orphan users while the SQL 8/2000 tools do. So my guess...
September 23, 2003 at 2:54 pm
http://support.microsoft.com/default.aspx?scid=kb;en-us;823718
without the trailing period will get you there. Thx.
September 2, 2003 at 4:17 pm
I spend more time on this web site then SSWUG. The two sites serve different purposes so I do both.
As to PASS vs. TechEd I think PASS every year...
June 25, 2003 at 10:51 am
Great article that addresses a classic question. We, for the most part, keep SQL and IIS apart. There are a few cases where it makes sense, especially for...
June 20, 2003 at 7:21 pm
Thanks for brighting my day some. Great to spend some time on technical subjects even if you feel compelled to ask C2 questions! Now back to the latest...
May 27, 2003 at 10:45 am
SP3 fixed a problem we had with our Oracle 8.x linked server connections. We heard about permission issues with xp_cmdshell and xp_sendmail and fixed those items before deploying.
March 6, 2003 at 9:19 am
Thanks for pointing out the nuance between auto_fix and update_one! I was using auto_fix with parameters that in effect worked like update_one. By changing to update_one our scripts...
January 27, 2003 at 11:41 am
Yes, but why not just check for null passwords or prohibit the creation of a new account with a null password? The way it was written broke our existing...
January 27, 2003 at 10:04 am
If you have a large environment like ours you spend a lot of time moving databases between servers. The target box, for a new project, seldom has the need...
January 27, 2003 at 9:43 am
So far so good. Installed SP3 on a dev and tst box. Can't say I am thrilled about the change to sp_change_users_login--requirement for @password. It is good...
January 19, 2003 at 2:23 pm
I think the number one reason people have trouble with Clusters is they slap it together without doing a lot of research and study. A cluster is much more...
July 15, 2002 at 2:05 pm
A good topic, but too short! There are more reasons to use SQL logins such as support of 3rd party apps and functioning in a LAN with seperate IIS...
July 11, 2002 at 9:13 am
Viewing 15 posts - 1 through 15 (of 58 total)