Okay great, thank you both! This application is a simple PHP page that accepts data and inserts it into a DB table. Obviously, it uses the same user...

Hi,

I ran into similar problems a year or so back, but I don't recall the exact error messages (yours look very familiar). When I went through the setup, I...

Our shop expects 50+ hours per week, but we're a small company treading closely to the mid-size category ( I think ). Are you (Jeff, Lynn, Steve) in a...

Hello,

While checking to see that connections were being properly closed, it occurred to me that there were a couple queries that the PHP page was trying to execute before making...

Hi!

Thanks for the response. Here are three consecutive lines:

2009-07-23 16:03:01.950LogonError: 18452, Severity: 14, State: 1.

2009-07-23 16:03:01.950LogonLogin failed for user ''. The user is not associated with a trusted SQL...

Lynn,

Thank you but I will work on Darryl's suggestions. The code in question was posted already. Adding that line in takes the overall process from 4 hours to...

If I'm not working from home on a day off from the office, I'd much rather be fishing. Like they say, "the worst day fishing is better than the...

Ah yes, thank you Matt. I had a feeling i was over-complicating things. This should do the trick. Thanks again.

I did some more digging and found this article: http://www.dbforums.com/microsoft-sql-server/1609971-changing-default-location-new-database.html

Perhaps that is what you are looking for.

Oh Okay i see now.

Did you update the model DB settings?

Great, thanks Jeffrey.

Hi Jeffrey

I opened the log via SSMS and saw entries in the current one from before I ran the previously mentioned commands. I did rerun 'exec sp_cycle_errorlog' to watch...

I see a similar message when I run Activity Monitor from SSMS. The only difference being I see '52' (right now) instead of '213'. I'm fairly sure that...

My apologies on the delay in posting a followup. Here is the DDL for the original table:

CREATE TABLE [dbo].[list_names](

[LIST_ID] [int] NOT NULL,

[NAME_ID] [int] NOT NULL,

[OWNER_FLAG] [bit] NULL,

[create_date] [datetime] NOT...