Answer Questions

• ChrisMoje Buld Data load import

  HI I have a table XYZ that needs to contain a million records as operational data. XYZ has a column named SLOT_VALUE which has values 1,2,3....100,000 What is the easiset way to bulk load this information in the shortest possible time... Insert scripts/ Batch program like if..while loop takes heck lot of time.... No worries. Just remember that performing this operation within a while loop will entail 1 million individual inserts! The set based solution described above would be much faster and much more efficient. If this is a once-off operation, then it's probably not an issue. Cheers, Rob Hello, If you mean that you just want to populate that tab ...Show All

• Dr.Virusi Maxis 3G connection

  I cannot connect to SQL Server 2000(Remote Server) through Maxis 3G connection. I'm using Windows Application to connect to SQL Server 2000. dim strsqlcon as string = "Server=000.000.000.000;databse=dbname;usr=sa;pws=1234" dim sqlcon as sqlconnection = new sqlconnection(strsqlcon) sqlcon.open() "It's Error : Sql not exist or access denied." But I can connect to SQL Server 2000(Remote Server) through Local Area Connection. Have any solution Thank you. Error : "Connecting To x.x.x.x ...Could not open connection to the host, on port 1433: Connect failed." How do i open the port I didnt ...Show All

• sureshsundar007 Query help

  DECLARE @Test TABLE (AccountNo INT, Startdate datetime, Enddate datetime) INSERT @Test SELECT 1180, '05/05/2006', '07/05/2006' UNION ALL SELECT 1181, '01/09/2006','05/05/2006' UNION ALL SELECT 1182, '01/05/2005','07/05/2006' UNION ALL SELECT 1183, '06/05/2005',NULL UNION ALL SELECT 1184, '04/05/2006',NULL UNION ALL SELECT 1185, '08/05/2006','09/05/2006' UNION ALL SELECT 1186, '05/05/2005',NULL UNION ALL SELECT 1187, '10/05/2006',NULL UNION ALL SELECT 1188, '07/05/2006','08/05/2006' UNION ALL SELECT 1189, '08/05/2006',NULL I need result like below. If account get deleted then i want a disply on buket that based on start date vertically and deleted date horizontally. Example: account 1180 was start on 05/05/2006 and end on 07/05/2006 t ...Show All

• Mowali AS2000 only using 2GB even when /3GB is activated

  I've done everything to enable the use of more than 2GB memory for AS 2000 according to http://support.microsoft.com/kb/295443 Still, according to the task manager, the process msmdsrv.exe stops growing around 1 996 000 kB. I've added the /3GB in boot.ini and set the Memory Conservation Threshold in Analysis Manager to 2.7 gb. I've also checked that the HighMemoryLimit was set accordingly in the registry. OS: Windows 2003 server Enterprise Edition Memory: 3 GB AS2000 sp4 Any other settings/limitiation I've missed Actually Standard Edition of AS2000 does support /3GB. Sorry for asking - but you did reboot after modifying boot.ini, right Actually, later today the memory usage finally ...Show All

• Jimmy Xiong Using Parameters with the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider

  Hi, For using Measures in rows and not in columns, I have to use the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider. When I try to use named parameters within my reporting query I get an error, that this provider can't handle named parameters (the "@" parameters in the example). I can only use the " " replacement for parameters, but how do I join the " " to the right parameter under reporting parameters menu And how do I use the " " placeholder in the right way in my subcube query part For exampleI will do a query like this: SELECT { [Date].[Periode - Year].[Month].ALLMEMBERS } on columns, { [Measures].[Sales Volume KG], [Measures].[Sales Volume M2], [Measures].[Average W ...Show All

• Evan Mulawski accesssing mirrored databases via SQLNCLI linked server?

  Does anyone know how to configure a mirrored pair as a linked server on a 3rd instance Say I have a mirrored database on two servers: PRIMARY and SECONDARY. I want to create a linked server on a 3rd machine that allows me to access the database on the mirrored pair. This is what I'm using: EXEC master.dbo.sp_addlinkedserver @server = N'MIRROR', @srvproduct=N'', @provider=N'SQLNCLI', @provstr=N'Server=PRIMARY;FailoverPartner=SECONDARY;' select count (*) from mirror.pubs.dbo.authors and it works fine if the database on PRIMARY is alive. however when the mirror has failed over to SECONDARY and PRIMARY is no longer available, I get the following when I try to query the database via the linked server: OLE DB provid ...Show All

• doank US Date Format in Calender Parameter (SRS2005)

  Hi this is driving me completely mad. UK based so we want the calendar parameter to display the date format as dd/MM/yyyy rather than MM/dd/YYYY. I'm using SQL RS 2005 on a Windows 2003 sp1 box. I've used regedit to look at all the user account international settings, all of which are set to UK. If i log on to the box and run the report the server the date format in the calendar parameter display correctly. Same account on annother machine displays it in the US format. I've also checked my regional settings on the other machine and it shows UK. Where else is it going to pick up the US format from Ok I thought that solved the issue, but after rebooting the server there is no change in the way the report ...Show All

