Viewing 15 posts - 31 through 45 (of 259 total)
What is the difference between the Upgrade Advisor (UA) and the Data Migration Assistant (DMA)?
All versions of UA are officially deprecated and have been replaced by DMA for...
December 13, 2018 at 1:15 pm
Did you check for any DDL triggers at the server level? Looks like there is a trigger which is stopping you from making this change.
December 12, 2018 at 3:25 pm
Below links should help...
https://www.sqlservercentral.com/Forums/759424/Exporting-Multiple-SSIS-packages-from-MSDB?PageIndex=2
http://sqlblog.com/blogs/jamie_thomson/archive/2011/02/02/export-all-ssis-packages-from-msdb-using-powershell.aspx
December 12, 2018 at 1:02 pm
Error log doesn't record shrink events. Your option is to pull that information from default trace and Yes, default trace doesn't retain information for ever. If your server got rebooted(or...
December 12, 2018 at 12:59 pm
No need to pause or do anything special. Refer to this documentation for clarification...
https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/remove-database-mirroring-sql-server?view=sql-server-2017
Also, to make yourself feel more comfortable, try this in your Test environment...
December 7, 2018 at 9:27 am
December 6, 2018 at 1:16 pm
Glad I could help.
November 28, 2018 at 10:40 am
What happens if you try using simple Import data wizard(Right click on your DB->Tasks->Import data) from your SSMS and use "Microsoft Access(Microsoft Access database engine)" as your source type? (That...
November 28, 2018 at 10:05 am
Just curious, how is email alerting setup in other enterprise monitoring tools in your organization?
November 28, 2018 at 9:27 am
If you are looking for an alternative tool for evaluation, ApexSQL has something similar called "ApexSQL Analyze".
November 27, 2018 at 8:13 am
November 26, 2018 at 10:36 am
Did you try filtering the results from your query using "AND LoginName ='sa' " as suggested in the original thread?
November 14, 2018 at 3:32 pm
No, you don't have to change anything in the above script provided. If you look at the script provided by Lowell, it's basically querying the default trace(trace id =1). This...
November 9, 2018 at 9:09 am
Domain Controller? I think you are interpreting the nslookup results wrong. Also, you can create a trace or an extended event session or create an audit to capture more details...
November 8, 2018 at 3:04 pm
Identify the host from where the login attempt is originating from by doing nslookup on the IP address. That should give you a hint on whether it's someones work station...
November 7, 2018 at 3:41 pm
Viewing 15 posts - 31 through 45 (of 259 total)