Are DBA's hard to please?

You Bettcha!

If you use a data transformation task to populate the excel spreadsheet, your destination table name is your sheet name in excel.

You can create an Execute SQL Task to perform...

The sp_help_revlogin proc calls another one that you need also. It is sp_hexadecimal, I have included it here.

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

/****** Object: Stored Procedure dbo.sp_hexadecimal Script...

For what it is worth, here are a few thoughts:

1. What about calling the stored procedure twice, passing an argument each time to indicate the result set you are looking...

How about one of these?

CREATE TABLE TestTable2

   (Segment_Id   int,

   Snapshot_id   int,

CONSTRAINT TestTable_SegmentSnapshot_pkc PRIMARY KEY CLUSTERED (Segment_Id, Snapshot_id) )

CREATE TABLE TestTable3

   (Segment_Id   int,

   Snapshot_id   int,

CONSTRAINT TestTable_SegmentSnapshot_pkn PRIMARY KEY NONCLUSTERED (Segment_Id,...

One way to work around the limitation of #table temp tables only being avilable in the process that creates them is to create global temp tables ##table or just use...

The answer to this question depends on your hardware and configuration. I have a 40 GB database that takes 11 minutes to run DBCC CHECKDB on but this is SQL...

Yes, this is yet another poor question. How many are we going to put up with before we stop trying to answer them.

It is like a magnet.....I keep getting drawn...

I agree, this was an irritating question. The fact that we are still talking about it a week later is proof.

Invalid object name is not a syntax error therefore the...

Finally, a question without FMTONLY in it.

An interesting point for vendors:

There is a finite number of lame questions a DBA is willing to endure before they find an alternative venue for sharing information.

A vendor could end...

I thought my computer was wack when I couldn't change the database in the drop down. Thanks for posting this.

I had never experienced that before.

I'm with Chris "I understand that it's in the best interest of the site to probably favor the answer that 83% of people chose..."

When you can please most of the...

I agree with 93fd3s "

BIG FAT HAIRY "DO-OVER"...completely worthless...."

I am an experienced DBA and I do know that the "use pubs" is ignored with fmtonly on and I did answer...

It is questions like these that frustrate me in the morning, and then others pay all day for it!

I really like the explaination...