Has any body done the porting from oracle to sql server, what were the issues in porting the data bases? Also suggest some resources which can be helpful in the porting project TIA Golu ...more >>

Is anyone here successfully running SQL Server 6.5 in a Windows 2000 Server?? We tried to and had some runtime problems relative to tempdb. ...more >>

Greetings All, does anyone know if there are licencing considerations involved if I just want to install MSSQL clients and tools? I need to connect to a MSSQL database server out on the network and I want to used Enterprise Manager, however my boss says that you may need to pay for licensing? ...more >>

Hi I have written following stored procedure but it take way too long to complete. I will be processing thousands of records and it is slow. I am importing data from a source table and adding logic and then inserting into another table. Any help with speeding it up will be highly appreciated. ...more >>

I'm considering adding domain integrity checks to some of my database table items. How does adding such constraints affect SQL Server performance? For example, I have a simple constraint that restricts a couple of columns to having values within the values assigned in my application by an ...more >>

I am trying to move data from SQL server table to a table in DB2 on Z/os. I keep getting a message that the function is not supported. How can I move data from sql server 2000 to db2 on os/390 could anybody please help ? Thanks ...more >>

Hello, I hope you can help me. We have a SQL Server 2000 database at work, (which works with a VB6 frontend) which grew to a considerable size, so one of my past colleagues sent me this truncate statement to use on the database. I ran it like this, and all appeared to be well, it shrank the...more >>

hi! I am having some timeout issues. I am running sql 2k with 3gig available ram. I did a 600,000 record delete on a table that gets written to by the active/production application and my application timed out when it was doing the delete. why did stored procedures that ran fine befor...more >>

where in sys tables does one find field property comments. neeed to query them. tia, mcnewsxp ...more >>

I am trying to build a merge replication. I created publisher and distributer at the same machine. I created PUSH Subscribtion. However, I am getting an error from Agent "The process could not connect to Subscriber 'MARSHWREN'." and from Data Source "Login failed for user 'NT AUTHORITY\ANONYM...more >>

I've installed and unistalled SQL Server 2000 and MSDE on my computer as I needed it (my machine is a development machine). I've tested SQL Server B2 and then uninstalled it, now when I try to install SQL Server Express B3 I can't get the client side tools to install (the command lines). The se...more >>

Hello, I have 2 tables, software and waretype. The waretype table is a simple table with 2 fields wareid and warename So the table looks like this wareid warename 1 shareware 2 trialware 3 donationware etc etc The wareid field in abov...more >>

