Logon Triggers: SQL Server
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,397 reads
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,397 reads
Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...
2012-09-16
696 reads
Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-09-16
1,228 reads
For the third year Steve Jones and I are coordinating a very informal networking dinner on Monday night the week...
2012-09-21 (first published: 2012-09-15)
1,827 reads
Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...
2012-09-15
720 reads
Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...
2012-09-14
1,128 reads
Order status on the web site still shows an estimated ship date of the 4th (of September) for my X1...
2012-09-14
819 reads
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
989 reads
It’s preliminary, but the fall 2012 SQL Server Connections schedule at DevConnections is out. I’ll be speaking Tuesday, Oct 30,...
2012-09-14
1,345 reads
A post from Alex Maccaw, programmer at Stripe. He talks about some things he likes about the company, and overall...
2012-09-14
1,213 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers