Microsoft SQL Server Forum

I have a column named "LIST" in a table with strings like the following: 151231-1002-02-1001 151231-1001-02-1001 151231-1002-02-1002 151231-1003-02-1001 etc.... What I'd like to do is include an ORDER BY statement that splits the string, so that the order would be by the second set of four numbers

I'm trying to do a simple update like I have done countless times before. However, when I update the empty fields in this table it places a -1 into the field rather than the enterred value. It is indexed with duplicates allowed. It says that zero lenght is set to yes. What can I do about this?

How do I get two values for two different fields in an insert statement values clause using one select? For instance: declare @test int @test gets assigned... insert into (id, field1, fname, lname) values

I have access to a Microsoft SQL server, but can only access it from the same local webserver. I need ideally to be able to access it, for both reading and writing, from a different webserver / computer application, which isn't directly possible. The local webserver which has access to the SQL server has both PHP and ASP on it, so I was...

I have a client that requires me to back up his sql7 db to my server and restore it in sql200, then restore it so they can run from my server if disaster hits his server. I have a batch file that runs to securely move data from his server to my server. Now all I need is a way to automate the restore process. I would like to do it all from...

Does anyone know the maximum number of CPU's that any version of SQL 7 (i.e. Std or Enterprise) can use on any version of Win 2K (i.e. Server, Adv Server, or DataCenter)? We are constrained by our app to stay with SQL 7. We run with 4 CPU's now and wonder if we can move to an 8-CPU box. Thanks in advance.

Hi All, While in the process of building my table (40 or so Insert statments) can I then query ("select * from @Table_variable") and use the results up to theat point for another insert into @Table_varible? If you look for stepID -15 I have commented that section out due to it not retuning the correct values. Thank you in advance

When i choose Windows Authentication during intstalling SQL Server2000,i can't register my Server in MMC with SA login anymore! I miss SA login? if Yes, what can SA login? if no, how can i use it? Thnks

More of an FYI in case anyone has run into this problem... We were running into the infamous "timeout on buffer latch type 3" error and was caused by the autogrow in tempdb. Apparently when SQL Server is getting hit pretty hard and tempdb is taking a timeout to auto-grow, SQL server craps its pants and times-out. This combined with the fact...

Hello All: Have a problem that I have never seen before and have not found anything on technet on how to resolve it. I have a SQL Server 2000 server that I have created a new database. I then used DTS to import data from a MS Access 97 database. Before making the import, I made changes to the MS Access database

I know how to detect errors if a stored procedure is used, by adding a ReturnValue parameter to the command object and then in the stored procedure having a RETURN @@ERROR But, If I am using the follwoing code in VB 6, How can I tell if the insert executed ok? I have to add error checking to a project that uses this

Hi! My first server is linked to an application (inserts, updates and delete). My second server is a read-only server that will be used on Internet. I need to send, each night, only changed data from my first server and restore or copy (or whatever) on the second server by FTP. FTP is the only choice I have for the needs.

Hi, Can you suggest a way to query an OLAP database maintained in Microsoft Analysis Services using a Java servlet? I particularly want to fire MDX queries from the servlet. Thanks in advance Manthan Kamat.

1) Can one find the location of the 'Transaction Log' at: <Hard Disk>\Program Files\Microsoft SQL Server\MSSQL\Data\MyDb_Log.ldf? 2) Is it safe to delete it, as SQL will create a new Transaction Log when it realises none already exist? 3) When trying to do 2) I get error message that file is in use, even though SQL Server is closed. Any...

I can't figue out whats wrong. I am a newbie to sql, however i'm totally lost. i get this error. "Microsoft OLE DB Provider for ODBC Drivers error '80004005' Data source name not found and no default driver specified login.asp, line 9" this is my code. <!--#include file=connection.asp--> <%

Hi to all, i've a "problem" with log shipping in sql server 2000 sp3. My log shipping works fine, but the task does not update log_shipping_primaries table on secondary server, and so log shipping monitor report always out of sync backup, even if all works fine. I've set log shipping using a sql server user created on both servers with...

Hi, On SQLServer 2000, I have a table with a following structure: MYTABLE col1 char, col2 date, col3 number My Objective:

What I am trying to do is get all of the records in a table that are out of sequence so I know which account numbers I can reuse. I have a range of account numbers from 50100 to 70100. I need to know which account numbers are not stored in the table (not currently used) so I can use. For instance say I have the following data in table: ...

Hi All can some one please tell me the transact sql code that can list all tables in a db. thanks Todd

We are quickly moving from a small comapny to enterprise. As it happens we want to watch SQL server (our bread and butter is data) more cloely. Weely/daily/monthly reporting, etc. I am wondering if there is something like webtrends for SQL server. i.e. what queries were called (or even tables), what stored procedures, how much bandwidth...

I have a stored procedure that takes 18 hours to complete. Sometimes I get the below error message when I run the stored procedure. 'Server : Msg 9002, Level 17, State 6, Line 1 The log file for database 'Customer' is full. Back up the transaction log for the database to free up some log space.'. I checked my log file and it is not full....

Hi, Could anyone tell me the backup strategy for a 1000GB database? Thank you! Peter Wang *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!

We're using SQL2000 on Windows 2000 Server, but this is a problem we've had on one particular database since SQL7 on NT4. The database in question is set to autogrow by 10% (currently sitting at 31Gb total size). However, last week users complained of a slowdown in performance. When we checked we found that only 14Mb was free on the...

This may be a simple question to answer, but I don't have a clue since I'm not a dba. I am using sql server 2000, while a client of ours is using sql server 7. Both using Windows 2000 as an OS, but I don't think that means anything here. My question is, why does he have to specify the dbowner in his query statements, while I don't? Is...

Hello, I am writing an application using Visual Studio .NET (C#). The application will be run on several workstations simultaneously, and all of them will be accessing a single sql server database. I am trying to have it so that when one of the applications updates the fields of a table in the database, all of the other applications are...