Answer Questions

• Kent Liu Save only the date in a datetime field

  Hello. A question please. Can I save only the date in a datetime field I don't want the hours. Do you are using .NET Use System.DateTime.Today instead of System.DateTime.Now. Do you want a TSQL form to obtain only the date This is more complex: Create a Function such as this: create function DateOnly ( @date as datetime ) returns datetime as begin return cast ( CONVERT ( CHAR ( 8 ), @date , 112 ) as datetime ) end Then use it in the following form: update mytable set mydate = dbo . DateOnly ( getdate ()) where id = @id or select dbo . DateOnly ( getdate ()) as onlythecurrentdate Regards, Not really. Using any o ...Show All

• Batikit Problem with a server broker conversation between two instances

  I have a problem with a server broker conversation between two instances on the same machine. I have used Server Listning Manager to setup the communication between the instances. When i a try to send a dialog it stops in sys.transmissin_queue and transmission_status is "The Service Broker protocol transport cannot listen on port 4022 because it is in use by another process." Can someone help me / Dan Svensson Are you trying to set up the communication between two instances on the same host Then only one instance can listen on port 4022, the second instance must use a different port (say 4023). Use ALTER ENDPOINT to change the listenning port of one of the instances: ALTER ENDP ...Show All

• BlueBeetle How to Export to Excel without hyperlinks

  How to export a report with hyperliks to a excel file with these hyperlinks removed Thanks in advace for any help I'm afraid that it is not possible and you need to make a cope of the report with removed links. ...Show All

• Aamer Problem with ReportViewer Control

  I have an ASP.NET web site with form authentication. When I use a ReportViewer control in a page (with a masterPage) and my report (ServerReport and Remote processingmode) has DateTime parameters I can't see that calendar gif in order to select a date. Same thing with a DropDownList bound to a dataset for another paramater (I can't see that arrow from the right side of DropDownList so I can't dropdown it). When I want to see the report with a browser direct from my Reports site it works fine. Only in reportviewer has this simptoms. IE has some errors in script 1. 'RSClientController' is undefined 2. 'ClientControllerctl00_contentPanel_ReportViewer1' is null or not an object. 3. 'DropDownParamClass' is undefined. I foun ...Show All

• Niehls Transferring or batch creation : Maintenance Plan

  I have a situation whereby I need to configure 100 servers with the same maintenance plan and don't want to touch every box. Anyway to script this in SSIS to create a plan of each I have a solution for this. If you need it please contact me at my e-mail address......gaoinc@hotmail.com. ...Show All

• abcoura Zero converted to null

  I have restore a SQL Server 2000 database in SQL Server 2005. I have a web aplication that uses dll to talk to the database using ODBC - SQL Native Cliente provider. I have a table with a key integer not null. The first element of my table has a key = 0. When the asp page recive the record set the value of the key field is null, why If i use the query directly in the SQL Server the value of the key is 0. Please help. Hi, ok, but you will have to keep in mind that NULL is NOT zero. In order to be type save you will have to use the ISNULL(key,0) for the Expression within your query or check the value for a NULL value in your asp application If IsNull(rs("key")) the ...Show All

