anyone from new zealand??...

I like that place very much(never been though)

It is said to have the most beautiful scenic places on earth and

lowest crime rate too...

Would love to travel...

any more views?

@ meltonDBA & mohit

Thxs a lot.

Regards,

Sushant

@ mohit

SELECT 'ALTER LOGIN [' + name + '] WITH PASSWORD=N''password'''

FROM MASTER.sys.server_principals

WHERE TYPE = 'S' AND principal_id <> 1

This script when run with results to text is speified gives all(500)alter...

@Krasavita

What does the job do?

What's the code of the first step??

Go to the job, right click, properties,steps, edit and then you can see the code...

write here what is...

@Bhuvnesh

How is that compression different from sql 2005?

Thanks,

Sushant

@Bhuvnesh

My database is 300GB and the .bak file(wen i do a backup) is 145GB only...

wat do u call this ?? Is it not compressed, the free space is...

@ sushant

The .bak file is already compressed..

@Bhuvnesh

Maybe its called something else, but the general meaning of compression is compressing which is as the .bak file wrt the data...

@ markus

I dont think the maintenance plan will fail as when the password is reset , it will be automatically be updated..

Thanks,

Sushant

Everytime, I try to enter the password, it throws the error :

Error1

Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the...

@tosscrosby

ya, it takes time to adapt to the winters specially when you have a frost bite experience at lake michigan...lol..(we went to explore lake michigan in tht cold)

It...

@ramyours

Ya, bhuvnesh is right and also

the credentials which are stored in the sql server have to be changed too

otherwise there will be errors in many jobs/scripts whcih verifies the credentials

before...

I just came from chicago...

Its best place in US to be in the summers

but in winters, it gonna freeze ur balls...lol

Anyway, it was nice and pleasant stay at chicago..

I...

@roy

Where could I find Logon triggers?

@Twinsoft

There are few linked servers but that server from which the attempts to logon are there , is not added as linked...

@ steve

The application on server tries to login every 30 sec or so and get faield..

Is there a possible way to block the connection attempt thru the sql server ?

Thanks,

Sushant