SqlCeReplication.HostName Size Limit Fix?

Jul 17, 2006

We are attempting to improve our merge replication process between our SQL Server 2005 server and SqlCe Mobile 3 client by switching to Data Partitions. We are using IIS as a proxy to SQL Server 2005 running on a different box using a DOMAIN account.

We've setup row filters to use HOST_NAME() and have set the option "Automatically define a partition and generate a snapshot if needed when a new Subscriber tries to synchronize" to true in the Data Partitions options under the publication's properties in SQL server management studio.

If I use a .HostName value of "1234", everything works fine. A subdirectory is created under a our publication's folder in the shared replication directory that relates to the host_name. Data is copied to the device and can be observed through query analyzer that the data is in fact filtered properly.

However, when using a .HostName based on the GetDeviceUniqueID (which results in '3D321F7212B2AD2CC824954662B9023441BB2D20'), replication works sometimes and sometimes fails with "The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have ben unable to create or write to the message file. [etc]". The final HRESULT is 80045017.

While this error indicates a permission problem, there were no permission problems when creating the "1234" partition. In researching the problem, I ran across KB905395 which states:
Limitations on the HostName property and the Subscriber-requested snapshotIf you try to initialize a SQL Server Mobile Edition subscription by using a filtered HostName property, initialization fails. This problem occurs when the value that is supplied for the HostName
property contains more than 12 characters. To work around this problem,
disable Subscriber-requested snapshot delivery at the Publisher. You
can also use a value for the HostName property that contains fewer than 12 characters.

====

This seems to be consistent with what we've observed (which actually led to the "1234" test). Does anyone know if a fix for this exists? Has anyone else run across this issue? I saw a previous post from March that did, but never got resolved. However, the KB article above was posted in March - hmmm...

This is an existing application and filtering based on the device's id is ingrained in the application. Changing it now would be large undertaking.

Regards,
Santino Lamberti
Senior Software Engineer
Launch Technologies, Inc.

View 5 Replies


ADVERTISEMENT

Database Row Size Limit

Sep 25, 2006

Hi, All,I came cross a problem like this.Cannot create a row of size which is greater than the allowable maximum of 8060  Is there any method to solve this ?  

View 1 Replies View Related

SQL Parameter Size Limit?...

May 28, 2008

Hey all --


Does anyone know if a sprocs parameter has a size limit? For example if you're passing in a XML document to a sproc - could that call fail based upon the size of the XML document? Consider memory a non-issue.

View 3 Replies View Related

Limit Table Size

Jul 30, 2006

Is there a way to limit a tables size in a database?

Davids Learning

View 4 Replies View Related

ErrorLog Size Limit

Sep 6, 2006

Hi.



I have a service on a server which contains Sql Server Express.

this service adds documents to the database to allow full text search features.

From some reason, the index crashes and than it writes to the ErrorLog file, the errorlog jumps to 20GB(!) causing the server to crash.

How can :

1. limit the size of the error log.

