I'm curious to know if anyone has any experience with using RAISERROR from within their SQL Server stored procedures and somehow trapping the error and message from within a VB application. When an ADO control is used to execute a stored procedure and there is an error returned from RAISERROR,...more >>

Hi! After my upgrade from 512Mb to 1024Mb of RAM, my sqlserver-process is taking it all. I did not have that problem before the upgrade. The sqlserver says that it has 1024Mb. Is it something I have forgotten to do after the upgrade? Can I change the max_server_memory to 500Mb? I restarted t...more >>

How would a query be written that concatenates a string field that meets the specified criteria? Here is some sample data. I need to concatenate the ItemDesc field where the ItemNo is equivalent: ItemNo SeqNo ItemDesc 02677 001 CONNECTOR,0.100x0.100 (2.54x2.5 02677 002 4),10Vrms,1A,-55-10...more >>

Hi All, I saved "select * from xxx where id=234" query on a remote server in a .txt file. Is there an easy way to "import" the data in the .txt file to a table with the same fields on my PC ? thanks !...more >>

Hi everyone, Is there a stored procedure or any other way of getting the current date and time of the SQL Server computer? Thanks in advance, Dan...more >>

Hi, How a bit field should be stored on MSSQL 2000 server database? As a bit, byte or word? Next question - a set of bits? Thanks, Dmitri ...more >>

We have a web application that supports multiple clients. Some clients will have (not yet) about 10^9 records in a certain table, others 10^6. The idea is to make a seperate database for each client, so the small client won't suffer performance wise because the big client is accessing the databas...more >>

Hope someone can help. I am trying to write a stored proceedure to display sales activity by month and then sum all the columbs. The problem is that our sales year starts in April and end in March. So far I have been able to get the sales info my using to sp's, one that say month >3 and the o...more >>

I got an error with "not a trusted connection". what is that meaning? thanks in advance. ggg ...more >>

I created a bar chart using report services (beta 2). But I could not found a way to change the font size of the chart title, x- and y-axis title and the width of the bars. Does anyone have a solution? I searched the book online for rs, and found a message saying: "The chart control used in ...more >>

I have a table with numbers in a row from 1 to 100. But some of the numbers are missing. Is there a way in a sql statement to select all the missing numbers?...more >>

select * from table2 where Date2 = '10-12-2003 12:00:00' Using the query analyzer "Display Estimated Execution Plan" shows a table scan will occur (and running the query takes a long time). The problem is - there is only 1 index on the table, a primary index on Date2 field. To make thing...more >>

Hello all, Could someone please help me with a query that will only the highest session number for each student id given the data below. StudentID SessionNo Grade Date 19 3 3.50 2003-04-14 00:00:00 19 5 3.60 ...more >>

Dear All, is there any other (better) way to perform this kind of query? Is there a way to do this in a single query? A simple example of the situation (on northwind DB): DECLARE @OrdersTotal MONEY SELECT @OrdersTotal = SUM(UnitPrice*Quantity*(1-Discount)) FROM "Order Details" WHER...more >>

Hi, We have an application that is writing to an SQL database that has several tables which we've created. We have been testing it for a couple of weeks to see how it reacts to large amounts of data and we seem to have hit a wall here much earlier than we expected. Our database's size is o...more >>

Does this strike you as odd? If I run SELECT @@VERSION I get: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3) What leaps out at me is the "Server Pack 3"...more >>

I am currently running Access 2000 and I want to upsize this database to SQL Server 2000. I only have one table in the Access database (a very small table) when I go to upsize the database into an exist SQL Server database I keep getting an "overflow" error. Does anyone know what I doing wrong...more >>

I need to execute xp_cmdshell in a trigger and pass a command line parameter to the .exe program i.e. I have a .exe program c:\program files\savedata.exe In the trigger I have a parameter @Id bigint I need to pass the parameter @Id to savedata.exe In the trigger, I am trying EXEC mas...more >>

I need to develop a Cold Fusion application using SQL tables, I am not sure how to setup my tables or that this is the optimal way of setting my tables for the application that I am trying top automate. I've first created 2 tables as follows: SOSC ----- 1 Record ID (Primary key) 2 C...more >>

I'm a pretty new user to SQL Server 2000 so forgive me if my question is elementary. I need to create a linked table and view from an oracle database to my SQL Server db. I can create this link in Access so I figure I can do the same thing in SQL Server. I'm obviously not doing something righ...more >>

Hello, Is there a way to stop stored procedure execution upon user requests. A stored procedure is called from APS.NET page. Actually a new thread is started that calls sp, the page is then reloaded every 5 seconds and progress bar is displayed. Usually it takes a few seconds to 10 mins to ex...more >>

I detached and copied both the mdf and ldf, renamed it using explorer... I was able to attach the copied files as a database with a new name, however, the original name remains the same. Any way to change that name as well ? Can I have problems with what I have done ? Thanks ! ...more >>

I am running a VB app with Access 97/2000 backend. I need a rough guesstimate as to how much faster I might expect my processes to run if I move over to stored procedures on SqlServer 2000. Again, I'm talking rough - like 1x, 100x,1000x, just approximate - forget the variables you might be think...more >>

I am using datepart in the following manner to create a weekly group: DATEPART(wk, o.SCHED_START_DATE) AS 'GROUP_WEEK' This gives me a numerical value for the week. Is there anyway I can convert that to a date range? For instance, week 46 is the same as the date range 10/9/2003 to 11/15/2003. ...more >>

Can the group suggest any way in which I might easily transfer a SQL Server 2000 database into a SQL Server 7 instance? I understand you can't restore a SQL2000 backup in SQL7, but perhaps there is a setting to make it SQL7 compatible? Or is there a simple DTS / BCP trick I could use? The...more >>