SQL Server Hosting Toolkit

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…

Created Issue: Object reference not set to an instance of an object. (SqlPubWiz)

chaliy — Mon, 04 Aug 2008 18:31:42 GMT

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

Object reference not set to an instance of an object. (SqlPubWiz)

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

at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptTableCommand.GetSqlDataType(Column column)
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptTableCommand.CheckSupportedType(Column column, ScriptingOptions options)
at Microsoft.SqlServer.Management.SqlManagerUI.Scripting.ScriptTableCommand.Script(Urn objectToScript, ScriptingOptions scriptOptions)
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()

-------------------------------------------
From .Net Reflector probably you do not support User Defined Types.
Do you guys use something like FxCop or ReSharper they help to remove such stupid issues. Anyway your public methods SHOULD check input, not sure how you will find issue root cause with this exception message.

Commented Issue: VS 2008

hfrmobile — Mon, 04 Aug 2008 14:49:39 GMT

How to Use Database Publishing Wizard with VS 2008?
I installed DPW but i don't see it in context menu of Server Explorer.
Comments: ** Comment from web user: hfrmobile **

I never used that context menu. Always used CommandLine to generate .sql files. But there seems problem with SQL 2008 ....?
VS 2008 .... SQL 2008 - never mind - I voted for it because an project member upgraded his machine to Server 2008 using SQL 2008 and now he is not able to use DPW .... :-|

Created Issue: VS 2008

realist — Sat, 02 Aug 2008 16:01:05 GMT

How to Use Database Publishing Wizard with VS 2008?
I installed DPW but i don't see it in context menu of Server Explorer.

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~

Commented Issue: Generated File has some deeper issues....

MToddSmith — Tue, 15 Jul 2008 19:21:36 GMT

Ok i don't really know how best to describe what's going on here but let me try.

I'm generating a .sql file and then using ANT to change the USE [DBNAME] value (which i manually add at this point).

The problem is that when i try to do this target:
<target name="sql-edit-schema-file" description="generates the file which creates tables, views etc">
<replaceregexp file="DB/MS SQL ${db.server.version}/boomsocket_MSSQL_${db.server.version}.sql"
match="\[[a-zA-Z0-1]{1,}\]"
replace="[${db.name}]"
flags="i" />
</target>

it keeps telling me that it can't find a match.

Now if i take the content of the generated file and put it into a new .sql file that i manually create and run the same ANT script it finds a match and process's as expected.

If I use TextPad to view the file and right click to view the "properties" the only difference i can see is that "file type" for the generated script is "unknown" and the "file type" for my manually created file says "PC". The other big difference is the SIZE of the file, the generated file is 1,951 KB and my file is 998 KB, this seems REALLY odd to me...

I've attached my manually created file so you can see the difference. I've noticed that EVERY generated file has the qualities mentioned above, regardless of the steps i take to create it.

I'm running this on a Windows XP Pro machine fully patched.

Eric
Comments: ** Comment from web user: MToddSmith **

I threw together the following app to solve this problem. The problem you're running into is that the file is unicode.

Usage: WriteHeader.exe [database name] [input file] [output file]

using System;
using System.Collections.Generic;
using System.Text;
using System.IO;

namespace WriteHeader
{
class Program
{
static void Main (string[] args)
{
StreamReader input = new StreamReader (args[1], Encoding.Unicode);
StreamWriter output = new StreamWriter (args[2], false, Encoding.Unicode);

output.WriteLine ("use " + args[0]);
output.WriteLine ("GO");
output.WriteLine ("");

string line = input.ReadLine ();
while (line != null)
{
output.WriteLine (line);
line = input.ReadLine ();
}

output.Flush ();
input.Close ();
output.Close ();
}
}
}

Commented Issue: Consistent scripting for subsequent script generations

hfrmobile — Tue, 15 Jul 2008 09:56:25 GMT

I am trying to use the scripts generated by your extremely useful tool to version control my DB schema.

However, there seems to be no consistency between subsequent script generations. For example, the ordering of the CREATE TABLE statements changes. This certainly hinders version comparison. I would greatly appreciate it if this issue could be addressed.

Thanks.
Comments: ** Comment from web user: hfrmobile **

Same "problem" still exists in version 1.1!

