Here you go:

CREATE TABLE [dbo].[DBA_SERVER] (

 [SVR_NAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,

 [SVR_ENVIRONMENT] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [SVR_ACTIVE] [bit] NULL

) ON [PRIMARY]

GO

You can use the following to setermine which day of the week it is:

SELECT DATEPART(dw, GETDATE())

This will return a number from 1 - 7.  1 being Sunday and 7 being...

Yeah, thats just a report table I created for my specific report..  It's defined as:

CREATE TABLE [dbo].[BAK_REPORT] (

 [SVR_NAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [JOB_NAME] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [JOB_STATUS]...

The report I have checks to see the status of the most recent backup job on all of my servers.  I have a base query that selects this information and what...

Assuming your are running a SQL Query against the server to return the result set you will need to run the same query against the other servers as well.  The...

I'm having a similar issue on SQL Server 2005 Pre-Service Pack 1.  It happens every time a specific query is run using sp_prepexec.

The jobs moved to a new server without the maintenance plan will not work.  If you look at the first step in the maintenance plan job you will see something...

I have had the same problem in the past.  I was never really able to find the exact cause other than the possibility of the fact that with the variable...

I found that i had problems similar to that after my initial install.  To correct the problem I installed the SQL Server Integration Services.  There was some functions of the...

Yep, youwill see an option for install client tools only.

Generally you can keep all system databases in simple mode.  Then back them up once a day, or whenever there are direct changes them, such as adding a service pack.

What you want to do is to install only the client tools on your computer.  If you follow through the install process you will see this option.  Once you have...

It pretty much should negate any return set.  This is because 0 will never equal 1.  Similar to if you were to put WHERE 1=1 then it will always return...

Something like this should work:

DECLARE @string VARCHAR(255)

SET @string = 'ProductionLinkedServerName'

EXEC ('SELECT * FROM  ' + @string)

This is probably due to the fact that there is a lot of rows being returned and the query is just timing out.  I have never found this method of...