You have been given the answer to your problem in both the error message you are getting, and in the post that Phil provided.

Use WITH REPLACE in your restore...

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. ...