SQLkiwi (2/24/2011)

---

atikdesai (2/23/2011)

---

Hi everyone,

There is one user who has permission to execute one SP.

In that SP, one table is created in database and finally it is dropped at the end...

Thanks for replying buddy !!!!

The problem is I don't have so many data. I have just TEST file with 10-20 records.

Thanks Bro. I knew the reason but wanted to find alternative way.

Please anyone if you can find an alternate way.

Post your SP and table definations

I don't have proper data. My client will provide some test data tomorrow. Please try to help me out without data.

I dont know how to do it.

script for Tbl_Messages

CREATE TABLE [dbo].[tbl_Messages](

[pbuserid] [uniqueidentifier] NOT NULL,

[mobile_number] [varchar](20) NULL,

[SWID] [varchar](50) NULL,

[message] [varchar](200) NULL,

[characterID] [int] NULL,

[tacticID] [int] NULL,

[destID] [int] NULL,

[subject_ln] [varchar](50) NULL,

[body] [varchar](50) NULL,

[campaign_code] [varchar](50) NULL

) ON [PRIMARY]

Script for tbl_Mobile

CREATE...

Gianluca,

Thanks for replyong so fast.

another problem is I have to get time stamp value from table tbl_Mobile. And primary key is SWID for tbl_Mobile table. I also have SWID...

I count 9.

Clustered, Nonclustered, Unique, Index with included columns, Indexed views, Full-text , Spatial, Filtered, XML

http://msdn.microsoft.com/en-us/library/ms175049.aspx