in order to connect to an alternate port, you either need the sql browser service running, or explicitly state the port.

the browser service runs on port 1434, and when running,...

this link seems to imply the default database for a user might be null?

http://www.sqlservercentral.com/Forums/Topic1259661-146-1.aspx

do either of these return any data?

SELECT *

FROM sys.server_principals

WHERE default_database_name IS NULL

...

the purpose of encryption is to prevent third parties from recovering the raw data, right? so encrypting at the field level is to at least make interception vectors more difficult....

this is the whole idea of what full text searching is all about. you leverage the ability to full text search specific columns,a nd search agaisnt that specialized index:

there's pretty...

assuming Koens assumption on Score,

:

;WITH MyCTE([ClientID],[ClientName],[Date],[Score])

AS

(

SELECT '1','Smith','12/31/2014','25' UNION ALL

SELECT '1','Smith','10/15/2014','45' UNION ALL

SELECT '2','John','08/11/2014','55' UNION ALL

SELECT '2','John','06/18/2014','15' UNION ALL

SELECT '3','Rose','04/15/2014','12' UNION ALL

SELECT '4','Mike','07/23/2014','28' UNION ALL

SELECT '5','Mary','01/5/2014','56' UNION ALL

SELECT '6','Lisa','08/1/2014','54' UNION ALL

SELECT...

column level encryption is what you are asking about., not table level. each individual field in a row would be encrypted.

effectively each column that specifically needs to be protected would...

you can create a view, but Not with schemabinding.

since a...

my first guess, based on what you posted;

the second query is assuming you want to compare just the "previous" row, whcih would be based on the effectivedate.

SELECT * FROM MyTable...

best practice is every permanent table has a clustered index. clustered indexes enhance performance.

that doesn't mean you need a unique, primary key, just a clustered index at a minimum.

Leaving a...

to get one columns a s a comma delimited, one to many, you'll want to use the FOR XML trick.

if you provide actual cREATE TABLe / INSERT INTO code that...

well something like this gives me the componenents to build a query;

for me, the trailing plus sign does not belong in the data, i'd use FOR XML and use the...

any intelligent answer depends...

in that case, after the resotre, you need to fix the orphan; sp_change_users_login is the "old way to do it, which of course still works, but i prefer to try...

the issue is that the user [ssrsuser] on one server does not have the exact same sid as the same named user [ssrsuser] on the other server where you restore.

if...

a connection without a port assumes the default port of 1433, OR that a SQL Browser service exists on port 1434, which in turn redirects the connection to the "right"...