Answer Questions

• alexgr Unable to retrieve Column information when using Ole Db Provider for sybase

  Hi All, I am in process of transfering data from Sybase to Sql Server using SSIS 2005 have taken a Data Flow Task in Control Flow tab In Data flow tab, I have taken one Ole DB Source and One OLe DB Destination For the source, I am using Sybase Adaptive Server Anywhere Provider 8.0 For Destination, I am using Sql Server 2005 database In Ole Db Source Editor , For OLe Db Connection Manager, I choose Sybase Connection For Data ...Show All

• Lewis Yeung Deployment 'utility' script using sqlcmd

  Hi all, I'm looking at creating a sample utility script that will invoking scripts to deploy some SQL code. For example, a utlity script that will run a SQL script, and on successful completion, execute the next script. Having not used SQLCMD at all before, and being very new to SQL2005 (< 1 month) please guide me if there is a better way of invoking this... For example, a way of avoiding the xp_cmdshell invocation! The fol ...Show All

• rogueAgent SQL Server 2005, Parameterized Filter: Snapshot could not be applied

  Hi My merge replication (over Web) has been working fine. But since two days, I've got the following error: If I'd like to reinitialize a subscriber or add a new subscriber, the following occures (on the client side): Client connects to the (Web) server All the snapshot files are loaded down to the client The client tries to apply the snapshot (to a blank database), but then, the following error occures: (Translation from German) Microsoft SQL ...Show All

• LitePipe Deployment overwrites partitions

  When I deploy to Analysis Services 2005 from BI Studio, it prompts me that 'Deployment will overwrite existing objects' and when they are deployed, it appears that certain partitions are lost. How can I deploy while retaining existing data   ...Show All

• Derek.Zhang How to truncate the log file

  How do I truncate the log file using TSQL   My client's log file is 44 gig and there isn't enough HD space.  Thanks The log will truncate if 1) simple recovery mode is set and 2) checkpoint is issued or the log is backed up. Otherwise, you need to truncate it every now and then manually. Try this: DBCC SHRINKFILE('mastlog'); The preceding truncates the master DB log file. 'mastlog' referes to ...Show All

• szzhouke Problem: Deployment works, but processing does not

  Hi, I am working with the 'Using SQL Server Data Mining" book, and am trying to deploy and process the 'MovieClick' example in chapter 3. Here is my problem: I am able to create the Data source, the source view, the data mining structure and data mining models (Decision trees and Bayes). When I select 'Buil - Deploy solution' all scripts are successfully deployed to the server, but once the processing start the application nothing happen ...Show All

• Orang Pemalang Column Grand Totals

  Is there a slick way to add grand totals to my report so far, in my report table I have the following sections TableHeader1 TableHeader2 Group1 Footer1 I added one of the same fields from my Group1 to Footer1....but it's not summing correctly. I have this in my footer right below one of my Group Fields: =SUM(Round(((Fields!FeeGoal_AZ.Value) / Fields!FeeSchedule.Value) * 100)) totals are accurate...I just needed ...Show All

• dlykins sql transaction

  I have created three stored procedures. Each one has a begin transaction and commit transaction and in the begin catch statement it has rollback transaction. i.e. create procedure sp1 as begin try begin transaction insert into table1(field1) values('field1') insert into table2(field2) values('field2') end transaction end try begin catch rollback transaction end catch -------------------------------- create procedure sp2 as ...Show All

• DialogDude Shared Memory Provider, error: 0 - No process is on the other end of the pipe

  If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless conn ...Show All

• m.singh server problem occurred during deployment of vb.net application with MSSQL db

  I use .net 2005 and server, the application i developed connects to a locally hosted mssql db, I want to deploy the application together with the db to client machine. when i installed the application on the target machine, and run the application, it gave me this message : "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 set ...Show All

• ddaaddoo Diffrence Between Varchar and NVarChar

  I was just wondering what the diffrences are between NVARCHAR and VARCHAR When do I use NVARCHAR as opposed to VARCHAR Thanks, Matthew Unicode (nvarchar) has the capability to store characters from all languages, while varchar typically uses a local code page and can only use local characters. SQL Server uses 2 bytes per character for n-type text columns, while the not-n-type columns use 1 (at least for latin-based languages). Most of th ...Show All

• SteveWitz Obtaining TCP/IP Port and Pipe name

  Hello All, Does anyone know how to obtain the TCP/IP port and the pipe name for an instance I would have expected to see these properties in smo.server.configuration or smo.server.settings. What am I missing here Thanks Rob You will need DMO for this (see Registry object), as the SMO only supports SQL Server 2005 instances. Hi Michiel, Thanks for your help. Basically, I'm attempting to ...Show All

• SlayerGatsu AdjustTokenPrivileges Error?

  Hi, I have created two packages.. a child package and a main package that is responsable by executing all his childs in a specific order... What start happening is that the child when executed alone is ok, but the the main package executes it... then i get a DOS Windows saying "AdjustTokenPrivileges () Failed (00000514)" What can be causing this I haven't changed anything and the package was executing right some days ago... ...Show All

• Christopher Crooker convert millisecond to "hh:mm:ss" format

  Hello guys, I have a column of integer data type that contains a millisecond data(for example 54013). I want to convert this value to the corresponding "hh:mm:ss" format. Can anybody help me with this issue Sincerely, amde How about this declare @SomeMilliSecondsNumber bigint select @SomeMilliSecondsNumber =54013 select convert(varchar,dateadd(ms,@SomeMilliSecondsNumber,0),114) ...Show All

• majkeli How to quickly evaluate SSIS, programmer perspective

  SSIS looks interesting .  I haven't loaded any Yukon or read the 2005 BOL, so I'm coming in with a clean slate. In the past I have found the graphical programming interface for DTS, limiting, annoying and unnatural.  I much prefer coding in an OO language the conventional way. I'm interested in evaluating SSIS as quickly as I can.  The ideal is programming with a standard .NET language.  I am happy if a de ...Show All