Search results for query: *

Hi, I am running SSRS 2000 on a Windows 2003 Server. I am having trouble running reports successfully on client machines. However, I am not having any trouble running the same reports on the Windows Server 2003 where SSRS 2000 is installed. I am using a Shared Data source with Windows NT...

Hi, I have a need to renumber or resequence the line numbers for each unique claim number. For background, one claim number many contain many line numbers. For each claim number, I need the sequence number to begin at 1 and then increment, until a new claim number is reached, at which point the...

Hi there, I have a situation in which I need to do one thing if the values of a field ("ServiceCode") fall within the range of 100-299, and do something else if the value is outside this range. The problem is that ServiceCode field has a datatype of char(6), and there are some non-numeric...

Hi everyone, I'm looking for a clear explanation as to why some queries return result sets that are ordered differently each time the query is run. The result sets are the same, just the order is different. Thanks, NWChowd ====================================== "I wish that I may never...

Hi There, I am looking for where the default value for columns is stored in the system tables. I can't find it anywhere, but probably just missed it. Thanks, NWChowd ====================================== "I wish that I may never think the smiles of the great and powerful a sufficient...

Help! Using SQL Server 2000, I tried to move the master database from its default location to a data only drive, specifically, I used the MS help file located at: http://support.microsoft.com/default.aspx?scid=kb;en-us;224071 Moving the master database 1. Change the path for the master data...

I get the following error message when I try to use a view that contains 2 separate SELECT statements "UNION"ed together. Server: Msg 8618, Level 16, State 2, Line 1 Warning: The query processor could not produce a query plan from the optimizer because the total length of all the columns in the...

I am wondering if anyone can tell me if setting a database will improve the performance of a database. I have a data warehouse which is only updated once a week. I've read a few articles that allude to improved performance by setting a database to read only. Thanks in advance. NWChowd...

I am trying to gain more in-depth knowledge of SQL Server distribution statistics and how to effectively use this information, and how often to update statistics. In general, this is a nebulous topic for me, and I am looking for a clear description. Does anyone have any pointers or resources...

I noticed that my msdb database is near 2GB, and, in particular, my sysdtspackages table is about 1.75Gb. the database I inherited has only 39 DTS Packages. I am running the SQL 7.0. Is the size large because so many versions of each of the DTS Packages has been saved? Can I cut down the size...

Is it possible to easily change a default instance ("(LOCAL)") of SQL Server 2000 to a Named Instance ("WASHINGTON", for example)?? Is there really much of a difference between the default and named instances? if so, what? Thanks in advance. DMill ====================================== "I...

Hi all, I am trying to test out restoring a database from a full backup and transaction log backups. Facts: 1) I have a full backup scheduled nightly @ 3am. 2) I have transaction log backups hourly between 5am and 10pm. 3) database name: CompanyDB 4) Recovery Mode: Full 5) backups are to disk...

Hi, I cannot figure out why the Application_Error event is not firing. I simply want to send an email whenever an error occurs. I don't receive any errors. it just does not fire. The C# code is below: protected void Application_Error(Object sender, EventArgs e) { MailMessage mail = new...

within one particular BoundColumn Header, I have a need to split the Bound Column vertically into 2 sections, and then in the bottom section, I need to split again. for example: ---------------------- BoundColumn Header ---------------------- Plan a | Plan B --------------------- Is...

Hi All, does anyone know if it is possible to run both ColdFusion and ASP.NET on the same Web Server running IIS 6.0? I would think that there would be no problems, but wanted to see if anyone has any other thoughts on this? Thanks, Dennis ====================================== "I wish that I...

I am baffled as to the results that I am receiving from the following Queries: Query #1: SELECT claimno,[lineno],pidate,deneop FROM claimlin WHERE paiddate BETWEEN (GETDATE() - 11) AND (GETDATE() - 5) returns 49462 records. Query #2: SELECT claimno,[lineno],pidate,deneop FROM claimlin...

Hi All, I need to get rid of (delete) about 50 tables in our current database. However, I would like to archive the data in a csv file (just in case). I need the field names to be included in the csv file. I am using SQL Server 7.0. Can I use BCP to do this, rather than having to right-click>All...

Hi Everyone, I have a need to replace any empty values in a certain fileld with a Null value. I need to do this on the fly in a fairy extensive (for me anyway) SQL Query. here's the portion of the query I a having troubles with: ... CASE WHEN a.formcd = 'U' THEN COALESCE(c.diagcd1, a.diagn1)...

Hi All, First, I am not a network admin, and have only a general knowledge of routers and router technology. Now, I have been asked by management to begin monitoring uptime/downtime between our Cisco 1601R Router and our Application Service Provider (ASP) in Alabama. The connection is between...

I am going to be setting up a SQL Server 2000 database in the near future. I was wondering if it is optimal/advised that the data files and the log files should be stored on separate logical drives? or even physical drives? or, what is the best practice on this...