Yes Ananda,

I will suggest the maintenance for audit detail if it is on production database because if the users

running update and and insert statements then it will take more space...

Trigger code will be like this

create trigger [tablenameinserted] on [tablename] for insert

as

set rowcount 0

set transaction isolation level read...

hi ananda,

i think there is no other way to find the data which is insterd except that need to create some manual tricks to this.

here two posible ways.

1). you should...

Check the bellow link for this topic

http://searchsqlserver.techtarget.com/tip/Stored-procedure-List-SQL-Server-database-objects-by-selected-types

Yousaf Khan

Referencing to the bellow link

http://blog.sqlauthority.com/2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/

here the example

CREATE PROCEDURE #RegularSP

AS

SELECT TOP 10 City

FROM Person.Address

GO

/* Create SP with Encryption */

CREATE PROCEDURE #EncryptSP

WITH ENCRYPTION

AS

SELECT TOP 10 City

FROM Person.Address

GO

/* Execute SP -...

Referencing to the link bellow

http://blog.sqlauthority.com/2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/

if we create procedure like

CREATE PROCEDURE #RegularSP

AS

SELECT TOP 10 City

FROM Person.Address

GO

/* Create SP with Encryption */

CREATE PROCEDURE #EncryptSP

WITH ENCRYPTION

AS

SELECT TOP 10 City

FROM Person.Address

GO

/*...

Right This query is not working if the query is running in another DB session

and also this syntax is wrong

select * from sysobjects where name = '#testvm%'

if the query...

Dear I think there no such way to convert value from bigint to int

the only way to change the datatype of int variable to bigint

@Deep bigint

If there is any...

Your Question is not clear

I think you want to do this

declare @sar bigint

declare @deep int

set @sar = 1234356

set @deep = 12

select convert(int,@sar)

select @deep

Regards,

Yousaf Khan

Hi

I am unable to find the sp or command like sp_update_schedule

i have searched it in sql 2005 & 2000 but there is no...

Hi Lorenzo Ascione

You need...

Dear Friend!

first check that the Raj1 1 is added as linked server if...

Dear Friend!

Try to use a compression software like winrar or any

...

Dear Kenneth

Your Post is very usefull for the new...

Dear Kenneth

These Both has the same functionalty

that shailesh got and you mentioned

from you

select convert(int, 900000 * rand() + 100000)

from shailesh

select cast((900000* Rand() + 100000) as int )

Note Cast and...