Answer Questions

• hmortada Creating SQL Server 2005 Mobile Edition On Desktop

  Hello Everybody I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application. Anybody having this solution for this prob.   Regards Chikuu       Glad that I could help you. Thanks, Laxmi Narsimha ...Show All

• johnmont == The SQL Server service failed to start ==

  I'm newbe with SQL Server , I'm looking for help with sql server express edition 2005. At the end of installation ocurrs an error: The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually. Error Number : 29503 . (Summary file) Rest of components has status : Successfully installed I've go installed .N ...Show All

• Lee Crabtree SA account Locked out

  I have been using SQL2000 for a number of years and the company I work for needs a new system so I decided to install SQL2005. I installed SQL2005 without any problems and set a complex password for SA. I tried to log on and had to make several atempts as I remmebered the password after the SA account got locked out with the following message: Login failed for user 'sa' because the account is currently locked out. The system administrator ...Show All

• JohnCP check what table are lock by application

  Dear All, Sometimes the application cannot write record into SQL Server, but the source code of this application cannot be seen. Therefore, I wanna verify the MSSQL status. I have to check what table are locked by application. I wanna know the following information. locked_table, locked_by_application, locked_status Can I write some t-sql to get the information I tried using Profiler, but it generates some useless information. Could you ...Show All

• crashed Calling SSIS packages from within a Script task

  Hello, I was wondering if someone could point me in the direction of any sample code or documentation that allows you to execute SSIS packages from within a Script task In SQL Server 2000 DTS this was accomplished by instantiating the DTS.Package object and calling either the LoadFromSQLServer or LoadFromStorageFile method. I have not been able to find any similiar logic in the SQL Server 2005 SSIS environment. Any help would be gr ...Show All

• Vincent Dumas design of the classes of data access layer

  hi all for designing the data access logic layer,if i have 3 table that relate to each other ,for example contact,address,sometime with creating the customer address should be created too. should i design one class for each of them seperately and design 1 class(in bussiness layer or data access layer(i am not sure)) for calling the create stored procedures of 2 tables and put the 2 stored procedures in one transaction or not ,should I desi ...Show All

• Luisgph Metadata Issues

  I am experiencing something really bazaar. The package I created usign SQL2K5 Sept. CTP Builds and functions just fine in one domain. When I deployed to another machine & new domain, we get Metadata errors within dataflow that was modified. We had encountered this earlier but by rebuilding the package it has solved the problem. This time, rebuild is not helping. How can metadata for data flow of a package g ...Show All

• ND.. Strange Results in executing views in SSME

  I am getting some interesting (read 'undesirable') results in SSME. I am attaching two scripts, one that creates a TestTable and the second creates a TestView, based on TestTable. When TestTable is created, enter the following rows (format is TestID, Sequence): 1 - 99 2 - 98 3 - 97 4 - 1 5 - 2 6 - 3 When the data is entered, highlight TestTable from the list of tables, right-click and select Open Table. The result shou ...Show All

• xyzt82 Selecting the first sheet in an excelfile when using For Each Loop

  I have a For Each Loop which cycles through some Excel files which is delivered to a FTP location. In the loop the DataFlow Task uses a Excel Connection Manager, in which you have to specify which sheet you want to take the data from. But what can i do if the sheet name is different from file to file I was thinking about a script task which somehow can read the first sheet in the Excelfile thats found in the Loop -> put it into a va ...Show All

• tca9 Install Sql Reporting Service - Windows 2003

  Hello I need to install the SQL Reporting Service in one Windows Server 2003, my schema is: One DMZ (Servers Web with II6/Win 2003) One SQL Server (Sql Server 2000) When I install Reporting Service in the step about SQL Server Configuration the SQL Server not make de authentication, the message with the user dont have permiton! I view the SQL Log with show the problem with not use Kerberous comuniction! Tks a lot I have also faced lo ...Show All

• Raba21 Using SQL Server 2005 to connect to SQL Server 2000

  Are there any issues with connecting to a SQL Server 2003 database with SS 05 TIA! David L. Crooks I guess you mean SQL Server 2000, not 2003 as there is no such thing. How are you trying to connect At the server level (linked servers etc) or using the client tools Nick DBA www.comoni.co.uk No problem connecting to a 2000 server with 2005 client tools. M ...Show All

• Itwazntme A Problems after the install of the Hotfix

  After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx id=918222 We now get the following error when trying to work with date parameters in Report Builder: Query (6, 117) The '[VBA].[DateSerial]' function does not exist. ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred duri ...Show All

• Jenska SQL 2000 AWE Performance Counters - How to Interpret them?

  We have a 2003 Enterprise Server box running with SQL 2000 Enterprise. The box has 16 GB of memory, PAE enabled, AWE enabled, 3GB NOT enabled. I'm tracking the 4 performance counters for SQL AWE usage, but I don't really know what are "good" or "bad" number for them. I've looked around the web and found plenty of stuff describing what the counters are reporting on, but no direction as to what they should be telling me abou ...Show All

• ANDRIAMA Replication Trigger Problem (SQL 2005): Assistance Please

  Our company is wanting to replicate a bunch of data down from our central server to tablet PC's. We really do not have anyone on staff with solid experience in replication, and have hit an error that we cannot seem to find any information whatsoever on. Here is the problem: When setting up a publication to replicate certain tables, we stop being able to do any updates on the tables. After some research, we were able to narrow the problem i ...Show All

• Ivan Ooi WMI alerting error

  After installing SQL Server 2005, I tried to create a WMI alert by doing the following: USE [msdb] GO EXEC msdb.dbo.sp_add_alert @name=N'Database Created', @enabled=1, @delay_between_responses=0, @include_event_description_in=0, @wmi_namespace=N'\\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER', @wmi_query=N'SELECT * FROM CREATE_DATABASE', @job_id=N'00000000-0000-0000-0000-000000000000' GO This p ...Show All