Is there a stored procedure to allow me to compare two SQL objects? In my case for example I want to compare two stored procedures on two different databases? If there is no SP that does comparison, would there be any code in SQL DMO that does this? How does someone learn SQL DMO? Does SQL ...more >>

If I have to send a database to someone and that person can be using a Case Sensitive or a Case Insensitive SQL Server 2000, what do I do? Should i create two databases: 1 CS and 1 CI? Can't I simply work on 1 CS database all the time and whatever the person's SQL Server Sensitivity is setu...more >>

Hi, its newbie question. I have one production server(A) ,one backup server(B),additional server(C). my database backup are moved from A to C in regular basis. My problem is that when ever I have to restore my database in Backup Server i.e B, I have to first copy that particular Bac...more >>

i have a situation, where i need to group my information by a certain id, but that information which should already be grouped, i need to order based on a number in one of the columns example: <ex id=2 listorder=1> <description>desc 2</description> </ex> <ex id=1 listorder=2> <descri...more >>

Here's my situation: I have an ODBC DSN setup for Timberline Data (An accounting package that uses pervasive.sql) on my sql box. I set up a linked server using the supplied timberline odbc driver. I have two sql instances setup, the default instance and a named instance. On the default inst...more >>

If someone can give me an idea to do this in Ms-SqlServer: Create a order, this order I have to asign different location for each process of the order. Each location has a lasting time asigned in Hours. I have to determine the DateTime of begining and ending for each process, the order has th...more >>

I have two tables, TableA and TableB. Each has a date in smalldatetime format. TableA has a qty field in int format. TableB also has a nvarchar field in which the date is in the format YYYYMMDD A simple Query on TableA sum Qty returns a result of 100. However, When I do a left outer join fro...more >>

Hello. I have an Informix SQL statement that I need to run in MS SQL Server. When I try to execute it I get the following error message from Query Analyzer: Server: Msg 195, Level 15, State 10, Line 4 'date' is not a recognized function name. Can anyone help me convert this informix sql sta...more >>

