mnachu (1/5/2009)

---

SQL Server : 2005.

Database: AdentureWorks.

.NET version 3.6 with SP1, EF is included in .NET. Using VS 2008 with SP1.

I am trying some examples in Microsoft Entity Framework. I...

I join to the "FREQUENT REORGANIZE" idea... In my 24x7 Servers Reindexing is banned!

row counts are not necessarily the same as the actual rows.

You should use tablediff or any other diff tool to determine if the rows are exactly the same. If they...

cherukuri1974 (1/4/2009)

---

Hi nvkumar,

Thanks for your reply , Suppose my Subscriber server is failed , Then what are immediate steps i have to perform,And i need complete solution if you have...

Kiran (1/5/2009)

---

Thanks for the reply. I have already tried it locally it works for me too, but when I'm trying to access the same as a URL it is giving...

sqlblue (1/5/2009)

---

Thanks Noel, but I wanted to be able to do just a set of row, say 10,000 or

100,000 at a time. How do i do it so that the...

sqlblue (1/5/2009)

---

Can I do batch insert or update with a set of rows at a time(does not have to be in order of any kind), and have it automatically go...

Yes. Manageability, is in my opinion one of the...

Restore will fail if there is a snapshot associated with the DB.

select datalength(imagecolumnnamehere) from tbl where productid = 'N340'

Jon.Morisi (12/31/2008)

---

At this point it looks like I'm back to my original plan of action. I'll repost my questions, please refer to the first post:

Is there a better way...

cpailma (12/30/2008)

---

How often should I back it up? What are the implications to my system? Will the user experience any slowness or timeouts while it the log backup...

you should do it more often!

Check the "severity" level

From BOL:

Errors with severity from 0 through 10 are informational messages and do not cause execution to jump from the CATCH block of a TRY…CATCH construct.

Errors that...

Are you backing up you transaction logs ?