1. Those 15 transactions will not be performed. SQL server will refuse any connection during that time.

2. I think they will be disconnected.

Nice question

The policy will check if the autoshrink is off for all the databases. The scrpits and conditions are attached.

---condition

Declare @condition_id int

EXEC msdb.dbo.sp_syspolicy_add_condition @name=N'Condition_name', @description=N'', @facet=N'Database', @expression=N'<Operator>

<TypeClass>Bool</TypeClass>

<OpType>EQ</OpType>

...

They are not exactly same. I found one disparity between them. After creating a policy in policy based management, I set the evaluation mode as 'on demand'. While enabling the...

Thanks

Hi MarkusB, thank you very much.

Whats the error message you are getting?

Can someone give some idea on this? I am also interested to get some information on this.

Initial size will not be changed. If the database contains the data less than the intial size, the size will be the initial size. As the database grows beyound the...

As Brandie said manual work is required to automate.

Create new step and add this to the job you want mail alert for failure. Add the below script to the new...

Hi,

Have you checked (sp_helpdb tempdb) from SSMS 2008 after adding the files? If it shows there it must be seen from SSMS 2005 from the server itself.

Have you checked if you can open the shared folder using \\servername\shared_folder from your server?

Is your SQL server browser running?

What is the recovery model of the database where you inserts the rows? You can change to bulk logged before inserting and change it once completed.

I ran the same and it worked for me.