DENY SELECT ON Table1 TO user1?

Similar thread here

http://www.sqlservercentral.com/Forums/Topic1059299-391-1.aspx#bm1087746

I have WMI based alerts configured to notify me.

SELECT @instanceName = CONVERT(NVARCHAR(128), SERVERPROPERTY('InstanceName'));

SELECT @namespace = N'\\.\root\Microsoft\SqlServer\ServerEvents\' + @instanceName;

SELECT @wquery = N'SELECT * from DATABASE_MIRRORING_STATE_CHANGE

WHERE State =...

This is better

select * from sys.messages where language_id = '1033' and text like '%mirror%' order by message_id

I've noticed a lot of the wmi state change events don't seem to have corresponding event IDs, like synchronizing and synchronized. I'm curious to know what you end up...

check this out

http://msdn.microsoft.com/en-us/library/cc645860%28v=SQL.100%29.aspx

I'm thinking I should just setup all my servers to use GMT no DST from now on...that's not way to not have to deal w/ any of it 🙂

dbcc shrinkfile, it's in books on line

I put up a similar post a few weeks ago and didn't hear anyone having troubles. I've yet to install it.

FYI, tempdb got hammered and grew quite a bit on my test server

Create a WMI based alert to trigger a job that runs an SSIS package when a new file is written.

Thanks, we had to forgo reindexing on this 14GB DB until we get more disk space, so I'm trying to avoid a disk space / tlog out of space error...

When I have issues with log shipping I have verified that no transactions have happened by verifying the LSN number hasn't changed when looking at the sql log for the...

Broken Link:

http://support.microsoft.com/smarterror/default.aspx?spid=global&query=scid%20kb%20en%20us%202289254%20spid%2013165&sd=rss&errurl=%2fdefault.aspx%3fscid%3dkb%3ben-us%3b2289254%26sd%3drss%26spid%3d13165

Thanks Gail!