Of course you can, I have them both and I even have a 2008 R2 version on my system.

Do you need them all?...

You can also create a LOGON TRIGGER which will disconnect all connections coming from a certain hostname or IP-adres

I see 2 times your calling RAISERROR 50001

RAISERROR (50001, -- Message id.

16, -- Severity,

1, -- State,

N'xp_cmdshell call in [dbo].[adminManagePartition_Trace] failed. Purge not complete.'); -- First argument...

What exactly is your job doing?

Does it run a TSQL script or a stored procedure which contains a RAISERROR (50001,16,1) ?

In that case if error number 50001 is...

Why don't you use Powershell?

This should give you a start

param ( [string]$ComputerName = "YourServer" )

gwmi -query "SELECT SystemName,Caption,VolumeName,Size,Freespace FROM win32_logicaldisk WHERE DriveType=3" -computername "$ComputerName" | Select-Object SystemName,Caption,VolumeName,@{Name="Size(GB)"; Expression={"{0:N2}" -f...

Sounds pretty simple to me.

Just add in the Where clause of your dataset the following:

SELECT *

FROM someTable

WHERE year = @parametervalue OR year =(@parametervalue -1)

Have a look at this post and you should find several ways of doing it.

http://www.sqlservercentral.com/Forums/Topic209722-150-2.aspx#bm870336

Error 10055 is about data integrity. What is your query?

From the error I would guess that you try to insert a value which violates the column defintion, but without knowing...

50001 is a user defined error, not a system error.

You first need to find out which application\database has created this error and when it's fired.

You can also check...

The "server network utility" is for SQL 2000 and earlier. SQL 2005 and higher you configure the ports in the SQL Server Configuration Manager under Network Configuration

Like I wrote before in single_user mode any use can still connect as long as there are no other connections. Only when you use restricted user mode access is limited...

If you simply...

Yes, that is possible and actually quite simple. You just need to create a parameter for the servername which you when use in your connections string.

Here you will find a...

Not sure if this is the one you where thinking about, but it's for sure a very good book (both of them).

http://www.sql.co.il/books/insidetsql2008/

There's also a 2005 version in case you...

You cannot restore a SQL 2008 backup on a 2005 server.

What you could do is using the copy database wizard to export your database to the 2005 machine. Off...