Answer Questions

• Ed209 Snapshot replication on-demand

  Hi, I have got a snapshot replication and have got distributor, publisher and subscriber on different servers all having sql server 2005. I am looking for a piece of code that i can execute in order to initialize snapshot with new data and push data to subscriber on demand. I assume there are TSQL calling replication sproc but i m not sure which proc should be used. any help would be highly appriciated. Thanks, Furrukh Baig If replication is all set up, and all the agent jobs are scheduled to run on demand, then just execute sp_start_job and pass in the name of the replication job. Hi, thanks to you all ... you guys are star ... while i have been bit lazy ;) Cheers, ...Show All

• Jim Sz Case conversion with SQL or Stored Proc

  Hi experts, I m new in SQL stuff. I have to work out a fucntion with ASP.net for CSV import to the DB in MSSQL. I would like to know for Stored Proc, is there any way that I can do the case conversion e.g the Full_Name read from CSV file: Lennon, John Then for the family name I need to convert into uppercase so the converted one: LENNON, John Is there any way I can check those words before the comma The CSV file is delimited with | instead of , Can I use substring for that And also do you have any online tutorial for Stored Procedure recommended Thanks a lot!!! Cheers, KNVB Hi, Here is an example: declare @fullName varchar ( 100 ) set @fullName = 'Lennon, J ...Show All

• BogN Dynamic DSN in Report

  I am creating a dynamic DSN in a report to pick which database to run a query against. I have a fairly simple expression, ="Data Source=MYSQLSERVER;Initial Catalog=ADV_" & Parameters!DBNum.Value When I try to preview the report, I get the following error An unexpected error occured while compling expressions. Native complier return value: '[BC32017] Comma, ')', or a valid expression continuation expected.'. I have also tried it without the parameter, ="Data Source=MYSQLSERVER;Initial Catalog=ADV_1" with the same result. When I use the exact same static DSN it works fine. Anyone have any idea what I might try to get it to work next R Found out that the ...Show All

• laja How to use SQL Svr 2005 Express in Excel 2003 VBA code?

  Hello, how can I use SQL Svr 2005 Express as database engine in background through VBA code in Excel 2003 I want to CREATE and DELETE tables and SELECT, INSERT and UPDATE data. Is it possible to use ADO or other database objects to get in contact with SQL Svr 2005 Express Thanks a lot. Christian Sorry, I was meaning ADO.NET 2.X not the old ADO. Yes, ADO is still supported... but... ADO 2.0 will take care of the new sophisticated features of SQL Server 2005 where ADO 1 doesn’t have a clue of, but at the end, ADO is still supported. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- This means VBA only supports ADO 1.0 ...Show All

• WXS123 GetDataDrivenSubscriptionProperties vs GetSubscriptionProperties

  Is there a similar method for Data Driven Subscriptions like there is for plain subscriptions ListSubscriptions. I would like to get SubscriptionID for use with the GetDataDrivenSubscriptionProperties just as I do for GetSubscriptionProperties. When I execute GetSubscriptionProperties for Data Driven Subscriptions there is no array of Subscriptions. Here is an examole of the code which I execute using rs.exe: Sub Main() 'Dim rs As New ReportingService() 'rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim DRPlan As DataRetrievalPlan Dim extSettings As ExtensionSettings Dim desc As String Dim active As ActiveState Dim status As String Dim eventType As String Dim matchData As Str ...Show All

• csname smtp test

  hi, would you know how to know if a connection can be established to an smtp server without even issuing any smtp command i want to be able to do this using ssis, script component. thanks. Not sure what are you refering to by saying without even issuing any SMTP Command... For sending emails through script - Check out https://blogs.conchango.com/jamiethomson/archive/2006/07/03/4176.aspx You can also try Send Email task @ http://msdn2.microsoft.com/en-us/library/ms142165.aspx Thanks, Loonysan Do you want to just check if you are able to ping SMTP server at port 25 before sending an email. May be evern after that kind of validation -you might have to still ...Show All

• Hughsieman Export To Excel Gives Me Gray Cells

  I have a report which was in RS 2003 and exported to Excel fine. Now when I export the same report using RS 2005 to Excel I get gray cells at the bottom of each table. I have the background of the body set to transparent. I have tried setting the background of the body to white and other colors. Those colors show up but the gray is still there as well. In preview mode and export to pdf I do not have those problems. Basically gray cells are showing up where they should not be. Any help would be great. I found a work around for this. Not sure of what is going on but I put a blank row about the table header row of the top most table. Set its height to minimum and made its background transparent and it clear ...Show All

• Lawrex how to fix report layout problems

  When you use Report designer in the BI development studio, on the Preview tab, you can have a straight preview or a print layout preview. I suppose what you see in the print layout preview is what you get when you print the report or export the report to the other format. However, often you see everything looks perfect in a straight preview but does look right in the print layout preview . For example, you might get the following problems in the print layout preview, even if everything looks perfect in a straight preview. · Every even page is a blank page · Items that should be together on the same page are separated into different pages. For example, on the first page, I had a TextBox1 followed by Image1 then foll ...Show All