Hello All, I am not a SQL Server expert, but I have been put in a pretty precarious situtation and I am close to panicking :( I have need to restore a SQL database from backup (through Enterprise Manager). The database got corrupt and I detached it, then was unable to attach it again. I cr...more >>

Hi, Is it possible to install Enterprise Manager without to install the server ? Thanks ! -- J-L M. (Alphomega) ICQ: 149635116 Pour m'écrire, cliquer le lien ci-dessous http://cerbermail.com/?G5iYdBb2Ce ...more >>

On quick observation, it seems to me DTS has a strange way to interprete File System. ENV: NT OS, SQL Server 2000. When a data import package (source point to c:\XYZdir) is executed at EM level, sql server seems to think the "c:\XYZdir" is the current user's "c:\XYZdir", however, if the same ...more >>

Hello, A script we run against the database as part of the upgrade of our product is failing with the following message: ALTER TABLE ALTER COLUMN EncodedID failed because STATISTICS hind_61_3 accesses this column The line that fails is: alter table Badge alter column EncodedID nvarch...more >>

Hi there, Got a small tech support problem. We gave our manual writer an installer that should install SQL Server (MSDE) and our software. Over the phone I've managed to ascertain that SQL Server is installed (it is running as a service, along with SQL Server Agent), but it does not sho...more >>

Hello all, I have a database with trade information. I have written a stored procedure (code at end of post) which pulls trades from a range of dates. There is a field called "Match ID" which is used to group together trades. Now, I need to modify this SP so that it pulls trades in the date...more >>

Hi All, I use DTs Wizard to import a text file into my MS SQLServer 2000 every month. This text file contains 236 text fields and it's format never changes. The problem that i've found is that the DTS wizard sets each of the destination fields to varchar (which is fine) but the size to 8000...more >>

Hi, How can I modify table with publication (change of one column length) without completely breaking replication. Thanks in advance...more >>

Ive been playing with this for a few days and thought I might thow it out for seggestions. I have Several Queries that need counts returned The Queries are Mutually Exclusive meaning whatever Query they return in first they cannot be included in the counts of any queries below them. This...more >>

Hi! I have a SQL 7.0. The backups created by maintenance plan worked very well before someone shut down the server to do some server maintenance. After restart the server, the backup job is not working any more. All the backups created by maintenance plan are not working, including the newely cr...more >>

Hello everybody, I have a file with several asp functions where some depend on others. Some of the functions I will need to transform a string value. How can I include these functions in a stored procedure? (in Sql Server 2000) Do I have to add all the functions as userdefined functions? ...more >>

We are considering migrating a large piece of VB code from Access to SQL server. All the code is in DAO, are there any known incompatibilities WRT SQL server and DAO? Many thanks Si...more >>

Hi, i am having a strange problem running memory intensive queries on SQL server. I am doing an update on a table with 9 million records from another table with 50 records. the query i am running is update table1 set var1 = b.var2 from table2 b where key1=b.key1 this query hanges ...more >>

We have a 10 digit primary key value in this format: M000123456. The order for this key is first determined by positions 3 and 4 in this example, then positions 1 and 2. So a brief sample of correct ordering would look like this: M000001501 M000011501 M000021501 M000001601 M000011601 M000...more >>

SQL Server 2000 SP5a on Windows 2000 SP4 Friday morning we discovered that we no longer have sysadmin privileges. We were able to query the syslogins table. In the output we can clearly see that our accounts do have the sysadmin privileges, since there is a 1 in that column. But yet we do n...more >>

MVP's and the like I am looking for suggestions , confirmation Let me start by saying bar none, performance is paramount with the queries to be retured off this view/table query. To that end I am completley donormailzing the data into a view (or a table) with all possible legal combinatio...more >>

I have a system that basically stores a database within a database (I'm sure lots have you have done this before in some form or another). At the end of the day, I'm storing the actual data generically in a column of type nvarchar(4000), but I want to add support for unlimited text. I want to ...more >>

Is there any similar tool that provides more helpful debugging info than SQL Analyzer? When one write hundred and hundres lines of code for some heavy duty task, it's almost inevitable that typo and the like happens, so, easy INDENT and LINE NUMBERING is very helpful for a tool. TIA. ...more >>

I have been using the following query to identify the IDENTITY columns in a given table. (The query is inside an application.) select column_name from information_schema.columns where table_schema = 'user_a' and table_name = 'tab_a' and columnproperty(object_id(table_name), column_name, 'Is...more >>

Hello, could anybody write me how to write an implementation "xor" association ( used in UML ) in sql ?...more >>

Hello to all: I want to get the output from xp_msver through ExecuteWithResultsAndMessage2 SQL-DMO and perl. This is the script I've got so far. Can anyone give me a few more pointers? use strict; use Win32::OLE 'in'; use Win32::OLE::Const 'Microsoft SQLDMO Object Library'; ...more >>

I have two tables MEMBERS Index tableindex Name ..... PROJECT Index Name I want to select data from PROJECT where a member is listed in MEMBERS table. Example: John is member index 5. He is a member in several PROJECTs select * from PROJECT where (MEMBERS.index=5 and M...more >>

I want to create a stored procedure that returns a list of records from a table. But depending on a userID value given only certain records will be returned that they have access to. I think this might be hard to do in a single SELECT statement because the user might also belong to a group tha...more >>

I have a hierarchy of menu and sub menus setup using this table: CREATE TABLE menu ( id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(30) NOT NULL, parentID INT NULL --Null If Root Menu ) I want all sub menus to be deleted when a parent menu is deleted. I wasn't abl...more >>

I need a little help here.. I want to transfer ONLY new records AND update any modified records from Oracle into SQL Server using DTS. How should I go about it? a) how do I use global variable to get max date. Where and what DTS task should I use to complete the job? Data Driven Query? Tr...more >>

Hi, I've managed to get a couple of shortcuts on my desktop that log me right into SQL Query Analyzer for whichever particular database I want (using the isql.exe command line options). Now, I want to do a similar customization for the SQL Server Enterprise Manager. I want to be able to ope...more >>

Is there a way to execute a script at login to check to do some additional security checks after authentication? Thanks, James Brake ...more >>

Hi, How can i import multiple accessfiles in sql server 2000 by using a dts package? The dts package should import files with the most current date in a directory (not today's date). The date can be found in the name, e.g.: <companyname>_20041214.mdb. Also i would like to use the company...more >>

Hello, We maintain a VB6 front-end application using an Access 2000 database. All code and forms are in VB6. The program also uses several queries/reports defined in Access. For corporate reasons we must move to SQL Server right away. Based on our configuration, we're hoping someone can give u...more >>

I have Enterprise Manager on my local machine. For the last twelve months it has been connecting without problem to my online SQL Server database provided by my ISP. Three weeks ago the ISP applied some sort of extra security arrangements to their SQL Server to allow access only through port ...more >>

Using the Query Analyzer, I issued the statement "EXEC xp_sendmail 'anyone@hotmail.com, 'Test.'" and received 'email sent' confirmation. But, my email was never received. I used the same statement to send mail to a Yahoo account and it was received. Is there a way to be able to send email u...more >>

I'm constructing a menu in a SQL Server database. Each menu can have sub menus. So my table looks like this: CREATE TABLE menu ( id INT NOT NULL IDENTITY PRIMARY KEY, name VARCHAR(30) NOT NULL, parentID INT NOT NULL /*ID Of Parent Menu -1 If Root*/ ) IS there a way of placing a ...more >>

Hey there, I'm curious about MySQL. Could anyone quickly summarize the differences between MySQL and SQL Server and outline why someone might pick SQL Server over MySQL? (Please post replies here, email address is fake) Cheers, Geoff Glave Vancouver, Canada ...more >>

Hello, when I export data from a table to a text file, I get trailing spaces if the data type in char. (This dosen't happen if the data type is varchar). I can get rid of the spaces by using the trim() function on every signle column. here is an example: DTSDestination("first_name") = DTSSource...more >>

Hello- I am trying to audit values between 2 different databases. ie: We send out dividend checks every year, and it is based on how much our customers spend with us. Therefore, once a year we allocate our profits to the customers by dumping customer information from the billing databa...more >>

I have a SQL7 database that was installed as case-insensitive. /* Sort Order = 52, Case-insensitive dictionary sort order. */ This database contains a table that has a varchar column which contains data such as: 'JUDICIARY; EDUCATION; Subcommittee on Justice and Judiciary' 'Subcommittee on ...more >>

How is it possible to tell which version of ADO is installed on an XP workstation? Thanks...more >>

Hello group, i am relatively new to SQL-Server database, but i have lots of experience with DB2 and Oracle Database. One of my tasks is setting up a replication between a Mysql-Database running on Linux and one of our SQL-Servers. How do i achieve this ? If i understand the documentatio...more >>

database replication: if I replicate a database and I update a record on Server_1 at the sametime I update the same record on Server_2 what would happen ? Thanks Tom ...more >>

How can you tell which datatypes in a given database are user defined (with a query, not by looking in Enterprise Manager)? This is for SQL Server 2000. ...more >>

We seem to have developed a memory leak in our sql server application and are getting the above error on occasion. Also, over several hours of hard usage the memory consumed by the sql server ramps up and is never released. The only thing we have found to remedy the problem is to stop/start sq...more >>

I've got a new server with Pentium4 xeon processors. I've used sp_who2 for quite a while on my old server -- to look at CPU and IO usage. On the new server, the CPU times are huge -- although actual performance is quite good. I know sp_who2 is an undocumented proc. Has anyone experienced thi...more >>

My application fetches a batch of data through a web service and writes 1000 entities per batch to a SQL Server 2000 database. There are 4 tables in every batch. There are the following number of SQL commands executed per average of every batch; Table #1: always 1 Table #2: 5 Table #3: 5 Ta...more >>

I have a table named Holding_Value that has several fields in it among which are UID, fkHolding, EffDate, Units, MarketValue, AssetPrice. UID is an identity field and fkHolding is a foreign key to a different table. EffDate is the the effective date while units and marketvalue are values stored ...more >>

Below is the statement i am working with and i am trying to figure out how to have the count in ascending order...is this possible? Right now it groups by FP in alphabetical order but i dont want that i want the whatever the FP1 count is to be ascending but i am not sure how to go about doing th...more >>

Hey all, I'm having this weird problem on my Windows 2003 Server machine.. Whenever I open two connection pages in Query Analyzer, then close one of them, it locks up and I have to kill the task. I read a posting somewhere that said this could be due to an MDAC installation problem, but I...more >>

Hallo All, I'm making in my DB some logs. I have a separate table containing: ID, Date, Source, Type, ErrorNo, Description Acctualy the table struct is not immportand that's why I do not post the script. I have one procedure, which I call in my other function procedures, triggers etc...more >>

Is there any third party s/w that lists SQL servers in a network and query more info about the server? I need to find out the sql version, whether its a msde or a msee. Also the service pack details and list the databases in that server. Any help appreciated... Thanks..! ...more >>

Is there any third party s/w that lists SQL servers in a network and query more info about the server? ...more >>

Hi all, I am fairly new to using triggers and was seeking some help from those that have experience with them. I am looking to transfer data from a SQL 2000 database to a Visual FoxPro database on another computer. I would like to transfer about three fields of data to a VFP table each time...more >>

I have a stored procedure that can take over 5 seconds to add simple data. Please give any advice on optimizing? Here are the details: ***** Access Info ****** ~10 rows are added to the table every second the table is read ~20 times a second (with no lock) ***** Stored Procedures ****...more >>

Dear all, i am planing to implement a Windows 2003 Cluster with MS SQl 2000 Enterprise Edition. I have 2 Nodes (4 * XEON MP Processors) with 8 GB RAM per Node. I have the need for 6 SQL instances and would like to implement a active-active cluster. What do you think it the best way to confi...more >>

Does anyone know how to get SQL Server versions, Service pack versions and the Server that instance of SQL is running on a network. I have seen some threads on how to list SQL servers in a network but I need to find more info about these SQL servers. Any help appreciated..! Thx... ...more >>

Does anyone have the logic to convert RTF formatted data in a text column into plain ascii text that I can use in a varchar variable or field? We have an app that allows formatted comments/notes to be stored in a SQL 2000 text column. Ideally, I would like a trigger that would copy any inser...more >>

I'm facing the next problem: I have a table with two columns (among others) modeling category and subcategory data for each row. I need to summarize info on this two columns, but with the next specs: 1.- Some grouping is only on the category column. 2.- Some other grouping consider the two ...more >>

Hi We are migrating from Access to SQL server. The code is in VB and uses DAO3.6. I have successfully made the connection to the databases on the SQL server and done operations with recordsets. I have also used a SELECT INTO command to create new tables. However CREATE TABLE and ALTER TABLE c...more >>