Yes, I think its messy, I will leave the votes as they are.

CreateIndexNonclustered - There is no remote DR.

Just some history - I had setup this env yrs ago ,...

• This reply was modified 1 year, 2 months ago by  SQLRocker.

use 3 party apps like autosys, db engine is for db engine purposes only not app jobs.

Tested it - It works exactly as i guessed, making it 0 does the needful.

Yes, thanks Alejandro, I made that change too, made in-doubt as 1, I wrote about it here, https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b08472b8-3716-45ae-8158-b30453756602/spconfigure-indoubt-xact-resolution?forum=sqldatabaseengine

Thanks Alejandro, you are right on the delegation etc for linked servers, they still apply to below:

Well, I had went thru the links and many more, there isn't one place...

Hi Alejandro,

Do you have a script for the linked server - I created a loop back linked server (linked servername = listener, datasource= listener), but I am getting various errors...

Got:

Msg 468, Level 16, State 9, Line 83

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation.

----
http://www.sqlservercentral.com/scripts/login/138379/ that...

Anyone?

MSDTC has changed with SQL 2008 Win 2008 clustering, Now having MSDTC is no longer a requirement, you can have 0 MSDTC, or 1 , or more than 1...

Good question, I was also looking for a query to tell me quickly which grp does a domain\user belongs to, the closest I think is(not a complete answer), xp_logininfo

EXEC XP_LOGININFO...

Shrinkfile (can use GUI - release unused space) - t-log backup - Shrinkfile (can use GUI - release unused space)

Got my answer:

Master Database

Expand Programability --> Extended Stored Procedures --> System Extended Stored Procedures

Right click sys.xp_cmdshell from the list

Properties and Permission

I always keep Static Ports only, unless required by app team, try this:

SSCM-N/W Configuration-TCP/IP (Enabled)-

Protocol tab - Listen All - Yes

IP Addresses tab - IPAll- Remove anything from TCP Dynamic...

I tried the above, tx. maint plans & tx. jobs, Modified the jobs - gave error while executing, Modified maint plans - gave error, better just to create new maint...

Thanks for replying & for your time. I am in process of checking with the app team about how the trace flag got initiaited. Will post if I get more...