Microsoft SQL Server Forum

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)

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 all, Here is my problem, I have 3 tables : People ------------- IDPeople Firstname Lastname

I have created a DTS package that pulls data in from Oracle into SQL Server. When I run it directly on the server (from Enterprise Manager), it works fine. When I run it from Enterprise Manager on a client machine that does not have the Oracle client software, it does not run, giving me the error: "The Oracle client and networking components...

I have a SQL Server database that is showing 2853.44 mb in size but when I export the data into MS Access the size is less than 1 mb. Can anyone tell me how to reduce the size of my SQL Server database so that it's less than 15 mb? Thanks in advance! Rob

Consider this SQL Query: ----------------------------------------------------------------- SELECT c.CASE_NBR, DATEDIFF(d, c.CREATE_DT, GETDATE()) AS Age, c.AFFD_RCVD, c.PRV_CRD_ISS, x.RegE, x.Type, x.Fraud, c.CUST_FN + ' ' + c.CUST_LN AS CustFullName, c.ATM_CKCD_NBR, x.TotalLoss, x.Queue, x.Status, c.QUEUE AS Expr1, x.CHECK_ACT_NBR,...

Should be easy, but I've been trying to figure this out for about half an hour with no luck. There is a table 'Cybex' which has all the Cybex products we sell, and a table 'Datasheets' which contains a list of the datasheets available for products. Both tables have a PartNumber column. On with the problem. If i do SELECT * FROM Cybex, it...

Hi, I just want to know to turn this: CREATE TABLE . ( NOT NULL , (50) COLLATE French_CI_AS NULL , NOT NULL , (50) COLLATE French_CI_AS NOT NULL , NULL , NULL ) ON into this:

Hello all... I'm stuck, I cannot figure out how I should go about flagging conflicts on a sheduling app. I currently have 8 columns (school grades) that have class over the course of 9 periods. I am populating the asp page fine, and making changes to the database with forms lists. I need to compare all the results of one period (thats 8...

Hi All, I want to create a cube using MSSQL2000 i dont know any thing how to create and what is parameter required so if any body help me i will be thankfull to him/her.For information : i have 4 tables custdetailtable which contain all about a customer as per example customer ID,name,add,CUSTOMERID IS PRIMARYKEY, Proddetail table which...

Hello Suppose a database Db1 with tables tl1 and tl2 and a second database db2 with tables tl3 et tl4. Is it possible to make a join between tables of the two databases ? As for example, Select * from tl1 INNER JOIN tl3 where tl1.Field1 = tl3.Field3

¹ï§Ü¤£´º®ð>>>>¦b®a¤u§@¼W¥www.cashcome.net ±b¸¹¡Gsohoman *W3

Good morning: At least it's morning where I am. :) I have a rather newbie question I'm afraid. I have VisualStudio.NET, and have installed it along with SQL server. However I can't seem to find an administration front-end to SQL, other than the VisualStudio, which is ok for creating databases and adding tables/columns. However when I go...

how do i specify the table destination only not the whole database from a text.txt source? thanks, trint

HI All, I created a SQL Server DSN using Windows ODBC Data Source Administrator. While creating the DSN, it asked me about authentication process in reply to which I selected "With SQL Server authentication using a login ID and password entered by the user." and then gave my SQL Server login ID and password. After following the regular...

Hello! I am looking for a SQL server Full-Text replacement. Does anybody know an alternative product that does full-text on db columns? This is my situation: I have large databases 40gb with varchar(200) fields. That I would like full-text index, so that later I could make CONTAINS

Hi, While restoring the log we receive a message after about 30 minutes: Processed 1152109 pages for database 'restest', file 'sales_Log' on file 1 Server: Msg 9004, Leverl 21, State 20, Line 3 An error occurred while processing the log for database ' '. It is unclear why the databasename is an empty string, I guess there must be

Hi, We have a problem when trying to present data retrieved from SQL Server in an e-mail. We don't use SQL mail - we use JMail (in ASP code) and need to encode the message using ISO-8859-2. When ISO encoding is set in a message header, static text written in the message are OK, but data from DB (where they're stored in UNICODE) come without...

How to make a query which contains fields from two different bases ? Thanks in advance. ReN

I downloaded the latest version on JDBC from Microsoft and I got problems. Indeed, when fetching a smallint from SQL Server i got instead an Integer. How can i do to avoid such a problem? Some hints? many tanks, gaetano

When we insert text into field in a table, SQL SERVER apparently replaces apostrophes with question marks -- is there a way to not have this occur? We don't have this happen with the mySQL databases that we also support. Much help appreciated.

I have a table in my database on SQL Server which holds a file name that refers to a file that is stored on the server. I would like to create a trigger to delete this file from the server if the row in the table is deleted. I have been trying to use this command in a trigger (<filename> is the name and path of the file): xp_cmdshell...

I have a web-based admin section for a site and I would like to be able to query the SQL Server database size and display it within my admin area. Is there a function or method of doing this? My database is hosted by a third party... I appreciate any tips or advice you can provide! Rob

I have an application that I am working on that uses some small temp tables. I am considering moving them to Table Variables - Would this be a performance enhancement? Some background information: The system I am working on has numerous tables but for this exercise there are only three that really matter. Claim, Transaction and Parties. ...

Hi, Trying to get a grip on the "join" thing :) Up until now, I allways used this kinda method: "(select t1.a from t1 where t1.b in (select t2.ab from t2 where t2.b=0))" How can this be accomplished using joins? And if you have the time please explain the "bits" :)