I think you need to go with something like the following:

EMPLOYEE

(EID INT IDENTITY PRIMARY KEY,

EMPID ...

I'd tried the function within a database that had been restored into 2014 from a 2008 instance, so the compatibility level (100) of that database was set too low. When...

It was the compatibility level of the database. It was set to something too old. I switched databases and it worked without problem.

--=cf

If there's a person who does not have to apologize for a rare mistake, it's you, Jeff. Your contributions to this forum are much appreciated.

--=cf

Jeff,

I think your windowing function needs a DESC, like DesNorton's solution has. I feel like a jerk writing this, since your Jedi SQL skills far surpass mine,...

I manually failed over to the patched server in the cluster, and the version on that server shows the SP1-CU6 in the version. So that sort of answers my question,...

Confirmed, it was a Cumulative Update. So I guess I still have a question ... when does a CU not result in a change in the SQL Server version number?

In...

Odd ... I restarted my computer, and the service started up using the same AD account that was previously throwing the invalid password error, without me having changed my password.

Is...

This is the error from the Event Viewer:

The MSSQLSERVER service was unable to log on as AGENCY\smithr with the currently configured password due to the following error:

Logon failure: unknown...

I would suggest using CASE over IIF within a SQL statement (it sounds like IIF can also be used in T-SQL code?), unless IIF is now considered to be part...

Sachin, that's what I understand. My question is how can I setup a procedure that restores an existing database, that someone who is not in these roles can execute. I...

It looks like the user account actually has to be the actual owner of the database to perform the restore. Being a member of db_owner isn't privileged enough. Aside from...

Are you saying that I should put this restore-capable user account into the db_owner role for the database? I haven't heard of making someone a dbo user (I always took...

If your 4 SQL statements were potentially part of a UNION or UNION all construct, you could push this on-the-fly lookup table into a WITH clause. (Not to make this...

Ok, thanks. I thought it was probably a non-issue, but it was asynchronous with what all of our other servers were displaying, so I thought I'd check. --=cf