On the contrary, overuse of stored procedures (e.g. writing much to complicated procs) is a common mistake.

 May i know the reason for this,  as we are heavily dependant on stored...

Is it pinging with server name . check your dns is configured properly or not...

Thanks a lot for the replay...

Hi Raj,

I was trying this

I was restoring a database with stats and resukt of this, I wanted to store into a table ..

declare @mdf_name varchar(70)

declare @ldf_name  varchar(70)

declare @from_disk varchar(70)

declare @mdisk...

Hi, Raj,

Even I have tried but the problem is you

Cannot perform a backup or restore operation within a transaction.

Hi Gupta,

as per me ,

the Other way is to  change the dataype to Text ...

Hi Raj.

Thanks for the reply..

Is there any tools for Coverting the scripts, procedures and queries from Sql server 2000 to MySql. I tell u what is exactly happening. We are...

Hi Raj,

Thanks for the reply.

Here What meant for Tuple is record and Entity means Table.

I have a table called Products having 74300 records. When i execute

"select * from products"...

Hi  Ivelisse Maldonado 

Thanks to raj for Providing the following information..U can Use

Start like this:

(i) Database name and Service pack.

(ii) No of Databases...

----AUTHOR  :  VEERESH V NASHI

-----CREATED ON :  14-10-2005

The following procedure shuold help u ...

CREATE PROCEDURE prc_CleanUp_DataBase AS

DECLARE @Cnt INT

DECLARE @sql1 varchar(1000)

DECLARE @key_Name varchar(100)

DECLARE @tab_Name varchar(100)

BEGIN

SET NOCOUNT ON

 CREATE TABLE  #Temp1

 ( CODE...

What is the solution u found for the problem.. Will please explain me.

These Decrypting tools are successfull in many times. Dont You think then SQL

not that much secured. Suppose if some body wants to hide the logical steps then they usually...

select * from sysobjects where xtype ='u'

like this

create table #temp

(mycolumn varchar(1000))

insert into #temp execute master.dbo.xp_cmdshell 'dir c:\'

select * from #temp