Tags » SQL Server 2008 R2

How to Encrypt and Decrypt Text in SQL Server (2008+)

Here’s a simple example on how to encrypt (and decrypt) values in SQL Server:

--How to Encrypt and Decrypt Text in SQL Server (2008+)
--Example by Clint Huijbers…
100 more words

SQL Server 2012

SQL Server 2008 R2 (x86x64) - Hệ quản trị cơ sở dữ liệu

SQL Server 2008 R2 là phiên bản mới nhất của SQL Server tích hợp các tính năng doanh nghiệp thông minh cùng các nền tảng từ trung tâm dữ liệu đến điện toán đám mây và khả năng mở rộng hệ thống cấp doanh nghiệp. 368 more words

Sql Server Replication Error Message: Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, and sp_replshowcmds) can connect to a database at a time. If you executed a log-related procedure, drop the connection over which the procedure was executed or execute sp_replflush over that connection before starting the Log Reader Agent or executing another log-related procedure

Quick one today:

Recently, in one of our lab machines, we ran into this errors during replication reconfiguration (rebuilding) efforts.

Msg 18752, Level 16, State 1, Procedure sp_replcmds, Line 1
Only one Log Reader Agent or log-related procedure (sp_repldone, sp_replcmds, 
and sp_replshowcmds) can connect to a database at a time. 157 more words
DBA

SSRS Error Message : The dataset `DataSource1' refers to the shared data source `DataSource1', which is not published on the report server. The shared data source `DataSource1' must be published before this report can run.

Quick one today:

Earlier today, in our SSRS lab, after deploying reports using PowerShell, we ran into this error:

The dataset `DataSource1' refers to the shared data source `DataSource1', 
which is not published on the report server. 132 more words
DBA

Server TCP provider failed to listen on [ 'any' 1433]. Tcp port is already in use.

Issue – Today I faced very weird issue; on multi instance SQL Server machine, couple of SQL Services was not starting after Server reboot ( In my case it was SQL 2014 and SQL 2016 ) and every time I was trying to restart my SQL Services, I was getting below error message – 99 more words

Sql Server 2005

Sql Server Reporting Services : SSRS : How to send reporting errors to client (or web page) - EnableRemoteErrors

Quick one day:

Lately, while working on SSRS, we’ve uncovered some tidbits that have been helping us identify the root cause. Here is one of them: 129 more words

DBA