Viewing 15 posts - 61 through 75 (of 118 total)
GSquared (3/2/2011)
Are there incomplete/uncommitted transactions showing?
dbcc opentran() shows "No active open transactions."
The database has a full backup Sunday night, differential Mon-Sat, and logs are backed up every 15 minutes.
March 2, 2011 at 8:11 am
As you wish.
-- --
[font="Courier New"]CREATE TABLE [dbo].[ActivityLog](
[ActivityLogId] [bigint] IDENTITY(1,1) NOT NULL,
[InstitutionCode] [nvarchar](10) NOT NULL,
[EnvironmentName] [nvarchar](50) NOT NULL,
[ServiceRqUID] [uniqueidentifier] NOT NULL,
[MessageRqUID] [uniqueidentifier] NOT NULL,
[RqDate] [datetime] NOT NULL,
[RsDate] [datetime] NULL,
[Signon_SPName] [nvarchar](50)...
March 2, 2011 at 8:07 am
The tables being purged contain ZERO rows. (Refer to the attached JPGs.) The data is in fact purged, but the disk space is not behaving like it's available.
March 2, 2011 at 7:46 am
GSquared (3/2/2011)
March 2, 2011 at 7:32 am
As I said previously, a cluster is either active\passive or active\active. This link from MS provides an overview of the 2 cluster operating modes and the terminologies!
From the link you...
October 29, 2010 at 7:26 am
Steve Jones - Editor (9/10/2010)
Create role MyDenyRole
Then I'd...
September 10, 2010 at 9:04 am
rmechaber (9/10/2010)
Mike Hinds (9/9/2010)
What we finally did was:[font="Courier"]EXEC sp_msForEachTable 'DENY SELECT ON ? TO [TheUser]'
GO
GRANT SELECT ON [dbo].[AllowedTable] TO [TheUser]
GO[/font]
For anyone considering this, sp_msForEachTable is "non-supported".
But what happens when you...
September 10, 2010 at 8:55 am
What we finally did was:
[font="Courier"]EXEC sp_msForEachTable 'DENY SELECT ON ? TO [TheUser]'
GO
GRANT SELECT ON [dbo].[AllowedTable] TO [TheUser]
GO[/font]
For anyone considering this, sp_msForEachTable is "non-supported".
September 9, 2010 at 3:29 pm
Perry Whittle (8/6/2010)
Mike Hinds (8/5/2010)
but manually bringing either online does nothing for the other.then you do not have your dependencies set correctly!
see my attached screenshot for details
Thanks for the screenshots,...
August 6, 2010 at 5:15 am
Perry Whittle (8/5/2010)
Bringing the SQL Server agent online first will automatically bring SQL Server up due to the dependencies between these resources 😉
Not on any of my clusters (I have...
August 5, 2010 at 8:04 am
No need to failover to restart the SQL service. From Cluster Administrator, select SQL Server resource, then "take offline", followed by "bring online". Remember to "bring online" for SQL Agent...
August 5, 2010 at 5:53 am
Relevant to the topic - a useful and fun file utility is WinDirStat. It's also really great example of displaying file space by single-file and by folder hierarchy, of where...
August 4, 2010 at 1:18 pm
Symantec Backup Exec is known to do this to SQL instances. The only way I know to prevent it is to remove NT AUTHORITY\SYSTEM (but don't do it!)
It messes up...
June 30, 2010 at 5:33 am
Thanks to all for the ammunition.
June 28, 2010 at 7:02 am
Still, rebar in concrete won't crumble, unlike its T-SQL counterpart.
April 27, 2010 at 6:57 am
Viewing 15 posts - 61 through 75 (of 118 total)