homebrew01 (6/27/2016)

---

BUT ....... Now RS seems to handle the parameters in a select list differently if there's 1 chosen or multiples.

If I select just sate CA, I get good...

Alan.B (6/24/2016)

---

If it's a multi-select then SSRS passes the SSRS parameter values as a comma delimited string.

If user selects CA then 'CA' is passed to the stored proc. If...

E McNeill (6/27/2016)

---

My company has a Quality control program that utilizes MS Access to store quality control data. The computer that runs the quality control is a component computer...

mart 13485 (6/23/2016)

---

Thanks for the responses. We had to restart SQL Server, affecting all databases, because one of the tables had a lock on it that we were unable...

You are correct. My apologies you need to backup and restore the SMK used on the original DMK. However this is not done by restore the master database.

But after...

I have a question.

Was this cluster setup and...

This is why SQL Server moved schemas from user dependent to independent objects in 2005.

Create a schema per client (you could also move this to its own database but the...

Just a suggestion but give your support team a batch file that runs a SQLCMD command with your SQL?

Erland,

Yes of course. For some reason I equated.

A few caveats: Always Encrypted may be available in Enterprise Edition only. You mentioned Access - I'm 100% sure that there...

Setting up and using server side encryption with SQL 2008 isn't...

Clint-525719 (6/13/2016)

---

Howdy folks. I have kind of a rambling question, so please bear with me. I have taken a new job, and this company uses column-level encryption. ...

Single left click on the database in question to highlight it then do the right click and select TOP 1000 option.

Check the SQL agent account and insure the user running that service has the proper permissions to the network location.

I agree with Jeff a partitioned view with your "table lite" criterion is the way to go.

salliven (5/14/2013)

---

I'm managing more Microsoft replication.

But Microsoft replication is slow and inflexible. Our replication program is fast and flexible (example: maximum 0,5 sec replication latency,...