Can anyone tell me what is best practices to define relationships between tables and to define their primary key? For example... One table is Orders and other is OrderDetails. For ease of accessing datas from table OrderDetails I have fields copied from Orders like year_of_order, order_numb...more >>

Does anyone know if Toad (freeware) that currently works great for SQL Server 2000, will also work for 2005? ...more >>

I would like to provide users of a client program a list of databases on the network that match a certain pattern, like "%frp%". I have seen a list of databases in the Windows XP ODBC configuration tool. What I would like to know is can I get that information through a query to one of the databas...more >>

Greetings, I want to bulk load data into user defined SQL Server tables. For this i want to disable all the constraints on all the user defined tables. I got solution in one of the thread and did the following: declare @tablename varchar(30) declare c1 cursor for select nam...more >>

hi guys, i've just started woth Excel component in .NET. i manged to import the Excel Component on windows Forms but i'm not able to load Excel file in that. if anyone has any idea how can this be done please do let me know. i'm in great need. thanks, Lucky ...more >>

Greetings, While loading data into Sql Server using BCP utility, we have to explicitly need to drop the indexes. then after loading the data we recreate them. I just want to know if this is possible through some other ways. i mean in DB2 we have an option of index rebuild option...more >>

Hi I want to lock a table using JDBC as I want to perform some query's (read and write) in exclusive mode. Different threads will be executing the same code simultaneously. I am using the following statements Statement stmt = connection.createStatement(); stmt.executeUpdate("lock table STAT...more >>

I have a table with the following columns --------------------------------------------- Payment Payment_Date -------------------------------------------- 900 5/15/05 900 615/05 900 7/15/05 900 8/15/05 900 ...more >>

We're developing an application request/packaging/rollout worflow application for our 50 site, 40,000 user company. There is a request table, an engineering table, a distribution table, etc. etc. But, the company has a designated "Application Owner" at each site, and each person who will use the...more >>

I have a stored procedure where I need to pass in a comma separated list of symbols and return back results. My original code built up the query (as a string) and used sp_executesql to execute it. I took the comma separated list of symbols and appended it to the query as part of the WHERE clau...more >>

Is there a limit to how much text you can concatenate (other than data type limits, of course)? For example, if you write: SELECT 'This is some text from: ' + Convert(char(15), SomeFieldName01) + 'some more text' + Convert(char(25), SomeFieldName02) + 'yet more text.' As BigNote FROM Table ...more >>

Does anyone know how Reporting Services for SQL Server 2005 are installed? I'm running SQL Server Express 2005 and it doesn't appear to be available. Do you have to install it as a separate download? ...more >>

I just wanted to post a follow up to a message I posted some months ago about a long running transaction that was blocking all other users... The link is below http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/1063b65df1f97492/8649bee2002646a2 By using the new "...more >>

Suppose I have a table Orders with the following fields: OrderID ProductID OrderDate I would like a SELECT query to return those rows with multiple values for both ProductID and OrderDate. For example suppose Orders contains the following data OrderID ProductID OrderDa...more >>

Greetings, Can someone recommend me some online redbooks or any link regarding "Migration from Sybase to Sql Server"? Any feedback will be appreciated TIA ...more >>

Dear group, i have the following setting: satellite databases in different locations with the same structure (and sometimes identical data) need to be replicated into one central database. The databases hold information on machine results and machines are numbered from 1 to n. Results fo...more >>

How do I determine which method I should use if I want to optimize the performance of a database. I took Northwind's database to run my example. My query is I want to retrieve the Employees' First and Last Names that sold between $100,000 and $200,000. First let me create a function that...more >>

How do I determine which method I should use if I want to optimize the performance of a database. I took Northwind's database to run my example. My query is I want to retrieve the Employees' First and Last Names that sold between $100,000 and $200,000. First let me create a function that...more >>

Is it generally or almost always better to have multiple small SPs and functions to return a result set instead of using a single big 1000+ lines SP? I have one SP for example that is 1000+ lines and early analysis of the SP I see it first has 3 big blocks of code separated by IF statements. ...more >>

Hello: I need to import an Excel file to SQL Server. The .xls file has the column names which contains dot inside, like AAA.BBB. When I import this file in SQL using DTS Import/Export tool, it creates a table with column names like AAA#BBB. So, during import process the dots substitutes with #...more >>

