Answer Questions
Pierre Leclerc Problem with query using SQL Server 2005 September CTP
To SQL Server 2005 Team: This query works fine on SQL Server 2000: select top 10 aename as EscrowOfficer,aomon,aoday,aoyeary2k, aemon,aeday,aeyeary2k,aprice,aescr#,aprpt#,abra#,arecmn, arecdy,arecyry2k,Source,absct,asrep1,asrep2,asre ...Show All
andyroz how do I determine how many columns there are in a file?
Hi, I have a few different files in a directory. I want to take each file and determine which columns and data types it has. How can I know how many columns there are in a file Thank you. one way is to start a new project in vs as ssis right click over solution explorer->SSIS Packages and select import and export wizard select your flat file as source and destination as server, by ...Show All
Dan Berkowsky Stored Procedure typed xml parameter DDL
The following will create a stored procedure that has @testXml as an xml datatype. As my tables in the database store "testXml" in a typed xml field, can I "type" the @testXml parameter coming into my stored procedure using an item from the database's "Xml Schema Collections" What would be the DDL syntax THANKS! ALTER PROCEDURE [dbo] . [PearUpsertShapeImage] @id [bigint] , @testXml [xml] AS ...Show All
Carmen Lipscomb ODBC Driver for SQL Server 2005
I can not find the driver update for SQL Server 2005 ODBC. Does anyone know where I can download it. I look in microsoft downloads not luck. The SQL Server 2000 driver will work for a fair number of cases against SQL 2005. If you have installed SQL Server 2005 locally then you will have the driver installed. The driver is called SQL Native Client(SQLNCLI) rather than SQLODBC as it was in older versions ...Show All
WilliamMandel bcp problem
this command: bcp MyDatabase..MyTable in Data\2005\MyFile.bcp.dat /f bcp.fmt /S MyServer /U sa runs fine when run from its original location on a network drive. When we copy the files referenced down to the C: drive and execute the command (with the path adjusted appropriately) and run the command I get an error: Unable to open BCP host data-file both MyFile.bcp.dat and bcp.fmt exist in the locations specified in the new command l ...Show All
orouit Calculated Member - #VALUE! in the Grand Total
Hi all This is a simple question on MDX. We have created a calcualted member that basically compares an existing measure to an attribute, and displays a certain value based on what's in the attribute (simple case statement) The calcualtion works fine against the proper dimension, but for Grand Total displays #VALUE!. What do I have to do to make the grand total actually display a grand total of this calculated member in the cube ...Show All
l0p0l SSIS fixed width file
I am attempting to import a fixed width file into a SS2005 table and am having problems when importing a date that has no value in it. The table will allow nulls. The date is in dd/mm/yyyy foramt and when there is no date then there are 10 spaces. When transforming the data I TRIM the data down using a derive transform script so all there is, is an empty string. When the file attempts to load I get the following message: [OLE DB Destinatio ...Show All
Manik_Mahajan_3112ff Developers cannot execute sp_addmessage
Hi, I have problems with the concept of user-defined messages. I'm migrating from sybase ase to sql2005 and found out that there is only one global pool of messages. Do you give every project on this server a dedicated range of error-numbers Another problem: only the sysadmin oder serveradmin can call sp_addmessage. In my environment the developers own their databases and used to be able to create their own messages. Now I try to let the develo ...Show All
Alberto Canabal doubts about report deployment
hi all i have doubts abt report deployment if i am deploying report then what process exactly happens also is any entry made in IIS or is any new file created in IIS if i am deploying report on remote server then what process exactly happens what r the entries or files that r created on remote server plz help me so that i will understand this deployment process very clearly. waiting for reply. ...Show All
DWinTX Reg questions!!
Hello all, I am doing my project for my university, The project is about making a registration in the university for students and also for tutors, I want for help on this question: how could I translate the fact that a student have registered for many courses, I mean how could I make this implemented using MS Access Any suggestion, even if it is not related to this question. Thanks for supporting. Suggestion: Go to an MS Access forum. ...Show All
Jean-Francois Peyroux Report parameter validation from report manager in reporting services 2005
Hi, Whenever user viewing a report using report manager, how can we validate the input values from user for a datatime type report parameter. i.e. validating whether the date is correct and in required format. Thanks in Advance. Regards Pintu Isn't there any built in functionality to prevent SQL injection Or any build in functionality to prevent other scripts from being inserted i.e. scripts to prevent < > cha ...Show All
HelOz DB Mirroring VS. Clustered Failover Questions
We are planning to update our two node, active/passive clustered system to SQL 2005 from SQL2K. Would we be better off to use database mirroring rather than clustering with failover I believe mirroring takes 3 systems rather than two (one for each mirror and one for monitoring), but can the monitor be a rather low powered PC Our current cluster uses two 4-processor Dells and an external PowerVault RAID array with fiber channel connections. E ...Show All
ERK33136 Execute SQL Task – Output Parameter on Stored Procedure causes task to fail.
I have a SQL Task that calls a stored procedure and returns an output parameter. The task fails with error "Value does not fall within the expected range." The Stored Procedure is defined as follows: Create Procedure [dbo].[TestOutputParms] @InParm INT , @OutParm INT OUTPUT a ...Show All
Johnny37 Replication -- New Subscription Wizard SQL Mobile error, please help..
I'm following the steps of sample SQL Server Mobile Tutorials.. error on my replication subscription wizard : "Initialiazing SQL Server Reconciler has failed HRESULT 0x80045003 (29045) The initial snapshot for publication 'SQLMobile' is not yet available. Start the Snapshot Agent to generate the snapshot for this publication. If this snapshot is currently being generated, wait for the process to complete and restart the syncronization. HRES ...Show All
&#214;z.Net Problems with SQL 2005 IDE and Column Names
Hello all. I'm having problems with SQL 2005 Management Studio not liking some of my column names, even though I believe they are valid when run directly through a SQL query window. An example... CREATE TABLE [Test] ( [ID] [int] NOT NULL, [The.Name] [nvarchar] ( 50 ) NULL ) INSERT INTO [Test] ( [ID] , [The.Name] ) VALUES ( 1 , 'Test' ) DELETE FROM [Test] WHERE [ID] = 1 This SQL will execu ...Show All