I don't know if it's true or not but I've read somewhere on Internet in some article that intellisense will be there in SQL 2008. Does anyone know if its...

This is just so cool! Thanks for sharing this information!

I had the same issue with sp_sendmail SP and later I found the user who was trying to access wasn't having enough rights to execute/access it. That might be something...

Yes you can encrypt stored procedure's, Check for WITH ENCRYPTION in BOL. But this is not 100% safe as there are heaps of methods available by which you can decrypt...

Check for OBJECT_ID() in BOL.

I would still go with SSIS instead of spending some time every week on download and upload!

Variable @Results is in different scope when you execute via dynamic sql.

You have to use sp_executesql if you want to get result back into variable from dynamic sql. Check proper...

IF OBJECTPROPERTY(object_id(N'yoursp'), 'IsProcedure') = 1

DROP PROCEDURE yoursp

GO

CREATE PROCEDURE yoursp

@fld1 int = NULL,

@fld2 int = NULL,

@fld3 int = NULL,

@fld4 int = NULL

AS

BEGIN

UPDATE ...

If you want to use sp_executesql, you can do something like this, or check BOL for accurate syntax:

EXEC sp_executesql @V_UPDATE_SYS_DB, N'@V_TABLE_NAME NVARCHAR(128)', @V_TABLE_NAME = @V_TABLE_NAME

If you...

try something like this:

create table table1 (column1 varchar(10) not null)

go

drop PROCEDURE spInsTable1

go

CREATE PROCEDURE spInsTable1

@out varchar(100) OUTPUT

AS

begin try

select @out = 'insert value yes'

insert table1 values...

I think you've to begin your transaction in loop of temp table

or

if you are using SQL 2005

Check for

--start loop for temp table

BEGIN TRY

BEGIN TRANSACTION

--your...

DECLARE @iRecipientID int

INSERT INTO NmsRecipient([iAddrQuality],[iEmailFormat],[iPartitionId],[iRecipientId]) VALUES (1,1,0,1)

SET @iRecipientID = SCOPE_IDENTITY()

OR

SET @iRecipientID = @@IDENTITY

OR

SET @iRecipientID = IDENT_CURRENT('NmsRecipient')

INSERT INTO [NmsSubscription] ([iConfirmationId],[iRecipientId]) VALUES (1,@iRecipientID)

Check BOL for more details about these functions.

SELECT *

FROM CUSTOMER

WHERE customer = ISNULL(@customer,customer)

AND city = ISNULL(@city, city)

AND...

Thx for the update.

I just don't want to use dynamic SQL. I thought there may be some other way out.

Thanks anyway!