Thanks Lucky thanks a lot ...It worked :w00t:

I think this is database level ....And this one comes back to default value when a new query window is opened...

Thanks to all ...:)

Thanks Karl 🙂

Have done it ....:D

I tried the dbcc shrinkfile after taking a log backup but still the log file is not shrinking ...Is there any option to truncate log???

Thanks All,

The problem is that after reviewing the codes they said that EXISTS and TOP have...

Hi Sugesh,

Used the GUI ...first i detached the db and copied the...

Hi Faheem

I went through the link but no solution for my...

Are you able to see that in sql server surface area configuration??

Try giving port no in sql server configuration manager..

Think you have a nice and efficient maintenance plan on your mind.Go ahead.All the best.:D

I want to send a proposal to client who want to make a test environment which is an exact replica of production environment.His requirement is "how to buid a user...

Created a job for the maintenance plan and alert is made to email id but am not getting any alert.I have given the option after completion of maintenance plan the...

Many Thanks jsheldon