If there were triggers active, this should also happen when you create 1 database.

This problem only shows up when creating 2 at the same time.

No changes to the model database, the model database has the correct options (FULL and 100 (SQL Server 2008))

This only happens when you create 2 databases at the same time.

I asked the same question on twitter and got an instant reply from John Sansom (@SqlBrit)

The answer is: use sys.server_event_sessions, not sys.dm_xe_sessions.

Thanks John,

Robbert

weberharter you are great!!, it WORKS.

Thanks.

I tried that, giving this error:

Msg 111, Level 15, State 1, Line 1

'CREATE SCHEMA' must be the first statement in a query batch.

A 'GO' in between the USE and CREATE...

If you want to archive the deleted records, use:

DELETE FROM table

OUTPUT deleted.* INTO archive_table

WHERE timestampCol <= DATEADD( dd, -90, GETDATE())

To be sure that the user connects to the correct database, start a profiler trace including Errors and Warnings events. You should see the same error in the trace, with...

The original script was only tested on SQl Server 2000.

If you use SQL Server 2005, try this:

set nocount on

declare @statistics varchar(32)

declare @value float

declare @Scheduler_ID int

declare @Online int

declare @Num_tasks int

declare @Num_runnable...

I had trouble executing the original script. This one worked for me:

You only have to adjust the variable @dbname.

Snapshot will be created in the same folder as the original database.

declare...

What extension is configured to be deleted? (.bak or bak)

Do you have an error message from the history?

Robbert

From books online:

A column or local variable of uniqueidentifier data type can be initialized to a value in the following ways:

- By using the NEWID function.

- By converting from...

How about security?

Have you checked if the account running SQL Server Agent has enough rights on the backup folder?

HTH

Robbert

Hi Jeetendra,

In Programs/Administrative Tools/Performance create a new Counter Log.

After that, save this with "Save Settings as". Now you got a HTM file.

You can edit this one in notepad (when you...

Andy,

does the database has the auto_close attribute set to ON?

If so turn it OFF.

If you look at the database owner, from database properties and then Files, is it blank?

If so...

Marc,

this has nothing to do with Windows or Mixed authentication.

It is about a login that is not member of the sysadmin role.

So, you have to create a windows user and...