Not enough information.

Please post table DDL scripts, some sample data and expected results based on sample data.

See the first article in my signature line to discover how to post to...

Post some code, otherwise I highly doubt you will get any help.

See the first article linked in my signature line if in doubt.

No, it would block SQLServer users and wouldn't drop existing connections.

I think a logon trigger would do the trick:

CREATE TRIGGER TR_UserShutdown ON ALL SERVER

FOR LOGON

AS

BEGIN

IF DATEPART(hour,GETDATE()) BETWEEN 4 AND 5

AND SUSER_NAME() NOT IN ('sa', 'SomeOtherAuthorizedUser')

BEGIN

RAISERROR('No user logon between 4...

Interesting, I didn't know that a negative %errorlevel% was possible.

GRussell31 (1/23/2012)

---

I've read that TempDB should not be placed on the same location as the Log Files so was planning on placing it on the same location as the Database...

Run this:

EXEC master.sys.sp_MSset_oledb_prop

What does this return for SQLNCLI10,...

Did you reboot the server(s) after tweaking MSDTC configuration? This step is required.

How is the provider loaded? In process or out of process?

Might be a totally different thing, but this article[/url] shows you how to set up and troubleshoot linked servers and OLEDB providers.

Hope this helps

Gianluca

This thread...

Great article Wayne!

Thanks for sharing.

See if this helps:

http://www.sqlservercentral.com/Forums/Topic1188295-392-1.aspx

Ola Hallengren has a great script for that:

http://ola.hallengren.com/sql-server-backup.html

No need to re-invent the wheel.

GRussell31 (1/20/2012)

---

Our current SQL 2000 server has 4 GB of RAM. Is there a typical recommended amount of RAM for SQL 2008? We are moving to a 64bit...

IG (1/20/2012)

---

Why not the following?

SELECT a.EmployeeID,a.Salary a.RActive

b.ManagerName

FROM Employees a (nolock)

,Managers b...