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)' ;

I got bcp working!

Here's how:

1. Open SQL Server Configuration Manager and go to the Named Pipe Properties of your instance.

2. Change the value to:

Note: if your 2000 instance, the old...

Have you ever used sp_MSForeachDB? It is an undocumented procedure otherwise I would provide a link to BOL for you.

What you want to do is call sp_MSForeachDB and provide an...