where is express edition mentioned in question.

Thank you dear for your reply. I know all this. But by this they can see all databases present on server.although they can't access them.but i had a condition they...

It could be any where, but both place should be accessible by sql server account. It will work on a network path too or a remote location.

--Configure advance options

sp_configure 'show advanced options', 1;

go

reconfigure;

go

sp_configure 'Ole Automation Procedures', 1;

go

reconfigure;

go

execute above code first. Then use this script, modify the script according to need like path. remove above code and...

Sure. @perry Whittle,

But what, if you have more than 50 or 100 databases or each database has multiple ldf & log files.

Will you write the query.

The script is...

Sure, Explanation is wrong -

You can understand this by below query :

CREATE TABLE mytable ( myid INT, mychar VARCHAR(10) );

GO

INSERT mytable

( myid,...

good question.

doubt on this question.

Review once again.. :-):-):-)

MMartin1 (10/31/2014)

---

Vimal Lohani (8/17/2014)

---

I didn't find any error with the code :

DECLARE @i TABLE( mychar VARCHAR(50)

,deriv as SUBSTRING(mychar,1,3) --Use this

,newderiv as left(mychar,3));--Or use this

INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')

, ('Sterling'),...

-7

Haha,

Steve, Is it fix.(Universal Truth)

+1

+1

What do you mean by correcting spelling mistakes and...

HAHA,

Still wrong answer

admin has not tested it.

Answer should be two rows.

OrderIDProductNameProductQty

1 ...

The answer is right for this kind of procedure :

CREATE PROCEDURE my_sp AS

SELECT id FROM my_table

The answer is Wrong for below procedure

CREATE PROCEDURE my_sp AS

SELECT Column FROM my_table