Answer Questions

• Syed Atheeque Pasha Dynamic loading of a file

  I've been told by Kirk that it is possible to load a file whose metadata is unknown at design-time by using bulk insert along with a file (not a flat file) connection. He didn't elaborate though. Can anyone explain -Jamie Very nice. This is always the fallback for everything, but not everyone wants to do it. Now you've gone and done it. Cool! If you have a metadata file, something that describes the metadata for a set of flatf ...Show All

• Dude987 Stored proc & transaction log size problems!!!!!

  For some reason, my stored procedure which is kicked off by VB.NET is growing the log file for the database in question by gigs, very fast. Why is it doing this The code: Sub Main() objConn.Open() Dim cmdSql As New SqlClient.SqlCommand("IT_sss_Collector_D otNet", objConn) cmdSql.CommandType = CommandType.StoredProcedure cmdSql.CommandTimeout = 1000 Dim reader As SqlDataReader = cmdSql.ExecuteReader() Dim ppa_rowcou ...Show All

• Amit Bhargava Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Hi All, Setting delayvalidation to true does not seem to help, I have a foreach loop for all the excel files, then a forech loop for the sheet names, how do I assign the variables to th ...Show All

• Dave Heinemann Report performance issue - time in processing

  I'm having performance issues with a report which is taking nearly 22 minutes to return 2100 rows. I've queried the execution log tables and the Time in Processing accounts for more than 99% of this. The report is applying cell formatting using a coded function to retrieve formatting from a stylesheet which hasn't proved problematic so far with other reports, and has several levels of grouping in a single table with sub-totals for each group ...Show All

• tamc1993 User-Defined Datatypes based on abstract classes

  I am trying to create a set of spatial datatypes for SQL Server 2005. Each datatype inherit from the abstract class "Geometry". ie.   public class Point : Geometry   public class Line : Geometry   public class Polygon : Geometry ...and several more. The reason for using the abstract class Geometry, is that they all share a common set of functions that return a Geometry object. For instance   Geometry Intersection(Geometry g1, ...Show All

• ChR Ignoring Source Field

  Hi, I am implementing a Transactional Replication btwn two SQL 2000 servers, which is using Data Transform services (DTS package) to manipulate the data. I need to ignore a source column from replication but that column field value needs to be appended with other field column. For ex. Let two source fields be named FirstName and LastName. In the target database i need to merge those field values into a Single field called Cus ...Show All

• Chicho Mendelevio compatability level

  i restored couple of databases from 2000 onto 2005. Should i change the compatability level of these databases to 90 Would it help/harm If your application has no issues with working against a SQL Server 2005 database I would definitely change the compatibility level to 90. This enables you to fully use the benefits of SQL Server 2005. Make sure you run the databases through the Upgrade Advisor first. ...Show All

• majid12345 Subreport Not Showing Properly

  Yet again, another question. Hopefully I'll get a reply on this one. I have a nested subreport that I am having difficulty viewing in both the parent and 2nd levels of the report structure. There are 3 levels. The parent, child, and sub-child (of which the child is the parent). I cannot get the sub-child report to view from within the child report. I read in a previous post that clicking View Report forces a retrieval of parameters, and ...Show All

• MGM54 differential database backup query

  Hi, I'm not 100% sure if my problem can be fixed but any help would be grateful, what I'm trying to do is discover what data in Great Plains is getting held in what tables in sql server. My idea was to take a back up of the current database, add a record and then compare the back up to the current system and get the differences. Does anyone know if this can be done. Thanks in advance. Jim You can try to run a trace on the GreatP ...Show All

• shmp2005 ALTER TABLE MODIFY

  hi! i encountered problems when running this code in SQL Query ALTER TABLE [dbo].[amsSchedule] MODIFY(CutOff1 datetime NULL, [FileName] varchar(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) my aim is to modify the two fields to change its data type. BUt when im trying to run this command in the query analyzer, itsays "incorrect syntax error '(' " What do i have to do please help me...thanks ...Show All

• jonNotTod Trying to put two pie charts adjacent to each other

  I am trying to put two pie charts next to each other.  I have sized them so that are pretty small.  The left pie went in the right place.  However, the one on the right was moved all the way to the right side of the page and is nowhere near the other chart.  It also has moved beyond the borders I established for the page. Are you sure that they aren't overlapping at all If so, the HTML rende ...Show All

• LLam Help Designing an App. to be Run from a Job

  Hello, I'm working on a project that uses SQL Server 2005 and C# 2.0. I need some ideas of the best way to design/implement an application that will be executed from a SQL Server job. The general idea is: a SQL Server job will call [ something ] and pass a couple of parameters to [ something ], then [ something ] will query a database and gather other information, then [ something ] will do some processing of data, and finally [ something ...Show All

• Benjy SQL Server and J# integration problem

  Hi, I am using SQL Server 2005 b2 and i want to integrate my J# project with SQL Server. .NET Platform compiles it. No problem there. But while i try to create assembly by referencing  produced dll file, SQL Server gives that error: "Msg 6581, Level 16, State 1, Line 2 Could not find assembly 'vjscor.dll' in directory 'c:\'." What is the problem Thanks in advance... I solved the problem. There is a path ...Show All

• spoly Upgrade SQL Server Beta 2 to Release

  Hello, I try to export a database from one sql server (beta 2) to another (release). Both server can see each other, but I cannot create a connection. From release I get the error message: TITLE: Connect to Server ----------------------------- Cannot connect to COCHRANE. ------------------------------ ADDITIONAL INFORMATION: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ...Show All

• Abu Islah New Java driver for SqlServer

  Theres been rumors on a future effort in building a new JDBC driver to support the SqlServer 2k5. What level of JDBC will it strive to accomplish Can it be a more open project Also, the old driver perhaps lacks some things that higher JDBC specs feature so it would be nice if it could provide some sort of backward compatibility. It would be nice to have the new RowSet thingies and some generics support. Hi schrepfler, where can I get that ...Show All