I would disagree. Typically web applications that are Internet facing where the web servers sit in the DMZ use SQL Server authentication. Internal web servers the typical method is a...

Instead of using IP, do you have the option of using the virtual server name that was created for the SQL Server instance?

If it's on the domain, generally speaking there are no issues. From my experience administering a domain with several thousand systems, we would only occasionally see GPO issues. And most...

Technically it gets it from the server. However, the catch is the server gets its policy from the default domain policy. So effectively it's the domain, unless the server isn't...

This may be a semantic argument, but just for clarification...

In SQL Server, scope refers to a securable that contains others securables. Server, Database, and Schema are all scopes. So the...

This is a normal "error" and can be ignored. If you are not using Kerberos authentication, you can safely disregard the error and do nothing more. If you have a...

You've explained the situation, but you didn't indicate what you want to do. For instance:

Do you want to stop the previous login from being used?

Do you want the application to...

jswong05 (8/27/2009)

---

I don't see why people got SQLExpress free and struggle to get it do something. Developer version is only $50. If you want a free database, you should use...

Steve's presented the typical best solution from a technical side, so I'm going to ask the procedural question. Why not have this scripted and have a DBA execute in a...

DAC does work with SQL Server Express. DAC is disabled by design. While DAC consumes a minimal...

Bob Hovious (8/27/2009)

---

You all do realize that in some cases SSC is the automatic transmission compared to the manual-shift F1 key? All the volunteers enable (some) people to...

There have been no replies on the patch management mailing list, so I'm guessing no one really knows outside of maybe Microsoft. Since it's concerning a service pack, it should...

imSQrLy (8/26/2009)

---

At the bottom of the article it states:

Keep in mind this script will kill any connected users by setting the db to single user with SET SINGLE_USER WITH ROLLBACK...

Lynn Pettis (8/26/2009)

---

So, what was the question and how did you handle it? I've just started ignoring requests for help sent via PM. I don't even bother responding...

EDIT: Brian needs to read more closely. 🙂