I wanted to add a quick additional note. I had several columns that were "longtext" in my MySQL database. When I would try to copy those tables I...

SQLRNewbie (11/25/2009)

---

Hi, thank you for your response

Yes I am running Windows XP Home. What does that mean for me?

My version of SQL 2008 Expression edition was downloaded from the...

SQLRNewbie (11/25/2009)

---

Thank you for your reply.

I do not see IIS under "Administrative Tools" console. I'm running Windows XP. Would that mean IIS is not installed on my computer?...

What MySQL storage are you using? And you could use ADO.NET with the current provider.

The likely candidate is someone inserting a value using SET IDENTITY_INSERT ON that is too high.

A rollback should not have affected things, as you've noted. If you inserted 1,000 values...

Dan Guzman - Not the MVP (11/25/2009)

---

Gift Peddie (11/25/2009)

---

Dan Guzman - Not the MVP (11/25/2009)

---

wouldn't a rollback also have removed the records inserted? The current coulmn value should have...

That is...

Dan Guzman - Not the MVP (11/25/2009)

---

My table of 35 million plus rows gave me a INSERT failure of PK last night. The PK is on the IDENTITY column...

cuongph (11/25/2009)

---

Gift Peddie (11/23/2009)

---

cuongph (11/21/2009)

---

Hi everyone,

I try to create/recompile some extend procedures that could be used in SQL 64 bit environments. However, the library file OPENDS60.LIB doesn't included in SQL...

jsheikabdullah (11/23/2009)

---

I have a asp.net application which is used intranet by the client. The hospital patient turn over is 900 per day and at least 40 users use the application...

Two Vista Home Premium machines setup. SQL Express 2005 is successfully installed on the first machine along with our application. Our application is able to browse and connectthe SQL Express....

If you are running Windows Server 2003, Windows XP Media Center Edition or Windows XP Tablet PC Edition, there is a version of the .NET Framework that ships as part...

gmamata7 (11/23/2009)

---

Yes, We have windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE x64 with SP3.

Does reinstalling .net 2.0, affects the SQL Server?

How can I reinstall .net...

The Open Procedure for service ".NETFramework" in DLL "C:\WINDOWS\system32\mscoree.dll" failed. Performance data for this service will not be available. The Status code returned is the first DWORD in the attached...

bkirk (11/23/2009)

---

I didn't explain that very well.

I am a web developer that provides and Administration login section for my clients to manage their data and front end website. Each...