Search results for query: *

Is there any way, via systems tables or other method, to capture the NT or SQL User name when the user is listed as sysadmin? For example I'd like to know which user is the owner of an object and dbo, for obvious reasons, does not supply the detail I'm looking for. I was hoping to find this...

I have a multi table join, where I need to select the record with an "open" end date...for example ID Start End 123 01/01/02 12/31/02 123 01/01/03 null 456 01/01/04 04/01/04 456 04/02/04 null 789 01/01/03 01/31/04 In the scenario where ID's 123 & 456 have multiple...

I have a team member that is trying to run the following query... SELECT DISTINCT REGID, TBL_02ND_NAME_DOB_SEX_ZIP.* FROM TBL_02ND_NAME_DOB_SEX_ZIP LEFT JOIN TBL_07TH_DOB_SSN ON (TBL_02ND_NAME_DOB_SEX_ZIP.DOB_SSN = TBL_07TH_DOB_SSN.DOB_SSN OR TBL_02ND_NAME_DOB_SEX_ZIP.NAME_DOB =...

I need to create a numeric value (*EntryID) for each ID that is listed more than once in a table, for example: ID ContractID EntryID -- ---------- ------- 12 1 1 12 1 2 12 1 3 12 2 1 So long as the ID and Contract are the same...

I'm hoping someone out there can offer some good performance and best practice tips! Here's a little background... I have several Access XP Front Ends using SQL 2K as a back end data source. All front ends rely on user input to return records. The user selects values from the available combo...

I have a developer who can't run the Index Tuning Wizard even though he is listed as dbo. He get's an error message stating "to perform this task you must be a member of sysadmin". Can anyone tell me if there is a way around this, my manager doesn't want anyone other than myself (the...

I have found myself in quite a pickle!! One of our executives has been working on a database for several months now. She states that she has been performing large data dumps into this database which is stored on a network drive. Last week while performing an import her system crashed. She...

I need to calculate the number of days between multiple records where the member ID is the same. For further clarification I'm trying to report on patients who visit an ER 3 or more times within a 30 day period. However there is a catch, a patient may visit ER once, let's say on 01/01/03 then...