It is okay. That works just fine.

BTW, why maintenance Plans for maintaining your indexes? Maintenance plans are not really smart enough IMO. Did you get a chance to look at...

Looks like related to Activity Monitor.

See these links...

http://stackoverflow.com/questions/4021428/where-are-all-those-sql-server-sessions-from

http://social.msdn.microsoft.com/Forums/en-US/c8c99b4d-c647-468b-bca8-0790cf7faf84/orchestration-taking-long-time-to-complete-even-though-all-shapes-are-completed-snapshot-?forum=biztalkgeneral

http://www.progtown.com/topic386616-not-clear-process.html

Have you checked the permissions? Are you sure, the remote user defined in the linked Server has appropriate permissions to access the tables on your remote server? How is the...

Adam Bean (1/29/2014)

---

Lowell,

This is great, I have many ideas already on how to expand this pretty intensely.

That's exactly what I needed, I didn't realize PWDCOMPARE was out there! Unfortunately...

Thanks Lowell for this Script...Very handy and very useful 🙂

Brent has an amazing 20 mins video...on this topic.

http://www.brentozar.com/archive/2013/12/video-the-secrets-of-tempdb/

I use RedGate SQL Search and ApexSQL Search(both of them are free and integrate with your SSMS) for searching Database objects. They both work flawless...

This might help you...

http://touchstone-systems.co.uk/blog/?p=74

Profiler and DTA are not included in any of the 3 Express Edition flavors...(Express, Express with Tools, Express with advanced Services)

FYI

http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx

http://office.microsoft.com/en-us/templates/northwind-sales-web-database-TC101114818.aspx

http://www.microsoft.com/en-us/download/details.aspx?id=21733

I've written a detailed 7 part series on how to setup a SQL Cluster Lab from scratch in the past. Below is the link. Hope this helps...

http://sqlbuzz.wordpress.com/2014/01/14/setup-a-sql-server-cluster-lab-in-your-own-laptop/

AFAIK...It's Mandatory for the first time.

You don't need to restart Agent Service each and every time you create a new Operator to work.

However I do remember on SQL 2005 and 2008, Agent Service needs...

You can change it in Startup Parameters with an "-e" switch.

see below link for how this can be done...

http://www.sqlservercentral.com/blogs/sqlandme/2013/07/08/sql-server-how-to-change-sql-server-errorlog-location/

Since you are not seeing 'NT AUTHORITY\ANONYMOUS LOGON', I think you fixed one issue and now you are dealing with User Permissions Issue...

Well, Can you double check if the user(Who...