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 >>