running sql script from text file - Support Queries

Welcome Guest

Search | Active Topics | Members | Log In | Register

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » running sql script from text file

running sql script from text file

Options · View

Previous Topic · Next Topic

deccks

Posted: Thursday, April 22, 2010 4:31:51 AM

Rank: Newbie
Groups: Member

Joined: 4/22/2010
Posts: 2
Points: 6
Location: USA

I have tried using the Tools section of myLittleAdmin by clicking the folder icon in the New Query page and it does not work when I run the script. I used the sqlcmd command line from a remote location and running the script worked that way. Is there something I have to do in order to run the script from myLittleAdmin?

elian

Posted: Thursday, April 22, 2010 5:59:53 AM

Rank: Administration
Groups: Administration

Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France

Which version of myLittleAdmin are you using?
Do you have an error?
What kind of script is it?

deccks

Posted: Thursday, April 22, 2010 5:21:29 PM

Rank: Newbie
Groups: Member

Joined: 4/22/2010
Posts: 2
Points: 6
Location: USA

It is version 3.5 and it is a 2005 MS SQL script created from Visual Web Developer using the Publishing Wizard. I created a database using this script from the sqlcmd command prompt for a website I tested and now it is going into production for a client. I am trying to help them run the script but the script does not create all the tables when running it through myLittleAdmin at their hosting provider.

Users browsing this topic

Guest

myLittleTools Community Forum » myLittleAdmin For SQL Server (2005, 2008, 2012) » Support Queries » running sql script from text file

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.