Hello, Im brand new and trying to learn SQL Server 2000, I have purchased a book and been reading it for a few weeks. I'm tring to find an ASP script that would let me know if my connection to my database is working. I use DSN, i created a DSN name "mail" anyone have any scripts? --...more >>

Hi all, Do you know how can I count the number of cubes and number of databases in SQL Analysis Services using T-SQL? Thanks. ...more >>

I have set up a query where I am using a cursor to pass result from one query to use as select parameters in another query. The problem I am having is that when I pass the results into the second query I get the column headers? How do you suppress the column headers from showing in the query?...more >>

Hi All. I'm currently maintaining 4 servers - 1 for public/customers and 3 for backups, development, etc... I regularly backup the entire SQL database for our public server and restore it on each of the other servers. Lately, however, the database backups have grown (in size) incredibly ...more >>

I haven't used triggers before, but I suppose they would solve the problem I am having. If anyone can give me some advice on this, then I would be very grateful. The problem is that I need to "sync" two tables used by two different applications. Assume, for example, that the tables are defined...more >>

Hello My sql server is running as domain admin, can i run this service as system account or should i create an account for this service?. thanks ...more >>

Hello, How to protect structures(Tables,SP,Views and Functions) of a SQL Server Database?(Password protect a database file) I have a SQL database that will distribute with my application, I want to protects it's structure from my appliction users. Only my application can access the database. ...more >>

