Answer Questions

• Demonslayer Problem starting MS SQL server 2005 service

  Hi, Anybody kindly help me. We have windows server 2000 and sql server 2005 on the same machine with 15 clients. There was a power failure. The sql server is automatically stopped. When we tried to start the service we are getting the error as action failed please check application event log for errors. This has happened for the 2 times, kindly tell me why this happens and what precaution we can take and is there any setting we are missing. Since I am newbie to sql server and windows server I am unable to solve this problem. Thanks This is the details of the errorlog file 2006-10-04 12:28:13.08 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corpo ...Show All

• safewithyou247 MM/DD instead of MM/DD/YYYY?

  Is it possible to display a date field as just MM/DD instead of the full MM/DD/YYYY That was embarrassingly easy. Thanks for the help. Yes, just go to the format property of the textbox in which this date is displayed and enter MM/dd ...Show All

• KentaroM Dynamic Query Problem in Reporting Services 2005. Help!!!

  Hello to everyone, Right now i am working on a reporting project. I am using SQL server 2005 Reporting services for this project. In my project I want to pass table name as a parameter to report. I tried but i cant get result. In other words, i want to generate a dynamic query in which i want to pass table name as parameter. This table name and other parameters are passed to report from .aspx page. I use @financialyear as my table name parameter in sql query of report, but it give me error that " @financialyear variable must be declared ." If anybody know answer pls reply me fast my deadline for project is near. ...Show All

