Hello group! I've just started using SQL Server 2000. I installed a while ago. I tried a lot to register a server but it only gives one message that "SQL server doesn't exists". My aim is to create desktop applications suing SQL Server. I don't need any networking facilities... I'm using Wi...more >>

Is it possible to exec a Cognos report from a SQL job? -- Message posted via http://www.sqlmonster.com...more >>

Hi, I'm in the process of implementing a multi-user system containing an adjacency list (tree structure). I'm using a TIMESTAMP field on each record in the adjacency list in order to tell when a node has been changed since the last read. Sometimes though, it is useful to flag a "parent" ...more >>

In the process of doing some routine monitoring/clean-up we've discovered that several (many?) users are apparently set to access our SQL Server 2000 database instances via the Named Pipes protocol. In readings and recommendations we've decided that our WAN would be best served if we use the les...more >>

I am using Microsoft SQL Server 2000 and have a question about our database design. Here is a sublist of tables and columns we currently have:- Employee ---------- Ee_Code PRIMARY KEY Ee_Name NOT NULL Branch ------------ Branch_ID PRIMARY KEY Branch_Name NOT NULL Is...more >>

Hi all, I have a table called PTRANS with few columns (see create script below). I have created a view on top that this table VwTransaction (See below) I can now run this query without a problem: select * from dbo.VwTransaction where AssetNumber = '101001' and TransactionDate <= '7...more >>

select ano,max(date),a_subject from MY_TAB where table_name='xyz' and ano=877 group by a_subject,ano order by a_subject id max(Date) A_Subject 877 2005-01-20 00:00:00.000 Subject_1 877 1900-01-01 00:00:00.000 Subject_2 877 2004-12-20 00:00...more >>

Hello, I have SQL Server 2000 Developer Edition. Where is SQL Server Network Utility? In Start menu SQL server group I have only Client Network Utility :| Is it a command line tool or sth? How to install it? tnx -- STEFAN ...more >>

Hello, How to determine, which ports do MS SQL Server instances listen to? I want to conect to sql server using PHP and I need to know exact port number. I suspect that my SQL (msde) server instances don't listen on default 1433 :] -- Stefan ...more >>

I'm having a ton of trouble with a dataset. It builds at design time, but fails at runtime, saying: --------------------------- Processing Errors --------------------------- An error has occurred during report processing. Cannot set the command text for data set 'ds_Legal_Entity'. Error dur...more >>

What is actually happening behind the scenes when you open a connection to sql server in code such as C# or vb.net. ...more >>

If I use BCP to export a very large table will that table be blocked for writes during the export process? I don't want to prevent users from accessing that table during the bcp process? Thank You, TFD. ...more >>

"I've created a customer table and I want to give each customer a unique id e.g 'ES001' But sql server won't let me I've looked at various books to no avail. My second question is when I delete a row from a table which had an ID of 2 when I put in a new row it gives the new row and ID of 3 how...more >>

I have a stored procedure that has some problems with slow performance. The procedure has 2 parameters @firstname varchar(100) @lastname varchar(100) These parameters can have values like a%, that is wildcard searches. The strange thing is that if one of the parameters has the value %, and ...more >>

