In my opinion you have the best case scenario in terms of being able to associate every DB session with a specific person. In my experience most applications do not...

Another option is to have a DDL trigger fire on the CREATE_LOGIN event to alter the login immediately after it is created.

This has some valuable insight into what event data...

stevehindle12345 (9/8/2011)

---

When restoring a database to a different server, do you still need to run a fixed orphaned users type script for windows logins, as I thought the SID was...

@Chimney

Here is a thread that may help shed some light on your situation:

http://www.sqlservercentral.com/Forums/Topic1097586-359-1.aspx

After monitoring this system for the last 2+ weeks I have concluded that this is a projection of everyone's worst fears regarding violating, and possibly the interesting combination of, these...

Waseem Jaleel (7/28/2008)

---

I thank all of you for all the responses, this has been very useful to me, I have finally decided to use the xp_msver, by Gail Shaw. Thank...

I use TextPad as my default text editor. It's usable after changing the "Keyboard Compatibility" under "Editor" in Configure > Preferences from "TextPad" to "Microsoft Applications".

After opening the file in...

Evil Kraig F (8/26/2011)

---

Set Textsize shouldn't cause the blocking.

What it indicates WILL cause blocking. Especially if they fubared the design.

For those playing at home since OPC knows this because...

Jeff Moden (8/26/2011)

---

Hi Orlando,

I know you know this but it'll make me feel a lot better if I say it out loud... I don't allow vendors such access. The...

I have heard of databases and sql agent jobs owned by domain accounts having issues when a domain controller is unavailable. The database issues had to do with cross-database ownership...

If you don't mind, please post the steps you took to correct the issue to allow others finding this thread via a search engine to learn.

Cool, HTH. The XML type has a theoretical limit of 2GB in size (~1MM characters in length, it's stored using UTF-16 internally) but IIRC some of the 2GB is used...

FOR XML is only shaping the result before it is returned to you, but after the DB Engine runs the query and gets the rows of data just as any...

Chandler3224 (8/25/2011)

---

Hi all,

Have been lurking for a while now, I've learnt a lot from these forums but I'm at the stage where I need a little hands on help,...

What is the max memory setting?

SELECT value_in_use

FROM sys.configurations

WHERE name = N'max server memory (MB)' ;