Archived Months
March 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server clients > april 2004 > threads for april 22 - 28, 2004

Filter by week: 1 2 3 4 5

Table Name
Posted by Noorali Issani at 4/28/2004 4:45:34 PM
I want to know the name of tables in which there are more than 200,000 records ? how can I Thanks Noor ...more >>

jeff
Posted by antz at 4/28/2004 7:59:16 AM
SQL .mdf file import. How can i import a .mdf file(291MB in size) into a txt file? a step by step guide - as i know nothign about SQL 2000 thanks / Regards, Jeff...more >>

DBCC CHECKDB Problem
Posted by Canaries at 4/28/2004 6:36:30 AM
I run the DBCC for a particular database in Query Analyzer, and it takes 3 minutes. I take the same SQL script and place it in a job to be scheduled in Enterprise Manager, and it takes 1 hour. Why? Please help....more >>

A TOUGH ONE - audit Login, Audit Logout connection
Posted by phil.smith NO[at]SPAM informatics.co.uk at 4/28/2004 5:25:45 AM
Hi all: Hope you can shed some light on this. we have a Vb6 app connecting to a slq server database using ado 2.6. when each client is started they initialize a connection object which is kept open for the life cycle of the client (i know this not recommended but it is an inherited problem)...more >>

SQL access via ASP scripts?
Posted by Mauricio Freitas [MVP] at 4/27/2004 11:17:29 AM
Hello! I'm using ASPAccessEditor (http://aspaccesseditor.aspit.net) with an MS Access database... Is there a tool similar to this for MS SQL databases? Thanks in advance -- Mauricio Freitas MS MVP Mobile Devices Bluetooth Guides: http://www.geekzone.co.nz/content.asp?contentid=449 Per...more >>

SQL/ADO (2.8) Timeout Error - Can't resolve
Posted by CJ Taylor at 4/27/2004 7:46:14 AM
Hello, We are a small/medium sized manufacturing facility that uses a home grown data collector on our shop floor to communicate with our SQL server that we do our logistics off of. Now I haven't been with the company all that long, I just maintain the current data collector now, and these ...more >>

Reduce Log File Size
Posted by cf_jian at 4/26/2004 3:51:01 PM
Dear Guys How to Reduce the log file size in SQL2000. I have used DBCC Shrinkfile(db_log,filesize) but it doesn't work. The Log file size still the same And my HD Size will be full. Have any suggestion. thanks ...more >>

Administrative Install
Posted by STEVE SCHNEIDER at 4/26/2004 10:26:00 AM
I am looking at attempting to create a deployable installation of the SQL client tools only. anyone know an easy way to do this?? Steve...more >>



set date format?
Posted by Janus Knudsen at 4/26/2004 2:06:05 AM
Hello.. As I remember I ran across a set statement that could control the dataformat on the server For instance print cast(getdate as varchar) it returns current date and time in am/pm format, but in Denmark we're not using this format, we're using 24hour format. Obviously I could use CONVERT, b...more >>

set password on backup file
Posted by Noorali Issani at 4/23/2004 12:38:41 PM
How can I set the password on my database backup file.. I don't wanna use zip options... Any idea about encryption? Thanks NOOR ...more >>


DevelopmentNow Blog