I have an environment that has 18 separate SQL server machines. When connected to the LAN I can connect to each and expand the databases tab no problem. When I try the same over a VPN I find that three of my servers will connect but on expanding the databases I get a long pause then 'No items'. ...more >>

Hello, I hope you guys can help me with a problem that I am facing... I have started the MSSqlServer service and SQLServerAgent services with a domain username and password. There are periodic password resets to this user. Security policies within the company dictate that the password for thi...more >>

I have a client who was installed improperly on a Case Insensitive Collation SQL system and have been working with this system for over a year. For them to move forward in application software versions, they will need to be reinstalled on a Case Sensitive SQL system. I was wondering if anyone ...more >>

Folks, I have the following data in a table: 4 NULL NULL 2 abc NULL 2 aaa NULL 4 xyz NULL 4 xyz pqr 4 pyz xqr I want to get o...more >>

I have a distributed inventory control database that I am going to migrate from Access to SQL Server. I am going to use SQL Server Replication to keep the data current. There will one SQL Server 2000 database at HeadOffice, and about 200 branches will each have MSDE 2000. For tables that ar...more >>

hi, guys i have query which given below output given below manager personlevel person name 2085 1 Howard Wilson1 2085 2 Howard Wilson2 2085 3 Howard Wilson3 2085 4 Howard Wilson4 2085 5 Howard Wilson5 6086 1 Andrew Saxon 6086 2 Andrew Saxon 6086 3 Ian Thompson 6086 4 Ian Thompson...more >>

Hi, Is there an easy way to determine the rate of change for table? I realize that I could do periodic select count(*) from XXX, but that would only determine the size of the table. It would ignore updates. What I'd really like to do would be able to determine the number of non-read opera...more >>

Hi, Every day we perform a full database backup. (during the night). Since we need no "additional" backups we had the problem that the transaction log file grows and grows. Therefore now just after the backup we perform a backup of the transaction log with no log. So we free up the space in...more >>

On a huge Sql-Server 7 installation, we have various client applications distributed along the Lan, accessing one main database. Each application accesses the db using one out of around ten logins. Most of them, have only DBDataReader right on the db, as they are consultation consolles only. ...more >>

I would like to access a table in MS Access from a stored procedure on MS SQL 2000. The MS Access DB is running on a diferent computer attached on the same network. I think I need to create an ODBC connection from the MS SQL 2000 to the MS Access DB but not sure. Secondly how do I refer to the ta...more >>

I have MSDE installed on my sistem, and I need to add a new user. How do I go about doing this?...more >>

Hello, I just installed MS SQL 2000 Enterprise on a Windows 2000 Server machine with 2 CPU's. After starting the MS SQL takes 2 x 100% of all CPU power. I do NOT load the DB in any way with queries. Obviously this leads to all kinds of software not working well anymore. Does anyone know ...more >>

Hi All I need to aggregate a query to produce the following: Workplace Avg M100 4.7 M120 3.45 Which would be a normal aggregate: SELECT Workplace, Avg(VALUE) FROM PROD GROUP BY Workplace However I need the average to only be based on the most recent 20 resu...more >>

I have a table in mssql7 that has 7000000 record and I want to take 100000 records out of it and place them into the new machine with mssql2000. The new machine will also have the same table name, so I want to append the 100000 records into that table. Thanks, Royal344 -- Direct access ...more >>

I have two date fields, start_date and end_date. I'd like to subtract the two dates, and come up with a number (the number of difference between the two dates). What function is there to do this? I haven't been able to find anything in BOL. Start_date = 6/1/03 End_date = 6/8/03 ...more >>

Hi there, Could somebody post some simple example how one can refer to a column in the 'deleted' temporary table within a trigger definition ? Should the 'deleted' and 'inserted' temp tables be declared, or they are 'implied' ? I keep having this msg when trying to create a trigger "The co...more >>

I have the following code to SUM based on one field but want to be able to not show rows which result is 0. ======================== SELECT Headers.employee_id AS Employee#, SUM(CASE Headers.scan_type WHEN 'I' THEN 1 ELSE 0 END) AS SIP, SUM(CASE Headers.scan_type WHEN 'F' THEN...more >>

I am creating a document management systems using asp. I have been researching the different ways of handling the documents such as using the file system and storing the path in the db, and actually storing the document in the db. I like the idea of storing it in the database much better becau...more >>

