Microsoft SQL Server Forum

Hi all, Here is my problem, I have 3 tables : People ------------- IDPeople Firstname Lastname

The following query works fine against SQL Server 2000 here in the US: SELECT * from TNEWSARTICLES where CreatedOn < '2003-04-25 14:22' But in the UK, it returns this error: 80040e07: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value If I change the format to YYYY-DD-MM, then it does...

Hi I tried running ITW against one of our databases, and it came up with a number of suggestions, but also filled the Application Log with messages like:- The description for Event ID ( 4 ) in Source ( ITW ) could not be found. It contains the following insertion string(s): Error in Parsing Event: declare @P1 nvarchar(1)

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

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

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

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

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

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>

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

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

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

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

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

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

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

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

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