Hi, Just found out that this error can be solved Server: Msg 7619, Level 16, State 1, Procedure usp_ft, Line 2 A clause of the query contained only ignored words. triggered when executing SELECT TOP 1000 * FROM ADS JOIN ADSFULL ON ads_adid = fads_adid WHERE (ADS_ADID IN (SELECT FADS...more >>

Can someome please advise what the equivalent query would be in Microsoft SQL Server ... I've tried a number of combinations with no success ... Thanks, Ralph Noble (ralph_noble@hotmail.com) ================ UPDATE INVENTORY INNER JOIN SALES ON (INVENTORY.BAR_CODE = SALES.BAR_CODE) AND...more >>

Hi, I've got a full text index which works fine, SQLSERVER2000/WIN 2000 SERVER. The system requires to update indexes immediately, so I use a timestamp field to enable this. No problems so far. Now, I've got a stored procedures which nearly daily inserts about 10.000 rows. When doing th...more >>

I'm looking for a tool that can extract only the schema from a database in a form that can be used to generate that schema in another empty database. This is to facilitate our disaster recovery processes where we need the objects only, not the data, and need to replicate this to our disaster re...more >>

How can I print the structure of a table from Enterprise Manager? Or is there another app that has a print option?...more >>

I've ready many of the posts on this and other newsgroups in which people describe working practices for source control of database scripts. We are looking to implement something similar in my current workplace. We have agreed that developers should not modify objects such as views or stored ...more >>

Greetings All, I was wondering if any of you would share some of your experiences regarding the task of loading a data store from an Oltp source. We are using Analysis Services in a BI product that requires data to be pulled from one of our products, an OLTP database. The design is to first ru...more >>

Hi, I would like to use database locking mechanism to control access to an external resource (like file system). What I need is 1. an exclusive (write) lock conflicting with any access to the resource (both for read and write) 2. non-exlusive (read) lock conflicting with writes only How this ...more >>

Hi, I've been creating a db application using MS Access and MSDE. Only two of us are using the application, and the server and the app both run great on my laptop (1.6 GHz Pentium M, 2GB RAM, W2KPro). Only problem is when I take my laptop home, my coworker loses access to the server. We r...more >>

They are corrupt. I cannot get the odbc driver applet for sql server to open when I click add and I cannot configure any existing ones. And the usage of the drivers fail. Other ODBC drivers work. Does anyone know how to reinstall the SQL Server set of ODBC drivers? MDAC wouldn't install, ...more >>

Hi all, I have a database with 40GB of binary objects stored in image columns in two tables. Our database server is also used for another 15 databases. SQL Server caches the image-column, causing the cache-hit-ratio to dramatically decrease, since fetching a couple of binaries from the ...more >>

Hello. Can you point me to books or good documentation that could help me in understanding in detail the dbcc showcontig output (and the output of other command that analize the status of a DB) and permit me understanding what is going on and taking appropriate action? Do you think a Micros...more >>

Is there any other way which is more simpler(shorter) to get the date part (I don't want the time part ) of Datetime than this ? Convert(nvarchar, DATEPART(dd,[Date]) ) + '/' + Convert(nvarchar, DATEPART(mm,[Date])) + '/' + Convert(nvarchar, DATEPART(yy,[Date])) As [Date]...more >>

Hi all, I have a stored procdure which does a select and returns the records directly -i.e. Not in output parameters e.g: CREATE PROCEDURE up_SelectRecs(@ProductName nvarchar(30)) AS SELECT * FROM MyTable WHERE [Name]=@ProductName In another stored procedure I need to do the followi...more >>

I need to conect my software from a remote client to a server, my standard connection: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=;Initial Catalog=MyDb;Data Source=192.168.0.100;Network=DBMSSOCN; and Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Pas...more >>

Hello all, I'm trying to write a stored procedure that will prompt the user for a date range and produce a report based on that date range and 4 incident types. I only need count how may times these incidents happen within the data range. The query looks like this SELECT incident, @Ente...more >>

Hi all, I am trying to write a query to do the following in SQL server but am struggling: I have a table with a int number field in it and I want to find out the lowest unused number in the table. Unfortunately, the numbers are not necesarily sequential (due to deletes). So I may have the ...more >>

I am using a select statement to obtain a result set back with aggregated data. The problem is that I am seeing column data with 11 to 13 digits after the decimal point. I tried using the STR function, but then the Order By clause does not sort properly because there are negative numbers in the...more >>

Folks, I work on a system which is growing rapidly, with the number of transactions we process growing on a daily basis. While this is good news or the business, maintenance is starting to become an issue as the database is the backend for a website which cannot be down for a lengthy period o...more >>

Hi I want to create a table with one column, which is a identity column. Let's say like this: CREATE TABLE DefaultTable(N int identity(0,1)) Then I want to fill this table with 15,000,000 records, so that I have a table with the numbers 0 to 14,999,999. How can I do this as fast as possibl...more >>

Dear Reader , There are some details <facts>, which can be stored (Hard coded) in exe. example: Measurement Units and their relations. Now I want to print the list of those Measurement Units and Relationships between them. Can we print them directly , without bringing them into Database? ...more >>

Hi, Sorry, this is a very easy question. I have to create a stored procedure in a SQL SERVER Database. I have read lots on MSDN about the syntax of this stored procedure : ie. CREATE PROCEDURE spGetContctDetails AS -- get everything out of contact table SELECT * FROM tblContact bu...more >>

Hi How can I convert integer to time . Ex: number = 91 Result = 1h 31m Something like that. I want to do it in DATETIME Function! Thanks Dishan ...more >>

Does anyone know if the source code for the ASP.Net application that comes with Reporting Services is available for viewing somewhere? ...more >>

I know this has come up frequently but I can't seem to put my finger on the precise problem as it applies to me. I have a workgroup with a 2003 box with Sql server on it. Also, on this, I have an XP pro machine. So the xp pro machine is running IIS. When I try and open a connection to the Sql Se...more >>

hi, just wanted to know if i need to insert a string with double quotes in it into a sql server table, do i need to use any delimeters, like \"? an insert like: insert into producttable values(key, "double quote text") where i need the "double quote text" to go in like that, with the " " at ...more >>

Is there an sp_zzzzzz function to return the name of the current database? I would like to use this name as a variable in a stored procedure in order to create names for further databases (by appending a tag, such as MYDATABASE_BLOB001, ..._BLOB002 etc. Thanks. ...more >>

I am try to update the Gender field for all females of a database with about 15,000 records. So how I started was by searching baby girl names on the web and manipulated some of there lists to create my own table of female first names (HSNames). I can then use this table to update the Gender f...more >>

If a table is updated via replication, will an INSERT trigger go off if a new row is being added? --Bob ...more >>

I have a stored procedure that I use for call a aspx page from within SQL. The stored procedure itself runs fine with no errors but I keep getting errors in the event viewer everytime it runs (with .vbs, .NET, .vb6 client) outside Enterprise manager or SQL Query Analyzer..... This is error: ...more >>

im using ms-access mdb. file...more >>

Hello. I am administering a SQL Server (Enterprise Edition on Windows 2003) from some month and can't understand what is going on in the latest week (when the db grow a lot). The DB is around 250G, and has one table with 1 billion rows. It is performing in a decent way, but can't understand...more >>

After running: SELECT [total size KB], B.rows, O.name FROM (select sum(convert(decimal(10,0),dpages)*8129/1024) [total size KB], id FROM sysindexes group by id) A INNER JOIN sysindexes B ON A.id = B.id and B.indid in (0,1) INNER JOIN sysobjects O ON B.id = O.id WHERE B.rows <> 0 ORDER BY [t...more >>

Greetings: I have a question about debugging or stepping through DTS package Active X scripts. When I hit a bug Microsoft Development Environment pops up the script and highlights where the error occurred. I can use the Immediate pane to find out the values in the variables, but I can't set br...more >>

Hello, i want to use toad to work with sql-Server for my business. But i cant get rid of it, after extracting the packets i find the toad ss.exe. I dont know how to connect to my database, as i never worked before with the odbc-database driver. I think it must be about the manager "start ->...more >>

The following query works perfectly (returning all words on a list called "Dolch" that do not contain a form of "doing"): SELECT 'Dolch' AS [List Name], dbo.Dolch.vchWord FROM dbo.Dolch LEFT OUTER JOIN dbo.CombinedLexicons ON CONTAINS(dbo.Dolch.vchWord, 'FORMSOF(INFLECTIONAL, "d...more >>

I need to migrate an application from SQL 7.0 to SQL 2000. I know that they use different collations, and this causes problems when 7.0 applications are moved to 2000. I would like to find a permanent fix (so I'm not happy with using "COLLATE" in future stored procedures) and I'd like to keep th...more >>

I don't know much about MS SQL-Server. I'm having SQL server 2000 and going to change IP address of the server. What need to be done?...more >>

I am looking for informaton about Reporting Services, in particular how to change the datasource, username and password for a report programmically. Right now, I can only get it to work after changing the file once it has been deployed to the server. For the amount of reports that need to be c...more >>

I am transferring data from SQl Server 2000 to Oracle through Linked Servers.It takes considerable amount of time while transferring data from SQL Server to oracle.Both these databases are at remote locations.I am executing a Stored procedure on SQL Server and what it does is,It has an Insert st...more >>

Hi, I have one stored procedure that calls another ( EXEC proc_abcd ). I would like to return a result set (a temporary table I have created in the procedure proc_abcd) to the calling procedure for further manipulation. How can I do this given that TABLE variables cannot be passed into,...more >>

I have a set of data coming in from a text file that looks like: Date ID Value 01/01/2005 1 Value1 01/01/2005 2 Value2 01/01/2005 3 Value3 01/01/2005 4 Value4 01/01/2005 5 Value5 01/01/2005 6 Value6 01/01/2005 7 Value7 01/02/2005 1 ...more >>

Hi, We are a systems research group at the Computer Science department at Rutgers University, and are conducting a survey to understand details about network, systems and database administration. We hope that this information would help us recreate a realistic environment to help research in...more >>

We were using sql authentication on our sql server 2000 servers, But need to use windows authentication. I have an sql user jdoe that owns many different objects in multiple databases. I have tried adding the windows login of jdoe with the exact same permissions as the sql user jdoe, but it c...more >>

Hi, In the MS SQL 2000 Server, if the log shipping is set up right, does that mean data in primary server changed will mapped to secondary server later on? Thanks. Jason ...more >>

How can you indicate that a FOREIGN KEY constraint references two columns in two different tables? "SQL Server Books Online" show an example of how to reference two columns in the SAME table: REFERENCES ref_table [ ( ref_column [ ,...n ] ) Here is the error and the 'bad' SQL code: Server...more >>

I'm trying to install SQL Server 2000 client tools on an XP workstation. MSDE already exists on the workstation. During the install I am never prompted for a location to install to. I want to install to my D drive. The install defaults to my C drive. Any thoughts? ...more >>

I'm working on a VB.NET project where we are intending to use MSDE as our back-end database. The actual number of users is expected to be low and I don't have any concerns as to whether MSDE will be up to the job (most of the time). I'm aware that if we end up with lots of users connecting to our...more >>

Hi, Currently we get data from more then 200 different sources and all of our vendors provide data in different file formats. The problem is we have more then 100 DTS packages now and the maintainance is very diffucult. Every time our vendor changes the format we have to change in multiple D...more >>

Hi, I'm writing an application that involves data that has a set of users that are allowed to perform certain operations on it. i.e. Only the row owner can modify a row, but there is a set of users who can view it. At the moment, I've started to implement this by calling a UDF at the beginni...more >>

I'm trying to create a local copy of a popular CRM database called Salesforce.com. Many of the tables in the DB have FOREIGN KEY references that I want to preserve, but I've run into a chicken and egg problem. Table "A" has a reference to table "B," and table "B" has a reference to table "A." ...more >>

One of the table that is in a merge replication somehow is missing an index. Strangely, only the table in one of the subscriber of the merge replication is missing the index; another subscriber and the publisher of the merge replication don't have this problem. How should I add the missing ind...more >>

Hello, does anyone know how to determine (within the stored procedure) whether a parameter has been passed explicitly to a stored procedure as opposed to a parameter that has taken on the default value. Many thanks Phil ...more >>

I am using a dial up connection to the Internet and to an online SQL Server database. I have a problem in that when I use Enterprise Manager to access even my local server , or even, it appears, when it is just open with no connection to any SQL Server, I experience very slow data transf...more >>

Hi, I have a table that lists all attempts at logging in to a server. Columns are: userid, firstname, lastname, login_date, login_time If a user attempted to login 5 times, then I want to return the row (with all columns)...... BUT I only want to return the row with the 5th time attempted....more >>

I have a question on a practice assignment that I can't solve. Can someone help me out? Question: The table Arc(x,y) currently has the following tuples (note there are duplicates): (1,2), (1,2), (2,3), (3,4), (3,4), (4,1), (4,1), (4,1), (4,2). Compute the result of the query: SELECT a1.x...more >>

IS there a way to combine all matching rows in a table so that it outputs as one row, for example: tblMyStuff UniqueID int IDENTITY ParentID int SomeSuch nvarchar(50) SomeSuch2 nvarchar(50) Table data: UniqueID ParentID SomeSuch SomeSuch2 1 1 Dog Bark 2 1 ...more >>

I know I should know this but here goes... I have a table with the following rows: UniqueID int IDENTITY ParentUniqueID int RecordLabel nvarchar(50) RecordText ntext RecordDate DateTime What I'm trying to do is to group all records by ParentUniqueID and display the RecordLabel, RecordTe...more >>

MS SQL Server 2000 SP3 Windows XP SP2 Error when try to debug in Query Analyzer: Server: Msg 504, Level 16, State 1, Procedure sp_sdidebug, Line 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on HORNET (Error = 0x80070005). Ensure that client-side components...more >>

Using the the NumId from TitleData, I would like to delete the corresponding row in Bookdata using pure SQL. I want it to delete all rows in bookdata where the Titledata.NumID is a match to bookdata.id The two tables are linked in that the NumId of table Titledata is identical to the Id of table...more >>