Hello, I would like to know if it is possible to create a form in Access2000, which would function like a calendar for 8 operating rooms in hospital, showing which hours are those closed for a specific date. For this intersection I would like to be appeared the name of the doctor, the name o...more >>

I have a column named "LIST" in a table with strings like the following: 151231-1002-02-1001 151231-1001-02-1001 151231-1002-02-1002 151231-1003-02-1001 etc.... What I'd like to do is include an ORDER BY statement that splits the string, so that the order would be by the second set of fo...more >>

I'm trying to do a simple update like I have done countless times before. However, when I update the empty fields in this table it places a -1 into the field rather than the enterred value. It is indexed with duplicates allowed. It says that zero lenght is set to yes. What can I do abou...more >>

1) Can one find the location of the 'Transaction Log' at: <Hard Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf? 2) Is it safe to delete it, as SQL will create a new Transaction Log when it realises none already exist? 3) When trying to do 2) I get error message that file is...more >>

Does anyone know the maximum number of CPU's that any version of SQL 7 (i.e. Std or Enterprise) can use on any version of Win 2K (i.e. Server, Adv Server, or DataCenter)? We are constrained by our app to stay with SQL 7. We run with 4 CPU's now and wonder if we can move to an 8-CPU box. Tha...more >>

Hi All, While in the process of building my table (40 or so Insert statments) can I then query ("select * from @Table_variable") and use the results up to theat point for another insert into @Table_varible? If you look for stepID -15 I have commented that section out due to it not retuning ...more >>

Hi All can some one please tell me the transact sql code that can list all tables in a db. thanks Todd ...more >>

I can't figue out whats wrong. I am a newbie to sql, however i'm totally lost. i get this error. "Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified login.asp, line 9" this is my code. <!--#...more >>

Hi, On SQLServer 2000, I have a table with a following structure: MYTABLE col1 char, col2 date, col3 number My Objective: ------------ Externally (from a command line), to select all columns and write the output into a file delimited by a comma. My method: --------- 1. Probabl...more >>

What I am trying to do is get all of the records in a table that are out of sequence so I know which account numbers I can reuse. I have a range of account numbers from 50100 to 70100. I need to know which account numbers are not stored in the table (not currently used) so I can use. For ins...more >>

Hi, Could anyone tell me the backup strategy for a 1000GB database? Thank you! Peter Wang *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

We are quickly moving from a small comapny to enterprise. As it happens we want to watch SQL server (our bread and butter is data) more cloely. Weely/daily/monthly reporting, etc. I am wondering if there is something like webtrends for SQL server. i.e. what queries were called (or even ...more >>

This may be a simple question to answer, but I don't have a clue since I'm not a dba. I am using sql server 2000, while a client of ours is using sql server 7. Both using Windows 2000 as an OS, but I don't think that means anything here. My question is, why does he have to specify the dbown...more >>

We're using SQL2000 on Windows 2000 Server, but this is a problem we've had on one particular database since SQL7 on NT4. The database in question is set to autogrow by 10% (currently sitting at 31Gb total size). However, last week users complained of a slowdown in performance. When we check...more >>

When importing data into MS SQL Server 2000 from a MyODBC (v3.51) data source using Data Transformation Services, special characters like öäüéàè are not imported correctly. However, when the MyODBC data source is used in any other program like Access, Excel etc. it works fine. Does anyone have...more >>

Folks, I need help with this task. I have a set of data that needs to be plotted on timeline chart. Example: Unit ProcStart ProcEnd Machine U1 5/5/03 6:01 5/5/03 6:04 M1 U2 5/5/03 6:03 5/5/03 6:05 M1 U3 5/5/03 6:03 5/5/03 6:04 M2 : etc. There are about 40K units and 3...more >>

Hello, I am writing an application using Visual Studio .NET (C#). The application will be run on several workstations simultaneously, and all of them will be accessing a single sql server database. I am trying to have it so that when one of the applications updates the fields of a table in th...more >>

Hi, The company I work for often develops databases for clients. Those databases always need to do similar tasks. One company might need a database to do task 1 and task 2, while another company might need it for task 2 and 3. Instead of having to redevelop each database from scratch, I'd lik...more >>