When using SQL 2000 personal desktop (i.e MSDE) on win 98 Machine with our VB6 application we sometimes get this error [Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: Provider DLL failed to initialize correctly. On Win2000/20...more >>

Hi All, There is some additional info I forget on this same topic I just posted. I have a database design question, pls give me some help.. I want to define tables for salesman's sales target commission . The commission could be given per EITHER sales amount of : Group of Products OR Group...more >>

Hi, I restored a database 2 months ago. After the restore, I lost all my "users" for that database. It has been a while, so I don't remember the detail of what I did. How can I reserve all the users when restoring a database from a file? Did I do something wrong? Thank you in advance, Edd...more >>

I have a table that contains the following: Job Number Contractor Name Bid I would like a query to return the lowest bid and the corresponding contractor for each job number. Can anyone help? I would greatly appreciate it. -- -- Karl A. Homburg Electrical Engineer U.P. Engineers & ...more >>

I have inherited support for a database with many used tables. There isn't any documentation on what is used or dead. I was hoping to run traces and capture the objectid but the property doesn't work that way. Any good ideas would be appreciated....more >>

I am trying to copy updated tables from a DB on a remote SQL server to my pc using import wizard. I choose "copy objects and data between SQL Server databases". On the screen "Select objects to copy", all of the options are unchecked/blank including the script location. Clicking "select objects"...more >>

Hi, Do any versions of SQL Server support the following functions, as they appear in the Oracle Database:- 1) XMLElement 2) XMLAttributes 3) XMLForest Thanks in Advance for your reply Bye Amardeep Verma...more >>

Hi I have a procedure that calls a view. The view is built with some outer joins but it performs fine. If I run in Query Analyzer select count(*) from long_name_view where name_id = 'AAA' it returns instantly The procedure has the same code. I juststripped down the code to narrow ...more >>

Can anyone give me some sugguestions here. Connection is declared at the start of the application Set rsFZReport.ActiveConnection = conn Then a function repeatly opens recordsets like this - rsFZReport.Open sRS, , adOpenStatic, adLockReadOnly, adCmdText .. .. reporting code etc ... ...more >>

I am new to the database. I have a user table. Currently, when I open this table thru Enterprise, I can see all passwords and usernames. Is there anyway I can make this table more secure? Any tips for handling user table will help....more >>

Hello Group Ok, I've read the BOL topic on sp_adduser and have done some research here in the groups but the 'why' question remains... A simple thing: I would like to empower 'User A' to be able to add logins and users to database 'ABC' so I don't have to do it. Let's assume I'm far away o...more >>

hi can anyone tell me if the order of the update staments on multiple tables can have an effect on deadlocks on a transactions. for examples if i have a dog -> dogid colorid breedid name color-> colorid color breed-> breedid breed would it make any difference if i update the breed table ...more >>

I have a big table (heap)... well, not so big, I have a small server and I want to spread access to it across several new disks dedicated only to that table. I known its possible to do that creating a clustered index with "ON filegroup" option but I want to maintain it as a heap, is there any ...more >>

Hello, I'm writing a prototype for a web application. The architecture is SQL <--> IIS (<-->Browser). SQL <--> IIS are communicating through ADO ASP components on one hand, and stored procedures on the other hand (no direct access). I'm not sure if for this phase I should add an application se...more >>

It's arriving from ebuyer tomorrow for 32 quid. I already have an instance of MSDE running on the laptop and ideally i would like SQL server to be installed and use the current instance and not install any other additional services. [hope i got my terminology correct here.] Basically all i would...more >>

Anyone support a config where you have an unix/linux (AIX here) ODBC client connection to SQL Server database? I am looking for a simple, supportable configuration that does not require me to learn perl or instal a bunch of crap gnu shareware on enterprise class machines. Please help!...more >>

Hi everyone! I am working with Delphi v7 and MS SQLServer. I am trying to insert data in a table with a SQL sentence. Some of the fields of my table are type char or varchar, and they can have null values. ¿What do i have to write in the SQL sentence to insert a null value in those fields? I...more >>