2. find out why the log jumps to this size (I can't open the error log file ofcourse...)



Thanks!

View 5 Replies View Related

Is There A Size Limit To This Cause Im Getting An Error That I Cant Figure Out

Mar 14, 2006

I create an sql string as so, add parameters to it and execute it:
string cmdstr = "INSERT INTO locations(id1, id2, companyname, address, city, province, postalcode, phonenumber, faxnumber, contact, contactemail) VALUES (@id1,@id2,@companyname,@address,@city,@province,@postalcode,@phonenumber,@faxnumber,@contact,@contactemail)";
SqlCommand sqlCmd = GetCommandSQL(cmdstr);
sqlCmd.CommandTimeout = TimeOut;
sqlCmd.Parameters.Add("@id1", SqlDbType.Int).Value = itID;
sqlCmd.Parameters.Add("@id2", SqlDbType.Int).Value = Convert.ToInt32(ddlDPCLocation.SelectedValue);
sqlCmd.Parameters.Add("@companyname", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbCompanyName")).Text;
sqlCmd.Parameters.Add("@address", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbAddress")).Text;
sqlCmd.Parameters.Add("@city", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbCity")).Text;
sqlCmd.Parameters.Add("@province", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbProvince")).Text;
sqlCmd.Parameters.Add("@postalcode", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbPostalCode")).Text;
sqlCmd.Parameters.Add("@phonenumber", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbPhoneNumber")).Text;
sqlCmd.Parameters.Add("@faxnumber", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbFaxNumber")).Text;
sqlCmd.Parameters.Add("@contact", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbContact")).Text;
sqlCmd.Parameters.Add("@contactemail", SqlDbType.VarChar).Value = ((TextBox)dvShippingInformation.FindControl("tbContactEmail")).Text;
sqlCmd.ExecuteNonQuery();
for testing purposes ive added the max text in each textbox area, so each textbox has 50 characters or so
and i get an error message as follows, when executing the query:
"System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
   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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at _default.InsertGKShippingLocation() in c:\Inetpub\wwwroot\cleanapp\default.aspx.cs:line 125
   at _default.InsertOrder() in c:\Inetpub\wwwroot\cleanapp\default.aspx.cs:line 93
   at _default.InsertandSend() in c:\Inetpub\wwwroot\cleanapp\default.aspx.cs:line 178"
Anybody have any ideas why this is happening

View 1 Replies View Related

Is Any Size Limit To 'query' In OPENQUERY

Mar 30, 2004

Hi,
in
OPENQUERY ( linked_server , 'query' )

is any size limit to 'query'

Thank you

Alex

View 1 Replies View Related

[Sql2000] How To Limit Table Size

Aug 28, 2006

hi all,I checked out in google groups but was not able to findthe answer...is it possible to limit size table in sql server?how can I do it?TIA

View 2 Replies View Related

What Happens When The 4 GB Database Size Limit Is Reached?

Jan 11, 2007

Does the user get an error message?

What error does an application get that tries to insert additional data via ODBC?

View 10 Replies View Related

Upper Limit On The Size Of The Database In Sql Server.

Apr 19, 2001

One of our database is approaching the gigabyte size. I know that microsoft claims to support terabyte databases with sql server 7.0. I was wondering if anyone could tell me about the max size of database they have used on an OLTP site without running into problems. ofcourse with SQL Server.

thanks,
rachna.

View 1 Replies View Related

At The End Of My Rope! Sql 6.5 On NT Type Size 255 Char Limit

Mar 27, 1999

I am so frustrated, I have upsized a data base from access to sql 6.5 and now had to clip data to fit into a 255 field? I have been looking for weeks to find a solution for this.

I am writing a discussion board very much like this one and need the message text to hold more than 255 chars. I have tried to create a table with a blob and text, The text will not allow me to specify the size when creating from a script (ASP) using create table. If I dont specify a size, it creates it as 16?

Been working on this for several weeks and cannot locate anyone that can answer this question, I want to create a column that will hold more than 255 chars.

IS there something in Sql 6.5 that I need to set to allow more than 255 on a text field? What am I doing wrong?

Please respond. Thank you.
Mike
(you can see this board here www.454ss.com)

View 2 Replies View Related

Limit On Row Size For Reading Fixed-width .txt?

Mar 8, 2005

Hi,

I have a customer who wants to send a fixed width file with 1400 characters per row.

Before I tell the 'OK', I was wondering if there is any limit to the length of rows when using a DTS .txt source.

Anyone know?

Thanks!

View 7 Replies View Related

SQL Server 2000 Standard .. DB Size Limit

Dec 29, 2003

Hi all.

On the MS website (at this URL: http://www.microsoft.com/sql/evaluation/overview/default.asp) it says that the Standard edition of SQL Server 2000 has a database size limit of 1,048,516 terabytes.

Talking to a friend, he tells me this is not true, and that it has a database size limit of 12gb.

Is Microsofts site incorrect, or is my friend lost?

Cheers! :-)

View 2 Replies View Related

File Size Limit / Offline Cache

Sep 26, 2006

Hi,

I have 2 questions:

Is there any way of getting around the 128MB file size limit when creating and adding SSEv databases to VS2005? Currently I get the following error when trying to connect to a database:"The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only...". This after I altered the app.config file to "...Max Database Size=600;..."
Have anyone tried to use SSEv to cache data with the use of the Smart Application Offline Building Block? Is there a provider I can use for doing this?

Thanks in advance!

View 1 Replies View Related

Limit File Size Of Subscription Reports

Mar 27, 2008



I have a report subscription this is generating PDF files. The end user of the PDF files requires these files to be below a certain threshold in file size. Is there any way to set up a subscription to generate files that are under the threshold size?

If I knew approximately how many records would generate a report below the threshold, is there a way to generate several reports all of which are below the threshold?
Thanks.

View 4 Replies View Related

Replication; What Is: SqlCeReplication.Subscriber?

Feb 24, 2006

I am tring to use SQL Server Mobile 2005 to subscribe to a SQL Server 2005 publication from a pocketPC. In my code I have a SqlCeReplication object. One of the properties that must be set is: Subscriber, but I have no idea what that should be set to. When I was setting up the publication I don't remember specifying anything like that, and the class description of this property doesn't help: "Specifies the name of the Subscriber". Any help will be appreciated.

View 3 Replies View Related

Exceeding SQL 2005 Express' 4GB Databse Size Limit...

Sep 5, 2006

Okay, I know the maximum size limit on a database in SQL 2005 Express is 4GB, but what happens when you exceed that limit? I can't seem to find much info on that topic. What kind of error return would you get from a stored procedure attempting to do an insert that will exceed the 4GB limitation? Also what factors go into that maximum size, factors that might not be completely obvious of course?

View 1 Replies View Related

Newbie - Sql Server 2000 Transaction Log Size Limit

Jan 12, 2004

Has anybody encountered a physical size limit for a sql server 2000 transaction log running on win2k?

Transaction log reached ~6Gb before rolling back the delete stating transaction log was full. There was 42Gb free on the server and the log was set to unlimited growth.

View 3 Replies View Related

Size Limit On CLR Extension User Defined Types

Jun 10, 2006



Why is there a limit of 8000 bytes on CLR Extension user defined types in SQl Server 2005?

We now have varchar(max), varbinary(max) and XML data types that are unlimited in size, byt UDT's are limited to 8000 bytes!.

This limitation is ruining a key project of mine!

Any ideas that MS may lift this limit?

Regards



Derek

View 3 Replies View Related

Size Limit For Dataset Query In Report Designer

Sep 16, 2007

I was working on the SSRS Report Designer and was trying to copy and paste a huge SQL query from SQL Management Studio (like I always do) to the dataset window.

This method usually works, but for this extremely long SQL query with nested SELECTs and JOINs, it seems as though the Report Designer dataset query window limits the number of characters including carriage returns I can input in it.

When I paste my SQL query from SQL Management Studio, it seems to paste only three quarters of the query, and thereafter I am not able to manually key in anything else or even make a line feed in the dataset query window.

Is there a limit to the number of characters I can key in here ? If so, is there any workarounds or configurations I can try ?

Kenny

View 11 Replies View Related

SQL Server 2008 :: DBmail HTML Body Size Limit

Nov 4, 2015

When sending an email in HTML format, shouldn't this allow for 2gb of data? Mine is getting truncated after 4000 characters.

@body NVARCHAR(MAX) = NULL,

EXEC msdb.dbo.sp_send_dbmail
@recipients='someone@some.com',
@reply_to='someone'
@from_address='someone@here.com>',
@profile_name = 'profilename',
@body_format = 'HTML',
@body = 'lots of data'

View 2 Replies View Related

SQL Express-solving 4GB Size Limit By Multiple Database Files?

Nov 19, 2006

Hi,I am new to SQL express and try to solve the 4GB size limitation.Is there a possibility to create a new database file every time I getto the limit?How can I do that with C#? how can I create new database file everytime it gets full?Can I be connected to two database files at the same time (the full dband the new db)?thanks in advance,oren

View 1 Replies View Related

Do Stored Procedures Have A Limit On Number Of Parameters Or Byte Size Passed In?

Nov 21, 2007

Hi,I'm using c# with a tableadapter to call stored procedures. I'm running into a problem where if I have over a certain byte size or number of parameters being passed into my stored proc I get an exception that reads: "Cannot evaluate expression because a thread is stopped at a point where garbage collection is impossible, possibly because the code is optimized." If I remove one parameter, the problem goes away. Has anyone run into this before? Thanks,Mark  

View 3 Replies View Related

VERY Wide Rows, 8060 Bytes Row Size Limit && SPARSE Columns

Apr 23, 2008

Hi,
I€™m trying to create a VERY wide table, with 1,000 columns of type varchar(MAX), nullable.
The CREATE TABLE statement (both in SQL 2005 & 2008), gives the following warning:


Warning: The table "WIDE_TABLE" has been created, but its maximum row size exceeds the allowed maximum of 8060 bytes. INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit.

When I insert data into the table, filling all columns with small, 10-byte string values, I get the following error:

Msg 50000, Level 16, State 1, Procedure sp_pivot, Line 118

Cannot create a row of size 15034 which is greater than the allowable maximum of 8060.

I€™d like to verify this observation: each row is created with 2000 bytes of offset data (2 byte * 1000 columns), 125 bytes for null bitmap (1000 columns / 8 bits) and some more €śwasted€? row information. This leaves less than 6K for the data itself. But since not all columns can fit within the page, forwarding pointers in the row need to be created, 24 byte per column, which very quickly add up to more than 8K, thus the error. So the 8K limit is met for much less columns than the max 1024 column restriction.

Furthermore, in SQL 2008, SPARSE columns will not solve the problem (maybe save some €śmetadata€? space in case the columns are null, but if not, I€™m with the same problem again, or even worse, since now each value takes more storage space. The max 30,000 columns in 2008 is only for cases where the column values are really sparse€¦

Is this the right observation? if so, is there a workaround besides splitting to multiple tables?

Thanks,

Aviv.

View 7 Replies View Related

Limit On SSIS String Variable Size, Trying To Get Big Xml File Into Xml Data Field

Nov 28, 2007

I have a SSIS package that opens an xml file, puts the contents into a string, then runs a stored procedure that dumps it into an xml column in a table. One of the xml files is huge. Putting the data into a ssis string causes an error. The length of the string variable is 58,231,886. The file will only get bigger.

How else can I get this data into a SQL Server XML field.

View 1 Replies View Related

DB File Size Limit With SQLServer 2000 In Small Business Server 2000

Mar 15, 2006

Thanks in advance. What is maximum SQL Server database (*.mdf) file size with SQL Server 2000 as part of Microsoft Small Business Server 2000? (Database files were limited to 10 GB in SBS 4.5 with SQLServer 7.0... has this changed?).

View 1 Replies View Related

SQL 2005 Resize Initial Log Size: MODIFY FILE Failed. Specified Size Is Less Than Current Size.

Sep 4, 2007


I am trying to resize a database initial log file from 500M to 2M. I€™m using€?

ALTER DATABASE <DBNAME> MODIFY FILE ( NAME = <DBLOGFILENAME, SIZE = 2 ) "



And I'm getting "MODIFY FILE failed. Specified size is less than current size." I tried going into the database properties and setting the log file to 2M, but it doesn€™t keep the changes.



Any help with this process?

View 1 Replies View Related

How To Get Hostname

Sep 3, 2004

We are using sql server 2000

Problem:
========
A few records in a particular table are getting updated with incorrect values everyday somehow by some process. No one is manually changing these records.
Every morning I query the database and fix these records. But somehow they again get set to the incorrect values.

So I want to figure out how this is happening. I'm thinking of creating an update trigger on that table. And whenever this update trigger is fired, check the modified record's id and if it is the problematic record, then get the hostname, username, processid which is doing this update.

Can someone give me ideas on how to get the hostname, username.

Any other ideas are also appreciated

Thanks in Advance!

View 2 Replies View Related

Hostname

Sep 27, 2001

Hi everyone,

ON SQL 7.0

I want to capture hostname of the client computer making changes to a table on the server. I tried to use sysprocesses table, but the max(last_batch) column is giving the datetime and hostname of previously ran query. I need to find the hostname of the client who is making change at that instant of time.

Can anyone help me.

Thanks

sekhar

View 4 Replies View Related

Hostname

Jun 18, 2008

Hi,

Question:
How do I get the hostname from the instance name please?

My present design at present is something as follows:

We have several sql server 2005 machines
i.e.
ServerSQLA, ServerSQLB, etc....

Each machine may have one or more instances,
i.e.
ServerSQLAinstace1
ServerSQLAinstace2, etc...

The server name in this case is ServerSQLA

Instance naming and node convention is different for clusters

i.e.
C_ServerSQLAinstance1
C_ServerSQLAinstance2

on the node(s):
N_ServerSQLA or N_ServerSQLB


Thanks

View 6 Replies View Related

Use Of Hostname

Sep 9, 2007

Hello

Can anyone explain how HOSTNAME works?

I have problem with identitys when subscriptions uploads new inserted data, I need somehow create a partitions for each user. All user need exactly the same data (now 10 user but in future about 100 users).

In the database is 116 tables and still growing. Because this is a project i working with.

My system is a one Server, one publication and server is acting as its own distibutor, and multi users

I have really problems with conflicts plz somebody help

View 1 Replies View Related

How To Get Hostname Via SQL Command?

May 21, 2004

Hi!

Can something tell me how I can obtain the machine name (either IP address or DNS name) on which SQL Server is running via a SQL query?

select @@version returns a lot of useful information, however it doesn't return the host name.

thanks in advance
- Garry

View 8 Replies View Related

HostName And ReinitializeSubscription

Apr 28, 2006

Hello all,

I'm having trouble with my Merge Replication setup in regards to changing the HostName property of the SqlCeReplication object. As we all know, if you modify the HostName value, you must then call the ReinitializeSubscription(true) method before calling Synchronize(). Unfortunately, this isn't working for me. Following this sequence of steps consistently results in error messages saying that I need to either call ReinitializeSubscription, or change my HostName back to it's original value. Has anyone ever experienced this problem?

Regards,

Rob Tiffany

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved