Viewing 12 posts - 16 through 27 (of 27 total)
Delphix is Oracle based even though it supports MS SQL now i would still be cautious. Red-gate had a similar product which has gone into retirement SQL Virtual Restore. It...
June 4, 2013 at 7:10 am
It all depends on the startegy that is being follow by your SAN team.
If they are using thin or thick provisioning.
With thin provisioning the disk is allocated as 100Gb...
June 4, 2013 at 6:16 am
Hi
Great Script. I was just wondering if there is a reason why the OBJName and DBName doesn't populate?
June 4, 2013 at 5:43 am
-- extract from a script by Jim Sebastiano that I use which provides the information that you need
DECLARE @ShowOnlyThisLogin VARCHAR(50)
SET @ShowOnlyThisLogin = NULL -- leave null for all IDs, otherwise...
June 4, 2013 at 5:10 am
I've had this problem before but finding the article that I used is proofing to be a bit difficult.
Found this one
June 4, 2013 at 5:00 am
Try this,
DECLARE @ServiceaccountName VARCHAR(250)
EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER', N'ObjectName',
@ServiceAccountName OUTPUT, N'no_output'
SELECT @ServiceaccountName
June 4, 2013 at 4:23 am
All I can think of is the process identifier used in task manager and the security identifiers as used in syslogins which uniquely identifies and entity.
June 4, 2013 at 4:16 am
I have been looking for a tool that documents everything.
The problem is that there is never a solution that covers everything that you as a DBA want.
Some DBA's...
June 4, 2013 at 2:47 am
If the other solutions don't work you can always drop the data into excel and use concatenate to add the '' and ,
June 4, 2013 at 1:19 am
Viewing 12 posts - 16 through 27 (of 27 total)