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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|