• FredHeida should the quorum disk be a physical disk or majority node set?

  Hello, I am trying to setup a test cluster and am having an issue. When I try to create the resource of a physical disk it takes both the drive e: and drive q: and doesn't seperate them into two physical disks as resources. This means when I try to associate the quorum disk it links the to physcial disk resource of drive e and q. Then when I try to install SQL2k5 I get the warning about installing SQL on the quorum disk. Am I missing something Is there a way to seperate e and q onto two physical disk resources so I can specifically associate the quorum to q and the sql to e or should I be setting the quorum disk to a majority node set Thanks in advance. John When MSCS looks at disks as resourc ...Show All

• MigiTheGuru For-Loop and Failed Items

  All, I am currently in the middle of writing a package that needs to loop round a record set and extract data from various source DB's in a common format. The inner package is a simple data pump that relies on a dynamic OLEDB connection being set at run time via a variable in the outer package. This works wonderfully, providing the value in the outer package points to a verifiable data source. However, If I make the data source invalid the execution status stops, In DTS 2000 this was simple to overcome with an Active X script, as you would set the package status to waiting and loop back to the next record. Waht i need to know is the object and property/method that will do this in SSIS, I've looked through BOL and theres ...Show All

• Moustafa Arafa Lookup Component Feature

  Has anyone seen this strange behaviour I have a package which loads the fact data from Stage into Warehouse database. This packages normally handles early arriving facts. In that package I use lookup to check the dims which exists, and where they don't I populate the dimension and use the surrogate key to load the facts. This works fine. I had a request to load 7 years worth of historical data. Instead of re-writing the package I took the package which handles early arriving facts and deleted the section which handles early arriving facts. I knew all the dimensions already exists and I don’t want to hinder the performance when I load millions of rows. During testing I found something very interesting. If you have configured err ...Show All

• dreameR.78 To bcp out a views results into a txt file

  I am trying to bcp out a views result into a text file. And the records in the text file should be comma seperated and each record should be enclosed in quotations. For tab delimited you use \t in the bcp.Can anyone help what needs to be used in the bcp to get the results in the txt file as specified For example: "100","name","2006-05-07" Thanks Thanks for the quick and explanative response. It answered my question. edited hi cast, first create a view with northwind use northwind create view mytest as select  '"'+ rtrim(employeeid)+'"' as employeeid,         '"'+ rtrim(las ...Show All

• nixps Temp Tables

  Okay i am not sure if i am doing this right but if i am i need help making each table unique so that the same report can be ran by more than one perosn at a time... i am working on some reports and using stored procedures to do this... in my final SP that populates the report it pulls from two other SPs: SP1, SP2. I made these first two SP make global temp tables so that i can use the temp tables they make in my final SP. I was wondering if they is a way to make it so either i don't have to use temp tables or if i can make each table have a unique name. Isn't that the purpose of the #temp tables So each session is unique within that instance of the named temp table   (Note the single "#") if ur creating a temp table i ...Show All

• Nilkanth Access SQL Server Reporting Server WebService using ip address

  Hi, I have a report server and I am trying to access the Reporting Server Web service API from a Web Server. When I call the web service using its IP address I get an access denied error but it works just fine if I call it with the server name. The funny is that, I have been accessing it by the IP address http://ipaddress:port/ReportServer/ReportService.asmx and it just quit working all of a sudden. There hasn’t been any change to the server or to the network so, I can’t figure this out. There are some specific reasons so I need to access it by the IP address. So could someone please help me out Thank you bjmp ...Show All

• jss3426 modify alias SQL server 2005 instance

  Hello, I implemented a database mirroring with 3 server, two partners and one witness. I had a problem when my primary alias server goes down... Its alias don't follow on the secondary. Do y know how can i do to change or to update an alias SQL server instance in transact-SQL Thanks your for your answers... ...Show All

• K_L Design question: static data & custom data & merging the two

  OVERVIEW: We have "normal" application data, like Company, and we have custom/override data that can override the "normal" data. We need the ability to switch back and forth between normal data and custom data and also merge the two (with custom data overriding any normal data fields). BASIC QUESTION: Is it best to set a flag in each table saying whether the row is custom or override OR is it best to have a Normal table and a Custom/Override table MORE DETAIL IF NEEDED.......... Company Data CompanyName - CompanyCity - Company Address (Normal/Default Data) Microsoft - Seattle - 1 Microsoft Way (Custom/Override Data) Microsoft - Atlanta - 1 Peachtree Way So, the first row would show up in the appl ...Show All