need to install SQL Server Agent SQL Express 2005
Fri, 25 Apr 2008 17:04:00 -0700
I am running SQL Express 2005 and I need to install the SQL Server Agent so I
can use it to do backups. How do I do that? ...
|
SqlExpress distribution and access rights
Thu, 24 Apr 2008 11:54:03 +0100
Hi, I'm using sqlexpress 2005 with a .NET
applikation. Security is set to integrated mode.
When deployed, the app's database will be created via
script by the installer.
Now, by default this database is not accessable if
the current user is not logged on as (xp-)administrator.
As workaround it is possible to ...
|
SQLCE Master/Detail using BindingSource
Tue, 22 Apr 2008 20:25:08 -0700
I have spent many hours on this and have not found a way to have a
Master/Detail or Parent/Child table work with the child having the correct
identity value passed. I build two tests projects one with SQLCE and the
other with SQL Express 2005. The SQL Express 2005 worked without a flaw.
The same code did ...
|
SQL Server Express: maintenance plan
Mon, 21 Apr 2008 04:01:00 -0700
I use SQL Server Express 2005 SP2.(Microsoft SQL Server 2005 - 9.00.3042.00)
I want to make a maintenance plan, but I don't have a task called
"maintenance plan"
I am user sa with "sysadmin"
How can I make a maintenance plan.
Thanks for your help
Thomas
...
|
MSSQL database security
Mon, 21 Apr 2008 00:09:19 -0700 (PDT)
MSSQL databases contain exclusive information so it is crucial to
secure them. MSSQL security becomes hassle free with the help of an
automated tool Secure Auditor which is capable to enumerate and audit
MSSQL database. Be a step a head of hackers or intruders and find
vulnerabilities in your MSSQL database. It ...
|
XP_CMDSHELL executes successfully on SQL 2000 but fails on MSDE 2000
for Sharepoint DB
Thu, 17 Apr 2008 16:20:27 -0700 (PDT)
We have two instances of MS-SQL Server 2000 on the same Win2003
server.
Both instances use a Startup Service Account (domain\sql) instead of
LocalSystem.
In both instances we need to use XP_CmdShell to map to a share on a
NAS for backup purposes. The NAS is in a server farm and is not part
of our domain.
...
|
MSDE sysadmins
Thu, 17 Apr 2008 12:06:01 -0700
Hi,
I have a W23k server running an app that uses MSDE. I have renamed the
administrator user. Since I have done that I keep getting this error in the
event log.
Login failed for user 'NT AUTHORITY\SYSTEM'. Searching the net - I have
found answers to add the NT Authority to the sysadmins. How would I do th ...
|
|
|
Move MSDE2000 database to SQL Server 2000
Thu, 17 Apr 2008 06:26:03 -0700
We have an application which has an MSDE2000 database and we need to move it
to our SQL Server 2000 cluster environment which runs on SQL Server 2000
Enterprise edition. Can we detach the MSDE2000 database and attach it to our
cluster server? I read a article on MSDN that the MSDE2000 can be upgraded to
SQL ...
|
.MDF file convert/attach to SQL 2000 Server
Wed, 16 Apr 2008 10:15:02 -0700
We have an application server that has a local database, using MSDE (.mdf).
We would like to point this database to our SQL 2000 server, which was
suggested by the techs ... curious to know if its possible to grab the .mdf
file from the application server and import it into our SQL 2000 server
server, or do ...
|
MSDE tries to install each time someone logs on
Mon, 14 Apr 2008 17:07:00 -0700
A web search which turned up a really old thread (circa 2006) about this
problem in this newsgroup, but alas, no solution was revealed in the thread.
I'm hoping sometime in the subsequent years, someone has come up with a
solution!
I am installing a third-party product to a WinXP SP2 machine that is a
mem ...
|
