bhavesh_183 (7/30/2009)

---

Hello Friends,

I have fairly huge table having 1 million records. The table has a binary tree structure.

I want to write a procedure for getting all the children records for...

Since the query is currently running, you may need to use sys.dm_exec_requests. This will provide you with a current statement start & end offset so that you can see which...

It depends on what you want to do. You can use sqlcmd to run command line scripts to move data from 2008 to 2000 & vice versa. SSIS will work...

To answer the question, it's going to be approximately a wash. Replace acts as a drop & recreate.

But, I'd suggest pursuing what happened as well. What do the consistency checks...

Glad to hear it's fixed. I don't think you did what I was going to suggest, clean out the registry & then try the reinstall. I had to do that...

To my knowledge, they'll see some of the other databases available in the server, but they'll only be able to connect to and perform actions on the db's that you...

But you test their results, right? Those things are notorious for suggesting poor choices on indexes. You need to exercise...

bhuvnesh.dogra (7/30/2009)

---

Thanks

While browsing to HKEY_LOCAL_MACHINE>>software>>microsoft>>microsoft sql server

in the instance folder "REPORT_DEV"

REPORT_DEV>>MSSQLSERVER>>SuperSocketNetlib folder

therer should be one more folder "Tcp"

can u please tell me how can i generate...

gochaithu (7/29/2009)

---

Hi friends,This is Chaithanya.

I have some doubt's in preparation of Online Exam database.My first doubt is...

Too true, but I always like to...

I've never run into that one before. It sounds like a bug or possibly a coding error.

I'm recreating databases pretty regularly in 2008 and I haven't seen this. Just a...

Not really, no.

But you know, I was just thinking... If I had RAQ Report, I think it would solve...

Since someone else may have the same problem and find this thread, can you post your solution?

Thanks Roy.

You can't refer to an alias as a column. Instead of this:

AND CONVERT (INT ,[True Arrears Balance]) > 0

You would need to do this:

AND ((CAST(TEN.[curr-balance] AS INT) + CAST(TEN.[hb-arrears] AS...