Answer Questions
MA Inayat selecting colunm with a space ''
When I submit a sql : select * from view from column='' the table is a view point to oracle table with ole db provider for oracle In mssql2000, the result return rows which containing a space ' ' However, in mssql2005, the result return no rows . Any advise on it Below is the statistics profile output in mssql2k and mssql2k5 respectively. Thanks a lot in Mssql2000 1057 1 SELECT * FROM [urbis_baso] ...Show All
KimberlyL SQL Agent Failing when trying to run my SSIS Package
I found a similar thread posted under the same title as this by dba123. Unfortunately, his solution does not match my problem. I have a SSIS package that will run fine in debug mode, will run fine when published to the server when I right click and execute it. However, when I run it through a job, either scheduled or running the job manually, the job fails. There is an entry in the servers application log telling me that "login failed fo ...Show All
Mark Kenworthy - MSFT Disable web connection in Microsoft Document Explorer
How do I disable Internet connectivity in the Microsoft Document Explorer - the help system Thanks, Tom Morris Use "Try local only, not online" option in Menu->Tools->Option->Online->When loading Help Content ...Show All
lslmustang Temporary tables
Hello, I have to import all the data from xml files (xml source) into temporary tables so that I can manage the data with sql statements (sql tasks). Then I created a sql task creating the temporary table (ie. Create table #temp ( a int)) followed by a data flow task. Into the data flow task I cannot see the temporary table from the sql server destination component. Any suggestion Thanks, Pierre Did you get to the bottom of this ...Show All
nkh8204 How to return varchar(MAX) from a CLR function?
Hi, I am trying to return [ string/SqlString ] from a CLR function, but it was truncated at 8000 characters. How can I solve this problem and return varchar(MAX) Thanks Thanks Adam, it works. Visual Studio deployment unfortunately has a lot of quirks. In case you're interested, I discuss another one in the following blog post: http://www.amazon.com/gp/plog/post.html/ref=cm_blog ...Show All
PeteDev1 Custom connection manager development sample?
Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class. TIA, Nitesh Hi Doug, I'm interested in the sample code, too. We plan to develop some custom connections. Thanks in advance. Fridtjof mailto:fw[at]team4[dot]de ...Show All
throne66957 Sync'ing a merge subscription before removal.
Hi, is there a way to ensure a merge subscription is synchronised before it is removed from the publisher using SMO - (it is a push subscription) I thought I had it as there is a MergeSynchronizationAgent object on the SubscriptionDatabase object, but calling Synchronize() on this throws an exception saying it can't contact the publisher. Any help would be really appreciated, thanks. Graham You sho ...Show All
RichardSw ForEach Loop utilisation
Hello, ForEach Loop Item allow to make operations row per row. How can i do operations 10 rows per 10 rows or 100 rows per 100 rows Thanks ! I want to make a request to yahoo stock quotes. In my database i have a list of quotes, and i want to get a page with a selection of quotes. look this example : http://fr.old.finance.yahoo.com/d/quotes.csv s=SLB.PA&f=snl1d1t1c1ohgv&e=.txt I can request up to 200 quo ...Show All
Nigel Watling Copy database from SQL Server 2000 to SQL Server 2005
I was trying to transfer a SQL Server 2000 database to SQL Server 2005 using SQL Server Objects Task. However, The following error message was encountered: "[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Cannot apply value null to property Login: Value cannot be null..".“ can anyone suggest me what is the error here Is there any other way possible to achieve this(tr ...Show All
Kaze Announcing SQL Server Everywhere Edition
Today we are announcing SQL Server Everywhere Edition, a light weight database designed for client applications that run from desktops to mobile devices. Pl see the section 'Dynamic Applications' in the Microsoft's Data Platform Vision and Roadmap from Paul Flessner, Sr VP, Microsoft. Microsoft’s Data Platform Vision and Roadmap: Your Data, Any Place, Any Time Microsoft’s Data Platform Vision and Roadmap: Your Data, Any Place, Any Time ...Show All
digitallyskilled01 Problem with plug-in algorithm in SQL Server 2005
Hi,all here, Could please anyone here help me for this problem My problem is: I have registered my plug-in algortihm with SQL Server 2005 analysis services, and I can see my plug-in algortihm added to the analysis service configuration file (msmdsrv.ini). But why I can not see my algorithm appearing in the list of algorithms when I tested it Really need help for that. Thanks a lot for any guidance and help. With best regards, You ...Show All
ASIAlewis Hello
Hello, I get the same error. I use sql server 2000, I added the account aspnet, but I always get the error and I'm not retriving any data from the database yet. Can anyone help me Thank you, Augusto What error are you talking about This forum is for .NET Integration in SQL Server 2005 that allows you to build stored procedures, functions, triggers etc. in .NET languages. You can try asp.net forums for your q ...Show All
pcaddict Merge Tables and FileGroups
Hey all For performance reasons i want to move the Merge Replication tables in a DB of mine (mainly MSMerge_Tomestone and MSMerge_Contents) to a seperate filegroup ... it's a heavy transactional DB and the index fragamentation rate is quite phenominal! The issue i've got however, is that when i try to transfer the table i get a warning saying that the current ANSI_PADDING / NULLS state is off in the current table, but will be switched on in the ...Show All
JariOjala Custom connection manager development sample?
Does anyone has code/sample/tutorial/pointer to developing custom connection manager with a custom UI. And then developing a custom task with a custom UI that can point to this custom connection manager... and passing values during runtime from UI to the custom class. TIA, Nitesh Hi DouglasL, Can you also send me those samples I am looking for ways to develop a custom connection manager in SSIS and the samples you mention would be extremel ...Show All
SADG!RL Convert, downsize, SQL Server database to Microsoft Access
. . . I know, WHY would I want to do this ! Well I like to develop databases in SQLServer, but there is a chance that when I transition this database to the client, they will only have Access at their disposal. Hence before I begin creating the database in SQL Server, I would like to know if it's easy to convert to Access should the need arise. Thank you in advance, Dan Regards. Why Access Convertion to SQL Server 2005 ...Show All