Where do you get the backup from??...Directly from the database or you download/FTP the backup file from somewhere?....Have you tried restoring it as a fresh database?

I think it might be...

very nice one Lynn.

Couldn't have done it better.

Medal of SQL HONOUR...must be given to all people who are behind this forum...CHEERS!! guyz

This works too.

--Create Table1

Create Table Ex

(billno int,

amount int )

--Insert Data into Table1

Insert Into Ex

Select 1 ,15000

Union All

Select 2 ,25000

Union All

Select 3 ,35000

--Create Table2

Create Table Ex1

(billno int,

amount int )

--Insert...

I am guessing, you must want to do that dynamically everytime a query is run....right??

This is the best I could do with the vague question you posted:

Create Procedure Give_More_Details

@Table1 varchar(10),

@Table2 varchar(10),

@Col1 varchar(10),

@Col2 varchar(10),

@Data1 varchar(max),

@Data2 varchar(max)

As

Declare

@query1 varchar(max),

@query2 varchar(max)

Begin

Set @query1 = 'Insert Into '+@Table1+'('+@Col1+') Values('''+@Data1+''');'

Set @query2...

By executing the procedure do you mean executing the above code you showed us(creating the procedure) or do you mean running the procedure?

PLS-00306: wrong number or types of arguments in...

You'll get whatever you need to know about Indexing at the following link:

Stairway to SQL Server Indexes[/url]

If you use the following code:

SET STATISTICS TIME ON

select *

from [a view]

SET STATISTICS TIME OFF

then it shows the Time Statistics in the message tab....so what is the problem here??...aren't you...

You're welcome.

Always happy to help.:-)

SQLCrazyCertified (4/17/2012)

---

vinu512 (4/17/2012)

---

What do you mean by BLOCKING?

According to Microsoft the following is BLOCKING:

Blocking

Is that what you mean??...

Anyways you can get the Database back to that state if you have...

Have you tried it like this??

I'm using SQL Server 2008.

declare @table table

(col1 decimal(18,2) )

insert into @table (col1)

values (1),

(10),

...

thats really sweet of you jennyaalt. But I think ColdCoffee was the one who gave the solution.

You're welcome anyways 😀

rvasanth (4/16/2012)

---

Yes we have installed the SSIS component indenpendely on the server.

Note : Same thing works fine if my web server os is 32 bit (Eg : Windows 2003 32...

I believe this would help you.

64-bit Considerations for Integration Services