I know exactly what you mean - I knew about this but couldn't find it, so wrote my own. Then, of course - I found it again. 😀

Actually just found a different approach:

SELECT object_name(@@procid);

-- with SCHEMA

SELECT schema_name(schema_id) + '.' + object_name(object_id)

FROM sys.objects

WHERE object_id = @@procid;

Jeff

Well, after thinking about this a little - I remembered something that simplifies this a little. Here is the updated script:

ALTER PROCEDURE dbo.TestProcedure

AS

DECLARE @sessionid smallint;

SELECT @sessionid =...

Here is a better version, forgot a couple of things:

ALTER PROCEDURE dbo.TestProcedure

AS

DECLARE @objectid int;

DECLARE @sessionid smallint;

-- Get the object id for this procedure

SELECT @objectid = objectid

...

How about using something like:

DECLARE @sessionid smallint;

SELECT @sessionid = session_id

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a

WHERE object_name(a.objectid) = 'MyTestProcedure';

IF (@sessionid IS NOT NULL)

BEGIN;

RAISERROR('Process...

You can determine the object name with the following:

SELECTobject_name(a.objectid)

FROMsys.dm_exec_requests r

CROSSAPPLY sys.dm_exec_sql_text(r.sql_handle) a

WHEREsession_id = @@spid;

If you need/want the schema also, you have to...

After adding a new drive to a cluster (both nodes, right?), then you have to add the drive to the cluster using Cluster Administrator as a resource in your SQL...

The best way to shrink is: DON'T. Size your database and log files appropriately and expand them as needed.

See: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

You can use the Import/Export wizard in SQL Server 2005, or - you can create an SSIS (Integration Services) package. If you use Import/Export wizard and save the package...

Looking at what you are providing, there really is not too much we can do to identify the problem. Try just selecting the variable instead of executing it and...

Of course - and probably additional checking to validate that we have 9 characters, etc...

SQL-challenged (5/13/2008)

---

Ok. I've made a few changes AGAIN, and now the drop down is showing the Environments and I'm not getting any errors on the Report Preview, but I'm also...

I agree with Jeff - but, just to have some fun - I would not use the 'correct' answer for this one. I would use this:

UPDATE Employee

SET SocialSecNumber =...

Off the top of my head, I would suspect that you are seeing the checkpoint operation in action.

See: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/98a80238-7409-4708-8a7d-5defd9957185.htm for additional information on what activities cause a checkpoint.

How often do...

snow_rose_87 (5/11/2008)

---

hi guys,i need your help. can you give me abot syntax of "select distict mid/left/right"?

i wanna select 2 characters from this record in a table to a combo box

10073010002

10072010012

10063020001

10083010001

how...