GilaMonster (2/26/2010)

---

GSquared (2/26/2010)

---

This kind of design can be done efficiently if you have the front end generate a GUID, instead of using a database-generated integer ID. The GUID can...

Luke L (2/26/2010)

---

I agree that this is perhaps not the best design decision. Perhaps if you're a bit more clear on what the business requirement is, we'll be able...

AndrewSQLDBA (2/26/2010)

---

Very, Very Poor design. Your database will many empty rows. What happens when you insert a new blank record just to get SQL to create an ID, and then...

I gave up. Deleted the instance and made a new one. Problem has now gone.

The cost of time to fix this was to extensive and it was more practical...

Still cannot get this thing to start and stay started and now I have the added confusion of the SQL Server Agent NOT being visible in the SSMS. However...

Tried changing the login credentials.

Same error. 🙁

Also, just to clarify, this is still a development server, security has not been implemented yet as I am the only one working on...

Hey there,

I can confirm that remote connections is selected. I can also confirm that this is a new installation of SS2005. I should comment that I am logged into...