I'm having trouble figuring out how to delete some _almost_ duplicate records in a look-up table. Here's the table: CREATE TABLE [user_fields] ( [fKEY] [char] (16) NOT NULL , [SEQUENCE] [char] (2) NOT NULL , [FIELD_LABEL] [varchar] (20) NULL , [FIELD_VALUE] [varchar] (50) NULL , [EXPORT_...more >>

I know I can use: @FirstName nvarchar(50) SELECT c.FullName FROM dbo.tblCONTACTS c WHERE @FirstName IN("Bob", "Robert", "Bobby") but... How can I get the same results if I have a table of like names and each row contains a group of similar names: tblLIKENAMES ID FirstNames 1 ...more >>

Hi Group, I am new with SQL Server..I am working with SQL Server 2000. I am storing the date in a nvarchar column of atable.... Now I want to show the data of Weekends..Everything is OK...But the problem is arising with Conversion of nvarchar to date...to identify the weekends...Like..Here DATE...more >>

I have an Employee table with 3000 records and an Excel file having the modified data of those emplyoees. Some of the data of Excel may be same as that of table data but some may differ. EmpId is the unique field. Other than this field, other fields of Excel may have modified data.I need to comp...more >>

Hi - The developers in my company are all switching to Windows 2003 Web Edition for their dev machines so they can better target the platform. Unfortunately we have discovered that we unable to install the SQL Server tools due (Query Analyzer, Profiler, etc) to the restriction that SQL Server...more >>

Suppose i have table with 20 columns. My store proc takes two input parameters (param1, param2), now i need to UPDATE column with param2 according to param1: e.g if param1 = 222 --> UPDATE col1 if param1 = 333 --> UPDATE col2 .................. .................. ......................more >>

Is it possible to create Fail-over Cluster with 64-bit (Itanium2) and 32-bit (Intel Xeon) nodes?...more >>

The following failed in EM (or whatever it is called now management studio I think) and I scripted it out and ran it in a query window to get more info. This works fine in SQL 2000 but not in 2005. I also tried to 'create' the database first then ran this command below but with the 'force restor...more >>

If I encrypt the SQL Procedures in my database will that cause any side effects? Will there be performance degradation? Is it good to encrypt them or they can easily be unencrypted? Thank you ...more >>

I am trying to make the following SQL statement, but there seems to a limit on how long a statement can be: INSERT INTO CUSTOMER (forename, surname, company_name, title, addressA, addressB, postal_number, city, country, home_phone, mobile_phone, work_phone, fax, email, sale_procentage, bank, a...more >>

Hi, i have table with 15 columns CREATE TABLE [dbo].[myTable] ( [m] [bigint] PRIMARY KEY , [c1] [bigint] NULL , [c2] [bigint] NULL , [c3] [bit] NULL , [c4] [tinyint] NULL , [c5] [nvarchar] (50) NULL , [c6] [bit] NULL ................ ................... now i want to...more >>

Hi Faculties, Is is possible to assign space quotas on filegroup(s)/files to database users? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I'm taking over an SQL Server database which is often updated with data from an Access database. Knowing little about either, this simple task has become a challenge. I'm told that the previous person used to type some simple SQL commands and this would update the SQL server database but...more >>

Hi, I have the following simple situtation: I created my database (just tables) in Server1, then made a copy to Server2. There, i changed all the datatypes and created relationships between the tables. Now, I want to transfer, not update, completely replace, all the previous versions of ta...more >>

Hi all, Let's say I have this: 1 2 fruit 154 4 5 fruit 178 1 2 vegetable 456 4 5 vegetable 458 1 2 nuts 123 4 5 nuts 485 I would like to have the fallowing result: 1 2 (fruit/vegetable - nuts) 4 5 (fruit/vegetable - nuts) ...more >>

If I open Enterprise Manager through a saved MSC file, the Tools > SQL Query Analyzer option is greyed out (unavailable). If I open Enterprise Manager from the Programs menu, Query Analyzer is available. Is there something specific I need to do with msc? I created an MSC file and added the Ent...more >>

I need to bulk insert very large amount of data into several MSSQL tables. The first Data model definition used identities to mantain relationship between those tables but we found that natural keys (compound) are better for bulk insert (there is no need to obtain the identity first) My que...more >>

I was expecting results from a Contains clause to return better hits first. Am I off base? Example Table: Title ----- red house green house red green house searching with Contains(' "red" or "green" or "house" '), I would expect the last row to show up first since it contains all thre...more >>

This from a SQL Server manual: "Complex queries, however, such as those in decision support systems, can reference large numbers of rows in base tables and aggregate large amounts of information into relatively concise aggregates (such as sums or averages). SQL Server 2000 supports creating a ...more >>

I am having some issues adding user logins to SQL Server. When I search for users in Active Directory from Security->Logins->New Login, I can search for and add users using the short name (samaccount, ex domain\abcde). However, when I search for users using their CA name (ex. domanin\firstname...more >>

I would like to determine if a particular user has sysadmin server role. Is there a way to do this via the connection string? Currently our code checks if a login is valid using SQLDriverConnect, however we need to be certain that the user can login and modify the schema. Is it possible to f...more >>

Hi All, >From last 2 weeks I am despirately trying to get the installation steps of R/3 4.7 on SQL server 2000 on Windows 2k or 2003 server. This is for a distributed environment, I mean central instance on the central instance host and the database instance on the on the database instance ho...more >>

Hello, I think I'd might have a small collation problem. Configuration: Two SQL Srv 2000 SP3 (running on clusters). Booth servers configured with SQL_Latin1_General_CP1_CI_AS collation. On each server, I have one database, which collation is Latin1_General_CI_AS. I've created a view ...more >>

Hi, I'm running SQL Server Version 8.00.194 on Windows 2000. I am am running this query: select TOP 2000 TheoVolImplied from OptionTrades where ReutersSymbol = 'IBM.N' and TheoVolImplied > 0.0 TheoVolImplied is of type float, precision 15, length 8. When I run this query I get this...more >>

We have an application that is based on several extended stored procedures. When we run our application in house, or when most other customers run it, they see performance of about X transactions per second. One customer is seeing performance of about X/5, and I'm having a hard time troublesho...more >>

I have a table, TableA with amongst other fields, a field for Qty. Qty can range from 0 to 100. How do I count the number of rows with a qty between 1 and 10, 11 and 20, 21 and 30, and so on using one SQL statement?=20 Regards, Ciar=E1n ...more >>

Hi, I am trying to print out a statement if a record is not found, but I keep getting Error 156: incorrect syntax near Else. Here is the stored procedure: CREATE PROCEDURE AddUpdateDoorStyles ( @myprojectid varchar(255), @doorstyle varchar(255) ) AS IF EXISTS (select * from ...more >>

Hi, I am new to writing SQL queries in MS SQL & would like to do the following: Write a query to retrieve all strings that start with a particular value. Basically, I am looking for the SQL equivalent of the regex "^". Thanks, Ashok ...more >>

Hi there, I need to take a backup with the following scanerio in mind: At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in c:\ Then at T2 I would like to take only the differential BACKUP of the Transaction log called BACK_1_TRANSLOG.BACK and at T3 I would like to take ...more >>

Dear All, How to store a separated company-calendar for each client-company (about 500). Company-calendar: workingdays, non-workingdays, meetings, etc. Thanks, Filips ...more >>

I am using a very basic query in Front Page 2002 against a SQL table in SQL 2000 SELECT * FROM tablename WHERE (f_docnumber = ::f_docnumber::) and f_docnumber is a search form field. When I run I get Description: The precision is invalid. Number: -2147467259 (0x80004005) The field i...more >>

I am studying for the MSCE/MCDBA exam 70-229. In the book I am using ("MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation Exam 70-229, Second Edition") I am looking at the section on the ANY/ALL keyword. <QUOTE> USE Pubs SELECT Title FROM ...more >>

Hello!!! I want to switch to SQL SERVER 2000, Service Pack 4 from Service Pack 3. So please advice, what all points need to consider. Also please share the experience, if someone have done the same. Thanks & Regards, T.S.Negi (MIND) ...more >>

Hi I think i have a very unique issue .... Running 2 machines Win2000 / WinXP Both have Sql / Service packs Identical ODBC Setup The issue is as follows : Both machines CAN access The internet server through ODBC ! (so i dont think the problem lies here) I CAN ...more >>

Hi there I am new to this forum and I was wondering if someone could help out. I am marked as "dbo" on a SQL Server database. Attached to this DB is a publication. When I right click > properties SQL Server gives me Error 7201 Any ideas as to how I can get over this? Is it permissions rela...more >>

Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit...more >>

I need to insert records into the table parSalesDetailModifier from OLDparSalesDetailModifier where (1) those records DO NOT exit in parSalesDetailModifier and (2) those records have a parent record in parSalesDetail. When I run the below query I get the error message that I am violating the...more >>

Could anyone, please, explain to me why I have negative values in RowModCtr column in sysobjects table? I have tested that after I update statistics the RowModCtr column is reset to 0. But why do I have negative values in the first place? Thx. ...more >>

Hello, I am importing data that lists rates for particular coverages for a particular period of time. Unfortunately, the data source isn't very clean. I've come up with some rules that I think will work to clean the data, but I'm having trouble putting those rules into efficient SQL. The tabl...more >>

Hi, I'm curious about the computational complexity of a query I have. The query contains multiple nested self left joins, starting with a simple select, then doing a self left join with the results, then doing a self left join with those results, etc. What puzzles me is that the time required...more >>

Hi, I'm installing SQL2000 on a new cluster server. I selected a 'custom installation' and was presented with a 'Collation settings' screen. I need it to be SQL_Latin1_General_CP1_CI_AS collation as I will be restoring databases with this collation. What should I choose from the 'Collation de...more >>

Hi, I have an access 2003 database which connect to sql server via a DSN that goes through a VPN. The database works fine and everyone can coonect from their normal computers but for anyone working on their Laptops (IBM Think Pad T42's) they cannnot connect to the datasource. The DSN fails upon ...more >>

Hey all, My intention was this: Find the stored procedure that will give you: =B7 database name =B7 database file location =B7 log file location =B7 backup file location With a little digging around it seems that this is not as simple a task as I originally thought. T...more >>

Hi all! In a statement I want to find the IDENTITY-column value for a row that has the smallest value. I have tried this, but for the result i also want to know the row_id for each. Can this be solved in a neat way, without using temporary tables? CREATE TABLE some_table ( row_id INTEGE...more >>

Hi, Is there any way of copying ALL DTS Packages from server to server apart from direct copy of sysdtspackages table and saving them one by one? Thanks ...more >>

Hi, I'm pretty good with Access, but I know nothing about SQL Server. My front end is Access 2000. I need to move the database tables from several programs to SQL Server 2k. Some of these programs came with scripts that will do the work. My question is, if I get the tables from one database...more >>

Hi All! I need help with a Statement! I am working with an Access2000 DB. I have the following Problem. ChNr Linie Datum Code 39 Stückzahl BHL1 BHL2 BMRH 582-064 L2.10 08.03.2005 02:30:00 FCAA 1482 17 0 1 582-064 L2.10 08.03.2005 02:30:00 FCAA 1487 17 0 1 582-114 L2.12 0...more >>

Hi Folks, I should begin by saying I'm fairly new to SQL Server. I'm an application developer who has built front ends atop Server, but have never done much in the way of design / development. My question is in two parts; 1). What is the best way to remotely "create" an SQL Server dat...more >>

Greetings, I've been reading with interest the threads here on deadlocking, as I'm finding my formerly happy app in a production environment suddenly deadlocking left and right. It started around the time I decided to wrap a series of UPDATE commands with BEGIN/END. The gist of it is I have...more >>

Hello! I am trying to investigate strange problem with particular stored procedure. It runs OK for several days and suddenly we start getting and lot of locks. The reason being [COMPILE] lock placed on this procedure. As a result, we have 40-50 other connections waiting, then next connec...more >>

I have a datetime variable coming from my ASP.NET application that has a time portion. I give my users the option to perform an equals, greater than, less than, or between comparison. The trouble comes in the way the application builds the criteria string. The WHERE clause passed in is in the fo...more >>

We have one single hash (#) table, in which we insert data processing priority wise (after calculating priority). for. e.g. Company Product Priority Prod. Qty Prod_Plan_Date C1 P1 1 100 C1 P2 2 50 C1 P3 3 30 C2 P1 1 ...more >>

I have one query that executes many times in a week. I created one Maintenances plan that Rebuild all index in my Database that has been executed at 23:40 Saturday until stop finished at Sunday. However at middle of week (Wednesday or Thursday), that query don’t return result like that must b...more >>

Hi. How can i set NOT FOR REPLICATION option to column in the enteprise manager. SQL Server 2000 -- Message posted via http://www.sqlmonster.com...more >>

When I try to put a new report in existing folder there's no problem, but now i have fresh installed Reporting Services and no Visual Studio 2005. How do i open a new folder?...more >>

Hi, Here's my problem: I want to write a stored procedure that returns all records from a table that have a certain column starting with given text. I however find that using LIKE and a variable always causes an index scan... which is causing performance issues. My table has about 3.5M records....more >>

Hi, I need some help doing a simple query. Here is what I have SELECT Category_Id, Category_name FROM AG_Category WHERE Auth_Logic_Id = 244 And Category_ID ( I want category_id to not have a '.' in it. Basically returning everything above but checking also the category...more >>

Hi! Server info - Win2K3 Server +SP1 with 1 GB Memory and 1.5 GB Virtual Memory SQL Server 2000 Enterprise Edition + SP3 running on this. Required result - Create a SQL Script that will contain a set of create, update, insert & delete statements (about 17500 lines including blank lines) ...more >>

When i do this statement: insert into table (cost) values ('2') cost column is a bigint datatype. will it auto convert the string 2 into integer 2??? ...more >>

is there a command that can change a login role to db_owner in all the tables, or do i have to use { USE table_name EXEC sp_adduser 'login name' EXEC sp_addrolemember 'db_owner', 'login name' } for each of the tables ? thanks ...more >>

Is there a way to compare two databases one being an old database and the second being a new database, I will update the old database's objects to match the new database's objects? Is there SQL code that could do this easily? How do you do this if you deal with the same scenario? Thank y...more >>