thanks Lowell,

I am going to do that.

Hope it helps me a lot

Hi SSC,

thanks for your reply. I need to check how many times my query has been modified and from which IP as the users are using the same user name...

ya sure

USE [Kingethelbert]

GO

/****** Object: StoredProcedure [dbo].[bacs_list] Script Date: 05/03/2013 11:00:36 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- EXEC bacs_list

ALTER PROCEDURE [dbo].[bacs_list]

@company_idINT,

@statusINT,

@INT_USERIDINT = 0

AS

BEGIN...

Thank u all for your awesome output.

It works fine for me. But the same query when I am pasting in SP it shows me the error

SELECT file_id ...

Hi,

My promlem is now solved through googoling.

SELECT

conn.session_ID as SPID,

conn.client_net_address as IPAddress,

sess.host_name as MachineName,

sess.program_name as ApplicationName,

login_name as LoginName

FROM sys.dm_exec_connections conn

inner join sys.dm_exec_sessions sess

on conn.session_ID=sess.session_ID

However thanks for your answer

yes I want to change it..

Please tell me the process.

However thanks for your reply...

Hi Lowell,

Thanks for your reply I have craeted role under CAS database..then grant select option and after that when I add rolemember then it shows me error

User or role 'ap'...

You are right SSCrazy. Agent is not running that's why I am getting error.

Thanks again for your help.

Thanks all for your reply.

Earlier I used to do it in the same way and also I have used SSIS package to move data from one server to other. I...

Then I need to take others help as the database is on Other server then I need to ask that person to take the back up and also will have...

Thanks for your prompt reply

I am trying to do it using Copy Wizard. Is there way why I am getting the above mentioned error.

Thanks in advance!