How i compare the date field in the table with date '29/11/2005' See following query select sum(quantity) as QTY_SQMT, sum(QTY) as QTY_SQFT from fade1105 where date=???????????????????? any help wil be great.. -- Regards, Amit Mohod AB Softskills, Nashik. Cell No: 09822939505 Office: ...more >>

We are using a third party erp system that uses MSSQL We have over the years created additional tables. One of these 'bespoke' tables appears to be corrupted and I am stuffed! I cannot access it using the select statement, or even via MS Access (ODBC call failure). Can someone advise m...more >>

Is there a way to install SQL 2005 Express with more than 1 gb. of ram. or limit the addressable ram in Express to just 1 gb? thanks...more >>

Hello... I am taking a slight break from my ASP.net 2.0 studies to finally understand SQL databases and the book I am using is asking me to create an SQL database and tables. However, I can't seem to find an SQL command prompt. I have SQL Express installed. Suggestions? Thanks, Brian ...more >>

I have been using sql server 2000 for about 4 months. For a small company, I need to come up with backup and restore procedures for a sql server 2000 database. This company will not consider using sql server 2005 until the end of 2006. Thus I am wondering if you can give me a script and/or...more >>

Hi all, I can't quite understand what's going on here, can someone please = explain. I created a SQL 2000 named instance (mixed authentication mode) on a = Windows 2003 + SP1 (32-bit) server, started the SQL server. The host is = not part of any Windows domain (belongs to default WORKGROUP)...more >>

Hi all, I have a new server with small business 2003 and SQL 2000 SP4. Also there is a VB6 app connect to the DB. On the old server when the VB app pass a sql with dd/mm/yyyy format, it works fine but now it seems the db server just want the mm/dd/yyyy format, the server already config....more >>

I am trying to restore a backup of Database1 on Server1 to overwrite the existing Database2 on Server2 and keep running into an error. The steps I followed were... * On Server1 Database1, I backed up the database * I move the .bak file to the new server (Server2) * On Server2 I said Restore ...more >>

I can run stored procedures in SQL Query Analyzer but not in Enterprise Mgr. One of the stored procedures runs a SELECT query that sorts a table displayed in a view. Another procedure deletes rows in a table. I can run all of these in SQL Query Analyzer. In Enterprise Mgr, however, I can...more >>

Hello, I could not find any information on the upsizing/upgrading MS Access 2003 database files to new SQL Server 2005 Express type. I am a novice in this topic, therefore I need step by step instructions. I am using XP (SP2), Office 2003, I also installed SSMSEE. Can somebody produce instruct...more >>

ok .. ive a small prob with inserting an array of dates .. this is the situation ... ive a sproc which when run checks for todays date & if its > the date in the db inserts a new date into the db & runs a bunch of cmds.. that much is working fine now if i run the sproc 3 days later th...more >>

I have a SQL server and would like to move one of the databases off of it to another server (not running sql) the reason is because we had to limit the size of this db because of HDD constraints, now the user has their own server and does not have their own SQL license so I want to move just ...more >>

What is this statement missing ? SELECT id FROM Cases WHERE Cases.tempcaselogid = CaseComments.tempcaselogid I get this error: Server: Msg 107, Level 16, State 3, Line 1 The column prefix 'CaseComments' does not match with a table name or alias name used in the query. I need to use "...more >>

Hello, I have a database that contains some data for a website. One of the tables has some data that was changed somehow and I want to change it back to the original values. The field is a date field named modified_date. I have tried to change it through query analyzer but the value will not ...more >>

Hello, Is there a way to check all columns in all user tables for a certain value? Thank you in advance for any suggestions! Diane...more >>

I am trying to compare 1 table in database Production_ED and 1 table on database Sales_Force. My query is: select production_ed.company.vista_account from production_ed.company where sales_force.dbo.Salesforce_Duplicate_Accounts.vista_account_id != production_ed.company.vista_account I am...more >>

Hi, I want to make a Diagram for my SQL 2005 Database. The Database is a former SQL 2000 database I moved to SQl 2005. When I open Database Diagrams I get this error: Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, fir...more >>