Getting one set of results does involve repeating some field values, but the overhead of this is almost always going to be much less than the overhead of multiple roundtrips...

The fact that no one has shown you a non-cursor way to generate the views in your app is not proof that cursors are necessary.

If you changed the form of...

So you're saying you never remove tapes for off-site storage?

I've seen many...

If I am the DBA responsible for the data, and someone else is a network admin responsible for running the tape backup jobs, I am very uncomfortable with any tool...

An easy way to view the definition of views, procs, etc. is "EXEC sp_helptext 'schema.object' ". I tested it on an INFORMATION_SCHEMA view from a user database, just to...

chitranjan.ranga (11/22/2009)

do i have to create as many number of Source - destination pairs in my data flow or there is some other way round to attach multiple destination task...

You could quibble that the complete rule is not stored in sysobjects, since the rule definition is in syscomments. But sysobjects is the best answer of the choices given.

Sorry, "SET CONTEXT_INFO {binary value}" works in SQL 2000 but the CONTEXT_INFO() function does not exist. You have to use

SELECT context_info

FROM master.dbo.sysprocesses

WHERE spid = @@SPID

Since it still requires a...

Sounds like a job for CONTEXT_INFO.

If you put "SET CONTEXT_INFO 0x0" before every BEGIN TRAN (and possibly after every COMMIT/ROLLBACK), put "IF CONTEXT_INFO() = 0x0" before every "EXEC ContextCheck", and...

I just did a server migration last weekend and faced the same issues. Some of the agent jobs are disabled because they are only run manually on demand. ...

jdurandt (7/28/2009)

---

Earlier in this comment list it is suggested that the program_name() function be used to separate the different environments. I do not think that this is possible, as the...

This script looks for indexes whose leading columns exactly match each foreign key, and generates CREATE commands where they are missing. It ignores INCLUDEd index columns.

/*Foreign Key Indexes

This query...

The reason a direct update of the Enabled field doesn't work is that SQL Agent has cached this information and won't see the change until it is restarted. The...

You can write a script that generates the commands for every agent job.

DECLARE @cmds TABLE (

idINT IDENTITY NOT NULL PRIMARY KEY CLUSTERED,

cmdVARCHAR(MAX))

DECLARE @i INT, @cmd VARCHAR(MAX)

INSERT INTO @cmds (cmd)

SELECT'USE msdb;...

Triggers react to DML and DDL events. If some code is suceptible to SQL injection attacks, you would have to predict the form of every possible attact to write...