Answer Questions

• semaja2 Missing ODBC Driver

  I have a Windows 2000 development server with multiple instance of SQL Server 2000 Dev Edition installed. Recently, i encounter an error on Enterpise Manager. "A connection could not be established to SERVERNAME\INSTANCENAME . Reason : Data source name not found and no default driver specified. Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the SERVERNAME\INSTANCENAME ...Show All

• sewyew Row Sampling Transform

  The "Sampling Value" is now exposed on the Control Flow so we can use expressions to determine the amount of rows that flow through a pipeline .  What is missing as far as I can see is the ability to say "ALL". I know I could remove the transform but what if I do not want to touch the packages.  The way i will set the value is through DTExec. This would be useful for testing in that I could have a series of runs and each one ramping up ...Show All

• ryuu_iku temporary table and multi-part identifier

  Hi, I want to join a temporary table with a table in my stored procedure : CREATE PROCEDURE sp_DeltaabgleichDarlehen AS BEGIN SELECT Grundeinstellungen.Dat_Initialisierung, Grundeinstellungen.Dat_Jahresbeginn INTO #temp_IniDatum FROM Grundeinstellungen INSERT INTO DeltaDarlStammdaten (Datum, Vertragsnummer) SELECT ImpDarlStammdaten.Datum, ImpDarlStammdaten.Vertragsnummer FROM ImpDarlStammdaten WHERE ImpDarlStammdaten.Datum=#temp ...Show All

• simon mcinnes Permissions using CLR triggers

  It seems that there is a difference between the way t-sql permissions and CLR permissions work. I don't know if this is a fault of SQL2005 or of my coding - perhaps someone can tell me. E.g. Assume there are two tables called test1 and test2 with no permissions granted to anyone on them. Below is a simple trigger that inserts into test2 when test1 is updated CREATE TRIGGER tr_test ON test1 FOR UPDATE AS BEGIN DECLARE @v INT SELECT @v = M ...Show All

• A Sedorian After Install of 2005 still 2000 Engine!

  I have installed the new SQL Server 2005, but I see my local database as version 8.9.193, means SQL Server 2000. I do not know why setup did not upgrade it. What do I need to do now  I think some new options are now working because of that... Was your SQL Server 2005 installation successful   And did you do an upgrade, or a separate instance installation   Check to see if you have a second instance of sql server run ...Show All

• richard_w What is the difference between Crystal report and SQL 2005 Report?

  hi, As default, VS2005 is able to create crystal report project, what is the difference between crystal report and SQL Server report I am trying to evaluate these same two products to determine which one to go with, and there is no info online comparing the two. Does anyone have a good reqource comparing features, or links to articles comparing the two products. These are two ...Show All

• M.Johnson Report Builder

  I have tried using the report builder for the first time by clicking on it from the report manager. I am not able to proceed ahead because of the error . The error occured when i start the application . The details log shows me this error. Error : Exception occurred loading manifest from file ReportBuilder.exe: the manifest may not be valid or the file could not be opened. + File ReportBuilder.exe is not a valid Portable Executable ...Show All

• Dave Balsillie Problem creating diagrams

  I just upgraded an existing sql server 2000 installation with the RTM sql server 2005 (developer). I went to work on a database that I've been working on for a couple of weeks before the upgrade, and wanted to create a database diagram. However, when I click on the "Database Diagrams" tree node, I get this message: TITLE: Microsoft SQL Server Management Studio ------------------------------ Database diagram support objects cannot be installed ...Show All

• Bill Horsley Saving SSIS results to Log or text file using dtexec

  Hi, How to save the SSIS package results to log file using dtexec command............please help regaridng this........... Thanks in advance, Hi Donald, Thanks for your reply, actually i am using the folwoing command with out creating connection manager for log provider dtexec /sql "\CTSFullPackage" /ser "test" /u "sa" /p "test" /l "DTS.LogProviderTextFile;c:\log.txt" ...Show All

• Martine Hall My SQL application on Windows Mobile 5

  Hi My application : On PC : Access application + Access DB On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB I synchronise my DBs through ActivSync. It runs good before Windows Mobile 5. My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported. So what are my solutions My customer wait for there PocketPC, so I need a quick so ...Show All

• DexIT Question about dataasource and the .rdl file and the .rdl.data

  Hi ! Maybe the only one who can answer this question is people from Microsoft but if someone have an idea just tell me ^_^ i really need a solution. We have over 500 Access reports. I have imported all those reports but since there is some difference between Access and reportServer we have to make some changes on the reports. Since i'll be too long to change all the reports one by one. I've created un program in .NET that open all the .rdl file. ...Show All

• pbergamo DTS Legacy and SQL 2005

  I am in the process of migrating to a new SQL 2005 server. I have a number of DTS packages on my SQL2000 server, approximately 200, that are used on a daily basis. I used the migration wizard to migrate the packages from the 2000 server to the new 2005 server however there are issues with the way some were brought over. I would like to have all of the packages moved from the 2000 to the 2005 server and appear under Legacy DTS so that I can r ...Show All

• Juggernaut. SQL String Help Please

  I'm in the process of creating an application that converts one database to another database with different fields...pointless, yes, but easier than typing in 4000 entries My SQL string is SELECT * FROM tblInformation However, that's all fine and dandy, until I don't know the name of the table in the database...I know this doesn't work: SELECT * FROM * or SELECT * FROM ALL but I don't know what else to try. Is it even possible to se ...Show All

• claire_northall Enterprise Publisher to Express Subscribers (2005)

  I implemented a merge replication publication on a SQL Server 2005 Enterprise instance on a test server. On my laptop I have VS.NET 2005 installed with SQL Server 2005 Express. It's my understanding that I can subscribe to a publication with Express. I also have SQL Server Workgroup installed on my laptop so I'm able to use Management Studio to control the Express instance. The first issue I encountered was that you cannot subscribe to a public ...Show All

• Henrylau Could not load file or assembly 'System.Data.SqlServerCe'...

  I am trying to use SQL Mobile 2005 with Visual Studio 2005.  I have a simple sql mobile db i created and am trying to test connectivity to the DB in a simple app.  I added the reference to the SqlServerCE and the verison # that is shown in properties is 3.0.3600.0, but when i look at the physical DLL in explorer (found at C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0) the version # is 3.0.5206.0, so ...Show All