http://www.red-gate.com/SupportCenter/content/SQL_Compare/knowledgebase/SC_Permissions_Required

VIEW DEFINITION and VIEW SERVER STATE are what's recommended, it looks like; otherwise you get data filtered based on what schema/objects you CAN see.

it took me a while just to massage your sample data into a usable format.

i ran out of gas just getting this data consumable, maybe someone else can run teh...

the zero-changes to the application thing is the tough part;

i know it's possible to use certificates to allow a view to decrypt data, and then i assume you could...

Luis Cazares (12/10/2013)

---

Lowell (12/10/2013)

---

if you group by both EMPID and PrimaryRater, you don't get the "end Date" you were looking for according to your sample data, so im not sure...

basically, you assign the results to a DataSet; since a DataSet contains a collection of DataTable,s you can then iterate through each datatable, or assign, say a grid's datasource to...

well, whenever you use any of the aggregate functions(MIN,MAX,COUNT)

you have to have one or more GROUP BY column(s).

IF you group by just EMPID, you can only end up getting...

typically what i've done in the past is to limit access to the table to require stored procedures.

the stored procedures get signed, so they can be called by other...

asranantha (12/10/2013)

---

its not given exacetely results and doj format data 0 not added .

2/23/211...

based on your response, i guess you cannot consider fixing the datatype.

here's an example based on your sample data;

the column BackToFormattedDate is what you are asking for

;WITH MyCTE([id],[name],[doj])

AS

(

SELECT '1','abc','3/1/2011'...

wouldn't switching to a union work, i think? i think the AND would short circuit any table scan right away, and will perform a bit better.

SELECT

*

FROM ...

first, a reminder: ALWAYS STORE DATES AS DATES.

from your sample data, it looks like you are storing as varchars, and converting varchars to dates and then dates to varchars introduces...

the answer is no, then.

speeding up of the queries will require indexing changes /additions based on the common WHERE statements being used;

partitioning for performance, like Gail mentioned, is WAY on...

azadrazvis (12/10/2013)

---

Hi

I am trying to create logins for multiple windows users to login in to sql server 2012 but after creation of login and database user...

this is the query i use for defining object ownership:

;with objects_cte as

(

select

o.name,

...

you could add a serverwide DDL trigger that watches for drop database, and issue a rollback command.

that would not prevent a sysadmin from disabling said trigger, nor from restore the...