Answer Questions

• Fahad349 SQL Express - can't change language setting

  I've got a problem in Server Management Express CTP - in the SErver properties dialog I can't change any of the properties on the 'General' page. At the moment the Language is set to English(United States), which is giving me a problem with datetime formats, but I can't change it. Am I missing something obvious In order to change the collation on a database open the properties dialog, switch to the "Op ...Show All

• Frapazoid SQL DMO - Backward Compatibility Components Redistributable

  I need to update our applications install program so it installs the latest SQL DMO.  I've downloaded the "Microsoft SQL Server 2005 Backward Compatibility Components" MSI from http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en . This MSI will not install on Windows 98.  This is surely a problem   Client machines running Windows 98 can still connect to SQL Server 2 ...Show All

• lihai SSIS and SQL Agent is WORTHLESS

  I have an SSIS .dtsx package that will run fine during debugging, however, when I run it as a job under the SQL Agent the job won't start. To be more specific, the Agent will load the package, ensure that it passes validation (which it does), then sit there without starting the rest of the package. The job will run under the "executing" status until I stop it manually. Does anyone have any idea why it might be doing this ...Show All

• blouie MySQL help in C++

  Hey, I'm sorta new at this, but I've been a web developer for many years. I know all there is about the actual MySQL languange, and now I'm expanding into computer programming. I was just wondering if anybody knew of some good tutorials on how to access MySQL databases that are on my server. Also, any extra software that is needed and any other useful information would be appreciated. Thanks If you have Vis ...Show All

• smeets116 Reporting Services 2005 - Problems displaying a report via a ReportViewer control.

  I have a report that displays fine in VS 2005 (in the Preview tab), and if I hit it via a URL in IE as a deployed report. However, when I embed it in a ReportViewer control for display on a web site, I get no data back for the report. I am using an Oracle database for the data source. None of the the logs in reporting services show anything wrong, there are no events in the event viewer to indicate any problems, Oracle logs also show no problems ...Show All

• tqlashot_kk Connection Error when trying to run MDX-queries

  To learn MDX (on SQL Server 2005 dev edition) I decided to put up some sample cubes and run MDX-queries from SQL Server Management Studio. When processing the cube in BI Studio I get the following error: "The datasource , 'Adventure Works DW', contains an ImpersonationMode that that is not supported for processing operations." Fair enough, then I change the impersonationmode in the datasource to service account. It all processes/deploys w ...Show All

• NinjaCodeMonkey Sql Express and One Care

  For those of you that are using One Care and Sql Express, there is a problem.  You will receive an error message in the Windows log that reads: FCB: : Removealternatestreams: Operating system error 6 (The handle is invalid) occurred while creating or opening file 'C;\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\mater.mdf" This message is for: Master, Model, Temp, etc..... OneCare blocks access to alternate NTFS streams. ...Show All

• dat1 extracting the specified record no of records from database table

  hi all, I need to select the no of records on the basis of specified range of records. In oracle i found rownum, i could not find it in sqlserver. how the data are extracted from the huge records.. I have used temporary table,map the table primary key to the next table with identity but i dont find it good. I need to ignore the insert the data in next table or craeting new table having the rowid ... Is there some other best wa ...Show All

• John Bocachica Create stored procedure wizard in 2005?

  Where is the create stored procedure wizard in SMS 2005 that we had in 2000 ! The templates are nice, but they show syntax only.  The 2000 wizard created insert update and delete stored procedures based on the table structure.  Regards Richard   Inside SQL 2005 Management Studio, expand the database (where you want to create your stored procedure) then expand programability, then on sto ...Show All

• RGBean I can't connect to SQL server 2005 with Management studio express

  Hi all, my server is on internet and can be accessed by sqlb2.webcontrolcenter.com to my hoster. I subscribe for SQL server 2005 I try to connect to sql server 2005 via Management studio express and visual web developper express without success. i got this error below with both: Cannot connect to sqlb2.webcontrolcenter.com a connectionmwas successfully established with the server, but then an error occured during the login pro ...Show All

• msctech Any advice on where to start with learning SQL and C#?

  Hi all, Not sure if this is correct place to post this thread but im looking for advice on where to start with learning SQL and C# as i wish to start in a new career as a DBA. Cheers, I have a legal copy of Visual Studio 2005 Pro and a copy of SQL 2005 Standard so as for the software im sorted, i have a limited understanding of VB6 but not the .Net Framwork not sure if it will help as i have been told th ...Show All

• gary-ccl ODBC Data Source error

  As other contributors, all I am trying to do is import data from an ODBC source (spelled 'non-Microsoft data source') into a SQL 2005 table. I can easily do this in SQL 2000 with DTS, but when I use the same DSN in VS 2005 it doesn't work. I created an integration project, and made a connection in Connection Manager to the DSN and clicked Test Connection. It succeeded, or so it claimed. Click OK and drag a DataReader Source onto the Data F ...Show All

• saynotoms Report Server error

  Hi,     I am getting the following error when trying to run report server. Whats the problem. Thanks, -Suri     Server Error in '/ReportServer' Application. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Pars ...Show All

• Saric Sead Replication with host_name

  Hello,    I am wanting to limit the amount of rows that are merged between the server and the wm device. Host_name() doesn't seem to be supported in sql mobile. I created a column called host and set the default value as host_name(). I get the table to replicate however when I try to insert into the table on the mobile side I get errors. Is there another option to filter like this or if I hard code a deviceID how can I add this to ...Show All

• CalBob Database Mirroring

  Hello, I'm having some troubles to set up database mirroring on Itanium II based servers. I have 3 servers registered in the same domain (windows authentication) I have created manually the endpoint and there are all 3 started (port 5022) When I do the alter database set partner on the mirror site it works. When I do it on the principal instance, I have the following error: Msg 1418 the server instance "TCP:itanium8.sql.net:5022" is not running ...Show All