How to log on to SQL Server Management studio
Sep 12, 2014 · If SQL Server is installed on the same computer where SharePoint is installed, then try to connect using “.\SHAREPOINT” (without quotes). If SQL Server and SharePoint are …
SQL LOGIN with weak password - social.msdn.microsoft.com
Feb 3, 2015 · I need to create a SQL LOGIN with weak password. Is there a way to change the password policy or bypass for a specific LOGIN ?
SQL Server uptime, Database uptime - social.msdn.microsoft.com
Sep 18, 2009 · Is there a way, preferably with T-SQL, to query how long the SQL Server service has been running?
Inserting Picture in Report Builder Report
Jul 23, 2007 · I want my users to be able to insert the logo when they create reports using report builder. Documentation tells that under Insert tab you can click on "Picture" and then browse to …
Bulkimport utilizando BCP e arquivo CSV
Dec 1, 2010 · Neste caso a cláusula WHERE não me adianta de nada, pelo menos não nesse momento, porque a Stored Procedure para logo no início no comando set @SQL = 'bcp …
Microsoft sql server extended event log file
Nov 6, 2014 · My MountPoint Size is only 3 GB; My Extended event log are growing fast and it is storing in the MountPoint Drive directly (Path: F:\MSSQL11.MSSQLSERVER\MSSQL\Log).
Collect diagnostic logs for the SQL Resource Provider
Mar 23, 2018 · I have managed to install the SQL Resource Provider on the latest ASDK build (Yah). However, I seem to be hitting some issues collecting the logs, using the defaut script …
How to load local XML File to Azure SQL Database?
Jun 16, 2016 · 1. Create a temp table with text string field in local sql server database, 2. read the xml file as text string and insert it into the temp table3. use linked server to transfer the temp …
Cannot not connect to SQL Server instance.
Mar 23, 2015 · SQL Server was running fine until we installed the product. We uninstalled the product, but SQL Server is still paralyzed. The product seemed to have severed the …
SSMS-EE limitations - social.msdn.microsoft.com
Dec 13, 2007 · It turns out that many SSMS functions take a dependency on SQL Agent, which isn't included in SQL Express, so a few items are lost because of Agent dependency. …