Hi,

The documentation reads :

Contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected...

Hi,

I don't think you can get the domain user name, but you can get its IP by looking to sys.dm_exec_connections (client_net_address).

Nicolas.

We have found the root cause of this issue : we actually how been mislead by the documentation of the HSM.

It mentions the need to add an environment variable when...

OK. What do you see in the FDLAUNCHERRORLOG files in the following default directory ?

Program Files\Microsoft SQL Server\MSSQL12.MSSQLServer\MSSQL\log

You can open them with Notepad.

Hi RonMexico,

What is the error you're getting when the service does not start ?

More exactly, you first need to empty the file with the command spaghettidba gave you, and then you will be able to remove this file with the following instruction :

ALTER...

Hi,

You have everything here 😉

Hello,

Here you go :

ALTER TRIGGER [Trigger_DB_Creation]

ON ALL SERVER

FOR CREATE_DATABASE

AS

BEGIN

SET NOCOUNT ON

DECLARE @event_data xml = EVENTDATA()

, @database_name sysname

, @sql nvarchar(1024)

SELECT@database_name = @event_data.value('(/EVENT_INSTANCE/DatabaseName)[1]', 'sysname')

SET @sql = 'USE ' + @database_name + ';'

SET...

Nice supplement to the article I wrote there[/url] 😉

The code extracts the class of the IP Adress 😉

@++ 😉

Hello,

Basically GO is an OSQL and now an SQLCMD command, and had never been a SQL or T-SQL command.

GO matches the SQL identifiers, so it has to work.

Anyway, as it...

The difference you have between detach / attach and backup /restore is that for the first way, you will lose the cache, which is not the case when you RESTORE...