thanks Gail.

Please restart your sql server and check if it works.

Select Name as IndexName,

STATS_DATE ( object_id , index_id ) as IndexCreatedDate

From sys.indexes

declare @a decimal(18,2)

set @a=18.40

if @a>round(@a,0)

Begin

if @a-round(@a,0)<=.25

Begin

select @a=round(@a,0)+.25

goto Value

end

else

Begin

--select round(@a,0)

select @a=round(@a,0)+.5

goto Value

end

end

Else

Begin

if round(@a,0)-@a=.25 or round(@a,0)-@a=.50

begin

set @a = @a

goto Value

end

If round(@a,0)-@a>.25

Begin

set @a=round(@a,0)-.25

goto Value

end

else

begin

set @a=round(@a,0)

goto Value

End

end

value:

print...

Getting the same error when connecting through cmd prompt. This may be due to some other automatic connection is getting established before I connect to the server.

Login failure can be seen from sql server error log files.

BCP utility

Best practice will be your sql server service and agent accounts not to be the local administrative group.

Thanks

You can use the below query to get the from date and to date.

declare @firstday varchar(20)

declare @quater int

DECLARE @curr_date DATETIME

DECLARE @Fromdate DATETIME

DECLARE @Todate DATETIME

SELECT @curr_date = GETDATE()

select @quater=DATEPART(qq,getdate())

if @quater=1

Begin

set @firstday='01/01/'+convert(varchar(10),DATEPART(YYYY,getdate()))

select...

what is the error you are getting?

Try connecting with . or your PCname to connect to default instances.

I suppose we can not run mutiple instances on same port.

You can get the information from syslogins table.

Check this link also

http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.database.refresh(v=sql.90).aspx