Hi All, I'm trying to track down a mysterious problem we're experiencing in which updates and inserts to tables in our mssql2k server appear to be 'disappearing.' To explain our situation: We have a web page (written in ASP, if that's relevant) on which we accept enrollment information. ...more >>

I'm needing to move a database from SQL 7 to SQL 2000. What is the best way to accomplish this and keep all tables, data, permissions, etc in place throughout the move. Should I use BCP, Replication or something else? Thanks for any help. ...more >>

I am trying the following query in and oleDbCommand: SELECT PartLocations.LocationName, Sum(PartsJournal.Quantity) AS SumOfQuantity, PartsJournal.PartsLotNumber FROM PartLocations INNER JOIN PartsJournal ON PartLocations.LocationID = PartsJournal.LocationID GROUP BY PartLocations.LocationName, ...more >>

i am having some trouble installing SQl server Reporting Services. well, in order to install the reporting services i have to install Service Pack 3a. so through my installation of package 3a i am encoutering some trouble. i was able to comlete the first part of the installation i receive th...more >>

Hi All I am getting an access denied message when I launch the Virtual Server administration screen, however I can connect through the Virtual Machine remote connectivity without any problems. Please help, I upgraded my memory and need to change setting though Virtual Server Adminitration scre...more >>

I have 3 tables A table of users containing the fields always required for a user. users: userid email name password projectid A table of extra properties for a user that can be different from each project. These properties can be "location", "department", and so on. userproperti...more >>

We are using SQL Server 2000 database (with sp3) and recently we faced an interesting issue with full text search. According to SQLServer help page "AND | AND NOT | OR Specifies a logical operation between two contains search conditions. When <contains_search_condition> contains parenthesized g...more >>

Given the following 3 Tables: CREATE TABLE [Company] ( [CompanyID] [int] NOT NULL , [DateTimeCreated] [datetime] NOT NULL CONSTRAINT [DF_Company_DateTimeCreated] DEFAULT (getdate()), [DateTimeModified] [datetime] NULL , CONSTRAINT [PK_Company] PRIMARY KEY CLUSTERED ( [CompanyID] ...more >>

We are currently running MS-SQL2000 on a MS Server 2003 OS with 8G of memory (AWE enabled) with 4 HT processors (OS thinks that there are 8 because of the HT). We are experiencing 1 - 3 days of very slow activity about the same time each month. Processes that usually take 20 minutes are la...more >>

I'm going to simplify the tables and queries to eliminate all but the pertinent info. We have a table containing detail information on our invoices called ARDETAIL. Each line item on the invoice is included as a record, each cash receipt is included as a record and each write off is included ...more >>

I'm setting up a new SQL server. Is there a way to transfer the SQL Agent jobs from one server to the other? ...more >>

I just looked at a coworker's stored procedure and this person is dropping 4 Foreign key constraints and then re-adding them after processing the required logic (updating rows in the 4 tables in question). Is there *ANY* good reason to do this? What are the performance implications of doing t...more >>

Greetings All, I was hoping that someone might be able to shed some light on this issue. I am trying to add a FileGroup/Datafile to an existing SQL database. The code below compile and it runs in .NET Studio, however nothing happens? The form closes, no error messages are thrown, there is no ...more >>

Is it possible to take the result from an SP that returns 1 value and insert it into a variable? ...more >>

Hello, In the project I'm working on, I need to add up all rows data for one column. So, I have this code: $getprodcount = mysql_query("SELECT SUM(qty) FROM purchase"); $numproducts=$getprodcount; Later on, I have this code: <?php print $numproducts; ?> What is being printed is Resourc...more >>

Currently I have a server that has two instances of SQL Server that are both heavily used. We are moving the databases that are on the default instance of this server to a new server. Since the old server will only need one instance (the current named instance) of SQL Server is there a good wa...more >>

hi I need to add all the records being counted for all groups. I would like to add this count for each group into a total for all groups( the 8 rows). Is this possible? MSG_CD MSG_TEXT COUNT(CCHDBA.III_SYNC_RESULT.I ------ -------------------------------------------------- -----------...more >>

I'm a VB programmer creating apps to write/edit/delete data to a SQL Server 2000 database. For HIPAA requirements, I need to track all changes to all the tables in our database. I'm looking for the easiest and cheapest solution. I have no experience writing Sql Server 2000 triggers and st...more >>

I am implementing Log Shipping. I have the transaction logs copying to the standby server and applying to the standby database with no errors. However, I am having problems with the role change. I am using the following article/link as my guide: http://msdn.microsoft.com/library/default.asp?...more >>

Went looking for an answer but not really sure what phrases to look for. Just decided to post my question. I have a collection of groups which contain items. I also have a collection of users which can be assigned permissions to both groups and individual items. If a user has permission to a g...more >>

When i execute the following in Sql query anlyzer Declare @dbname varchar(30), @str varchar(500), @emailID varchar(50) set @EmailID='santosh@yahoo.com' set @dbname='DB_kms_prv' set @str='SELECT empid, NTName, officialEmail, PreferredName FROM ' + @dbname + '.dbo.tblEmployee where...more >>

What would be the correct syntax, if any, that allows updating a table variable in a statement that uses the same table variable in a correlated subquery? Here's an example: DECLARE @t table (N1 int NOT NULL, N2 int NOT NULL) UPDATE @t SET N1 = (SELECT COUNT(1) FROM @t AS t ...more >>

how to handle sql errors with severity less then 10 in .NET i call to stored procedure which raise error with severity 10 for example however in c# i can't cach this error (with severiry >= 11 it going to the catch block in my c# app), also the @@ERROR is equal to zero when severity <= 10 -...more >>

Hello Group, I am having a really weird problem... Can anyone tell the difference between Query 1 and Query 2 below? Why Query 2 excludes '2/28/2005'? Many thanks! create table a (ApplicationID int ,timestamp datetime) insert into a values(1111,'2/26/05 3:24') insert in...more >>

I have a SAP Server running SQL2000 on Windows 2003. Recently I migrated the server from a NT4 Domain to a AD Domain using ADMT (with SID Migration for users) and everything seems ok. Now, after one month, I have to shut down the old NT4 domain and before doing it I have to replace the old login...more >>

Hi. We have a .NET programmer using our SQL server. The database is roughly 8GB at this point, full of all of our inventory, payroll data, etc. for running reports. This is on a dual-xeon 3.2Ghz, 4GB DDR, 3x15k RPM SCSI RAID-5, gigabit ethernet, etc server. Yet, every once in a while it slow...more >>

I'm using the query desinger in ASP.NET , however the number of records in the resultset are not displaying, so I cut and paste it into Query analyzer which is silly. How do I set this in the output window, or result grid? Thanks Moe ...more >>

I've been discussing here a SQL 7 view which scrolls slowly when linked to an Access 2000 MDB. After trying various things, I've distilled it down to the following: when the linked view has a virtual primary key, it is slow; when there is no virtual primary key, it scrolls quickly. Looking ...more >>

I do not know SQL but learning fast and furious. I am programming an agent and working with a group of existing databases. I would like to able to compare the database before and after an update. The testing databases are relatively small. I have no problem programming some compare but how do ...more >>

Hi, I have quite a complicated request to do in sql. I've got on table with 3 fields (id, field1, field2) and I have to process a request on each of the records, one by one, and then determine if the status is OK for each records For example, I would check if the sum of field1 and field2 is gre...more >>

This is a general question regarding the use of view and stored procedures. I'm fairly new to databases and SQL. I've created a SQL database using an Access Data Project ("ADP") and I'm satified with the table structure. I've moved on to building some front ends for our users. I'm running...more >>

I use a database that has user names stored in Encrypted format using the following API. Declare Sub Encrypt2 Lib "QPRO32.DLL" (ByVal Work As String, ByVal PASSWORD As String) Every time i require the user name i have to again decrypt the name using the same function. My problem is that ...more >>

my problem is that i need to find if a user is adult or minor using a simple select query .I have the date of birth of the user and a column named isadult as well in the table but the isadult column also updates only when the user enters or updates his/her details. I even tried using a sql funct...more >>

Hi, I am quite puzzled how SQLServer manages transactions. Whatever the isolation level I set when performing an insertion, other connections do not have access to the table in select mode. Example in SQL Analyzer: create table foo ( id numeric(10), data varchar(100) ) On Connection 1 ...more >>

Hello all, I don?t often export data from a table. I am wondering how you export data from a table. I?d like to know how you export in real world. Do you export data from a table to a flat file or what type? There are many selections when you choose file type. When do you need to export ...more >>

Let's say I create a multi-statement function like this: CREATE FUNCTION dbo.Test () RETURNS @res TABLE (N int NOT NULL CHECK (N >= 0)) AS BEGIN INSERT INTO @res SELECT 1 RETURN END That works fine. Then I make a change in the function's body, replace the CREATE FUNCTION with ALTE...more >>

Could someone out there please help me to answer these questions? Thanks in advance. 1. What aspects of SQL Server allow it to reliably scale up to support a large global enterprise? And, when does SQL Server reliability begin to fail? 2. Given a role-based security model and withou...more >>

Hi, I am running SQL Server 2000 on a machine not connected to any network. Can someone please give me a step by step instruction on how to setup SQL Server to send emails? I can send email through IIS in my ..NET application but I am also wanting to send emails from a stored procedure. I ...more >>

Dear all, On Win2000 server with SP3, I am trying to access a SQL Server 7.0 database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO 2.7. In SQL Server Enterprise Manager, there is a login named "Tester". In its property window, NO "Server Roles" was assigned but its "Database...more >>

I have a table that has two dates in it, a date opened and a date closed. I would like to create one query to give me the number of records that have been opened each month plus, and this is the hard part the number of those records that have been closed each month. I can get the result with t...more >>

I am trying to import a password-protected Excel file into SQL Server using DTS. I am getting an error that it can't decrypt file. Does anyone know how I can pass the password to the file during the DTS execution. Please help. Thanks, Michelle ...more >>

Suppose this is the table data: col1 col2 col3 item1 3 aa item1 2 bb item1 5 aa Would it be possible to get something like this output: item1 10 2 where col2 was summed and col3 had the numbers of aa's counted? that is, select col1, sum(col2), count(number of aa's in...more >>

Hi, I am trying to use BULK INSERT with format file. All of our data has few bytes of header in the data file which I would like to skip before doing BULK INSERT. Is it possible to write format file to skip these few bytes of header before doing BULK INSERT? For example, I have a 1 GB...more >>

I don't know if anyone can help with this, I've got replication running between 2 SQLServer installations, the distributor is on the the same server as subscriber. Replication is a once a day snapshot and all has been working well until recently. I needed to make a change to the replicatio...more >>

Is there any better way to debug a query encased in IIF statements than to find bugs at runtime? I have an especially ugly CommandText for one of my datasets, and debugging it when there is an error is nearly impossible. I realize that it's much cleaner when you have straight SQL, but otherwise ...more >>

I need to run a stored procedure on all the results of a select query. For a simplified example, I'd like to be able to do something like this: SELECT JobID, QtyToAdd FROM Jobs WHERE QtyToAdd > 0 Then for the results of the above: EXEC sp_stockadd @JobID, @QtyToAdd Where the above ...more >>

Hello, I have a server running Windows 2000 Advanced and Sql Server. The systems runs fine throughout the day but reboots at night, somtimes multiple times. The event log has a message that reads "The previous system shutdown at X:XX PM was unexpected." Any ideas? Paul ...more >>

I just resolved a strange situation I was having with an ODBC linked SQL 7 view in an Access 2000 MDB file, and I'm trying to get some understanding as to what happened. The linked view was scrolling very slowly in the MDB file; however, it scrolled very quickly when accessed through an ADP...more >>

hi, I'm building a simple search engine using keyword and title of a page: select ID, content_ID, 3 as 'weight' from tblPage where keywords LIKE '%test%' union select ID, content_ID, 2 from tblPage where title LIKE '%test%' now I want to sum and order 'weig...more >>