Microsoft SQL Server 2005 RTM merge replication issues

We are trying to implement merge replication between 2 servers. Database size is around 11GB.

When I tried to create publication, snaphot agent is failing with following errror.

Error: 14151, Severity: 18, State: 1.
Replication-Replication Snapshot Subsystem: agent NBTENTSQL1X-PayDirectWeb-PayDirectPub-2 failed. The
replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
Exception Message: String or binary data would be truncated.
Cannot find the object 'MSmerge_sel_4D388

The table where the snapshot is breaking contains around 169 columns. Can someone please help me get through this error ?

Are you using vertical partitioning to replicate subset of the columns of the table? You may be hitting an known issue in Microsoft SQL Server 2005 where the list of column names for the table is longer than 4K and hence gets truncated in an internal proc.

|||

Thanks Sudarshan, your reply is very helpful. No we are not using vertical partitioning.

If this is a known issue, did Microsoft have any immediate fix for it or we have wait for SQL2K5 SP2 ?

|||Please wait for SQL2K5 SP2. You can install the latest CTPs availalbe and test out that your scenarios works. If not, please reply back and we can take a look further.|||This is a known issue in SQL2K5 SP1 which is fixed in SP2.|||Does the same limitation apply to the complexity of joined tables in the filter? I'm getting an error in the snapshot agent, saying:

String or

binary data would be truncated.

Cannot find

the object 'MSmerge_ctsv_2C675AF5938E4EA1B7D0DCFF9ECAD9EB', because it does not

exist or you do not have permission.

sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_upd_2C675AF5938E4EA1B7

But this only happens when I add too many joined tables to the filter section of the publication.

Dan

Microsoft SQL Server 2005 RTM merge replication issues

We are trying to implement merge replication between 2 servers. Database size is around 11GB.

When I tried to create publication, snaphot agent is failing with following errror.

Error: 14151, Severity: 18, State: 1.
Replication-Replication Snapshot Subsystem: agent NBTENTSQL1X-PayDirectWeb-PayDirectPub-2 failed. The
replication agent had encountered an exception.
Source: Replication
Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
Exception Message: String or binary data would be truncated.
Cannot find the object 'MSmerge_sel_4D388

The table where the snapshot is breaking contains around 169 columns. Can someone please help me get through this error ?

Are you using vertical partitioning to replicate subset of the columns of the table? You may be hitting an known issue in Microsoft SQL Server 2005 where the list of column names for the table is longer than 4K and hence gets truncated in an internal proc.

|||

Thanks Sudarshan, your reply is very helpful. No we are not using vertical partitioning.

If this is a known issue, did Microsoft have any immediate fix for it or we have wait for SQL2K5 SP2 ?

|||Please wait for SQL2K5 SP2. You can install the latest CTPs availalbe and test out that your scenarios works. If not, please reply back and we can take a look further.|||This is a known issue in SQL2K5 SP1 which is fixed in SP2.|||Does the same limitation apply to the complexity of joined tables in the filter? I'm getting an error in the snapshot agent, saying:

String or

binary data would be truncated.

Cannot find

the object 'MSmerge_ctsv_2C675AF5938E4EA1B7D0DCFF9ECAD9EB', because it does not

exist or you do not have permission.

sp_MS_marksystemobject:

Invalid object name '[dbo].[MSmerge_upd_2C675AF5938E4EA1B7

But this only happens when I add too many joined tables to the filter section of the publication.

Dan

Microsoft SQL Server 2005 - DB

What is the maximum number of DB that I can create? Infinite?
ThanksYou can create an infinite number of databases but you are limited to 32,767
per instance according to the Books Online topic Maximum Capacity
Specifications
(ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/13e95046-0e76-4604-b561-d1a74dd824d7.htm).

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Falivirdis" <nospam@.yahoo.itwrote in message
news:ed69ke$1s4i$1@.stargate1.inet.it...

Quote:

Originally Posted by

What is the maximum number of DB that I can create? Infinite?
Thanks

