sqlhost Forum Rss Feed

New Post: Specifiy Table in Command Line Utility?

lizE — Mon, 21 Sep 2009 09:07:41 GMT

I quite agree , it would be helpful if you could use this tool to specfiy table names.Or even be able to run a query on select tables you like to script too. As well as having the option to script users and roles separately too.

New Post: SQLPUBWIZ store procedure error using view is created before trigger on view

vince144 — Mon, 18 May 2009 20:03:44 GMT

I used SQLPUBWIZ with the -schemaonly option which created the script without any errors. Now when I try to run the script it returns an error of:

Msg 4405, Level 16, State 1, Server MYSERVER, Procedure usp_CreateSomething, Line 25
View or function 'dbo.SomeView' is not updatable because the modification affects multiple base tables.

This is because the store procedure is using a view which has a trigger on it. The view is created before the store procedure (which is correct) but the trigger on the view is created much later than the store procedure. I had to cut and paste the store procedure and put it after the creation of the view trigger to get the script to function properly.

Is there another work around or fix for this as I am trying to automate the process of the script?

Thanks for any help in advance.

New Post: Errors pointing to browser to run runsql file

bbrooks — Wed, 29 Apr 2009 22:13:52 GMT

Hellllllp somebody...

I have been trying to run this runsql file on server and when i point to it from browser i get this error.

Opening url C:\inetpub\wwwroot\newClub.mdf.sql
Connecting to SQL Server database...
An error occured: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'objects', database 'mssqlsystemresource', schema 'sys'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer)

What do i do

New Post: Cannot find microsoft.sqlserver.batchparser

kinterry — Fri, 06 Feb 2009 03:37:21 GMT

Hello,

I am using sql 2005 express advanced edition under vista 64 bit, i cannot use as following error. Pls help.

TITLE: Microsoft SQL Server
------------------------------

This wizard will close because it encountered the following error:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server+Database+Publishing+Wizard&ProdVer=1.1.1.0&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

無法載入檔案或組件 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' 或其相依性的其中之一。系統找不到指定的檔案。 (Microsoft.SqlServer.ConnectionInfo)

------------------------------
BUTTONS:

OK
------------------------------

New Post: Version for SQL Server 2008 and VS 2008 ?

KlausObd — Fri, 06 Feb 2009 01:46:43 GMT

Hi,

is that tool also available for 2008-er Version of SQL Server and Visual Studio ?

best regards

Klaus

New Post: Internal error during begin publish

newwebmz — Thu, 29 Jan 2009 17:24:42 GMT

I just ran into this error last night when I tried to import my database into GoDaddy. My workaround, thank good ness worked.
Here's what I did:

> Created the database in GoDaddy.
> Using the DB Publishing Wizard, I selected the option to create a script instead of publishing it directly to GoDaddy.
> Logged in to my database in GoDaddy and using the query analyzer, ran the script that I had created from the previous step.

Hopefully that helps some of you all who are still having problems.

New Post: Internal error during begin publish

boizan — Wed, 28 Jan 2009 02:08:51 GMT

Jeremyk’s experience is very insightful, but in my case I can run Database Publishing Wizard from Visual Web Developer 2005 Express Edition, but after I paste the script file that it creates in Godaddy database, I publish the rest of the site and it does not work. It means you cannot have access to the protected pages. It gives an error when you try to log in or try to create a new user.

But now I believe that I am making a mistake.

Thanks,

307-1680 East 6th Avenue

Vancouver, BC V5N 1P3 Canada

(P) 604-879-0644

(F) 604-648-9369

New Post: Internal error during begin publish

jeremyk — Tue, 27 Jan 2009 23:47:06 GMT

I've been searching and searching for a resolution to this issue and never found one. I then thought that I could export my data from SQL Server 2005, which is what I use, and then import it since I couldn't get the publishing wizard to work. When I tried to do that I ran into some issues. I forgot that when I setup SQL Server I didn't install all of the components like SQL Server Agent, and Workstation, etc. Found out that in order to export data you need to have certain components install like integration servers, and I believe the workstation option. So, I uninstall SQL Server 2005 which came with it's own complications like manually stopping IIS Admin Services an Web Publishing services and then uninstalling the SQL Server Report Service. That won't uninstall unless you stop those services and delete two or three Report Services that get setup in IIS when you add the SQL Server Report Service. Microsoft has information on their site for uninstalling SQL Server 2005 and I recommend reading it first. It'll save hours of time. Anyways, once I reinstalled all of the available SQL Server components to be able to export data, clone a database, etc. I thought to myself that maybe that's what was preventing the publishing service from working. So I reinstalled the publishing service and set it back up with the information I got from godaddy (I.E. webservice, DB name, password, etc.) I tried it again and it worked. It would seem that if you don't have all of the proper services installed when you setup SQL Server then you won't be able to use the publishing service. This of course I learned after several days and many countless hours trying to figure crap out. I thought I'd post this to perhaps help someone else save that time and use the DPW (database publishing wizard). It really is a time saver.

