Mark,

try SQLPing http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

Though there's no option of importing a list of subnets, you can define a range of IP addresses.

Markus

There are various ways to do something like that, but my favourite way is using master..sp_msforeachdb. It's the easiest way to execute an sql command in each database. Google for...

Sorry I forgot to exclude stpe_id 0 which gives you just the overall outcome, no details.

So better use:

SELECT message FROM sysjobhistory

WHERE run_status = 0 -- only failed executions

AND job_id =...

The message your looking for is in sysjobhistory.

Try

select message from sysjobhistory

where run_status = 0 -- only failed executions

AND job_id = 'Your_Job_Id'

and you will find it. The problem with sysjobhistory is...

Luk,

check this article http://support.microsoft.com/kb/297369

Markus

Jim

you can't start SQL Server in single-user mode from SSMS. You have to use the command line option. After that you should be able to connect from SSMS. Which error...

You might also use the sysperfinfo table. It's sometimes not that easy to read, but easily accessible through TSQL. See also here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=107424

Markus

Hello Isa,

the way SQL server executes your query depends on the fact if the table has (usefull) indexes or not and the size of the table. The query optimizer determines...

Have a look at the QUOTENAME function. Something like this

Select QUOTENAME ('Markus','"')

Markus

If you're using the maintenance plan and logging is enabled you should find more information in the logfile. I'm not talking about the SQL errorLog, but the logfile for your...

The syncobj_0x1566... views are created by SQL Server for replication when a snapshot gets created. Are you still using replication ? I know that sometimes not all replication objects are...

JDC,

could you post your code which works on the pre-SP2 machine. Because when I originally posted this question I tested it on a SP1 machine and my code did not...

To answer your questions:

1. By default a named instance uses dynamic ports. If you still want to use a fixed port you have to set it after installation in SQL...

In SQL 2000 it was possible to read the text from an encrypted stored procedure by opening a backup file in notepad. Someone told me thats still possible in 2005...