Microsoft SQL Server Forum

I have a SQL Server 2000 database that I will need to take from development and put into production. Currently the database is on a workstation running Windows 2K Server for development purposes. The database will have dozens of users with data entry capability and hundreds of users with viewing/querying capability. The users will have a web...

I need to have a script that will stop replication before we failover to our high availability server. I am running on SQL Server 2000. I really only need the command line syntax. I can write the script... Thanks Leigh

Hey everyone, I have a set of stored procedures that call each other to perform a set of tasks. I have decided to do this for database performance reasons rather than doing it from a ColdFusion page (and to prevent timeouts, etc.) These stored procedures run every night and handle scheduled tasks in a complex system.

Hello, I am having a problem with a join. Either I am just not seeing the obvious, it isn't possible, or I need to use a different approach. I have an application with a vsflexgrid that needs to display the following: filenumber, BL, Container_BL, BL_HBL, HBL, Container_HBL The tables look like:

We have forms written in Visual Basic 6.0. They were previously written for an Access database which was moved to SQL Server 2000. Here's the connect string I used: ODBC;UID=visualbasic;PWD=password;SERVER=MPSQL;DRIVER={SQL SERVER};DATABASE=MPPhoto The user visualbasic and the user logged in to the computer have full rights to the...

I am at a client that uses an xml form to email from java rather than setup a true email server. Does anyone have any suggestions as to how ms sql can write to the xml or maybe even call java or xml directly. This will be done as part of the error detecting process of various sql jobs in EM. Thanks, Mike --

Having this description column in a table "Cookies, peanut butter sandwich, regular" When using this WHERE clause: WHERE (((Food_Data.Description) Like "*Butter*" & "*Peanut*")); I dont get any results, however when using it this way round

Hi, I have a SQL script which create few tables. Currently, I have to paste the scripts to the SQL Enterprise Manager and highlight one by one to run it. It can't seem to run it as "one unit". My script looks like below: CREATE TABLE T1 AS ...;

My need is to add a linked server into an MSDE1 server. Linked server is a Cachè dbms engine, running under NT OS. I found ODBC drivers by InterSys, and they seem to work. I really appreciate any comment, suggestion, tip&trick about reliability, performance, of this link. Thanks

How would I create a database alias name for the following database testingdatabase.com This database exisist on a remote server. I have tried using the database name as server..dbo.table were server is a linked server using sp_addlinkedserver is the database name dbo is the instantance

I have user that we just migrated his Access database to SQL Server. All went well with the migration, but then he came up with another requirement to be able to replicate the database to a local SQL server living on the hard drive of a laptop. Before the migration he just copied the entire Access databse to the lap top. I tried using the...

current config: Windows XP SP1, SQL Server 2000 trying to install : SP3a on SQL Server 2000 1. I downloaded the three files of the service pack from (http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en) .. 2. Saved the three files to a same local directory d:\sqlsvr3a. 3. Click...

I am getting lot of deadlocks in my application. As it is very complex ti avoid deadlocks at this stage of application we have done few steps to lessen the impact. We have added retries after deadlock is capturted. We have added select * from TABLE with (nolock) wherever possible. But interestingly second step is not working. I have few...

Hello All, SQL 2000, case insensitive database I have a situation where I need to find abbreviations in the rows in a table. The rule i came up is, get all the rows from the table where there is more than one character is capitalized consequtively eg. "USA", "TIMS", "AIR" Here is the sample data:

I keep getting the following error message when I run a serie of SQL commands: Server: Msg 9002, Level 17, State 6, Line 15 The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space. I have tried "dump transaction tempdb with no_log" right before I run the SQL command. But that...

Hello, I have a script running that is supposed to run through a Cursor of Records and, by some checks, insert or update a few other db tables. For some strange reason the procedure seems to stop at some point without producing an error. This only happens if I run the procedure as an SQL task in a DTS package. If I run it in the SQL...

Hello, I have a script running that is supposed to run through a Cursor of Records and, by some checks, insert or update a few other db tables. For some strange reason the procedure seems to stop at some point without producing an error. This only happens if I run the procedure as an SQL task in a DTS package. If I run it in the SQL...

I'm having a difficult time calling UPDATE when my 'WHERE" clause calls ID, which is numeric and the primary key. I found that I can do a SELECT just fine with "WHERE ID".. Is there something special about UPDATE that i'm not getting? I've searched the internet but it appears that what I'm doing should work. Any help would be greatly...

How do I order a query by a date field ASC, but have any NULL values show up last? i.e. 7/1/2003 7/5/2003 7/10/2003 <NULL> <NULL>

MySQL Turbo Manager Provides powerful tools for MySQL Database Server administration and development. New features 2.4.2.5 and 2.4.1.0 Table data export Table data import

Hi, I've run into a bit of a sticky design issue. We have products in three categories which I will call 'A', 'B' and 'C'. We have "kits" which contain three products, one from each category. Below is some sample SQL to set things up, but I need to ensure that each kit gets three products -- one from each category. Obviously, this...

Hi, I have an SQL Server database sitting on IIS with a booking system that holds info on customers, training courses etc and a callback log .. My colleague has a website that details training courses, locations, prices etc and was developed in Coldfusion that sits on a MySQL server. There is no customer booking facility. There is an admin...

Hello- I created a MS Access 2002 database with linked tables on a SQL Server database by way of a File DSN, A. I have created a form which points to one of the linked tables. After I finished testing it in the development environment I updated the path for all the linked tables to a new File DSN, B. After this action, I opened the form to...

Hello all, I have the following requirement (SQL 2000, SP2) 1. Need to restore production database(A) to another database (B) on another server (No direct connection) 2. In the restored back-up(B) SP codes should not be visible (even to sa) or all SP's can be deleted . 3. This needs to be carried out daily

Anyone has a "one sql statement" to get the total spaceused and total space allocated of an instance ? ie same as sum of relevance fields from sp_spaceused for each database in an instance, that works accross version of mssql from 6 onward. Thanks KD