Viewing 15 posts - 1 through 15 (of 47 total)
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.
May 30, 2013 at 6:22 am
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.
May 30, 2013 at 3:00 am
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
January 29, 2013 at 2:10 am
weberharter you are great!!, it WORKS.
Thanks.
November 28, 2012 at 1:44 am
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...
November 28, 2012 at 1:24 am
If you want to archive the deleted records, use:
DELETE FROM table
OUTPUT deleted.* INTO archive_table
WHERE timestampCol <= DATEADD( dd, -90, GETDATE())
November 11, 2010 at 6:31 am
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...
November 11, 2010 at 6:21 am
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...
November 11, 2010 at 4:06 am
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...
November 11, 2010 at 3:08 am
What extension is configured to be deleted? (.bak or bak)
Do you have an error message from the history?
Robbert
May 17, 2010 at 5:11 am
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...
May 17, 2010 at 5:08 am
How about security?
Have you checked if the account running SQL Server Agent has enough rights on the backup folder?
HTH
Robbert
May 17, 2010 at 5:03 am
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...
March 25, 2010 at 5:51 am
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...
March 8, 2010 at 7:42 am
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...
March 8, 2010 at 5:49 am
Viewing 15 posts - 1 through 15 (of 47 total)