I am using a SQL Server 2000 SP4 on Windows 2000 SP4. There is a linked server to MS Access database on a remote machine. The startup account of SQL Server is using a domain account and has full rights to the access DB file. The linked server was working fine until couple of weeks ago. But now...more >>

Hello. Sorry but I'm not sure where to ask this question but was wondering if anyone could advise me the best way of importing data in a named range or specific cells from Excel into SQL2K? Thanks in advance. J ...more >>

Your know the ones, you have a table and it has Create,Read,Update and Delete Stored procedures and the app always uses these to talk to the DB eliminating dynamic sql in your apps. Makes perfect sense when you have a table however when you have 500 tables its not so clever (thats 2000 st...more >>

I have stored procedure that process very slow . the job runs every minute and execute the SP after it does update stats on the ChangeQueue table and recompile the SP. The SP is processing very slow . any HELP Please Thankjs! EXEC dbo.C1_ProcessChangeQueue NULL, NULL, NULL, 10000, 0 The...more >>

My program has recieved this error from SQL 2005: Error: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark after the character string ''. SQL Command: select * from udf_CheckDups(18100, ' L8Qla', 8975) If I execute it works fine. Can someone help, pleas...more >>

Hi all, We loaded our DB onto a customer database and we noticed that certain commands (i.e. USE DATABASE) is case sensitive. On our internal DBs, this is not that case. Does anyone know what flag we can set to disable case sensitivity? Thanks! ...more >>

I need help to set a condition (based on data) on an update trigger. Do an instert to table B only if it meets this condition on table A i.e. " select * from A where color = 'red'" create table dbo.A (id int, color varchar(20)) create table dbo.B (id int, color varchar(20)) insert i...more >>

Hi Guys, In sql server there is not rownum like oracle, if I want delete rows less than a number, is there any efficent way to delete? Also, how about goto statement, is that ok to use it? I mean is there any limitation to use it? Thanks....more >>

I'm trying to clean up a database that has a lot of duplicates from an update attempt by the previous technician. Some rows are duplicated as much as 20 times, some only 5-10 times, etc... So i ran this query to see duplicates. SELECT CONTACT, COUNT(CONTACT) AS NumOccurrences FROM [...more >>

Can you use 'optional' parameters in an SQL server 2000 stored procedure?? I have a situation where some of the parameters may be 'nothing' when the stored procedure runs. It always fails when this happens as it assumes that I did not pass a required parameter. Help! ...more >>

I'm looking for some input as to best practice for accomplishing the following: I have a table with say a thousand records. Each record contains a status flag column. I have a process which comes along every so often and grabs any records where the status flag is 'New'. It then does some thin...more >>

I'm running into a problem in SQL 2005 with an incorrect number of rows being returned from a TOP (n) PERCENT query in some cases. The example below illustrates the problem. I think it should only return 21 rows (75% of 28 is 21) but it actually returns 22 rows. Note, in SQL 2000 21 rows ar...more >>

I have a table that list dates such as 2006-03-28, how can I get the week and quarter from this so if i have dates such as 2006-03-28 2006-03-1 2006-03-15 2006-10-10 2006-10-05 how can I return that week and what quarter that month is in? ...more >>

I have an application that is calling the T-SQL in a procedure below. The app (not SQL Server) is complaining "You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels." Could someone suggest a work around? The code below attempts to identify a reco...more >>

So I set up a "Replication/Local Publication" on a Production SQL 2005 Database. It publishes a Database on the production database. I then set up a "Replication/Local Subscription" on another Database we call "Report Database" that will have reports running on it and querying the Subscriptio...more >>

I am a Oracle DBA new to SQL Server. We actually have a small MSDE database running here. How do I select records for update so if somebody tries to updates I have locked they will get an error. In Oracle I would just do: select column1 from mytable for update In sql server I try to do th...more >>

I am looking to create an employee schedule table, which will contain the following information: The employee's name The shift start time The shift end time We are a 24 hour operation, so I will have shifts that begin on one day and end on another. I assume I'll need a shift_start_date and...more >>

Below is the query I have so far. Here is what I am trying to accomplish. I want to run the query, which is after the where, using the financial_message table. I then want to take the table store , which contains all of the stores possible and compare the query results against that row. Is...more >>

My question revolves around performance. I would like to know how SQL Server 2005 will react to the following: Let's say I have 60 one day partitions based on time. I would like to "select top 1000" XXXXXX. If the data for my query is in partition 55. Would the query then have to vis...more >>

I have been putting together my first ever trigger and it has gone well. I am essentially recording changes made to a table for auditing purposes. However, I created it on a table of a third party app over which I have no access to the code. One of the things I want to record is from which ...more >>

Hi All, I am facing a wierd problem condition where SQL compiler is not trapping compile/run time error. Here is an example to illustrate: Create Table Table1 ( Col1 INT ) Go Create Table Table2 ( Coll1 INT --Note an extra "L" in the column name. ) Go Now fire this query: Select * ...more >>

Disclosure: I'm an Excel user more than anything, with rudimentary SQL skills and some Access experience I need some help with the logical structure of a database for my wife, who is volunteering for a nonprofit (so the database is really for the nonprofit, I suppose) They need a means t...more >>

I have a query that is going to be on an ASP page, but I am not sure how to get it on there because its not an ordinary select statment. I though about doing a stored proc but not sure how to do that either. Below is the query, anyone have any suggestions? or should I be posting in an ASP grou...more >>

I have an execute SQL task with an OLEDB datasource. I want to pass in an input string and execute some sql using the string. It seems that there are limitations on what you can do with the input variable. Using the SQL Statement below, it works fine: select count(*) from test_code_source...more >>

I have to create a web site and a database for a company. Thats easy, the part I am running into issues trying to figure out is I wont have access to their system. To get the data from their internal system into the database to where the web site will be accessing has got me stumped. What the...more >>

I want fo put the result of a function call in a parameter to a stored procedure without having to use an intermediary variable like: exec spname @somvariable1, dbo.somefunc1(@somevariable2) --This returns the error "Incorrect syntax near '.'." I know I can do it like below, but if there is a ...more >>

Hi, I am using SQL Server 2005 (Standard), and the client is using VS2005 C#. Question: Can you improve my stored procedure? I don't like using @@ROWCOUNT for COMMIT TRANSACTION. Maybe it would be better to write 3 stored procedures, and use them inside another SP? How should this be done...more >>

My data table has 4 million records, each record is assigned a business ID based on the company, so its possible some records have the same business ID. My query needs to return just one from each business ID (it doesn't matter which one at this stage -the first occurrence will be fine) as ...more >>

Hi, Is the restore of a database in SQL 2005 is online by default or is there any special procedure to make the restore of a database as online? thanks and regards prince ...more >>

Does anyone know, please, what triggers xp_cmdshell to decide that what it just executed errored? Books Online says "If xp_cmdshell is executed within a batch and returns an error, the batch will fail. This is a change of behavior. In earlier versions of Microsoft SQL Server the batch would cont...more >>

Hi all, I have some strings like these: aa/aa// // aa// 4/5/6/7 I want delete the character "/" when is at the bottom of the string, or the string is only /. So to obtain: aa/aa Null aa 4/5/6/7 How can I get this? Thanks a lot. Luigi ...more >>

Hey all, I have a query which returns the name field from a table. I use the sp_executesql to execute this query. The code looks like, SET @Query = 'SELECT ' + @TableName + 'Name' + 'FROM' + @TableName + ' WHERE ' + @TableName + 'ID = ' + @ID EXEC @Name = sp_executesql @Query SELECT @Name...more >>

Frequently it's stop respond to Enter and Backspace key while browsing Object. have some one with such experience? ...more >>

Is there a T-SQL mechanism for capturing the name of the client pc that is executing a stored procedure? I was hoping for something like @@ServerName but specific to the client. Thanks, Mark ...more >>

I want to insert as many records into a table as fast as possible using a C# and ODBC (or OLE DB, if there is a benefit). I want to use SQL Server, but currently MySQL with InnoDB is currently much faster, what am I doing wrong? I tried a few things, first I have tried used BeginTransaction a...more >>

Hi I'm looking for some catalog tables/views in SQL2000 that will give me information about my user-created statistics. I managed to get some information from sysindexes where (status & 64) > 0 so I can join with sysobjects and get the stats for a given table. However there are no entrie...more >>

olá Need to split funds from Funds_Pool tbl based on availability and priority in Allocation_Pool tbl. What may be allocated from the Funds_Pool depends on the alloc% e.g even though quantity is 100 in Allocation_Pool tbl if alloc% is 50 then only 50 can be allocated from that pool, also which...more >>

Just need some pointers only ... not good at this thing. Need to split funds from Funds_Pool tbl based on availability and priority in Allocation_Pool tbl. What may be allocated from the Funds_Pool depends on the alloc% e.g even though quantity is 100 in Allocation_Pool tbl if alloc% is 50 th...more >>