Viewing 15 posts - 76 through 90 (of 259 total)
August 28, 2018 at 8:30 am
sys.servers will return results specific to whatever Instance you are connected to. It has no clue about other Instances which are installed on the machine. Recommended way is to make...
August 23, 2018 at 9:09 am
A quick Bing search landed me here...
https://blogs.msdn.microsoft.com/sql_pfe_blog/2016/12/22/create-index-monitoring-progress/
August 20, 2018 at 2:32 pm
Not sure how critical the subscriber is for your business to be available and how large the DB is, but I would recommend comparing data in pub and sub table(s)...
August 20, 2018 at 10:25 am
Interesting...If allow_anonymous and immediate_sync is set to false, the newly created snapshot should include only newly added articles(in theory). So the rows which it's complaining about, are they from newly...
August 20, 2018 at 10:00 am
Hello,
Looks like it is appending data to your existing tables. Is it complaining on newly added articles or existing ones(I am guessing existing tables)? Just curious, Do you have...
August 20, 2018 at 9:36 am
100% agree with Sue, Paul is the best when it comes to deciphering CheckDBs. If you are concerned about VLDBs, these two specific articles might be helpful:
https://blogs.msdn.microsoft.com/sqlserverstorageengine/2006/10/19/checkdb-part-6-consistency-checking-options-for-a-vldb/
August 20, 2018 at 8:47 am
August 15, 2018 at 1:00 pm
I haven't run into this, but hope the below references have something useful for you to troubleshoot the issue.
https://dba.stackexchange.com/questions/165501/configure-unconstrained-delegation-for-bulk-insert
https://thesqldude.com/2011/12/30/how-to-sql-server-bulk-insert-with-constrained-delegation-access-is-denied/
August 14, 2018 at 12:20 pm
Hi Ronnie,
When using Gmail, you have to enable POP and IMAP and port number should be 587 for smtp.gmail.com. Refer to this article for detailed instructions
https://mssqltrek.com/2011/08/16/configuring-sql-server-db-mail-to-send-emails-to-your-gmailyahoo-mail/
August 10, 2018 at 12:59 pm
I could be wrong but I don't think you can use a single Linked Server to pull from multiple Excel files. My 2 cents, An SSIS package would be way...
August 9, 2018 at 2:34 pm
Was the Listener Online when you tried making a connection? What is the Quorum configuration?
July 30, 2018 at 10:49 am
Mainstream supported is already gone long ago(July 2014). Extended support will be ended in July 2019.
July 27, 2018 at 7:38 am
Great question. Had to pause for a moment to think and I got it right.
July 10, 2018 at 8:47 am
Viewing 15 posts - 76 through 90 (of 259 total)