Another aspect: "INSERT ordering for in table FK" (http://www.codeplex.com/sqlhost/WorkItem/View.aspx?WorkItemId=15577)

Even it is not a very big problem I hope it will be fixed.

Commented Issue: INSERT ordering for in table FK

hfrmobile — Tue, 15 Jul 2008 09:51:26 GMT

Hello,

First of all, thanks for the tool!!! Great help, especially for the Generate Data option!

Wanted to tell you about something I found while working with the Generate Data functionality. I have a table with a reference to itself (think Employees table with a ManagerEmployeeID column that has a FK reference to another row in the same table). When it generated the INSERT scripts for my data, I found there were several items that were out of place and resulted in FK constraint errors.

I worked around it. Just used Query Analyzer to located the problem lines, and moved them to the bottom of the INSERT section for that table.

Would be nice to get this resolved if possible, but not critical.
Comments: ** Comment from web user: hfrmobile **

Same problem and same workaround too ;-)
Would be really nice to get this solved.

New Post: remote sql

navbingo20 — Sat, 12 Jul 2008 12:42:50 GMT

hi ,
i am new to this field..i am creating an e-commerce website. we are getting support for the sql server from the third party (not the host provider)..my coding works fine with the local host.. i am using visual studio 2005 , vb script , asp.net 2.0..
i am using two databases in my project....since , i am using the wizards(login) which are available in VS2005 ,asp.net 2.0...obviously , it creates its own database (aspnetdb)..i am using this database only for registration and login purposes ...it works fine with my local host--bcoz inbuilt sqlserver in vs2005 supports it , when i moved to the host provider they dont provide sql server.. so i could not able to execute the project.. when i was surfing in the net , i got this site and i downloaded the database publishing wizard.. i got the online query analyser from the third party .. as you said , i have just copied the whole text in the .sql file to the query textbox in the analyser... when i execute the code it showed me error...can anyone help me out to solve this issue...

email id : navbingo20@gmail.com
thanks in advance