Hi, Need help in optimizing a query in SQL Server. Following is the problem statement. There are two tables; 1st table (t1) has a KEY ( char(8) ) column, with a clustered index. this is not the primary key. The table can have billions of records; in test environment, we are having 3,000,...more >>

Hi, I'm stuck on the following query. Any help would be greatly appreciated! table1: Customers uid, name 1, bob 2, jane 3, john table2: Purchases uid, custID, datepurchase, item 1, 1, 1/1/2004, mouse 2, 1, 1/2/2004, keyboard 3, 1, 1/3/2004, usb key 4, 2, 1/1/2004, mouse 5, 2, 6/19/2...more >>

Hi I currently have a problem with registering a new server in my Enterprise Manager on a new PC. I need to connect to a MSSQL2K server on a windows 2003. My current PC is on the same LAN as the server and has no problem registering the server in Enterprise manager. This PC uses NT (about tim...more >>

I've upgraded MS-Access 2002 to a MS-Access Project (adp), so now I have to deal with more sophisticated queries (may I call them so?) like stored procedures. I have a form with a combobox for selections and a textbox to enter a certain value. Let us say I call the combobox @select and the textb...more >>

I have 2 databases, one that we use called MyShop and one that I develop on called TestShop. After I have a stored procedure working the way I want in TestShop , is there a way to just copy the SP to the other database without the copy and paste method?. Same if I have a new table. Any way to a...more >>

Hi, Has any one ever compared the performance of calling a DataTable's Select method with a stored procedure doing the same thing? My point is: dataRows = DataTable.Select(filter) is better or Passing paramters to stored procedure? The datatable holds about 500-700 rows at any given tim...more >>

Hi all, I'm building an ASP app on a Windows 2000/IIS machine which interfaces with our SQL Server 2000 database via OLE DB. Since we're based in the UK I want the users to be able to type in dates in UK date format to input into the database. In Enterprise Manager on the SQL Server I can ...more >>

Hi. I would like to setup a job that monitors other jobs and will fail (so I can receive an email/or see it in the Event Viewer) when any of these other jobs have not completed after running for a set duration. Or more precisely, I would like to check if one of my existing jobs have freezed, ...more >>

Help, I have a database that has a data file of 2GB and a log file of 31GB. In enterprise manager, when I choose shrink it says there is 30GB of unused space. When I shrink the database, it does not shrink, (however it says it has completed). I've done a complete backup, tried shrink again, n...more >>

Hi, I'm trying to run a select statement that takes includes an if/else clause. I need to select the 'tran_date' between.... if the current month is greater than 10 i.e. after OCT then the tran_date will be between '01-Oct' - plus current year or the tran_date is '01-Oct' plus previous yea...more >>

I'm trying to get the machine free ram value using either T-SQL or SQL-DMO. I found .Registry.PhysicalMemory which takes care of the total ram but I still need eithrt the free or the used. Any ideas? Thanks! ...more >>

Hi, does someone know how much memory a user session takes on a SQLServer database server? How many concurrent user sessions can a normal server (4 GB primary memory) handle, before connection pooling is needed? /Fredrik...more >>

Can anyone help me understand what it takes to define a Linked Server connection to an IBM eSeries (AS400)? Do I need Microsoft's SNA Server or some other product or can I simply do it with the tools provided with SQL Server 2000? Any guidance would be very appreciated. Thanks. Farid ...more >>

I want to use System Monitor to moniter the performance of SQL Server. My SQL DBA book tells me how to add counters to system monitor. But the book shows a Performance Object called SQLServer:Databases. This isn't appearing in the list of Performance Objects on my computer. How do I get the SQ...more >>

I can't get my head around this: I want to select all IDs from table A that do not have a related record in table B according to some condition: Table A contains, say, Parents and table B contains Children. I want to select all Parents that have no children called "Sally" (this is a nodd...more >>

Let's say I have a type hierarchy: (just an example) the general entity customer: CREATE TABLE customer(customer_id int, customer_name varchar(250), customer_type int) three specific customer subtypes: 1 - business, 2 - home, 3 - university represented by the following three tables (be...more >>

"Do something for each row of the query" The only way I know is: --- declare @C cursor set @C= cursor for select F from T where ... declare @F int open @C while 0=0 begin fetch next from @C into @F if not(@@FETCH_STATUS = 0) break exec myStoredProc @F end close @C deallocate...more >>

Hi Few questions more newbie kind of things hope you can help out: 1- SQL 2000 on Windows 2000 ( and XP ), how can I utilize performance monitoring tools on a daily basis to detect workload, usage and keep it in a text file as a base line. What are thye most important parms to set? Is perf ...more >>

I know passing table/column name as parameter to a stored procedure is not good practice, but sometimes I need to do that occasionally. I know there's a way can do that but forget how. Can someone refresh my memory? Thanks. Saiyou...more >>

Ok, I'm a beginner so forgive me for my ignorance. Could someone help me with this? tbl_x has two fields xid and xlist xlist being a list of numbers.....1, 5, 6, 8 i want to create a new table from tbl_x that converts each number in that xlist into a row in tbl_new so for example tbl_x...more >>

I'm working on a website remotely through a VPN and my client uses SQL Server. There's a requirement for a database and my client uses SQL Server 2000. Is it possible to administer this database remotely, just like I do with MySQL/PHP MyAdmin? Please elaborate. Thanks, Marjorie...more >>

Hi, there are functions YEAR, MONTH, DAY ... in the MS-SQL for extracting of year, mothn,... from date data. I cannot find anything analogous for extracting time part. Like year(1999-12-30 13:00:00.000) = 1999 time(1999-12-30 13:00:00.000) = 13:00:00.000 or if I'm more demanding hour(18...more >>

Hello, I have the following problem; In my application I have certain items that have properties. Item Property --------- ----------------------- ToyBear Hairy, Soft, Brown ToyCar Brown, Plastic, Wheels To...more >>

I have a question...say I have an asp app that works as a front end to an sql server 2000 database. Would it be better, performance wise, to seperate the webserver from the sqlserver or to have them on the same machine? -Jim...more >>

Information: Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 Server Enterprise Edition. SQL Service pack is 3a. Member of domain ABCDomain. Server A is going to function as a Distributor. Location: New York. Server B: SQL Server 200...more >>

Let us suppose that I have two similar databases and need to create an sql-script upgrating one database structure to another. For example, these databases are from different versions of some software, first is from early version, next is from current, and second one contains several new tables, ...more >>

We use an oracle database. I want to select adress, postal code en city from the table 'subject'. But those fields are not allways filled. If they are empty, there is allways an unique adres number. This number can be matched with the table 'adress'. So if the fields 'adress' 'postal code' and '...more >>

I am having multiple threads in my c program to execute same procedure with differnt parameter values every time. I have created different functions to execute the same. However when SQLExecute is run on one of the thread it returns an error saying [Microsoft][ODBC SQL Server Driver]Connection ...more >>

I'm using ms access 2000 .adp file, and tables on sql server / msde. On the menu there's a backup option. It creates a file with a .Dat extension. How do I take the Dat file and restore data? This news group has been real helpful-- thanks. ...more >>

I'm fairly new to sql. I've got a database that all I want to do is view some records from some tables. But the thing is, I do not know the table names or their relationships. I've got access to the database thru query analyzer. Can someone assist me in gettign the correct statements ...more >>

Hi, I am trying to convert string entered in a field to uppercase using its formula property. I know it can be done using trigger but still I want to use formula property to achieve the same. Any help will be greatly appreciated. -Max...more >>

Hi, I am having a problem with IDENTITY_INSERT command with MSDE 2000 (ADO 2.8) in that I cannot insert a specific value to an identity field. (lines below with >>> are code lines. I am using Python, but the syntax should be about the same as VBScript) First, I create an ADO Connection an...more >>

Hi all. Does anyone know of any good DTS tutorials? I am relatively new to this and will need some help getting started. Thanks in advance! --James...more >>