Dear all, I have table called CATEGORY, which is defined as follows: CREATE TABLE CATEGORY ( CATEGORY_ID INTEGER IDENTITY(1,1) NOT NULL, CATEGORY_NAME VARCHAR(40) NOT NULL CONSTRAINT UC__CATEGORY__CATEGORY_NAME UNIQUE, PARENT_CATEGORY_ID INTEGER, CATEGORY_ICON IMAGE, ...more >>

I have the following table; CREATE TABLE [x_Note] ( [x_NoteId] [int] IDENTITY (1, 1) NOT NULL , [Note] [varchar] (7200) COLLATE SQL_Latin1_General_Pref_CP1_CI_AS NOT NULL , CONSTRAINT [PK_x_NoteId] PRIMARY KEY CLUSTERED ( [x_NoteId], ) WITH FILLFACTOR = 90 ON [USERDATA] , ) ...more >>

Am attempting to use SQL Server 2005 EXPRESS on WINXP. Have successfully downloaded SQL Server 2005 Express and Maintenance Studio Express. No errors were received duing the installation of either program. However, when I click on the icon for MSE, the hard disk spins for about a minute, but ...more >>

Hi there, I have created a sp and function that returns amongst other things a comma seperated string of values via a one to many relationship, the code works perfectly but i am not sure how to test its performance.. Is this an efficient way to achieve my solution.. If not any suggestions how...more >>

Please see DDL and INSERT statements below. Let's say that some process throws out the second row, where the Clocktime = '02/01/2005 12:34' Without the use of a cursor, how can I retrieve the PREVIOUS value for that employee? Pseudo SQL might be something like: SELECT * FROM tbl...more >>

I have a table with the following structure: main_category| category| sub_category| answer|date Basically, the data will be along these lines: Neuro | LOC | Status | answer1|date Neuro | LOC | Status | answer2|date Neuro | LOC | Status | answer3|date Senso| Visi | Clarity | answer1|da...more >>

Dear All I have a problem ,as i created the new user its password became changed. I logon SQL Server as >> Server Name: localhost >> Server option : window athentication then i created a new user >>user name = test >>password = 123 then,i refreshes the server as i clic...more >>

How can I run a single SP by asking multiple sales question either by using the logical operator AND for all the questions; or using the logical operator OR for all the questions. So it's always either AND or OR but never mixed together. We can use Northwind database for my question, it is ver...more >>

I'm evidently not understanding nested triggers and I'm looking for some help. I've an Invoice table (see below) that I want to enforce two actions via after triggers. The first trigger maintains a set of audit columns in the table indicating the date on which the row was inserted, the d...more >>

Hi All Can you please help me with a few queries on adding a header line and padding rows out. I apologise profusely for not providing the DDL for this, but I don't have it. All I have is stored procedure that I'm trying to edit to make the front-end app display the right data. The rele...more >>

I am using SQL Server 2000. In Enterprise Mgr, under Management/Current Activity, I see a list SPIDs. I have a multi-tiered .NET web app that uses ADO.NET to connect to the database. Each time a Stored Proc is called, a new connection is opened, the data retreieved, and the connection close...more >>

I have a table that has values as follows: PersonID Degree 55 MD 55 Phd 55 RN 60 MD 60 Phd I need a create a query that will give me output like this: PersonID Degree 55 MD, Phd, RN 60 MD, Phd Any ideas ...more >>

Hi all...I have a stored proc that works fine except I can't get the paging property to work in ASP. It seems that because I'm building the SQL withing the SP is causing the problem. If I don't build the SQL as a string paging works. In my ASP page, the pagecount property returns -1 for some ...more >>

Is it bad practice to use 'Select * ' from a security perspective? Thanks for any advice. Ray ...more >>

I do not understand the error handling of SQL Server here. Any error in bulk insert seems to halt the current T-SQL statement entirely, rendering it impossible to log an error. The first statement below executes as expected, and were I to replace "print" with something meaningful I could do ...more >>

I'm cleaning data which involves updating ~12 million rows with three different models, progressively. First clean values using the model with finest granularity, then the remainder with the next model, finally what's left using the last model. The first model sets ~1/2 of the rows, the second...more >>

I have a table with a few million records and I need to search and return rows where a varchar(1000) field has the value "Showed" SQL will not allow me to add an index for a field of this length. Is it possible to create some kind of index for only the value "Showed" Or is there some oth...more >>

It makes no difference if I'm working with Enterprise Manager, Query Analyzer, Access, self written app with OleDb or Visual studio 2003 builtin DB manager. Everything is fine but aufter some time - about 30 minutes I get message "cannot create SSPI context" After rebooting my machine I can...more >>

Enterprise Manager for MSSQL 2000 (V8.0), connecting to MSSQL 7 database server: Some logins can see the listing of all databases through Enterprise Manager, some cannot. Logins are set up as users in the same databases, and do not have any special server roles. If it makes any differen...more >>

Does anyone know how much it costs to upgrade from SQL 2000 to SQL 2005? All I can find is the "Software assurance" package which also mentions buying SQL 2000. What options are there if you already have SQL 2000 installed and just want to upgrade? ...more >>

Hello, I've very often a deadlock problem. The deadlock is generated always in the same way, by one application calling in DB two sp's (application has two threads). This is an error message from trace: 2005-11-29 08:20:29.97 spid4 ResType:LockOwner Stype:'OR' Mode: S SPID:1160 ECID:0 E...more >>

All my queries are being blocked while the tables are being replicated and it is causing some 2 minute blocking. Is there a way for the Replication to allow dirty reads because I really don't care about that, I would rather have dirty reads than 2 minute waits. Thanks. ...more >>

Looking for a consultant with solid experience in application and database security for a project in the GTA. CONTACT --------------------------------------------------- Please send your resume to: hottracker@hotmail.com ...more >>

P4 2.8G Hz, 512 M RAM. thanks. ...more >>