• Alien72 how to do this in SSIS? soory if i m a noob

  Hi all, Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination. I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases): After 1st run, Source table has: 1 - 1000 records Destination table has: 1 - 1000 records For 2nd run, Source table has: 1 - 1500 records Destination table has: 1 - 1500 records How I insert only the 1001th record - 1500th record, without touching the 1st to 1000th record Secondly, if there are any changes in values in the records 1st to 1000th record, how to I compare and only update the value that has changed Is there any particular configuration setting in sql that I can use Many thanks for any help provided. ...Show All

• r0d dynamic archiving

  I need to set up a stored procedure or DTS that can export data to a text file - based on parametres passed when it's called. We have a scheduling server, where all our logging is stored and procedures are called. The data I need to export can be on diffierent servers in different databases. I started with the following: DECLARE -- @TableName varchar(128), -- @Filename varchar(200), -- @date_field varchar(20), @SQL varchar(2000) -- SET @TableName = SET @SQL = ''''+ 'bcp "SELECT * FROM '+@TableName + ' WHERE ' + @Date_Field+ ' > GETDATE()"'+ ' queryout "c:\test.txt" -c -q -U"sa" -P"" '+ '''' print @SQL -- set @SQL = 'EXEC master.dbo.xp_cmdshell ' + @SQL -- EXEC (@SQL) However, I'm ...Show All

• BradN What's the performance difference between WITH and a subquery?

  Hello Everyone, Does anyone know if there is a performance difference between the new WITH clause t-sql and the subquery On a basic functionality level, they seem to perform the same function but I was wondering if there are any performance difference between the 2 Thanks, Joseph What do you mean "new WITH clause" I suggest you write two example queries that are functionally equivalent, one using the WITH and the other the subquery. Use Northwind tables or just make something up that is easy to follow (like Book Authors or other things we all have a grasp of the relations between). Say... the set of books written by authors with "KING" in their name. SELECT * FROM [books] WHERE [author_ ...Show All

• Madhusudanan Migration to SQL Server 2k5

  Hi all, I have script written in SQL Server 2000. When i tried to migrate to SQL Server 2005, it is working fine in the SQL Server 2005 installed in Windows 2003 Server . System tables(syscolumns, sysobjects etc)are created in "Database->Tables->SystemTable". But when i tried to run in SQL Server 2005 installed in Windows XP , I'm facing the following problems. 1."The object 'CK_SavedSear_LastL_4B422AD5' is dependent on column'LastLoadedTime' "ALTER TABLE DROP COLUMN LastLoadedTime failed because one or more objects access this column" 2.Moreover none of the tables had been created in "Database->Tables->SystemTable". In both XP and 2003 Server, While installing, i ha ...Show All

• Pouyan connect dbase II in ssis

  I am having trouble connecting dbf of version dbase II. I can connect dbase III and dbase IV in ssis package,but can't connect dbase II.hope your help! liguancong wrote: I am having trouble connecting dbf of version dbase II. I can connect dbase III and dbase IV in ssis package,but can't connect dbase II.hope your help! have you tried saving the dbf as a version III or IV file who can help me MS does not support DBBase II with their solution (JET). See the supported versions listed here- How to use dBASE data with Access and Jet ( http://support.microsoft.com/kb/230125/en-us ) You will need to find a third-party driver, for ODBD, OLE-DB or ADO. ...Show All

• tviel how to use XML as report parameter

  Hi all, Is it possible to pass a xml as the value of a report parameter I have a stored procedure with a input parameter in xml type, and I use its output(still xml) as one column in the old report(asp.net). Now we plan to migrate all our reports to RS 2005, and use reportviewer to browse the reports. We encounter some problems on the report parameter,one of them is, we deployed a report and set the parameter in the web application like ReportParameter rp = new ReportParameter ( "Name" , "Tom" ); ReportViewer1.ServerReport.SetParameters( new ReportParameter [] { rp }); But an error occured and said no such a parameter had been defined in the report; then we set a parameter in the report with ...Show All

• I am Mats Trying subreports - does not work

  Hello colleagues, I have the following issue: I am trying to create a report with subreport this way: 1) create report 2) create subreport. Set parameter @AccountName in the SQL query (...WHERE account.name = @AccountName) and in the parameters collection - AccountName, data type string 3) place the subreport into the report and set parameters AcountID = =Fields!name.Value, so that the WHERE clause in the subreport should filter the content according to the field Fields!name.Value. So far, I suppose this should work. Nevertheless, I get this result in Visual Studio .net: An error occurred while executing the subreport ‘subreppp’: An error has occurred during report processing. Cannot read the next data row for the d ...Show All