I wrote a script that uses the sp_refreshviews. The script will be part of a larger one that is automatically run in multiple databases where different views exist. Question: My understanding of views is that by simply stating 'select * from myviewname where 0=1' that the view is recompiled...more >>

Lets say I have 1000 records stored in my database. Now I insert a new record into my database, how do I retrieve the lastest record from my database using a simple SQL statement. Eugene Anthony *** Sent via Developersdex http://www.developersdex.com ***...more >>

[ANNOUNCE] Hey Everyone, Stylus Studio is very excited about the World Wide Web consortium's candidate recommendation of XSLT 2.0 and XML XQuery 1.0 as standards for transforming and querying XML (http://www.internetnews.com/ent-news/article.php/3561396). We are celebrating by giving away f...more >>

I installed Sql Server 2000 on a Windows 2003 machine and everything appeared to be fine. It has Sql Server SP4 and Windows 2003 SP1 installed. The problem occurs whenever I use Enterprise Manager or Query Analyzer for more than a few minutes. After a while, all internet connectivity on the ...more >>

Hello, The select statement needs only 1 second to complete the query. But the update statement spends 30 minutes. Why? SELECT STATEMENT: declare @IDate smalldatetime select @IDate=col001 from USDay select * from USDay A join ( select US990010, US990020, US990030, US990040, US9...more >>

Hi All Wondered if you could help me with the below query. I have 1 simple table called STOCKCATS that consists of 2 fields. These fields are called CATID and LEVEL. The contents of this table are as follows: CATID LEVEL cat01 <nothing> cat02 <nothing> cat03 ca...more >>

Hi, I still haven't got a decent book on relational databases :-) My stored procedure insert_wire inserts values into two tables (wire and cablewire). The wire_ref (primary key) will be the same for both inserts. However, if for any reason the first insert fails then I would like a roll...more >>

Hi All, I have a stored proc which looks like this. Create .... ( @id int, @ud int, @td int=0 ) if @td=0 select bkah from asdf where id=@id and ud=@ud else select bkah from asdf where id=@id and ud=@ud and td=@td --------------------------------- I am wondering if i c...more >>

hello i have a table with four fields : name_id, name, tree_id, level with these data: 1 name1 001 1 2 name2 002 1 3 name3 003 1 4 name4 001001 2 5 name5 001002 2 6 name6 001003 2 7 name7 001001001 3 tree...more >>

Hi, I'm enclosed a snippet of test code which highlights my problem. The Stored procedure insertValue should insert text into the parent, then insert other text into the child table but the 2 tables should auto increment in sync (i.e. so that they both end up with the same id numbers). I'...more >>

Hi, has anybody knowledge about the safetyness of encrypting stored procs in SQL-Server 2005 using WITH ENCRYPTION? Or can they be hacked with the same old tools which exists for SQL 2000? thanks, Helmut...more >>

I have stored procedure: create procedure sp_PagedTaxPerPlace @Page int, @RecsPerPage int AS SET NOCOUNT ON CREATE TABLE #TempItems ( TaxPerPlaceID int IDENTITY, CountryID int, StateID int, Zip int, TaxPerPlace smallmoney, ParentTaxPerPlaceID i...more >>

I have a quick question for you about SQL stored procedures. If I'm in a stored procedure and want to call another stored procedure and return values from the second stored procedure what is the procedure? I know you do the following to run the second stored procedure and pass in any paramet...more >>

Hello, Using Enterprise Manager, I deleted from my database the only table that contained records (Right-Click on Table, Choose "Delete Table"). My expectation was that the LARGE .mdf file would be reduced to minimal size (at least as small as the Northwind MDF). However, it's still 4+ Gig i...more >>

DELETING 100 million from a table weekly SQl SERVER 2000 Hi All We have a table in SQL SERVER 2000 which has about 250 million records and this will be growing by 100 million every week. At a time the table should contain just 13 weeks of data. when the 14th week data needs to be loaded the...more >>

I need to secure a datawarehouse table at the row level based on 1 to many keys on that table. A user should only see the rows they have access to. I need to be able to figure out which rows they have access to using a single sql statement and it cannot be dynamic SQL or a stored procedure (this...more >>

Does anybody used BlackBerry Enterprise Server? Windows Server 2003 Enterprise Exchange Server 2003 Enterprise + SP1 SQL Server 2000 + SP4 Problem: Everything is instaled properly (I hope so) exactly as is written in manual (Creating database, adding users) but BlackBerry Manager can't ...more >>

Hi when i right click table and click design table then error occured (an unexpected error occured during this operation) If any one knows please let let me know your help would be appreciated . thanks pardhi -- Message posted via http://www.sqlmonster.com...more >>

Hello: I have 2 MS SQL Servers 2000 Developer edition. Both have same settings and databases. I'd like to have them as mirrored servers - all transaction on one server must be performed on the other automatically. More than that I'd like to get possible if something happened to one server, all ...more >>

Hi, How can I tell If my sql server is MSDN or Standard or Enterprise version. Thank you AR ...more >>

I was trying to find the bottle neck on our server while we were running a couple very large updates. I ran the following query and noticed there were a couple sleeping spid's that were really eating up the memory. One had a value of 16000. I guess my question is was this query still holdi...more >>

Exciting Oracle News Oracle DB Worm Code Published http://www.eweek.com/article2/0,1895,1880682,00.asp?kc=ewnws110205dtx1k0000599 Researcher: Oracle Passwords Crack in Mere Minutes http://www.eweek.com/article2/0,1895,1878883,00.asp ...more >>

Hello all, We need to access MS SQL 2000 database from RHEL platforms. I've tested unixODBC and Easysoft ODBC-ODBC Bridge (under trial license). They work together pretty well. Unfortunately Easysoft ODBC-ODBC Bridge is not a free solution. Anybody have any experiences with other ODBC solu...more >>

If I am doing an Index Server query from SQL, such as: SELECT Q.* FROM OPENQUERY(FTIndexPM, ''SELECT path, characterization, rank, hitcount FROM SCOPE('DEEP TRAVERSAL OF ..... can anyone tell me which TCP/UDP ports will be used between the SQL Server and the Index server if the Index ...more >>

In the below structure, if I wanted to get the Id of the comment for each Generic record having the latest comment time, how would I do that not using a subquery? Table: Generic Id Description Table: Comment Id GenericId CommentTime Currently I have something like the following: S...more >>

This is more a theoretical question so I do not have any DDL (working) to post. Let's say that I have a query which needs to be filtered for specific accounts while also needing several joins to retrieve additional data. Is it better to so one big SELECT / JOIN / WHERE statement? As in SE...more >>

Hi I got a table with 2 columns as follows col1 col2 10 193.51 10 194.5 10 202.71 20 192.79 20 197.6 20 192.9 30 192.76 30 191.91 30 187.9 Now i need to add a column dynamically thru sql statement to the t...more >>

Howdy, I have a SQL server in a completely different forrest than the workstation I am running query analyzer on. However in query analyzer when I choose windows authentication I cannot manually specify "domain\username" as I could when mapping a file share across domains or forests. Is there...more >>

The following sql statement is rejected by asp.net (working with sql server). It says something is wrong near "TableFlights". But I don't see anything wrong with it. Any help is appreciated: SELECT TableFlights.IdFlight, Concat = (TableFlights.OrganizerLastName + ', ' + TableFlights.Organiz...more >>

For anybody that implemented fuzzy searches in SQL Server or any other database for that matter. I have implemented edit distance algorithm, specifically q-grams, in SQL Server and wanted to get some opinions from anyone who used a similar algorithm in a DBMS. We are looking to implement fuzz...more >>

I have a requirement where I need to perform a query for position information. But for some types of entries, I need to "expand" the row to include additional position rows. Let me explain with an example: An index is a security that is made up of components where each component has a "weight"...more >>

Hi - I'm completely new to Microsoft Query Analyzer and I need to learn it for work to do data mining as a Product Manager. Does anyone have any recommendations on how to learn this and where? Which books? What classes? What links to online tutorials? thanks ...more >>

Hey everyone, trying to set up a SQL Query to run on a pre-determined batch cycle that will automatically dump out specific table data to a ..csv file so that users can load the file into Excel right away, with no manipulation or modification. We are running SQL Server 2000. I am a novice SQL...more >>

Hi, I am writing to a text column in my SQL Server 2000 database. The text comes from a web form in my java web application, where the character encoding is ISO-8859-1. (I have no control over the charset, my app is a plugin inside another app.) Characters such as =80(ascii 128) and '(ascii 1...more >>

Hello All, Does SQL Sever 2000 keep track of all the logins/userids that were deleted over the last year? For example, If I deleted a login "Joe" from a SQL 2000 server, (and of course the corresponding userid "Joe" got deleted from the database) would that be recorded somewhere in the syste...more >>

Here is my dilema. I have a 120 GB database that I need to mask customer credit card numbers in. The field is a varchar (16). I need to update the field so that we only store the first 4 numbers and the last 4 numbers of the credit card and insert * to fill in the rest of the credit card numbe...more >>

Hi all. I'm getting an error mssage which tells me I have a torn page: ODBC error 823 (HY000) I/O error (torn page) detected during read at offset 0x00000080b5c000 in file 'D:\WINSUPPORTDATA\Win Support Database_2_Data.NDF'. I ran DBCC CHECKDB and it returned no errors: CHECKDB found 0 all...more >>

Hi guys, Sounds a bit strange, however, if we could put some calculation in stored procedure it would be quite convenient, just... where can I find a REGEXP library for matching checking? thanks. yours, athos ...more >>

Hi, I have a question regarding host_name() and IP addresses of clients. I'm running on a shared server - so access to xp_cmdshell is barred which is the standard response to questions about getting the IP address of a client from sql server. My issue is this: For security reasons every...more >>

I have a large table and I want to get a spesific record. The table is sorted by timestamp and I have a startdato column. Now I want to get only one record less or equal to a dato: idd startdate .... 122221 2005/01/01 02:35 122222 2005/01/01 05:01 122223 2005/01/01 10:19 122224 2005/0...more >>

I have a question about database design that I think some of the more experienced developers might be able to answer... Early on in the development of the DB for a project we are working on, the decision was made to use physical deletion of records from the DB rather than logical deletion. ...more >>