Answer Questions

• ReneeC Expression Data Type Conversion

  I am getting the following error in my report. I am tring to program the BackgroungColor Expression so the if the value is null display a blue color else leave it white. Conversion from string "" to type 'Date' is not valid Here is my code sample: =Iif(Fields!ReturnTime.Value = "" , "AliceBlue" , "White" ) Hi RayClark, You cannot compare a string with a date. You can do this in several ways here is one: =IIF(Len(Fields!ReturnTime.Value)=0, "AliceBlue", "White") Use the length function to check the length of return time. If it is 0 set it to alice blue else set it to white :). http://jhermiz.googlepages.com Thanks that worked ...Show All

• Tecumseh How to locate the database folder in sql 2005

  We want to locate the database folder/files (where the databases are stored) like SQL Server Management Studio UI does, when you click on attach database / Add. The question is how to retrieve this folder/files programmatically (C# or VB, SMO ). For example we want our application client to connect remotely to an SQL Server and attach a new database, using the folder/files obtained from the retrieved method. We tried profiler but we didn't find something to help us. Thank you Anyway. Remove the WHERE clause and get a list of all databases attached to the server, and their locations. SELECT    name,    physical_name FROM sys.m ...Show All

• asiaenforcer Standby reporting server

  We have a process wherein the production DB is replicated to a server.subscriberA nightly and then a job processes the database for reporting services. Whenever the job fails we have to redo the process all over again. By the time we are finished it is already late in the day and our customers dont like it. Our solution for a standby server is as follows: 1. create another server.subscriberB and start same process from server.subscriberA. So, both servers are replicated from the Production server but SubscriberB is set to run half an hour delayed than subscriberA. The purpose is that should subscriberA process fails, we still have subscriberB. Then we could just change the datasource of the reports to subscriberB 2. replicate subscriberA.R ...Show All

• tlc660 Syntax issues with UPDATE in SQL2005 Table-valued functions

  I am trying to make a simple mod to a table based on a select and keep getting a syntax error - problem is I can;t see it!! I think I may be going Mad...........Code is: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER FUNCTION [dbo] . [fncunprinted] ( @Start datetime ) RETURNS TABLE AS return SELECT dbo . frclients . [Name] , dbo . frclients . Title , dbo . frclients . Inits , dbo . frclients . Addr1 , dbo . frclients . County , dbo . frclients . Pcode , dbo . orders . Printed , dbo . orders . Orddate FROM dbo . frclients INNER JOIN dbo . orders ON dbo . frclients . Account = dbo . orders . Account UPDATE dbo . orders SET printed = 'Y' WHERE ( dbo . ord ...Show All

• CodemasterMM Remote conflict viewing

  Is there a way to view replication conflicts remotely without System Administrator privileges in SQL Server 2000 You can connect to the remote publisher server from SQL Server Management Studio and Right click on the publication and select View Conflicts. query the tables conflict_tablename to get this info .... ...Show All

• DarrelC SQL 2000 CALs on SQL 2005

  Hallo are CALs bought for SQL2000 valid for SQL 2005 We're going to move the database servers from 2000 to 2005, and would like to know if we need to buy new CALs too. thanks no, if the CALs aren't under the Software Assurance Program. We shall buy new CALS. ...Show All

• AAG Indestructible stored procedure

  I want to describe step by step what I want to do, what I am actually doing and what comes out of it in SQLEXPRESS. I managed to create a few stored procedures. Now I changed my mind on one of them. The idea I tried did not work, period. I want to modify it. The Object Explorer offers me this chance. I go to my database: hist_O for simplicity sake, click Programmability-->Stored Procedures--My Stored Procedure and then say: MODIFY. I see (much hated already) my stored procedure in the lookup window on the right. Its name is CreateTableO . It is not what it is suposed to be and I want to change the content. A sensible way to go about it is perhaps to click Ctrl+Shift+M . I do it and get a parameters window. I see Specify Values For Te ...Show All

• sourvil How ChunkData is Serialized?

  Hello, everyone! I wanna ask a question. You know that SQL Server 2005 Reporting Services creates a ReportServer database in the database engine and there is a table called dbo.ChunkData. I once saw in a webpage that the [Content] field of dbo.ChunkData is not encrypted but serialized. I wanna know how it is serialized and how I should deserialize it in C#. Looking forward to your reply. Thanks! ...Show All

• theTroll527 Energy Policy Act of 2005

  Hello, Does the Energy Policy Act of 2005 affect SQL Server 2005 and SQL server 2000 running on windows 2003 sp1 and windows 2000 sp4 respectively... Thanks in advance. Thanks for your reply! There are the products affected by DST Legislation. If you post your question on OS forum and keep your OS in compliance it should not affect your SQL, but please check with OS folks. Windows Client Windows Server Windows Mobile Windows SharePoint Services Microsoft Exchange Server Microsoft Office Outlook Microsoft Dynamics CRM Entourage Please contact your CPA for more information Sorry for not being specific..I just wanted to know if ...Show All

• feby bulk load change in 2005?

  I have a dts package that does some bulk load operations without a problem in 2000. When trying to convert them to SISS or trying to run the same dts package against the a copy of the database (in 2000 mode) running on a 2005 server I get Bulk load data conversion errors (truncation) for row xxxx.... Has the bulk load process changed in 2005 My Sproc is using a bulk insert command with a fmt file.. CSS stands for Customer Service and Support. It used to be called PSS. What is CSS I have cleaned up my data and got the import to run successfully. Is there any way to relax those checks I was under the assumption that running a database in 2000 mod ...Show All

• DavidAWinter Deployment

  I'm working through Ch 3 of "SQL Server 2005 Reporting Services Step by Step" by Stacia Misner, published by Microsoft Press, but I can't get the example report in Ch3 to deploy. I get a long error message, which says this: TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Repor ...Show All

• Mark Benningfield Error when attempting to backup to a second disk file

  In SQL Server 2005, via the GUI, I wish to backup a database to an additional disk file (there is already an existing backup disk file for this database), so that I can have more than one backup. I've added the new disk file name, highlighted it, and clicked OK. I get an immediate error (see below). Note, the 2nd error message is specifying the existing backup disk file, not the new one I'm attempting to create. "Backup failed for Server 'WCS-DEV-TPA'. (Microsoft.SqlServer.Smo)" "System.Data.SqlClient.SqlError: The volume on device 'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\WCS_ADV_Longmont.bak' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. (Microsoft.S ...Show All

• DreamingBear Unable to register SQL Server 2000 Database as Publisher to SQL Server 2005 Distributor

  Hi Guys I am in a fix now. I have managed to install SQL Server 2005 on an Win XP prof. SP 2 and configured the same to be only a Distributor. I have an existing server with SQL server 2000 SP 3 installed on a Win 2K SP4. I have managed to register the server as a remote server on the SQL Server 2005 and am able to connect to the database. I have also managed to register the SQL 2005 server on the SQL server 2000 but it give me the error "You must use SQL Server Management Studio or SQL Server Management Objects" . How to fix this The second problem I am having is in order to start the publication I need to put my SQL Server 2000 as a publisher on the SQL 2005 server. However I am getting this error message :- ...Show All

• zenox sort_int in tempdb

  Hi: Can anyone explain why I am seeing the following in my tempdb db. This transaction has been open for 3 hours and it took my tempdb log space. I had to kill the spid to rollback the transaction but i was wondering if there is a worka round to solve this. A input buffer on this spid showed a sproc being called and I am wondering if my select statements in the sproc were not using correct indexes and thats what might be causing this. Can anyone from the community please confirm. Transaction information for database 'tempdb'. Oldest active transaction: SPID (server process ID) : 112 UID (user ID) : -1 Name : sort_init LSN : (128:150438:113) Start time : Jul 30 2006 9:50:55:503AM Thanks AK ...Show All

• class How to subtract previous value of one column from current value of another column

  I have a table like this: Bottom Top 0 2 4 6.5 9 14 1 5 17 In Transact SQL I need to calculate the difference between the current bottom and the previous top. If there is no previous top, then the result would be the current bottom. So, the result would be 0, 2, 2.5, 1 I must return the value in a table. Thank you all for your help! Karen   Louis Davidson wrote: What do you mean by this   Does the code not work   Why wouldn't the code be static   No problem saying something is wrong but please substantiate, otherwise you are just being negative. Just b ...Show All