Answers 1 and 3 were wrong for me, 2 was correct.

Here's a mixed bag for you:

Green Day -- Bullet in a Bible

Elton John -- Captain Fantastic and the Brown Dirt Cowboy

Glenn Gould -- Goldberg Variations

Beethoven's 6th Symphony (many good recordings...

I suggest you just snip the useful statements from the other SP and include them in-line in your own.  It creates some extra work, but it's the only way to...

Your understanding is basically correct.  You can create a role in each database with the specific permissions required, then assign users to those roles.  If there are no sensitive columns...

When you start a transaction log backup while a full backup is running, it will fail with a serialized process error.  It doesn't hurt anything really, but it is annoying.

We...

Try this:

declare @bigEventinfo nvarchar(4000)

declare @eventinfo nvarchar(257)

create table #x (

 EventType  nvarchar(30)

,Parameters Int

,EventInfo  nvarchar(255)

)

  insert #x exec('dbcc inputbuffer(1)') -- Change the spid, of course

  select @eventinfo = left(eventinfo, len(eventinfo)...

create table #tblTest

(Name char(20),

state1 char(2),

state2 char(2),

state3 char(2),

state4 char(2))

insert into #tblTest values ('Fred',NULL,NULL,'CA',NULL)

insert into #tblTest values ('Bill',NULL,'AZ','NY',NULL)

insert into #tblTest values ('Joe',NULL,'CA',NULL,'WA')

SELECT rtrim(Name)

+ isnull(', ' + State1, '')

+ isnull(', ' +...

ER/Studio from Embarcadero is another good product comparable to (better than, IMHO) ERwin.  Again, kinda pricey and probably overkill as well.

My two cents:

A logical schema is a picture representing the tables, columns, indexes, foreign key relationships, views, stored procedures, etc. as they would be physicalized.  The physical schema is what...

Here is a sample script to get all the connections and data sources from a DTS package.  You can also declare a cursor on msdb.dbo.sysdtspackages to get the names of...

But once you have created your temp table, before you get your execution plan, be sure to go through the steps to populate the table.  Otherwise the optimizer won't give...

You can use sp_OAGetProperty on the DTS object.  You can use the Visual Studio object browser to get the list of object properties exposed.

Use sp_OACreate to create a DTS package...

While in principle I agree with your attitude on this, I've seen several people tank their employment on just such hard-line stands as this.

The cold reality is that in some...

Tricky little problem.  There were some interesting twists with the cross join.  Here's my whack at it (Although you've probably got it by now already):

select x.recid, x.recdescrip, x.grantedid...

We have run across this a couple of times.  Strange as it may seem, the vendor is adamant about having their login be the database owner, even though it's not...