hi try this

DECLARE @Month TABLE (Names Varchar(50),Team varchar(5),[1] SMALLINT ,[2] SMALLINT ,[3] SMALLINT ,[4] SMALLINT ,[5] SMALLINT ,[6] SMALLINT ,[7] SMALLINT ,[8] SMALLINT ,[9] SMALLINT ,[10] SMALLINT ,[11] SMALLINT ,[12]...

Superb thats what i need thanks a lot u have saved my time

Cheers

Parthi

But how cum it is done tro Generate SQL Script in object explorer

Hi

But What about scripting Tables i need to script tables how to do it.

Thanks

Parthi

hi i got it

DECLARE @Name varchar(100)

DECLARE contact_cursor CURSOR FOR

select Name from sys.sysobjects where xtype in('p','tr','v') order by Xtype

OPEN contact_cursor

FETCH NEXT FROM contact_cursor

INTO @Name

WHILE @@FETCH_STATUS = 0

BEGIN

exec SP_Helptext...

I have given my error details in my 1st post itself

again i am sending

TITLE: Microsoft SQL Server

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

SQL Server cannot create the mirroring endpoint, 'Mirroring'.

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

ADDITIONAL INFORMATION:

Create failed for...

Yes i am using Same...

amalanto (2/25/2010)

I am using sql server 2005,In that we have one stored procedure A to call stored procedure B, which returns a set of records from...

hi

Nice one it worked out.Say for eg: take this as input of the below query's output it is in XML then how...

This is the continuation of the above thats why i have posted here.

Hi

This Time my problem is bit different

I am having a database with daily Full backup i did not put Translog backup for the...

Hi Friends

DECLARE @Tmp TABLE (I INT ,VALUE VARCHAR(25))

INSERT INTO @Tmp

SELECT 00,'1,2,3,4,5'

UNION ALL SELECT 01,'1,2,3,4,5'

UNION ALL SELECT 02,'1,2,3,4,5'

UNION ALL SELECT 03,'1,2,3,4,5'

UNION ALL SELECT 04,'1,2,3,4,5'

UNION ALL SELECT 05,'2,3,4,5'

UNION ALL SELECT 06,'2,3,4,5'

UNION...

Hi Mark

Nice one, that is good in 2005,we are using 2000 how to get in 2000 any idea.

The above O/P is what...

Then use 3rd party Tool log Rescue (if you u have from beginning) and find date and time...

What is mean by No space to create a new table with the...