Aside from the fact that neither TableB or TableC have a primary key defined, what is wrong with the structure in the script you posted?

Neither of the two possible solutions...

You probably do not want to use BETWEEN for a datetime field.

If you are...

sgmunson (6/18/2015)

---

sqlnoob2015 (6/17/2015)

---

I am having the hardest time combining these two select statements into one. Can anyone give me some advice on these?

Thank you!!

Basically i want my...

mark.dickinson (6/18/2015)

---

Michael L John (6/17/2015)

---

Sorry, I saw this post and ran out the door after I published the code.......

3. I don't think Database name is part of the EventData Function....

1. Mark, if you don't have a database of DBA-type stuff, give it some thought. Don't give anyone other than the DBAs permission to it and collect whatever you...

At the risk of sounding like a certain grumpy expert, why???...

Union will not work.

This will:

SELECT

case

when Substring(gl_account.id, 5, 3) = 001 then 'Group 1'

when Substring(gl_account.id, 5, 3) = 002 then 'Group 2'

when Substring(gl_account.id, 5, 3) = 003 then 'Group...

Sorry, I saw this post and ran out the door after I published the code.

1. I have a DBAUtilities database on all my servers. This holds auditing tables,...

CREATE TRIGGER [Server_Logon_Trigger]

ON ALL SERVER

FOR LOGON

AS

INSERT INTO DBAUtilities.dbo.Server_Logon_History(EventType, PostTime, ServerName, LoginName, LoginType, SID, ClientHost, IsPooled)

SELECT EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]', 'nvarchar(100)'),

EVENTDATA().value('(/EVENT_INSTANCE/PostTime)[1]', 'datetime'),

EVENTDATA().value('(/EVENT_INSTANCE/ServerName)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/LoginName)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/LoginType)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/SID)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'nvarchar(512)'),

EVENTDATA().value('(/EVENT_INSTANCE/IsPooled)[1]',...

See this thread:

http://www.sqlservercentral.com/Forums/Topic1694442-2893-1.aspx

What likely will happen in the event you need to restore from a SAN backup is inconstancy.

As was suggested, test your RSTORES regularly. I would suggest...

This may be better

SELECT

count(hc),

CS,

S_W,

SUM(case when Reg_Temp = 'Reg' then 1...

Does this work?

SELECT TOP (100)

COALESCE(DB_NAME(ST.dbid),

DB_NAME(CAST(PA.value AS INT)) + '*', 'Resource') as [Database_Name]

...

This will not work inside a procedure.

Can you post your code?

karend211 34657 (6/15/2015)

---

I do see in the sql log that when the snapshot backups are taken that the database IO is frozen, backup is taken & IO is resumed. ...

Jeff Moden (6/12/2015)

---

Just...