Sending commands to the SQL engine with the |DataDirectory| string in the database name
Sun, 6 Apr 2008 20:00:23 +1000
Hi,
Here's my code:
SqlCommand cmd = new SqlCommand("sp_dboption", sqlConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@dbname", mdfName);
cmd.Parameters.AddWithValue("@optname", "offline");
cmd.Parameters.AddWithValue("@optvalue", "true");
try
{
cmd.ExecuteNo ...
|
Article/tutorial needed regarding deployment with mdf
Sun, 6 Apr 2008 06:08:35 +1000
Hi,
VS2005 running with SQL Server Express. My app needs a simple table, if I
include the mdf with the deployment, then the database will be overwritten
with updates (losing the site data). So does anyone know of a good
article/tutorial describing how to deploy a simple table via scripts
particularly in regards ...
|
help,a difficult text how to sql table code ?
Sat, 5 Apr 2008 15:32:34 -0700
help,a difficult text how to sql table code ?
i have a text as follow, line with ¡°|¡±and {LF},
8|-000000186075919.|+000000000387820.|2008-03-31|20010423|
9|-000000000003919.|-000000000123620.|2008-03-31|20010123|
8|-000000018623419.|+000000000381230.|2008-05-30|20010423|
i want to sign char(1)£¬ ...
|
MSDE sp4
Thu, 3 Apr 2008 12:38:24 -0400
I have MSDE installed from a Crystal Enterprise installation. It is
throwing flags on our security scan and needs to be moved to SP4. A
straightforward upgrade, I am told, doesn't work.
How might I upgrade this app?
Thanks
B
...
|
Which Version of MSDE to use?
Wed, 2 Apr 2008 13:16:02 -0700
I need to load MSDE on a client computer to support an access databases that
kicks off a DTS package. Since SQL Server 2005 does not directly support
DTSRUN should I install MSDE 2000?
Thanks,
-Chris
...
|
Re: SQL Express edition install
Tue, 1 Apr 2008 11:12:24 +0000 (UTC)
Hello Ekrem,
think this is the easier way:
i am trying to install SQL Express Edition on a cluster node and during the
setup it stops just. On the cluster node was installed BackupExec11d which
was removed and also completely deleted from the registry.Also did follow
http://support.microsoft.com/kb/90996 ...
|
Re: SQL Express edition install
Tue, 1 Apr 2008 10:34:02 +0000 (UTC)
Hello Ekrem,
That's seems to be the same content like this i have used:
http://support.microsoft.com/kb/909967
Best regards
Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http ...
|
|
|
2 processes accessing one mdf file
Tue, 1 Apr 2008 15:05:53 +1100
Hi,
VS2005
I am trying to write a service and a service controller. Independently, both
work properly. They both access an mdf file with the following connection
string:
String connectionString = @"Data Source=.\SQLEXPRESS;" +
"Initial Catalog=;" +
@"AttachDbFilename=C:\development\portSAF\portSAF.mdf;" ...
|
SQL 7 SP-4 kills Win2K SP-4 rollup v2
Mon, 31 Mar 2008 18:35:20 +0300
Installing SQL 7 SP-4 to update MSDE (Office 2000) is causing MS Baseline
security analyzer to flag Win2K SP-4 rollup v2 as missing. (Before the SQL
update, MBSE showed the rollup installed normally) After reinstalling the
Win2K rollup, it still does not show up in MBSE.
Any suggestions to resolve the issue w ...
|
How to make 2 installation of MSDE coexist on one PC ?
Wed, 26 Mar 2008 13:48:43 -0400
Hi All,
We have 2 apps that use MSDE 2000. One app uses MSDE 2000 SP4 and is already
installed on the workstations. If I install, on the same machine, a second
app using MSDE 2000 SP3 then the first app stops working. I was able to run
a conflict detection tool (from Altiris) that gave me a result file
(too b ...
|
