sqlserv.exe high memory usage on TFS server
Apr 3, 2014 · TFS 2012 Express on Windows 2008 r2, and every couple of weeks OS is becoming unresponsive due to sqlservr.exe taking up all the available memory. My SQL …
SQL Agent Job completion notification - social.msdn.microsoft.com
Jul 7, 2011 · Isn't there a way for SQL Agent to send a success email if a job is successful, and a failure email if the same job failed? I only see how to send one or the other. I could set up …
Retrieving Columns Information for SQL Server Table
Mar 17, 2008 · In my app, i need to get columns information from a sql table.
How to identify the real blocking lock - social.msdn.microsoft.com
Oct 2, 2012 · I am a dba, not a developer. We need to identify a problem with a blocking lock. I have try using profiler to capture blocking and also use master..sysprocesses to identify a …
An error occurred while executing batch. Error message is: …
Oct 16, 2021 · Note SSMS is a 32-bit process. Therefore, it is limited to 2 GB of memory. SSMS imposes an artificial limit on how much text that can be displayed per database field in the …
Business Intelligence Installation Error
May 8, 2014 · To design Integration Services Packages in Business Intelligence Development Studio (BIDS), BIDS has to be installed in one of these editions of SQL Server 2008 R2: …
Visual Studio 2013 and SSIS Package Project integration
Jan 15, 2014 · I have installed Visual Studio 2013 Ultimate Edition and SQL Server 2012 Developer edition on a Windows 7 pro x64 machine. I have also installed Microsoft SQL …
Connecting to Azure SQL using Visual Studio SSDT and my …
Jan 1, 2018 · AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access …
Issues with Import/Export Wizard - social.msdn.microsoft.com
Nov 15, 2007 · It seems like the SQL statementconstructed by wizard to create the destination table (s) is not valid. This is most likely caused by data type issues between source and …
SQL Server 2008 mirroring through firewall port requirements
Oct 25, 2010 · Are you configuring the port for SQL Server? Since the principal database needs to communicate with mirroring database while setting up Mirroring, if the port for SQL Server is …