Hi All,

I have modified it and code is as follows, if we can minimize the code then please reply.

ALTER PROCEDURE [DBO].[CreateTableByMenuId]

(

@iMenuId [INT]

)

AS

BEGIN

/*

WRITTEN BY SYED SANAULLAH KHADRI

DATE 29-Aug-2008

EXEC...

Ok but while concatenate we need to add this CREATE TABLE TableName with that, but my main problem is

iPhotoGalId INT Primary KEY IDENTITY(1,1) NOT NULL ,vPhotoGalTitle VARCHAR(50),dModifiedDate DATETIME(8),iOrder INT(0)

How...

Hi,

Is there any one who can help me to solve this issue.

Please i am in need............

Hi,

Now see i have connected from my system using querry analyser to that server and its working fine but when i am connecting from that server using query analyser i...

Hi,

Backend means Query Analyser and Front end means Application.

We are able to connect from any system any where just we need to pass the details.But some times after restarting the...

Hi Gail,

I have just now executed two queries ie from table1 and table2, Now i am having 15062 records in both the tables and table1 is taken 45 sec and...

Hi Gail,

I ran this query

SELECT SD.NAME,SD.dbid,lastWaittype FROM SYSPROCESSES SP INNER JOIN

SYSDATABASES SD ON SD.DBID=SP.DBID WHERE SD.DBID=21

and with that database i got only two lastwaittype they are

MISCELLANEOUS and

PAGELATCH_UP

And the...

Hi,

I dont know what client will do but he said to give csv format. Thanks for the support. It will help me to learn new concept.

Hi

But i want the result in money only,If we cant get it then how to display it normally as we have a bigger value with vCurrencyValue column.

we need to...

Hi,

You can change the password using enterprise manager,

Go to security--> Logins and Double click the user name and change the password.

So simple..........

Syed Sanaullah Khadri

DBA

Hi

Got the desired result, ih have visited this link and got the explanation

http://www.mssqltips.com/tip.asp?tip=1016

Very useful

Thanks,

Syed Sanaullah Khadri

DBA

Hi Kevin,

Yes its SQL SERVER 2000 maintanence plan querry, but i have connected that server usin sql server 2005.

EXECUTE master.dbo.xp_sqlmaint N after setting this as maintenance plan i am executin...

Hi All,

Thanks for ur responces but i will tell u the exact reason. My website code is on one server and the database is on other server. I am...

Thanks all,

I will start working on development servers and then will move to production servers.

Syed Sanaullah Khadri

DBA

Hi Gail and Others,

I have done the same thing, previously i was using single login for application and admin page also. Now i have restricted original login for select privileges...