I need a little MSDE 2000 help
Fri, 14 Dec 2007 11:27:08 -0600
Hey everyone,
I have a system that is running MSDE 2000 and we run the following script to
back it up:
osql -Usa -P -n -Q "Backup Database MyDB To Disk =
'E:\mssql7\backup\mydb.bak'"
The problem is that it appends and fills up my HD. Anyone know what I would
need to do to change it to "overwrite"?
...
|
MSDE over TCP/IP
Tue, 11 Dec 2007 12:25:00 -0800
I've got a SQL Server Desktop Engine (version 8.00.2039 - SP4) installation
running our SharePoint site. I now need to connect to this database remotely
via TCP/IP, but can't get it to enable the protocol.
The log file always just says:
2007-12-11 12:13:46.39 server Using 'SSNETLIB.DLL' version '8.0.203 ...
|
Question about MSDE on ISA Server
Wed, 05 Dec 2007 09:04:56 +0100
Hi @all,
maybe you know that after installing an ISA-Server 04 a msde sql server
will be installed as standard log-backend. Now our ISA is a
domain-member and every domain-admin has access to this sql instance.
How can i strict the access only for a few people (especially for
domain-admins) to this instan ...
|
SQLExpress2005, Backups to File, and Maintenance Tools
Tue, 4 Dec 2007 06:50:03 -0800
Greetings all,
I have a third-party app that used to use MSDE 2000. In order to ensure we
were able to backup the data from this app, we would connect using Enterprise
Manager to configure the database to create a file backup every night into a
specified folder. Now the vendor has moved to SQLExpress2005 ...
|
Migrating Data from SQL Express to SQL Server 2005
Wed, 28 Nov 2007 10:41:36 -0800 (PST)
Is it possible migrate a database from SQL Express to existing SQL
Server 2005? It is a encrypted DB. We are reaching the 4GB limit on
Express, and would like to move the Data to a existing SQL Server
2005.
Thanks
saqib
http://www.quantumcrypto.de/dante/ ...
|
Back up fails and restores empty database
Mon, 26 Nov 2007 23:31:01 -0800
Hello,
I have scheduled a daily backup. One database is empty every morning. The
log tells me:
Bypassing recovery for database 'DWHJZ_2000_Reports' because it is marked IN
LOAD.
Than it does this
Recovery is checkpointing database 'DWHJZ_2000_Reports' (8)
And finally it restores an empty version:
...
|
How to tell sql server the maximum size my temptable will grow so that it does at most 1 memory allocation?
Wed, 21 Nov 2007 13:42:04 -0800
How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?
...
|
|
|
Instalation MSDE failled !
Wed, 21 Nov 2007 11:58:52 -0000
Hello,
I'm trying to install MSDE but it fails.
I notice thatthe install log has several return values 3 wich means
problems.
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (AHFTSH,LocalSystem,87).
Action ended 11:25:35: InstallFinalize. Return value 3.
...
Start c ...
|
SQL Server 2000 v MSDE2000
Mon, 19 Nov 2007 17:34:02 -0800
How do we can ascertain if either the full version of sql server 2000 has
been installed, or MSDE 2000 on a computer? ...
|
bcp to xml
Sun, 18 Nov 2007 16:11:22 GMT
can someone please advise me on the correct syntax to bcp export executing a
stored procedures results to xml
I know it begins
bcp "exe sp_procedure" queryout
but unser on the rest of the syntax
many thanks
...
|
