Viewing 15 posts - 646 through 660 (of 4,477 total)
I see now that the above now says 'In' for that link. That kind of makes sense now why it is doing that. But now I will ask 'How...
April 19, 2019 at 7:56 pm
All of the scripting options used in SSMS generate scripts are exposed, available programmatically when using SMO. There are quite a few different sample scripts available using SMO but it...
April 19, 2019 at 7:08 pm
It's not a SQL Server issue. Check the google forums for smtp with gmail - that's what I did when setting up something at home to use gmail.
Sue
April 19, 2019 at 6:20 pm
There are other settings in gmail that can affect this. Other things to try such as Disable two factor authentication, disable unlock captcha, log into gmail while on the server...
April 19, 2019 at 2:31 pm
Try enabling the less secure apps setting. Refer to the following which addresses the same error with gmail:
Sue
April 19, 2019 at 12:52 pm
I've used that stored procedure since he first wrote it - great little utility. There are a few people who have done some updates to that stored procedure - search...
April 18, 2019 at 9:24 pm
In the release notes, it says that if you use a locale other than English, you need to set your session to use UTF-8. Refer to the Localization section in...
April 18, 2019 at 9:05 pm
We have several new servers running SQL 2014. Some servers are single instance servers and have the default instance installed. Others are multi-instance servers and have named instances on...
April 18, 2019 at 8:56 pm
I've been playing around with some free alternatives, not interesting in any of the online only type of tools. Apex has a free data modeling tool you may want to...
April 18, 2019 at 2:59 pm
What indexes will help or what would be too much is the same thing you would ask yourself with any database, replication or not. You often have to weigh those...
April 18, 2019 at 2:50 pm
One option would be to drop the article from the publication, delete the data and then add the article back to the publication.
Sue
April 18, 2019 at 2:33 pm
I don't think they are replacing it with anything. Since they removed the database modeling in Visio 2013, the diagramming in SSMS was all that was left in MS products....
April 18, 2019 at 2:03 pm
I don't think there is a message for any autogrowth. You can find the messages by querying sys.messages - that's how I found the error number for the message you...
April 17, 2019 at 7:23 pm
It is frustrating that the diagramming tool built into SSMS hasn't evolved in any significant way since 2005. One thing you can do is print to diagrams to PDF...
April 17, 2019 at 5:38 pm
You may want to check the article and see if the issue applies in your case - make sure to read the beginning and query sys.dm_db_task_space_usage. There is a CU...
April 17, 2019 at 5:01 pm
Viewing 15 posts - 646 through 660 (of 4,477 total)