Microsoft SQL Server 2000 JDBC Driver issue

I was wondering if anybody has run into the following problem with ms's
jdbc driver. We're using cursors in our app - when we create a
java.sql.Statement object in the app, we're indicating that we want the
corresponding ResultSet object to have a TYPE_FORWARD_ONLY cursor.
We've noticed when we do this that if the app executes a query with
'UNION's in it, it never gets a ResultSet back from the server (I've
noticed on the SQL server profiler that it stays stuck doing the 'exec
sp_cursoropen' call). If we change the resultSetType to
TYPE_SCROLL_INSENSITIVE then the query returns in no time.
Any ideas?
Thanks.
--Yogesh
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
joe wrote:

> I was wondering if anybody has run into the following problem with ms's
> jdbc driver. We're using cursors in our app - when we create a
> java.sql.Statement object in the app, we're indicating that we want the
> corresponding ResultSet object to have a TYPE_FORWARD_ONLY cursor.
> We've noticed when we do this that if the app executes a query with
> 'UNION's in it, it never gets a ResultSet back from the server (I've
> noticed on the SQL server profiler that it stays stuck doing the 'exec
> sp_cursoropen' call). If we change the resultSetType to
> TYPE_SCROLL_INSENSITIVE then the query returns in no time.
If you can show an example of your code, it'll help.
If you do a trivial query like "select * from sysdatabases UNION select * from sysdatabases"
that hangs?
thanks
Joe

> Any ideas?
> Thanks.
> --Yogesh
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
sql

Microsoft SQL Server 2000 Desktop Engine

I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
computer. How do i create tables and stuff like I do in the standard versio
n
of SQL server? I tried connecting to it with enterprise manager but this
fails. Are you allowed to use enterprise manager with this product?
I created a dts package that deletes several database tables and reimports
the tables once a day. Ultimately I would like to run this package on this
new install of SQL desktop engine. Im not sure how to do this w/o enterprise
manager?
Any help would be greatly appreciated!-- Are you allowed to use enterprise manager with this product?
Yes the only limitation is that it is not shipped with MSDE, but it can be
used if you gotta licence from SQL Server.
Another program could be QALITE which can be downloaded for free.
--I tried connecting to it with enterprise manager but this
> fails.
This should work, what kind of error are you getting ?
Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
You can use dtsrun.exe from the commandline to run the package if you
stored it properly(for example in a structured storage file)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> computer. How do i create tables and stuff like I do in the standard
> version
> of SQL server? I tried connecting to it with enterprise manager but this
> fails. Are you allowed to use enterprise manager with this product?
> I created a dts package that deletes several database tables and reimports
> the tables once a day. Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
> Any help would be greatly appreciated!|||Thank you for your quick response and info - The QALITE program looks pretty
interesting - i have never heard of it before.
When I try to use enterprise manager. I am running it from my workstation
and am trying to register the machine that is using the desktop Engine - Whe
n
i try to do the registration it says the server either doesnt exist or i do
not have the right credentials. I am using the sa user name and the password
I gave it when i installed the desktop engine. Does enterprise manage have
to be run on the mackine that is using the desktop engine or is it the same
as a standard version of SQL server where u can manage it on a remote
workstation?
Is there anyway I can schedule my saved DTS package to run on the Desktop
Engine? I would like it to run every morning at 3AM?
"Jens Sü?meyer" wrote:

> -- Are you allowed to use enterprise manager with this product?
> Yes the only limitation is that it is not shipped with MSDE, but it can be
> used if you gotta licence from SQL Server.
> Another program could be QALITE which can be downloaded for free.
> --I tried connecting to it with enterprise manager but this
> This should work, what kind of error are you getting ?
> Ultimately I would like to run this package on this
> You can use dtsrun.exe from the commandline to run the package if you
> stored it properly(for example in a structured storage file)
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>
>

Microsoft SQL Server 2000 Desktop Engine

I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
computer. How do i create tables and stuff like I do in the standard version
of SQL server? I tried connecting to it with enterprise manager but this
fails. Are you allowed to use enterprise manager with this product?
I created a dts package that deletes several database tables and reimports
the tables once a day. Ultimately I would like to run this package on this
new install of SQL desktop engine. Im not sure how to do this w/o enterprise
manager?
Any help would be greatly appreciated!-- Are you allowed to use enterprise manager with this product?
Yes the only limitation is that it is not shipped with MSDE, but it can be
used if you gotta licence from SQL Server.
Another program could be QALITE which can be downloaded for free.
--I tried connecting to it with enterprise manager but this
> fails.
This should work, what kind of error are you getting ?
Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
You can use dtsrun.exe from the commandline to run the package if you
stored it properly(for example in a structured storage file)
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> computer. How do i create tables and stuff like I do in the standard
> version
> of SQL server? I tried connecting to it with enterprise manager but this
> fails. Are you allowed to use enterprise manager with this product?
> I created a dts package that deletes several database tables and reimports
> the tables once a day. Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
> Any help would be greatly appreciated!|||Thank you for your quick response and info - The QALITE program looks pretty
interesting - i have never heard of it before.
When I try to use enterprise manager. I am running it from my workstation
and am trying to register the machine that is using the desktop Engine - When
i try to do the registration it says the server either doesnt exist or i do
not have the right credentials. I am using the sa user name and the password
I gave it when i installed the desktop engine. Does enterprise manage have
to be run on the mackine that is using the desktop engine or is it the same
as a standard version of SQL server where u can manage it on a remote
workstation?
Is there anyway I can schedule my saved DTS package to run on the Desktop
Engine? I would like it to run every morning at 3AM?
"Jens Sü�meyer" wrote:
> -- Are you allowed to use enterprise manager with this product?
> Yes the only limitation is that it is not shipped with MSDE, but it can be
> used if you gotta licence from SQL Server.
> Another program could be QALITE which can be downloaded for free.
> --I tried connecting to it with enterprise manager but this
> > fails.
> This should work, what kind of error are you getting ?
> Ultimately I would like to run this package on this
> > new install of SQL desktop engine. Im not sure how to do this w/o
> > enterprise
> > manager?
> You can use dtsrun.exe from the commandline to run the package if you
> stored it properly(for example in a structured storage file)
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
> >I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> > computer. How do i create tables and stuff like I do in the standard
> > version
> > of SQL server? I tried connecting to it with enterprise manager but this
> > fails. Are you allowed to use enterprise manager with this product?
> >
> > I created a dts package that deletes several database tables and reimports
> > the tables once a day. Ultimately I would like to run this package on this
> > new install of SQL desktop engine. Im not sure how to do this w/o
> > enterprise
> > manager?
> >
> > Any help would be greatly appreciated!
>
>

Microsoft SQL Server 2000 Desktop Engine

I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
computer. How do i create tables and stuff like I do in the standard version
of SQL server? I tried connecting to it with enterprise manager but this
fails. Are you allowed to use enterprise manager with this product?
I created a dts package that deletes several database tables and reimports
the tables once a day. Ultimately I would like to run this package on this
new install of SQL desktop engine. Im not sure how to do this w/o enterprise
manager?
Any help would be greatly appreciated!
-- Are you allowed to use enterprise manager with this product?
Yes the only limitation is that it is not shipped with MSDE, but it can be
used if you gotta licence from SQL Server.
Another program could be QALITE which can be downloaded for free.
--I tried connecting to it with enterprise manager but this
> fails.
This should work, what kind of error are you getting ?
Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
You can use dtsrun.exe from the commandline to run the package if you
stored it properly(for example in a structured storage file)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>I have recently installed Microsoft SQL Server 2000 Desktop Engine on a
> computer. How do i create tables and stuff like I do in the standard
> version
> of SQL server? I tried connecting to it with enterprise manager but this
> fails. Are you allowed to use enterprise manager with this product?
> I created a dts package that deletes several database tables and reimports
> the tables once a day. Ultimately I would like to run this package on this
> new install of SQL desktop engine. Im not sure how to do this w/o
> enterprise
> manager?
> Any help would be greatly appreciated!
|||Thank you for your quick response and info - The QALITE program looks pretty
interesting - i have never heard of it before.
When I try to use enterprise manager. I am running it from my workstation
and am trying to register the machine that is using the desktop Engine - When
i try to do the registration it says the server either doesnt exist or i do
not have the right credentials. I am using the sa user name and the password
I gave it when i installed the desktop engine. Does enterprise manage have
to be run on the mackine that is using the desktop engine or is it the same
as a standard version of SQL server where u can manage it on a remote
workstation?
Is there anyway I can schedule my saved DTS package to run on the Desktop
Engine? I would like it to run every morning at 3AM?
"Jens Sü?meyer" wrote:

> -- Are you allowed to use enterprise manager with this product?
> Yes the only limitation is that it is not shipped with MSDE, but it can be
> used if you gotta licence from SQL Server.
> Another program could be QALITE which can be downloaded for free.
> --I tried connecting to it with enterprise manager but this
> This should work, what kind of error are you getting ?
> Ultimately I would like to run this package on this
> You can use dtsrun.exe from the commandline to run the package if you
> stored it properly(for example in a structured storage file)
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
> "PCL" <PCL@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:85CB0C41-377E-4A4D-8335-103A4AAE8488@.microsoft.com...
>
>
sql

Microsoft SQL isapi extension ERROR and SQLXML 3.0

Hi,

I'm using WinXP SP 2, IIS 5.1, SQL Server 2005 Standard, and Visual Studio 2005 Professional.

When I create a virtual directory with IIS Virtual Directory Management for SQLXML 3.0, I get a Microsoft SQL isapi extension error when going to the default page.

If I delete the virtual directory, and then add it directly in the IIS snap-in, with executable permissions, all goes well.

My website is from the Wrox book, Beginning ASP.NET 2.0. An appendix in the book says to add the virtual directory with the SQLXML 3.0 tool, and not to use IIS. I'm very new to this, so I'm not sure if I'll lose functionality down the road or not, by using IIS.

Has anyone run into this before or have any ideas how to get sqlxml 3.0 virt. dir's to work?

The error according to Microsoft support is related to permissions in SQL Server, I also found a FAQ from the SQLXML experts so you will find the answers to all your questions. Hope this helps.

http://support.microsoft.com/kb/820874

http://sqlxml.org/faqs.aspx?faq=79

microsoft sql database (*.mdf) using help ?

Hi

I use visual std. 2005 and I create a asp.net web page after >add item> sql database > I added my project *.mdf file when I make project my project is runnig with visual studio 2005 but I sent my hostting (internet server )I cant use this mdf file . Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .

Thanks

I know some hosts don't support SQL 2005, FastHosts in the UK for exampe have no plans to allow the user of the SQL Express MDF files so it cannot work like an Access MDB file. They say that this is down to performance and security implications.|||

prokurs:

Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .

No, you must have a SQL instance on the host to use mdf files. Although in VS2005 you can create mdf files and use them by attaching them to a SQL Express Instance (specified in the Data Source property in your connection string), you still need a SQL Instance to which you have access. So you must have a SQL2005/Express instance on the hosting machine, and then add proper permissions to your account.

|||

hi can you look my mistake this mistake's source ishttp://www.prokurs.com/e/loginana.aspx you can enter this page after write random user name and passwors after then I have got a this mistake please help ?

Server Error in '/' Application.

---

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

|||

It is a connection failure, if you're using SQL2000 you need to make sure TCP/IP and Named Pipes network libraries are enabled on the SQL2000 instance via Server Network Utility; in case of SQL2005/Express you can enable the remote connecitons using SQL Server Surface Area. Then rewrite your connection string to point to the correct SQL instance.

If you're using built-in Login Controls (membership provider) in .NET 2.0, you can customize the database connections as mentioned in this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

sql

Microsoft Reports

I am trying to create some reports in MS Visual Studio Express. Is there way to make report viewer or report templates available in Visual Studio Express ?

Hi,

Do you mean those express editions like Visual Web Developer, right?

Business Intelligence Development Studio is the environment that you will use to develop reports and report models in SQL Server 2005 Reporting Services. Business Intelligence Development Studio is theMicrosoft Visual Studio 2005 environment with enhancements that are specific to SQL Server 2005 business intelligence solutions.

Thanks.

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

Microsoft OLE DB Provider for SQL Server

Why do I get the following error each time I am trying to create a new datasource view " SQL server does not exist"......

Could you please provide more information?

Thank you

|||

Hi

thanx but i have managed to resolve the problem. Instead of typing local sever name i typed localhost.....

sql

Microsft Development Environment - Missing Toolbox Items

Hi,
I had some problems with the MDE application used to create reporting services reports, and rectified the problem by running the program with the command switch /resetskippkgs. Since doing this, my toolbox has lost all the controls used to design a reporting services report (e.g. Matrix, Table, Image etc).
Anyone know how I can get these back? I've tried doing a repair on the installation of the application, but no joy.
Thanks.
SimonRight-click in the toolbox, choose Add/Remove Items, and click the Reset
button.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:F7117049-4270-49A4-A9D0-08CDAB6D70A9@.microsoft.com...
> Hi,
> I had some problems with the MDE application used to create reporting
services reports, and rectified the problem by running the program with the
command switch /resetskippkgs. Since doing this, my toolbox has lost all
the controls used to design a reporting services report (e.g. Matrix, Table,
Image etc).
> Anyone know how I can get these back? I've tried doing a repair on the
installation of the application, but no joy.
> Thanks.
> Simon

Methods of #temp table creation.

Hello,
What is the difference between the two?
(a) Explicitly create a temp table using "create table #tableName...".
After it has been created, populate it using an explicit "insert into
#tableName".
Table creation and population of records take place in 2 t-sql statements.
(b) Let the #tableName get created on the fly when using a "select top 10
cid into #tableName from storesLink".
Table creation and population of records take place in a single t-sql
statement.
Both of them achieve the same result.
But, what is the difference in performance?
Are there any other points that I should keep in mind when adopting any of
the above two approaches ?
Cheers!
SQLCatzThe second one causes locking on some of the system tables and should
be avoided. Use the first one or better yet, use the table variable.
Aramid
On Wed, 6 Apr 2005 23:29:03 -0700, "SQLCatz"
<SQLCatz@.discussions.microsoft.com> wrote:
>Hello,
>What is the difference between the two?
>(a) Explicitly create a temp table using "create table #tableName...".
>After it has been created, populate it using an explicit "insert into
>#tableName".
>Table creation and population of records take place in 2 t-sql statements.
>(b) Let the #tableName get created on the fly when using a "select top 10
>cid into #tableName from storesLink".
>Table creation and population of records take place in a single t-sql
>statement.
>Both of them achieve the same result.
>But, what is the difference in performance?
>Are there any other points that I should keep in mind when adopting any of
>the above two approaches ?
>Cheers!
>SQLCatz
>|||they are about the same in performance if you don't have recompile. For
recompile info, see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;q243586
--
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:9FBD6D28-361B-460A-B47B-7CBD7DE86430@.microsoft.com...
> Hello,
> What is the difference between the two?
> (a) Explicitly create a temp table using "create table #tableName...".
> After it has been created, populate it using an explicit "insert into
> #tableName".
> Table creation and population of records take place in 2 t-sql statements.
> (b) Let the #tableName get created on the fly when using a "select top 10
> cid into #tableName from storesLink".
> Table creation and population of records take place in a single t-sql
> statement.
> Both of them achieve the same result.
> But, what is the difference in performance?
> Are there any other points that I should keep in mind when adopting any of
> the above two approaches ?
> Cheers!
> SQLCatz
>|||On Wed, 6 Apr 2005 23:29:03 -0700, SQLCatz wrote:
(snip)
>Are there any other points that I should keep in mind when adopting any of
>the above two approaches ?
Hi SQLCatz,
If you use CREATE TABLE, you can add constraints and indexes right away,
or you can chooose to add them after the INSERT. If you use SELECT INTO,
you can only add the constraints and indexes later.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Methods of #temp table creation.

Hello,
What is the difference between the two?
(a) Explicitly create a temp table using "create table #tableName...".
After it has been created, populate it using an explicit "insert into
#tableName".
Table creation and population of records take place in 2 t-sql statements.
(b) Let the #tableName get created on the fly when using a "select top 10
cid into #tableName from storesLink".
Table creation and population of records take place in a single t-sql
statement.
Both of them achieve the same result.
But, what is the difference in performance?
Are there any other points that I should keep in mind when adopting any of
the above two approaches ?
Cheers!
SQLCatz
The second one causes locking on some of the system tables and should
be avoided. Use the first one or better yet, use the table variable.
Aramid
On Wed, 6 Apr 2005 23:29:03 -0700, "SQLCatz"
<SQLCatz@.discussions.microsoft.com> wrote:

>Hello,
>What is the difference between the two?
>(a) Explicitly create a temp table using "create table #tableName...".
>After it has been created, populate it using an explicit "insert into
>#tableName".
>Table creation and population of records take place in 2 t-sql statements.
>(b) Let the #tableName get created on the fly when using a "select top 10
>cid into #tableName from storesLink".
>Table creation and population of records take place in a single t-sql
>statement.
>Both of them achieve the same result.
>But, what is the difference in performance?
>Are there any other points that I should keep in mind when adopting any of
>the above two approaches ?
>Cheers!
>SQLCatz
>
|||they are about the same in performance if you don't have recompile. For
recompile info, see:
http://support.microsoft.com/default...;en-us;q243586
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:9FBD6D28-361B-460A-B47B-7CBD7DE86430@.microsoft.com...
> Hello,
> What is the difference between the two?
> (a) Explicitly create a temp table using "create table #tableName...".
> After it has been created, populate it using an explicit "insert into
> #tableName".
> Table creation and population of records take place in 2 t-sql statements.
> (b) Let the #tableName get created on the fly when using a "select top 10
> cid into #tableName from storesLink".
> Table creation and population of records take place in a single t-sql
> statement.
> Both of them achieve the same result.
> But, what is the difference in performance?
> Are there any other points that I should keep in mind when adopting any of
> the above two approaches ?
> Cheers!
> SQLCatz
>
|||On Wed, 6 Apr 2005 23:29:03 -0700, SQLCatz wrote:
(snip)
>Are there any other points that I should keep in mind when adopting any of
>the above two approaches ?
Hi SQLCatz,
If you use CREATE TABLE, you can add constraints and indexes right away,
or you can chooose to add them after the INSERT. If you use SELECT INTO,
you can only add the constraints and indexes later.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

Methods of #temp table creation.

Hello,
What is the difference between the two?
(a) Explicitly create a temp table using "create table #tableName...".
After it has been created, populate it using an explicit "insert into
#tableName".
Table creation and population of records take place in 2 t-sql statements.
(b) Let the #tableName get created on the fly when using a "select top 10
cid into #tableName from storesLink".
Table creation and population of records take place in a single t-sql
statement.
Both of them achieve the same result.
But, what is the difference in performance?
Are there any other points that I should keep in mind when adopting any of
the above two approaches ?
Cheers!
SQLCatzThe second one causes locking on some of the system tables and should
be avoided. Use the first one or better yet, use the table variable.
Aramid
On Wed, 6 Apr 2005 23:29:03 -0700, "SQLCatz"
<SQLCatz@.discussions.microsoft.com> wrote:

>Hello,
>What is the difference between the two?
>(a) Explicitly create a temp table using "create table #tableName...".
>After it has been created, populate it using an explicit "insert into
>#tableName".
>Table creation and population of records take place in 2 t-sql statements.
>(b) Let the #tableName get created on the fly when using a "select top 10
>cid into #tableName from storesLink".
>Table creation and population of records take place in a single t-sql
>statement.
>Both of them achieve the same result.
>But, what is the difference in performance?
>Are there any other points that I should keep in mind when adopting any of
>the above two approaches ?
>Cheers!
>SQLCatz
>|||they are about the same in performance if you don't have recompile. For
recompile info, see:
http://support.microsoft.com/defaul...b;en-us;q243586
--
Wei Xiao [MSFT]
SQL Server Storage Engine Development
http://blogs.msdn.com/weix
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQLCatz" <SQLCatz@.discussions.microsoft.com> wrote in message
news:9FBD6D28-361B-460A-B47B-7CBD7DE86430@.microsoft.com...
> Hello,
> What is the difference between the two?
> (a) Explicitly create a temp table using "create table #tableName...".
> After it has been created, populate it using an explicit "insert into
> #tableName".
> Table creation and population of records take place in 2 t-sql statements.
> (b) Let the #tableName get created on the fly when using a "select top 10
> cid into #tableName from storesLink".
> Table creation and population of records take place in a single t-sql
> statement.
> Both of them achieve the same result.
> But, what is the difference in performance?
> Are there any other points that I should keep in mind when adopting any of
> the above two approaches ?
> Cheers!
> SQLCatz
>|||On Wed, 6 Apr 2005 23:29:03 -0700, SQLCatz wrote:
(snip)
>Are there any other points that I should keep in mind when adopting any of
>the above two approaches ?
Hi SQLCatz,
If you use CREATE TABLE, you can add constraints and indexes right away,
or you can chooose to add them after the INSERT. If you use SELECT INTO,
you can only add the constraints and indexes later.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Method of EnumJob()

I use the method of EnumJob() in order to create an DataGridView in Visual Studio to put in it all the jobs of a server with three of their propertes!

So I use three columns!In first Column I put the "Name",in the second the "Status" and in the third the "Last Execution".

I found from the "SQL Server Books Online" that their DataPropertyNames are Name,CurrentRunStatus and LAstRunDate.

I used them and only the DataPropertyName : "Name" works!!!!!

What am I doing Wrong?

I would appreciate if somebody could help me or give me an idea

Seems that this is not implemeted in the SMO classes, the appropate lines shows:

public DateTime LastRunDate

{

get

{

return (DateTime) base.Properties.GetValueWithNullReplacement("LastRunDate");

}

}

Perhaps you might query the system tables directly.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Meta Data Catalogue

I am wanting to set up some kind of metadata catalogue to manage
metadata records of the data we collect and create for my companies
clients.

I am thinking I want to do this using XML and SQL Server and have some
type of web-based browser to search for records.

Any suggestions on existing applications or resources that I could use?

ThanksHi

You may want to look at full text searching.

SQL 2005 has more XML functionality so check out the new features as it may
influence your plans.

John

"dharr" <darylh@.envisiontools.com> wrote in message
news:1123275095.936622.208720@.g44g2000cwa.googlegr oups.com...
>I am wanting to set up some kind of metadata catalogue to manage
> metadata records of the data we collect and create for my companies
> clients.
> I am thinking I want to do this using XML and SQL Server and have some
> type of web-based browser to search for records.
> Any suggestions on existing applications or resources that I could use?
>
> Thanks

Messages stuck in sys.transmission_queue

Hi,

At my company, we're trying to use service broker to create a client-server system where there is a head office machine and multiple outlets registered with that head office. My problem is that sometimes when a branch sends a message to the head office, it just seems to sit in the transmission queue and never gets sent. If I run a script that forcibly ends the conversations on the client machine (with cleanup), storing the message bodies and then resend them, they seem to get through fine.

The way that we send messages is by calling a t-sql stored procedure from a c# application using SqlCommand (don't know if this should make any difference).

If I monitor the Head Office machine and one of the Outlets while this is happening, on the HO I get three events in a row:

Broker: Message Classify (1 - Local) Audit Broker Conversation (2 - No Certificate) Broker: Message Undeliverable (1 - Sequenced Message)
The TextData contained in the third event is: This message could not be delivered because the security context could not be retrieved.

The RoleName of the server is Initiator, and the TargetUserName is the name of the service on the Outlet.

On the Outlet I get the following event repeatedly (presumably as it continues to try sending the message) - Broker: Remote Message Acknowledgement (1 - Message With Acknowledgement Sent).

On the client the RoleName also appears to be Initiator, and the TargetUserName is blank.

This would make me suspect that certificates were missing or something, except that if I remove messages from the queue and resend them they seem to get through, and also I've checked both databases and they have the correct certificates.

Any ideas?

Thanks in advance,

AdamThanks for the detailed info, it is always helpfull to have the full details when trying to diagnose an issue.
The most likely culprit in such cases is an account that has more certificates to be picked from when encrypting/signing a message. Whenever SSB has more than one certificates 'valid' to be used for a particular database principal, it will pick the one with the latest expiration date. So sometimes even though the configuration 'seems' correct, SSB will pick the 'wrong' certificate simply because it has multiple choices. The typical account prone to this problems is 'dbo', as certs are being created for dbo for various reasons and by default they are all valid for SSB to pick.
To confirm this problem, the 2nd event in your post (the Audit Broker Conversation one) actually tells which certificate was not found: it has the issuer name and serial number of the cert 'not found' on two of the columns (I can't remember now which ones and the BOL 'ommits' this detail). You can then look into the message sender's database to see why that particular cert was picked.
Certs can actualy be controled whether they are available for SSB to 'pick' by turning off the ACTIVE_FOR_BEGIN_DIALOG option on them (the option refers to certs used for the reverse path from target to initiator as well, despite the name 'begin_dalog'...)|||Thanks for the reply. What you're saying makes sense, and seems possible to me (we re-registered one of the outlets recently which could have caused this). The only problem is that the Audit Broker Conversation event doesn't appear to have the issuer or serial number in any of the columns. Maybe I'm using profiler wrong or something, but I would have thought that just selecting the event would have been enough. Any idea what I'm doing wrong?

Adam

|||

IssuerName is DBUserName and SerialNumber is in TargetLoginName.

Make sure the columns above are selected when defining the trace.

|||I had worked out that the IssuerName was DBUserName, but hadn't noticed the serial number. Thanks for explaining that. The thing is that the IssuerName isn't much use to me because the way I generated the certificates, they all have the same name .

But anyhow, I found a solution to the problem. Basically we had an old database on the same server that had broker enabled as well, and I'm guessing that since they both have the same service names in them, that was causing the problems. I disabled service broker on the old db and everything seems to be working again. The only thing I'm worried about now is how the broker became enabled on the database - but that's not really a service broker issue.

Thanks for the help.

Adam
|||

Whenever SSB finds multiple instances of the same service it assumes a load balancing scenario and will hash the incomming conversations to the available service instances. Specifying a broker_instance in the begin dialog from the initiator would make the application stick to a specific service (database), even if more instances of the service show up on the target.

Message Queue Task 64 bit Cluster issue

Hello,

I'm using the Message Queuing task to create a local private queue message. Everything works great on a 32 bit machine. When I try this on a 64 bit Itanium Cluster I keep getting the message "Message queue service is not available" in my SSIS log. I've using this string as my path "ClusterName\private$\QueueName". Does anyone know of any issues with the Message Queue task on 64 bit or a cluster? The Message Queue service is up and running, it doesn't make sense.

Thanks,

Andy

I found out that you must install MSMS on each node of the cluster separately. Then set up your Message Queue using the Cluster Administrator. See this document for help.

http://download.microsoft.com/download/4/f/5/4f518f76-c1ce-431b-b79f-71caf9e27578/MSMQ3incluster.doc

Also, it's easier if you use the utility mmcv.exe to set up the cluster:

http://support.microsoft.com/?kbid=898701&SD=tech

Andy