Arthur Kirchner (11/22/2012)

---

I am sorry,

I trusted Pinal Dave on this one, without crosschecking MS:

http://blog.sqlauthority.com/2011/02/15/sql-server-lck_m_xxx-wait-type-day-15-of-28/

who wrote

"LCK_M_SCH_S - Occurs when a task is waiting to acquire a Schema Share lock."

an...

Thanks for...

Hello again,

I found the problem. Change the /* to */ on the second comment at the end of the line. If not the complete code will be commented out.

Sorry for...

Thanks for the comments! 🙂

Could please tell me where the problem is? i don't see the problem.

Thanks,

Rudy

Hello Lee,

Thanks for the update. Sorry about that, it not always easy to get real testing for scripts.

Glad you like it 🙂

Rudy

Hello,

Looks like the code works outside the stored proc. It could be a SQL 2012 issue, not sure. As for dropping the temp table, I still think it good to...

Hello,

Got your script to execute. Looks like the spaces from the copy/paste from the website caused issues. Now I get the proc created and have created a link connection to...

Hello,

Just wanted to let you know that this script isn't working properly on a SQL 2008R2 server. I think you may upload an older version. Getting erros on this line...

VladaL (7/8/2012)

---

So shall we conclude that it is not possible to install SQL 2008 R2 on Windows Core 2008 R2? I did try to do it following described steps but...

Hey you are correct, SQL 2008R2 is not supported on Windows Core but you can install it. The purpose of this exercise was to learn more about how SQL server...

scweichel (6/26/2012)

---

Change these two lines in your script to make it 2012 compatible -

-- Read physical memory on server

SET @TotalMEMORYinBytes = (select physical_memory_kb from sys.dm_os_sys_info)

-- Coverting value from...

Tec_Chief (4/30/2012)

---

Great Script.. Thank You. Can you add direction on how to take your script results and have it use the MAX MEM (SQLMaxMemoryMegaByte) results to automatically change/update the...

Hello,

Nice article!

You should really say "no" to xp_cmdshell. It is very bad for security.

Instead of using xp_cmdshell, why not just create a local database on each server (very small...

Enable the Protocols "Named Pipes"

Interesting article!

Just talking about automation and the pros and cons with staff here. I believe as long as you fully understand what you are automating then go ahead automate...