Hi Ten Centuries

I Installed the Microsoft SQL Server Database Publishing Wizard from the given location but unfortunately its not for SQL 2008 as while connecting I got this following message...

This above link says, The wiki page 'Database Publishing Wizard

' does not exist.

sp_spaceused

This system stored procedure will return the size statistics for the current database context in which it is running. It is very useful for returning ad hoc information regarding database...

CoulumnNameTypeLength

---------------------------------------

PK_ID int 4

Name nvarchar 100

Married bit ...

thanks, thank you so much.

Hi,

Can any one tell me, how can i generate the sqlscript for all the tables and the storedprocedure and triggers of my Database, i successfully generated the sqlscript of the database....

Hi Shushila

Thanks for your guidance.

and i too get the way to create view inside the stored procedure.

CREATE procedure UpdateCL  as

SET NOCOUNT ON

begin

      Exec ('Create view Vxxx as ...

Hi Shushila.

First: of all thanks for your reply.

Secondly: My requirement is to create a view , and after doing some task there , i want to drop the view...

Thanks to all of you,

just now i finished my work , i do the same by stored procedures.

have a nice time to all of you.

Hi Shushila

Thank u so much for your reply ,

1) I m not using the storedprocedure,

   because i can;t call them within the sql query in VB.net forms.

2) and i m...

I feel no need of any stored procedure at all. and even no need of doing any "Set Quoted_Identifier Off" ".

I have done the same thing by...

Hi ron_K

Thanks a millions i got what i was required !

and thanks to madhusudan also who had created this function !

Yes there is the alot of difference in the stored procedure and the USER DEFINED PROCEDURE ,it will be better if u check this link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vdbt7/html/dvtskworkingwithstoredprocedures.asp

Thanks Mark

Its that only for which i was searching !

Thanks you  so much

Have a nice time

just paste this statement on your query analyzer it will show what u need !!!

SELECT B.GAME_ID,A.TEAM_NAME ,C.TEAM_NAME FROM Teams A,Teams C,Schedule B WHERE

B.home_team_id=A.TEAM_ID AND

B.AWAY_team_id=C.TEAM_ID

Have a nice time...