Sounds like it is basically a middle tier that provides caching/fast access to often accessed data. COuld be a good performance benefit with the right architecture. In many cases you...

I am not familiar with Lucene. I have used service broker in several designs and it has worked out well. It does have certain quirks limitations and you should understand...

script all the views on your test database first (save to a file). Restore the database then run the scripts to re-create/alter the views to the ones you saved. shouldn't...

yes.

backup and restore the service master key also.

The SqlCommand class of the SQLDataReader has to be properly initialized and set up with the command parameters (both input and output) to the stored procedure before calling ExecuteReader. Any...

here is psuedo-tsql to pull all parent rows and their most recent detail row:

select [columns you need] from

parent P

JOIN (select parentID, max(detailID) as newID from detail group by parentID)...

there is no way around it (for the ones where there are multiple parent rows in the view result set).

I recommend you use stored procedures to retrieve and update your...

This will return the most recent detail row for a given HeaderId

select *

from tblTrailerUtilizationDetails

where lngTrailerActivityHeaderId = parentID

and lngTrailerUtilizationDetailsId = (select max(lngTrailerUtilizationDetailsId) from tblTrailerUtilizationDetails where lngTrailerActivityHeaderId = parentID)

if admin can connect but user COMP\XXXuser can't then I would look in the SQL Server log and find out the reason why this user cannot connect.

Edit: duh... the reason...

do you have the browser service running? If not you can set up an alias with the native client tools that specified the port.

old way:

select Fname,LName,Mname

from Employee, Timekeep where (employee.id *= timekeep.id

and (timekeep.dept <> 'TRY' and timekeep.wvgroup <> 'SEC' and and time.uname <> 'smith'))

new way:

select Fname,LName,Mname

from Employee

LEFT OUTER JOIN Timekeep ON...

something like this perhaps?

select sum(case when field1 = 'A' then 1 else 0 end) as SUMA,

sum(case when field1 = 'B' then 1 else 0 end) as SUMB,

sum(case when field1 =...

simplest way is to do something like:

group by (datepart(year,date)*100 ) + datepart(month,date)

something is not configured right. Check out this link:

http://blogs.msdn.com/b/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx