Tables ( not the # or ## tables ) created in tempdb will exists till next restart of the server, as tempdb is rebuild from scratch at each start of...

You could store the login/password (encrypted)  in a table and let the procedure fetch this from that table. You could also store this in the registry and read it from...

Do you have a list of tags ?

You can not use the temp table after the EXEC. This is because EXEC is run in a new "connection". You could try to create a 'global temporary...

 DATALENGTH returns the number of bytes, and not the number of characters ( this is not the same ) But Len returns...

I saw the script "Function To Retrieve Last Index ". I do not understand why it is so complicated. THis script does the same :

create function dbo.LastIndexOf

(

 @strValue varchar(4000),

 @strChar varchar(50)

)

returns...

select CName,CADD,CScore

from CustomerDetails

where CName in ( Select CName From CustomerDetails group by CName having count(*) = 1)

Me to, I wrote my own log shipping routines , and have a stand by server that I can use. I do not understand...

The rsultset is not stored. If you want the result in a table, you should do like this :

create table #header

(

BackupName nvarchar(128),  -- Backup set name.

BackupDescription  nvarchar(255), --...

Little error in your trigger. Please try this :

Create trigger dbo.bkiTriggerTest_Instead

      on dbo.bkiTriggerTest

      INSTEAD OF INSERT

   AS

   set nocount on

   insert into dbo.bkiTriggerTestDups (i2.pkid, i2.dval1, i2.dval2)

     ...

There's nothing wrong with it !

I do create a lot of sp_ procedures in the master database, but to distinguish MS sp_ procedures and mine, I use the prefix sp__...

Do you need something like this :

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Sales_All_Children]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop proc [dbo].[Sales_All_Children]

GO

CREATE PROCEDURE [dbo].[Sales_All_Children]

(

 @EntityID varchar(30),

 @EntityTypeID int

) AS

begin

 --Total sales...

To strip only the ending *, you could try this script :

create table tsttable ( tstcol varchar(20) )

go

insert tsttable values ('ABC**')

insert tsttable values ('ABC**D')

insert tsttable values...

You can do 10 fetches. But this will generate 10 result sets ... :

create procedure aa

 @rowset integer

as

begin

 SET NOCOUNT ON...

If the trigger runs for insert, the deleted table will be empty. You could do this like :

CREATE TRIGGER [sp_trrequest] ON [dbo].[TrRequest]

FOR INSERT, UPDATE

AS

BEGIN

 DECLARE