I have a question regarding database design and size . I am migrating from several DB2 databases to SQL server. I was going to create different databases based on application dept or business units (the way it has been in db2). But my application folks says, they cannot connect to multiple datab...more >>

Is it possible to limit a particular MS SQL 2000 user from using up all available processor time? Thank you, Dustin...more >>

I have a table that contains a column that collects discreet data (1 for on and 0 for off, just those two values) and a date column which is a timestamp containing a date and time. There are other columns in this table but they are unimportant in this discussion. A process inserts rows int...more >>

Hi, I have a table as follows that i am tring to alter but getting error message... CREATE TABLE [dbo].[test111] ( [Lname] [varchar] (10) COLLATE SQL_Latin1_General_CP850_CI_AS NULL ) ON [PRIMARY] GO I am tring to alter column Lname to varchar(20) with following syntex.. alter table te...more >>

Hi everyone, I have a date field in my database. I like to issue a sql query to return all the rows for the next 30 days from today. Can anyone help? Thank you Maz. ...more >>

Hi, Within Oracle (SQLPLUS) you can do the following command to get a count of all the tables from index: select count (*) from cat; Is there something similar for MS SQL (OSQL) ? thanks Sanny ...more >>

I have two identical tables, T1 and T2, each with fields f1, f2, and f3. I want to populate T1 with all unique combinations of f1, f2, and f3 from T2. selet f1, f2, f3 from T2 group by f1, f2, f3 I was thinking of something like insert into T1 (f1, f2, f3) select f1, f2, f3 from T2 ...more >>

i have 3 tables which i am trying to generate a pretty complex query...here are the tables. tblmap formid int inputid int listorder int tblresults inputid int respondantid int respondandinput nvarchar tblinput inputid int displayname here is some sample d...more >>

Anyone here when SQL Server 2005 will be available? ...more >>

Hi I have SQL server Sp3 on my sbs2003 A friend created a small Data Base with SQL 7 WE put it on our old machine which had 2000 and it worked fine. So when we bought the new one with 2000 SP3 we copies the 3 files of .ldf and .MDF and .LDF into the Data Folder (under the MSSQL chain)...more >>

Hi, I have a sql server database. How can client applications get data out of the database without having to supply a username and password? e.g I would like to write an api interface with my own username/password authentication to allow access to certain areas. Thanks JJ ...more >>

hi, I'm building a simple search engine functionality for a client searching the keyword and title and content of a page: ---- select ID, content_ID, 3 as 'weight' from tblPage where keywords LIKE '%test%' union select ID, content_ID, 2 from tblPage where title LIKE '%test%' ...more >>

I have a selected statement like following SELECT * FROM atable WHERE COLUMN1='aaa' OR COLUMN2='bbb' Is there any way I can added a indictor to tell me a record returned because which condition (COLUMN1='aaa' OR COLUMN2='bbb') matched? The reason is I will have to use the return records diff...more >>

I am currently using a stored procedure to delete users from our database who are considered inactive. This works great. However, we have decided that we want to archive these users to a identical (structure) table in the same database. To do this, I need to find an easy way to take the dat...more >>

I have been looking for a copy of a tool called the 'data sizer' that could be found in the Microsoft BackOffice 4.5 Resource Kit. I have had no luck tracking it down. What I would like is a tool / script / stored proc that would allow me to estimate how large a database would be and what t...more >>

I have a table that holds an SQL database name, and a table name. I want to parse the names and use them to reference a table in a select statement: someting like this: SET @DB = 'MyDB' SET @TBL = 'MyTBL' SET @TABLE = @DB + '.dbo.' + @TBL SELECT * FROM @TABLE Is there any way to ac...more >>

Hi all, I have a requirement to build a web-based front end for a SQL Server back end for users to view data, input data, produce documentation, etc. I currently use a MS Access database (non-web-based), but need to expand to allow access over the internet. Can anyone suggest a product t...more >>

Hello folks! Is it true that query performance will be enhanced if you place the arguments in your where clause in a position such that the "most prevalent" filters are towards the left? So if I wanted to query a table that had fields for Gender and Color and Pants and I wanted to see peopl...more >>

What port does SQL Server Enterprise Manager need open to connect to a remote database? I'm not finding documentation on this. ...more >>

Can anyone recommend the easiest way to get a full copy of a database from one server to another. The servers are not part of the same organization or network. I have received a backup of the database created with enterprise manager but am unable to restore it into a database of the same name ...more >>

Is there a way to configure a fiscal year starting on Oct 1, in SQL Server, or do I need to create a UDF to handle conversion of quarter and week? Thanks Patrick ...more >>

Hi What T-SQL commands need to be executed / permissions granted, in order to grant permission to: Granting permission to bcp, bulk insert, and XP_cmdshell Without giving full admins. Thanks Paul ...more >>

Hi I need to pass a long filename to a stored proc., which will then export a file via BCP How can I pass a file, which has: c:\program files\blah blah etc The proc seems to fail at the moment, due to the long filenames. How can I force the BCP command to accept this? Thanks ...more >>

Hello, I want to access my database server from the internet. I've created a rule on my router to redirect port 1433 to the desired machine, but still get a Server does not exist, or access denied message. When I change the (external) ip to the local IP address, connection succeeds. Is ther...more >>

