As stated, you cannot use @@PROCID to see the calling proc. As you have no doubt found out @@PROCID returns the trigger's identity.

You could however look at @@SPID and...

All the mainframes I have dealt with use some form of EBCDIC...but "EBCDIC" is about as ambiguous as "Unicode". If you're providing data to a mainframe you'll need to ask...

What you are trying to do points out a fatal flaw in the design. If you want to make things dynamic in terms of which database your application is connecting...

I think I misunderstood the intent of your question a bit. I think Gail is a lot closer to what you were asking but now I am curious...are you seeing...

+1 on the Excel file needing to exist first

When you consider that an Excel file is treated as a file-resident database (and not a simple text file) by SSIS (via...

Indianrock (4/23/2012)

---

Normally we check index fragmentation only where index_level=0 I'm wondering about the need or not to rebuild fragmented indexes where index_level is 1 or 2...

Please post the actual code.

rustroot1 (4/19/2012)

---

Hello All,

I have a general question on Policy Conditions... Is it feasible to create a condition that evaluates more than one Facet?

For example, let's say I wanted to create...

I'll second everything Paul said, and add that most serious developers rely heavily on tools to help them in developing scripts and interacting with source control, many times all those...

preity (4/20/2012)

---

Thanks for the prompt response.

I'm converting it to DT_DBTIMESTAMP.

I used a script component to get it to work, but just wanted to find out if there was some...

You could start with Microsoft® SQL Server® 2008 T-SQL Fundamentals by Itzik Ben-Gan. I have not read this particular offering from Mr. Ben-Gan but have been impressed with most everything...

There are a lot of great books, but most of them specialize in one area or another. Some of the big areas that come to mind are T-SQL Development, SSIS...

AIRWALKER-375999 (4/20/2012)

---

Is it to set a WMI DataReader task to fail if the query does not return any rows. For example:

select * from CIM_Datafile where Drive = 'K:'...

Here is another option in the SQLCLR-space for concatenating grouped strings:

GROUP_CONCAT string aggregate for SQL Server[/url]

Something like this?

IF EXISTS ( SELECT *

FROM sys.objects

...