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 Management Studio - Results to File - I think they are coming …
Apr 22, 2010 · SQL Server has Unicode and non-Unicode data types. Unicode includes nchar, nvarchar, ntext and non-Unicode includes char, varchar, text. If the query result has Unicode …
Error Message Installing Northwind.sql: Msg 2812, Level 16, State …
Oct 30, 2013 · SOLVED! 1. I Created a Database with the name Northwind (CREATE Database Northwind) 2. Opened the northwind.sql in Notepad 3. Copied it unto the SQL Server …
Can login domain instance of SQL server with local SSMS.
Jul 31, 2013 · 1- Window server authentication - if we are trying to connect a domain SQL server instance from our local SQL server then we have not option in SQL server to connect from …
problem restoring a back up database (operating system error 21)
May 12, 2011 · Figured it out, in SQl Management Studio, right click on your sql instance and choose Properties. Go down to Database settings and change Data and Log paths to the new …
Web Synchronization failed on Permission
Sep 8, 2014 · I was trying to setup Database Replication on SQL Server 2005 running on Windows Vista with IIS 7. I can setup the publication fine, but when I tried to setup Web …
"The Database Engine instance you selected is not valid for this ...
Sep 10, 2010 · The details of this warning says: "To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup …
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 …
Syntax error in TextHeader of StoredProcedure is there a solution …
Dec 6, 2018 · Microsoft SQL Server Management Studio get this error when trying to modify script the above stored procedure.
How to create Relationship between two or more items/columns …
Jan 5, 2010 · This is just an example what im trying to do. Can anyone help ? I'm using SQL express 2005 SP3 and MS SQL Server Management Studio Express.