Recent content by mkelly11

Thanks for the quick replies, I'll stick to enforcing the fact that all object creations must be manually noted in a "meta data" table. Unfortunately we are all sysadmins by title, so I can't demote people to lower level permissions simply for tracking purposes. Thanks.

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...

Thanks for the many suggestions! The problem turned out to be with the table design,(I decided to take a look instead of taking my co-workers word for it:)) After changing the datatype and field lengths of several columns, and then adjusting the query to use the correct fields (instead of the...

Yes the fields are indexed. I know there is a way to run this query through profiler, but I'm not certain how to capture just this query. If I'm on the right path, please send me a suggestion:)

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 have a cursor written, which I believe will work fine. But I'm having a case of the sometimers and just can't get the "Counter" to work correctly. Could you offer any suggestions on syntax based on the example data listed above?

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...

Yes, he does have MSDE on his workstation. Now since I'm a newbie to the DBA world, is this an accepted practice in med to large companies? I'm entirely self taught and do not have any "Mentors" at my company. In your experience have you found it to be acceptable for developers to...

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...

Quick question to clarify... Are you looking into which version of SQL Server to purchase or have you already purchased one? 1)Microsoft Access Project is similar to SQL Server in that end users can access and create databases on the Server and manipulate them as if they were using Enterprise...

How familiar are you with SQK 2K? Are you looking to create the back end from scratch? Access does offer an "Upsizing Wizard" for SQL, which will automatically create and link your tables. I was in your same scenario about a year ago, if you have any other questions I'd be happy to...

Check out www.ontrack.com, I believe the price was around $600.00. However I found several others ranging in price from $100.00 - $350.00. Just search on "Access Recovery" on your favorite search engine. I found the higher the price the more detail you can recover or completely...

Hey folks! Thanks for all your idea's [thumbsup2]. Unfortunately for me (and our VP) our network team was not backing up this particular network drive, it's actually a miscellaneous drive meant for files to be temporarily loaded to, then removed (i.e. to another drive that's backed up or their...