Linked server UPDATE fails with message about optimistic …
Oct 20, 2020 · After moving a production environment to a new server (from a windows 2003 32 bit server to a new Windows 2012 64 bit one), the linked server set up in SQL Server is no …
SSDT support for JSON in VS 2013 Database project
Oct 25, 2016 · We have started using the JSON support in Azure SQL Server V12. One of the features we use is "FOR JSON PATH" to convert results into JSON formatted strings. The …
alter databse TestDB set TRUSTWORTHY on fails
Jan 12, 2007 · in which version u r executing this query, makesure that it is SQL Server 2005. I thing u r running it on SQL Server 2000. SQL 2000 does not support this Option. Madhu …
SSIS package is failing when using SQL server agent
May 4, 2014 · @Koen Verbeeck, I checked and rechecked my login, which is the sql server login and it's correct. :/ This is happening with this SSIS package which I am using an excel file but I …
Using READ_COMMITED_SNAPSHOT to reduce deadlocks
Mar 28, 2011 · However we upgraded our application and deployed it to one location, this is now using vb.net 2008 and SQL server 2008 (10.0.2531.0 SP1 Enterprise Edition (64-bit)), this is …
Using XML as a file-type database in WinForms applications
Oct 4, 2007 · Sql Compact edition is a light weight version of sql server might be a good option for you also.
MSSMS reports (ex Activity report) are failing with an invalid …
Jan 15, 2018 · And I do not want to change a general setting for SSMS only. Some other applications are using it so the problem have to be resolved for SSMS only. Regarding the …
Restore the primary database of a log shipping configuration
Jul 15, 2013 · I support a company that is using Log Shipping setup by the previous DBA. The log shipping is setup to do the default transaction log backup/ship each 15 min’s, 24 hours a day. …
SQL 2008 R2 SP1 : Crashing On Linked Server Query
Nov 11, 2011 · Now this query worked fine in SQL 2000 and works fine in SQL2008 Management Studio - why is it crashing from client !!!
Syntax error when creating database - social.msdn.microsoft.com
Nov 10, 2014 · The code checks for SQL Server, gets it's version number in order to use the default SQL Server path. If SQL Server isn't available, ACE / OLEDB is used to create and …