• William Wong Create Time dimension Year, Week, day problem

  Hi, I have a problem when creation a Time dimension Year, Week, day , The week does not start on the correct date eg. Week 42-2006 should start on 16 th. october and end on 22 th october, but in this case it starts on the 15th october and ends on the 21 october. So what happens is that it starts 1 day before it actually should. This is my Time Dimension: DatePart(year,"dbo"."fCapacityLedgerEntry"."Posting Date") DatePart(week,"dbo"."fCapacityLedgerEntry"."Posting Date") 'Week ' + convert(CHAR, DateName(week, "dbo"."fCapacityLedgerEntry"."Posting Date")) convert(CHAR,"dbo"."fCapacityLedgerEntry"."Posting Date&quo ...Show All

• ooboyle Can't Connect with Remote Sql server.

  Hello All , I had installed Sql Server 2000 on Windows server 2003 enterprize Edition. But when I Try to connect it with Remote, 'Sql Server doesn't exists' message appears.. anybody know what may be the reason Moving this thread to the SQL Server forums. You can connect using IP Address without any problem and for that ensure to add an entry on the client network utility on your client's machine. Also refer to KBA http://www.sql-server-performance.com/faq/sqlviewfaq.aspx topicid=12&faqid=143 which helps to resolve any issues you might get. My question was slightly wrong.. I want to connect with sqlserver 2000 with Ip address. ----my installments are 1. Microso ...Show All

• LynnOoi kiran

  I don't get the code of sqldatareader for connection with datagrid True, that helps and fyi http://www.datadirect.com/developer/net/sqlserver_code/index.ssp Coudl you explain this in more details HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Martin Schmidt mdx expression

  I have a cube with 1 fact (historic sales data) and 3 dimensions (Time, Product and Customer) and i have created two calculated measures 'Bud_Qty' and 'Bud_Price' that I then multiply to create 'Bud_Sale'. I can browse the 'Bud_Qty' and 'Bud_Price' dimensions by both the Product and Customer hierarchies, but the aggregation of the 'Bud-Sale' is incorrect. I have tried a number of alternatives using various Scope, Leaves and Descendants scripts, but I have not been able to make 'Bud_Sale' calculated measure aggregate properly. Any Help is appreciated. Thanks in advance...Burnswell If you derive them from historical data, yes. If Bud_qty is a simple percentage of last years actual quan ...Show All

• Viktor Weimer Password in config file

  Hi Config files doesn't seem to work for me :( i want to make a common config file for all of my packages but it is giving me error Validation error. The AcquireConnection method call to the connection manager failed with error code 0xC0202009 I have placed pasword in my config file too. Following is config file which i m using, server name n password are masked. < xml version="1.0" > <DTSConfiguration> <DTSConfigurationHeading> <DTSConfigurationFileInfo GeneratedBy="SSBKD\955688" GeneratedFromPackageName="DTS_ACPM_MarkIT_Indices_Composites_TRAC_X_Asia_Index" GeneratedFromPackageID="{CB3660A1-5E6C-4D08-A7F5-4D6CE83578E2}" GeneratedDate="2006/10/19 14:05:20&q ...Show All

• Rapper sql 2005 install

  Hi, Installed sql server 2005 full version. Now in the start menu there is no management studio. Only the following are present; configuration tools sql server 2005 upgrade advisor documentation and tutorial Any thoughts please Thanks How did you install SQL Server 2005 Check this out for a guide http://msdn2.microsoft.com/en-us/library/ms143516.aspx Could it be because IIS is not allowed to be installed on the PC (Company regulation) Which edition did you install Management studio does not come with some of the editions (such as SQL Express). Here is the support matrix. http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx Thanks, Sam ...Show All

• gbvdh Encrypting SQL Server table columns

  I have never used any type of encryption for SqL Server 2000, but I have recently been asked to research what would be involved to encrypt data like social security numbers. Since I have no idea where to begin, I was wondering if someone could point in the right direction Do I need to buy a third party tool to perform this, are security certificates involved Overall, I need information on everything that I need to encrypt data using SQL Server 2000, and How to perform the tasks!!! Thank You! As Euan already mentioned, I always liked the way doing encryption on the application / business layer in my application. You will have full control over your encryption and can easily hook some extra m ...Show All

• Mikepy Issue with Report Parameters in Page Header

  I believe report parameters cannot be used in Page Header. I seemed to work around it by creating an "Internal" Parameter and using it in the report header. It works if the dataset returns data but fails otherwise. Is there any fix for this Thanks, Dinakar ...Show All

• prasoot Using credentials and proxies in transactional replication

  Hi everybody, while playing around with replication in SQL Server 2005 I tested other accounts then the server agent account for log reader agent, snapshot agent and distributor agent. I found that the SQL Server generates credentials and proxies for every agent. But when I use procedures to set up a replication I need to specify the account and the passwort. And I don't like to have passwords in scripts. So my idea was to generate my own credentials and proxies and use them for setting up a replication. But it doesn't work. I couldn't find out how I can use my own credentials and proxies instead of accounts and passwords. Is it somehow possible to do what I want Did I miss something Regards Wolfgang I ...Show All

• ramana reddy Calling SSIS package from web service - Security issue

  I am trying to call a SSIS package from a web service hosted on the same machine as the package file is sitting. All that the package does is a simple Execute SQL task with one datasource connection. I have set impersonation as true. When I run the package from the web service on the virual port (through Visual studio IDE) it runs fine. http://localhost:4609/WebServiceRunSSIS/LaunchSSISPackageServiceCS.asmx In the above case I don't think impersonation means anything coz it runs successfully even when there is no impersonation set! I then run the same service (asmx page) from the browser after making it a web service on my machine http://localhost/WebServiceRunSSIS/LaunchSSISPackageServiceCS.asmx I get an error indicati ...Show All

• D. Choquette SSIS DTC Transaction's HOT questions

  I am using SSIS with Transaction, and I met a lot of questions as below: 1.IF DTC doesn't support ADO.NET Connection Please check the ADO.net Connection's property, it has a property named like: DTCTrancactionSupport. But it's always set to False and unable to edit. IF the answer is NO, HOW could I bound all my Tasks into one Transaction You know, I have some Tasks with SQL connection, and I have also some Script Tasks, witch need the ADO.net connection. 2.IF DTC required to run in both the Destination Server and the Source Server I have a Dataflow Task, and take some data from a table in a Source Server to a Destination Server. The DTC doesn't run on the Source Server. I found the Dataflow Task hangs when I use the SSIS ...Show All

• jdang Creating process doing specific job periodically

  Hi, can I create a background process in SQL Server doing specific jobs periodically Stored procedure is the only solution Hi, Andrea. I'm using SQL 2005 Express edition. There is a table which saves data from clients every other minute. This table keeps only one hour's data before from current time. So I must delete the expired data. This is the task that I want to schedule. I don't exactly know which is efficiant that doing in my application or let SQL Server does. I'll visit the site you commented and thank you very much. hi, remedios_ wrote: Hi, can I create a background process in SQL Server doing specific jobs periodically Stored procedure is the only solution SQLExpress does not provide the SQL Server ...Show All