all groups > sql server clients > july 2003 > threads for july 1 - 7, 2003
Filter by week: 1 2 3 4 5
MMC as a SQL app front-end
Posted by Steve Jensen at 7/7/2003 7:37:56 AM
This may be the wrong place to ask this, but here goes...
How programmable is MMC? Can it be used as a front-end
for a SQL Server app (it would always be run on a server
anyway)?
It would need multi-select drag-and-drop between nodes,
and context menus would need to call VB.NET programs... more >>
Backup
Posted by Alan Roberts at 7/4/2003 9:58:33 PM
Does anyone know of a technique/tool for backing up a database on a remote
machine. My ISP provides me with s SQL Database within their SQL server
farm. I have admin rights over my database within the system but vcan't
access all of the other databases that exist. I would like to be able to
b... more >>
real world question :- is Access a good front end to a SQL server or should I use VB, .net etc..
Posted by Vince at 7/3/2003 5:15:03 PM
Hi,
I have a rather 'busy' Access DB used by no more than 10 users at the mo',
it doesn't have lots of records, (under 100k), bu the user drag and the way
that the tables get their data for queries means I am thinking of using SQL
as a back end.
As I have over 100 forms, 250 reports and qui... more >>
DSNLess - SQL Server Connectivity
Posted by Sutapa Das at 7/3/2003 12:53:51 AM
How to create SQL server database connectivity without a dsn? I am using
ASP as frontend.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!... more >>
Subqueries
Posted by Jeremy Moncho at 7/2/2003 2:34:46 PM
Hello!
Using on other DBMS I am today needing to do some work on Sql Server 2000.
My question is, are Subqueries "really" illegal in insert statements?
I am trying something in the following:
Create table test(
test id int,
testStr varchar(25)
)
Insert into test values ((sele... more >>
Query Analyzer hangs during File Save
Posted by Tim Shults at 7/2/2003 10:29:31 AM
When I save a file in Query Analyzer the program freezes
up for 20-30 seconds at a time.
This is getting very frustrating because out of habit I
hit Ctl-S every few lines or so.
I've defragged my disk. Turned off my Virus Scan.
Archived several folders under MyDocuments (under which my... more >>
cleanup the tempdb
Posted by Abraham at 7/1/2003 6:01:01 PM
Is there currently a way to cleanup the tempdb?
Tried dbcc shrinkfile , but no luck.
Can't restart the server ,because it's on production.
What makes tempDB big ?
and tempDB is in Simple mode , but not truncating it .
Thanks
... more >>
|