New Post: Database Publishing Wizard to connect to Godaddy

boizan — Fri, 23 Jan 2009 04:21:47 GMT

I am using Database Publishing Wizard to transfer my site to Godaddy.com. When I select the option "Specify Server Information" and "Use Windows authentication." It never goes to the next step so I could pull out the website that contains the database. I get always the error:

TITLE: Database Publishing Wizard
------------------------------

Failed to connect to server localhost. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Can anyone help me to fix this problem?
I would appreciate very much your help.
Regards,
Boizan

New Post: Diagrams not scripted

fhtino — Fri, 09 Jan 2009 09:40:40 GMT

I have a DB with a diagram. Using Database Publishing wizard I was not able to "script" it. The generated script contains all the DB tables but not the diagram. Is there a way to "script" it?

Thank you

New Post: Internal error during begin publish

nester — Wed, 07 Jan 2009 09:38:00 GMT

Hi blacktops

You said you had a work around on publishing MDF with Godaddy.

Could you please explain more like what setup u talking about (godadddy database section?), step-by-step explanation would be nice.

I'm a newbie to aspx and godaddy as well, so hope you dont mind if i'm asking too much.

Thanks

New Post: Internal error during begin publish

blackops — Thu, 01 Jan 2009 18:52:16 GMT

I tried to generate the scripts but that didn't solve my problem. Once I created the structure for the data, I used the Right Click, Tasks, Import to import all of the data in the table. It worked but not flawlessly. It didn't import the Primary Keys as their number. It imported them incrementally which screwed up all of the relational data. Oh well. So eventually, instead of generating the scripts, I imported the entire database. This option leaves out primary keys, triggers, constraints, auto-increment fields, etc. So I had to go in and manually add all of those things.

I tell you what, it would be a hell of a lot easier if they would just let you upload the .mdb file and attach it. It would have saved days worth of work.

New Post: Internal error during begin publish

benives — Thu, 01 Jan 2009 15:00:08 GMT

I am using SQL Server 2005 Developer edition. I am able to make a connection to the database from SLQ Server Management Studio, but before I could I had to move my database to a different server at GoDaddy. Developer Edition is only 50 bucks and so well worth it for the features you don't get in the Express edition. However, I was previously using 2008 Express and I dearly miss IntelliSense and may upgrade to 2008 Developer Edition of SQL to get it.

Anyway, I gave up on the database publishing wizzard after GoDaddy's response to my support quesion was completely worthless. However I must say that I have been with GoDaddy for several years and am pretty happy with them.

So here is what I have done so far...

Connected to my database (mydatabase.db.2548868.hostedresource.com) remotely from MSSMS.
Right-clicked on mydatabase in Object Explorer and selected Tasks>Generate Scripts..., went throught the Script Wizard and it produced a nice script for me in the query window. Alternatively I could have saved the script to a file or to the clipboard.
Thats it...It made a beautiful script that I then ran against my existing database through the remote connection.

Now I will look into the best way of getting my data uploaded.

Oh and Happy New Year to everyone! I hope the world can get along better this year.

New Post: Internal error during begin publish

blackops — Thu, 01 Jan 2009 03:45:49 GMT

I found a work around because it looks like GoDaddy is having the same issue they had a few months ago. The publishing wizard server isn't connecting to the database. The work-around I came up with is during the setup. There is a new option in the databases that allows your database to be connected to from outside resources. I was able to connect my version of SQL Server Management Studio. The Express version can connect and can run scripts, but unfortunately, it cannot do imports/exports. This is because the import/export feature is available in the developer, standard and enterprise editions. I didn't want to wait for GoDaddy to fix it again because it took so long last time.

New Post: Internal error during begin publish

benives — Thu, 01 Jan 2009 03:38:00 GMT

I am having the exact same problem with server https://p3nmssqlpub.secureserver.net :

