Viewing 11 posts - 1 through 11 (of 11 total)
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...
August 18, 2016 at 6:39 am
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.
August 18, 2016 at 6:30 am
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...
August 10, 2016 at 4:18 am
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.
June 21, 2016 at 4:24 pm
Hi RonMexico,
What is the error you're getting when the service does not start ?
June 21, 2016 at 10:50 am
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...
April 27, 2015 at 10:45 am
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 '...
February 2, 2012 at 9:06 pm
Nice supplement to the article I wrote there[/url] 😉
The code extracts the class of the IP Adress 😉
@++ 😉
August 29, 2009 at 10:58 am
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...
March 17, 2009 at 3:33 pm
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...
March 2, 2009 at 11:07 am
Viewing 11 posts - 1 through 11 (of 11 total)