Hi

Only in case of non clustered index

If u create the index on a null field it will be faster because SQL Server treat that column as empty(no records).

from

Killer

Dear Hans,

Will be pls post ur post in English we can understand what u had written in ur posts.

So, pls post in eglish.

from

Killer

Hi,

It is possible that u can install two instances of Sql Server 2000 and 2005 but diffrent location , i dont know it is recommended by Microsoft or not.No 2005...

Hi Brain,

Thanx for u help

I did it like this

exec xp_cmdshell 'osql.exe -L >C:\log.txt'

from

Killer

Dear,

I want to know the name of the network computers having installed sql server.(Sql Server2000)

thanx

from

sufian

Hi ,

There is no way to save the execution plan out put in a text file.

from

Killer

Hi Ryan,

Thanx It worked like magic.

Thanx to all of u.

from

Killer

Sorry not to mention that the ERP application(Naviosion Axapta) we are using do not support distinct function.

so do we have another way of doing this

from

killer

Hi KP,

There are normal locks on the table.

from

sufian

HI Thanx for the reply,

The sp_reset_connection is called 3,898 times in 8 hours.Is this ok i mean is it not bad.That the stored procedure is called upon so many times...

Thanx bkelley.

I understood what u where trying to say.

from

Killer

Thanx for ur reply.

But i did it myself.

from

Killer

Hi,

If we left the guest user as .Then any user can access the database and can harm it or miss use it.

Is there anyway that user other then Sa cannot...

Hi,

I created a login given permission on a database but this user can access the master database becasue of guest login.

I need to restrict that user not to access the...

Thanxs for ur reply.

The same answer i got from microsoft support.

I needed this information becauses the company i am working was asking me that he want a report to see...