"Internal error during begin publish. (System.Web.Services)

Has anybody solved this problem?

New Post: Internal error during begin publish

jewelthief — Sat, 20 Dec 2008 18:43:51 GMT

I am facing same issue. my publishing wizard connection URL is provided as https://p3nmssqlpub.secureserver.net

New Post: Login errors when using DPW

daniel2078 — Tue, 09 Dec 2008 17:18:49 GMT

I've been trying to publish my MSSQL Db in godaddy site and when I tried the login with the user name and password that they gave it won't work. I have used all the logins and passwords that they gave me or I created (i.e.for the DB) none works

I called them and told me their server don't accept remorte connections and they web interface in not very friendly tried to import a CSV file and is only limited to 2.5 MB

I also noticed that they don't offer the option to attach the DB using the MDF files which would make my life easier.

I would appreciate any help or suggestions.

New Post: Internal error during cancel publish. (System.Web.Services)

Mark1234567 — Sat, 27 Sep 2008 06:09:34 GMT

I have been using the "MS Database Publishing Wizard" to remotely publish to my
SQL shared webhost (GoDaddy) since they don't allow connections.

Everything's been working fine for the last 3 months but now I have been
getting an error because of one table. It's the largest by far now (added
3000 rows of data last week):

Here it is:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblLanguageValues](
[AutoNumberID] [int] IDENTITY(1,1) NOT NULL,
[LanguageCode] [varchar](20) NOT NULL CONSTRAINT
[DF_tblLanguageValues_LanguageCode] DEFAULT ('EN-US'),
[LookupID] [int] NOT NULL,
[LanguageText] [nvarchar](4000) NOT NULL,
[ToDo] [bit] NULL,
[LastUpdatedBy] [nvarchar](200) NULL,
[LastUpdatedDateTime] [datetime] NULL CONSTRAINT
[DF_tblLanguageValues_LastUpdatedDateTime] DEFAULT (getdate()),
[Platform] [nvarchar](100) NULL CONSTRAINT [DF_tblLanguageValues_Platform]
DEFAULT (N'www'),
CONSTRAINT [PK_tblLanguageValues] PRIMARY KEY CLUSTERED
(
[LanguageCode] ASC,
[LookupID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =
OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

The error message that halts the publishing process when it gets to that
table is:

===================================

Internal error during cancel publish. (System.Web.Services)

------------------------------
Program Location:

   at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
   at
Microsoft.SqlServer.Tools.HostingServices.PublishService.CancelPublish()
   at
Microsoft.SqlServer.Management.SqlManagerUI.Scripting.PublishToWebWriterProvider.Dispose()
   at
Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptWriter.Dispose()
   at
Microsoft.SqlServer.Management.SqlManagerUI.Scripting.SingleScriptTarget.OnScriptingFinished(Object
source, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at
Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptProcessor.OnScriptingCompleted()
   at
Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptProcessor.GenerateScript()
   at
Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptingEngine.GenerateScript()
   at
Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptingDriver.GenerateScript()
   at
Microsoft.SqlServer.Management.SqlManagerUI.GenerateScriptMaker.DoScript()
   at Microsoft.SqlServer.Management.SqlManagerUI.GenScriptWizForm.Script()

Does anyone know why this would be happening? Also, if I exclude this table from the publish (un-tick it), the "MS Database Publishing Wizard" still tries to upload it and the same error has been occuring.

New Post: Database login string - help.

ollep — Mon, 08 Sep 2008 07:51:47 GMT

Backup Live Website without control panel?

We are hosting with Re-Invent.com, a DNN host that doesn’t allow Control Panel access. We are therefore left with an option of using the “Data Publishing Wizard” to access or server database.

Re-invent recommend this tool, but does not provide any support for it.

Are here anyone that can help me get the login string right?

You can view the entire problem here, including connection string from hosting provider and web – config file.

http://www.ollepersson.com/flash2008/sqlWizard.html

Any suggestions would be welcome!!

Cheers

Olle…

New Post: Service Install on 64bit 2003

Chrism720 — Tue, 22 Jul 2008 14:07:05 GMT

I am attempting to install the Database Publishing service on my internal SQL boxes I want to use the service to automate some database pushes. I am using the pre compiled install
and using default settings. Is there an easy way to not use SSL? this is going to be on an internal servers going through a dedicated point to point to my hosted servers.
Any help would be greatly appreciated.

C~