Viewing 15 posts - 1 through 15 (of 61 total)
use 3 party apps like autosys, db engine is for db engine purposes only not app jobs.
June 4, 2020 at 10:25 pm
Tested it - It works exactly as i guessed, making it 0 does the needful.
April 29, 2020 at 6:25 pm
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
April 6, 2020 at 5:16 pm
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...
March 26, 2020 at 11:50 pm
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...
March 25, 2020 at 4:41 pm
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.
August 4, 2017 at 2:05 pm
July 9, 2012 at 2:13 pm
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...
June 18, 2012 at 1:53 pm
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
July 13, 2010 at 6:19 pm
Shrinkfile (can use GUI - release unused space) - t-log backup - Shrinkfile (can use GUI - release unused space)
May 19, 2010 at 6:33 am
Got my answer:
Expand Programability --> Extended Stored Procedures --> System Extended Stored Procedures
Right click sys.xp_cmdshell from the list
Properties and Permission
February 10, 2010 at 9:25 am
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...
February 10, 2010 at 9:09 am
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...
January 15, 2010 at 11:59 am
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...
December 23, 2009 at 11:10 am
I will try this next time, think will work:
1. Use GUI or dtutil to copy all packages from one server to other.
dtutil /COPY DTS;"msdb\maintenance plans\testdtutil" /DTS "msdb\maintenance plans\testdtutil" /SOURCESERVER server1...
November 17, 2009 at 7:56 am