error message: its very lengthy error.. i donnow how to sort out this issue ..plz help me out...
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.objects'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Membership_BasicAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Membership_FullAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Membership_ReportingAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Personalization_BasicAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Personalization_FullAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Personalization_ReportingAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Profile_BasicAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Profile_FullAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Profile_ReportingAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Roles_BasicAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Roles_FullAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_Roles_ReportingAccess'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near 'aspnet_WebEvent_FullAccess'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 4
Invalid object name 'sys.database_principals'.
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near 'ROLE'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.schemas'.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.aspnet_SchemaVersions'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.login1'.
Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near 'max'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.aspnet_Applications'.
Server: Msg 170, Level 15, State 1, Line 22
Line 22: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 14
Line 14: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.aspnet_Users'.
Server: Msg 170, Level 15, State 1, Line 28
Line 28: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.aspnet_Membership'.
Server: Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.aspnet_Roles'.
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles'.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near '('.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.views'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.objects'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.default_constraints'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 1, Line 2
Invalid object name 'sys.foreign_keys'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_CheckSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_ChangePasswordQuestionAndAnswer'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_CreateUser'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_FindUsersByEmail'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_FindUsersByName'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetAllUsers'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetNumberOfUsersOnline'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetNumberOfUsersOnline'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetPassword'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetPasswordWithFormat'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetUserByEmail'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetUserByEmail'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetUserByName'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetUserByName'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetUserByUserId'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_GetUserByUserId'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_ResetPassword'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_SetPassword'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_UnlockUser'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_UpdateUser'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Membership_UpdateUserInfo'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Paths_CreatePath'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Personalization_GetApplicationId'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAdministration_DeleteAllState'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAdministration_FindState'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAdministration_GetCountOfState'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAdministration_ResetSharedState'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAdministration_ResetUserState'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAllUsers_GetPageSettings'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAllUsers_ResetPageSettings'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationAllUsers_SetPageSettings'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationPerUser_GetPageSettings'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationPerUser_ResetPageSettings'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_PersonalizationPerUser_SetPageSettings'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Profile_DeleteInactiveProfiles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Profile_DeleteProfiles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Profile_GetNumberOfInactiveProfiles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Profile_GetProfiles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Profile_GetProperties'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Profile_SetProperties'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_RegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Roles_CreateRole'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Roles_DeleteRole'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Roles_GetAllRoles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Roles_RoleExists'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UnRegisterSchemaVersion'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_Users_DeleteUser'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_AddUsersToRoles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_FindUsersInRole'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_GetRolesForUser'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_GetRolesForUser'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_GetUsersInRoles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_IsUserInRole'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_IsUserInRole'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_UsersInRoles_RemoveUsersFromRoles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.aspnet_WebEvent_LogEvent'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Applications'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Applications'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Applications'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Applications'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_MembershipUsers'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Profiles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Roles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Users'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Users'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Users'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_Users'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_UsersInRoles'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_WebPartState_Paths'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_WebPartState_Shared'.
Server: Msg 208, Level 16, State 11, Line 1
Invalid object name 'dbo.vw_aspnet_WebPartState_User'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.database_principals'.

New Post: char data type to smalldatetime...out-of-range smalldatetime

fideleon — Mon, 30 Jun 2008 20:29:04 GMT

Hello,

I am using the database publisher to extract data as a bunch of insert statements from a database that is set to the United State region. I am running the generated tsql inserts on a machine set to Portugal and getting the following error reported:

failed: System.Data.SqlClient.SqlException : The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

The insert statements define the smalldatetime column values in a format like this "CAST(0x9A5B01A4 AS SmallDateTime)" so my original thought that "MM-DD-YYYY" was being misinterpreted as "DD-MM-YYYY" isn't correct.

You can test this on any machine, just create a table with a smalldatetime column, insert some data, extract (via Publishing wizer), change the regional settings to portugal, then run the insert statements.

Any idea on how to get around this? I am happy to do some search and replace of the insert statements.

Thanks

NEW POST: Internal error during begin publish

blackops — Mon, 02 Jun 2008 04:22:30 GMT

sounds like the same problem. It required me to keep sending them email several times. Give them a link to this site and see if that helps with anything.

NEW POST: Using Database Publishing Wizard

meamea — Mon, 02 Jun 2008 03:13:10 GMT

Hi, I get a similiar type error when I attempt to deploy a user defined function called "fn_diagramobjects" to my web-site hosted by GoDaddy. The error is:

"User-defined function fn_diagramobjects has the execution context ExecuteAsUser. Scripting user-defined function with the execution context ExecuteAsUser is not supported.(SqlPubWiz)"

I am using the "TheBeerHouse" as a base, and on my local machine this "user defined fucnction" works just fine. When I use the "Database Publishing Wizard" (DPW) I get the above listed error. So, in essence DPW is telling me I cannot deploy this user defined function called "fn_diagramobjects" (which I have not altered).
Does anyone have have a work around?

NEW POST: Internal error during begin publish

jayirvinh — Sun, 01 Jun 2008 22:18:26 GMT

I am having the same problem on www.godaddy.com windows hosting. My website publishing wizard connection test succeeds however the publish fails.

I have contacted godaddy support with no answer for several days.

CREATED ISSUE: Creating database users

cfguidry — Wed, 28 May 2008 20:58:42 GMT

There is a known issue that's listed as, "When scripting a source database, Database Publishing Wizard converts any users the database contains into roles, and where appropriate, schemas. This behavior occurs because Database Publishing Wizard does not script logins.".

I am wondering if this behavior is going to be changed? I'm in the process of automating the periodic rebuild of our development environment to match production, but I need database logins to be created.

Thanks!
Chris

NEW POST: Where is the source code?

hfrmobile — Wed, 30 Apr 2008 08:30:53 GMT

Open Source project without sources... Not a good idea...

Ok, it is a useful utility for developers but why do the authors host it here on a open source platform?

NEW POST: Where is the source code?

lashchev — Wed, 23 Apr 2008 00:11:09 GMT

rtonerii wrote:
I spent hours trying to read what I was doing wrong.

Same here.

NEW POST: Where is the source code?

rtonerii — Tue, 22 Apr 2008 12:34:41 GMT

I spent hours trying to read what I was doing wrong. Why don't they just say the code is not available.

NEW POST: Where is the source code?

lashchev — Mon, 21 Apr 2008 20:27:13 GMT

rtonerii wrote:
Are you sure?

As far as I know the code was never available.

NEW POST: Where is the source code?

rtonerii — Mon, 21 Apr 2008 11:37:27 GMT

Are you sure?
I would expect that I may just be doing something wrong.
I thought that the code was there but I just was not doing something right, I am new to codeplex.

Thanks
Rick