Delivering replicated transactions - Replication seems stuck
We are trying to set up replication for a very big partitioned table on SQL Server 2012. It was not possible to initialize the replication from backup so had to follow snapshot option. Concurrent …
SQL Server 2008 R2 Error 10060 on Remote Connection
Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the …
Unable to connect my SQL server 2000 instance using SMO object …
Please let me know what is the pre request for connecting SQL server 2000 instance or anything else needs to be check. Note :- I have tried to connect some other SQL server 2000 instance, …
Windows Server 2012 R2 and SQL Server Enterprise Edition 2012
Just got a few questions I want to ask. We are running a Windows 2012 R2 server in a WORKGROUP with several clients that use our APP. Our APP is connected to SQL Server …
SQL 2014 and PowerShell 2 - social.technet.microsoft.com
Mar 9, 2020 · During the installation of SQL 2014 the Windows feature 'PowerShell 2.0' will be installed.
Find Unique Values and String Concatenation
I have a dynamic column with Orders Key. These are repeating. I need to find unique values and show horizontally with comma delimited value as below. And also need to get no of unique …
Drop failed for LogFile Microsoft SQL Server, Error: 5042
The file 'Test_log6' cannot be removed because it is not empty. (Microsoft SQL Server, Error: 5042) By Sanz. -- If you find this post helpful then please "Vote as Helpful" and "Mark As …
SQL Server 2008 SP3 (KB2546951) - Installation Failed. Error Code ...
Please take in consideration SQL Server 2008 SP3 cannot be applied on a SQL Server 2008 R2 instance. SQL Server 2008 and SQL Server 2008 R2 are two different realeases of SQL …
Is it possible to select columns conditionally in the SELECT clause …
In any tiered architecture (not just SQL), the database does the “data stuff” and presentation layers worry about what gets to the end users. We do not care about display on this side of the …
The transaction log for database 'Database' is full due to 'ACTIVE ...
Adding to what others have said, I assume you are using maintenance plan to rebuild indexes, if so you are just killing your SQL Server and disk I/O. Why not use some intelligent script like …