• HappyZimmer Stored Procs in Master

  I had a user (don't ask how) get access to Master and ran a script that deleted all the stored procedures in Master. Some how the server was still working but the database dropdown lists in the GUI would not populate, but the default DB was Master. I was able to make the connection to the server, copy the code for all the SPs and recreate them. Now the GUI reports that my SQL2000 server is a SQL6.5. There are also some errors relating to sysconstraints when I try to view properties of a table. Any hints other than reinstall Pete Hello Troy, Thanks for your help.So i have a quick question,what will happen to the existing logins and permissions.will be login and permissions are preserved after ...Show All

• ImagineNation Mirroring and Replication

  I'm using replication and want to mirror my publisher to get high availability.  As I understand the documentation the principal and the mirror must both use the same distributor instance.  So if the distributor fails the replication fails.  This seem like a big weakness.  Maybe I'm missing some thing.  Is there a way to set it up so that replication continues if a distributor fails -- some mechanism that will switch in a "back-up" distributor   I'm looking for a configuration that will continue to run in the event of any single failure.  This means that both the publisher and the distributor must be covered by mechanisms that keeps them going in the event of a failure.  Mirroring covers the failure ...Show All

• Shocky DATEPART questions

  Hello, I need to use the statement DATEPART(datepart, datetime) , but i want to set dinamically the datepart parameter. Something like this: CREATE PROCEDURE my_procedure (@datepart_parameter ...) AS BEGIN ... DATEPART (@datepart_parameter, my_table.datetime) .... END GO But it doesn't work. Someone knows how I can do this Thank you very much for your help. Jonathan hi, ur already passing the datepart as a dynamic parameter...try to pass to the proc the value of that datepart as well beforehand...so that u can use it..say pass it ..month and 10 ... or write a case statement within the proc... declare @datepart varchar ( 5 ) set @datepart = 'day' select case @datepart WHEN 'day' THEN datepart ( day ...Show All

• SuperSaiyanZero SQL Mobile Server 2005 to SQL Server Developer Edition 2000

  I am looking for a detailed tutorial that explains how to set-up merge replication services for a major project. I have seen all of the claims that SQL Mobile Server 2005 is able to connect to a merge publication with SQL Server 2000. However, where are the tutorials I must have a proof of concept in a few days to quote this project. Can anybody help with this issue Thanks! Have you looked at Books Online for SQL Server and SQL Server Mobile ...Show All

• Stefan van der Merwe Enable and disable websync.log

  Hi, is there a way how to enable / disable logging on web merge synchronization into the file websync.log The file exists in the ISAPI folder, on some machines there are some messages, on others there is nothing. There are Timeout messages on the client during synchronization and we need to find where is the problem, if it is on the server side or if it is a network error or something else. Thanks, Pavel I dont know how you got into this situation, but here is what you can try: Check if you have this key in your registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\Replication\WebSyncLoggingOff Is this value 1 If it is, reset it to 0. Then do iisreset. That should solve y ...Show All

• Paul_Rus MDX to aggregate measure over specific dimensions

  Hi, I'm trying to write a calculated member in SSAS 2005 that will only aggregate across certain dimensions. For example, say I have five dimensions: D1 - 5. I only want the member to aggregate across three of these dimensions. So in the cube browser, when I drag these three dimensions in, I get the correct aggregated value. But when I then drag dimensions four and five in, I want this value to stay the same. (The measure is currently in a measure group that uses all five dimensions). I was thinking that the solution would be to have an MDX expression of the form ([Measures].[Measure], [D1].CurrentMember, [D2].CurrentMember, [D3].CurrentMember, [D4].[(All)], [D5].[(All)]) but I would prefer not to have to list all dimensions and their hie ...Show All

• macyp "Could not open SQLEVN70.RLL"

  "Your SQL Server installation is eigher corrupt or has been tampered with (could not open SQLEVN70.rll). Please uninstall then re-run Setup to correct this problem." What do I do It says to uninstall/reinstall, but what DO I install I need a step-by-step procedure to follow to get rid of this. In the directory C:\Program Files\Microsoft SQL Server there are probably 2 subdirectories starting with MSSQL$. One of them is empty (look in C:\Program Files\Microsoft SQL Server\MSSQL$ MSDE\Binn\Resources\1033 or 1043). Delete this subdirectory and the problem is solved. Not finding much on this one, I did see http://www.experts-exchange.com/Applications/MS_Office/Q_21754121.html tha ...Show All

• Eric H. How to: Check if a column exists, and if not, add it?

  Well, actually, as in the title. I have a table. The script should add a column if that column doesn't exist already. I use VB to combine the two queries. So what I want: Query1: Does the column exists: if No, query2: create the column How can I achieve this In SQL Server 2000 and before objects had an object owner, in SQL Server 2005 objects belong to a schema. In common, this is what you see in the already existing tables as "dbo". look in the Information_SCHEMA Tables to see to which schemas / objectOwner your objects belong to. IF NOT EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'SomeColumName' AND TABLE_SCHEMA = 'SomeSchema' AND TABLE_NAME ...Show All

• Martin Moe How to Encrypt or Hide parameters in URL

  Please help, i have been struggling for a solution could'nt able find any info. on the net. I am currently using SSRS 2000 updated with SP2. Is it possible to hide or encrypt the parameters in URL. Please help, Thank you very much for the information. are you using any front end application to pass the parameters Yes, i am using a front end to pass the parameters via URL http://servername/reportserver /ttsReports/StatusReport&eStatus=Open&UserName=myname But want to hide the parameters information completely from the URL, using SQL2K RS PLease Please Help, if any one has the info. That will be a gret great help for me. Thank you all. ...Show All