I have an application that allows for searches, but it appears when I stress test it with 50+ users the CPU utilization on the MS SQL server machine is hitting 100%. The machine is on RAID SCSI, running on 4GB of memory and dual AMD Opteron cpu's. I can get a more powerful machine, but not sure...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

While trying to troubleshoot error messages about being unable to connect to the sharepoint database in SBS 2003, I realized that I don't even see one. When I open Enterprise Manager, I see no Sharepoint database at all. I did, however, find there the .mdf and .ldf files were created when I i...more >>

I need to store scanned images of checks in our database. Can I save the images themselves as an "image" datatype, or would it be better to save a reference path / URL to each scanned image file? Thanks - Jordan ...more >>

I develop a staff scheduling system where there can be over 75 users at a time making changes to scheduling data for different departments. This results in long lock waits during peak usage. I want to break the large tables (2 million rows) into a smaller set of tables that contain say 5 sets o...more >>

I am using SQL Server 2000. I have two sql statements like the below example. Declare @id int set @id = 21 select * from rule where corp_id = 123 and (rule_id = @id or rule_id is null) select * from rule where corp_id = 123 and rule_id = @id Both statements will return 1 result back...more >>

Hi, I'm trying to get log shipping to work with a distribution server used in transactional replication. Shipping the distribution database is no problem but the issue is in failover getting the distributor to talk to the publisher. The replication monitor won't display anything. I've tried b...more >>

Hello, What is wrong with this query? There are no messages other than (0 row(s) affected). The criteria 5 and 16 does exist. UPDATE articles SET DEPART_REF = '19' where ARTICLE_PARENT_ID = '5' or ARTICLE_PARENT_ID = '16' Thanks in advance from a sql newbie Jake ...more >>

Greetings, I have a text variable A = 't1:t2:t3' that I would like to use in the SQL IN clause (i.e. SELECT * FROM X WHERE c IN (A);). I tried REPLACE and TRANSFORM with no success. For example IN (REPLACE(a,':',''',''')). Is there a way to do this directly in the SQL statement and not ...more >>

Hi, I have a table t1 with columns a,b,c,d,e,f,g,h,i,j,k,l I have created a clustered index on a,b,d,e which forms the primary key. I have created a covering index on all the columns of t1. There are 1 million rows in this table. My query chooses the TOP20 rows based on some filter con...more >>

Hi, Currently it is running on SQL 7.00.623 on Winnt 4.0+SP5. Now i want to upgrade this with SP 4. As i follow the installation procedure according to Microsoft SQL7SP4 readme help, It hangs during the installation of Mdac_typ.exe. Don't know where and whats went wrong with the p...more >>

Have been googling for a SQL 2000 vulnerability scanner, but to no avail. Any pointers are appreciated. Thanks, ...more >>

I have created a database for keeping track of Purchase Orders, Vendors, Ordered Products, etc. When an order is placed, each product ordered goes into an OrderLine table. This table includes the following attributes: OrderLineID(PK), OrderID(FK), ProductID(FK), QtyOrdered, QtyReceived, Unit...more >>

I am creating a stored procedure which is passed a comma delimited string of ids as a varchar datatype. The param is to be used in an SQL statement such as: CREATE PROCEDURE GetFromTable @IDs varchar(255) AS SELECT * FROM table WHERE iId NOT IN(@IDs) GO The problem is that the iI...more >>

Using SQL Server 2000, I have a stored procedure that creates a temp table and populates it with statement similar to the following: select Col1 into #TempTable from Table1 where Col2 = @Var1 In my test case, the temp table should always be populated with 50 records. However, sometimes (...more >>

Hi Group: I have a store procedure. When I first run it in Query Analyzer, it takes 25 seconds to finish, but after that, it only takes about 2 seconds. In my application, I create a ADO connection to the database to execute the store procedure, then close the connection. this makes the execu...more >>

hi, does a sql server DBA need to be a win2k domain administrator to effectively do his/her job? ...more >>

Anybody know why in sql 2000 enterprise manager, if you edit a table or view, the 'dialog box' or 'model window' has the minimize and close icons in the upper right corner BUT if you edit a stored procedure, no icons ???? We reinstalled couple times and installed service packs before we real...more >>

How do I build a select statement that will show me all records in a table where there is more than one record for TICKETID? In other words, I want to know which TICKETID numbers show up more than once in the table. Thanks!...more >>

This one has stumped me! I recently implemented a process to monitor database usage and growth on our production servers. I use on server as the "master" that collects data from all the other servers into one database. The problem I'm having is that only every other day the process completes...more >>

I have a series of database objects that represent things such as people, accounts, etc. I have a set of options (boolean) that I need to add to these objects. Normally I would just create a bit field for each one and be done with it. The challenge however is that there could be hundreds o...more >>

I have an application that lets users search based on degree of separation, so for instance, a user can search for age, hobbies, etc. and limit the search to just users who are 1 degree separate, 2 degrees separate, or 3 degrees separate. However as it stands now, searches are taking a long lo...more >>

Hi there Is there any difference in speed between WHERE Year(SomeDate)=@SomeYear and WHERE SomeDate BETWEEN @StartDateOfSomeYear AND @EndDateOfSomeYear Which is preferred? TIA Alan ...more >>