|
|
|
June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Replacing MSDE by SQL Server 2005 Posted by anibakore at 10/30/2006 1:55:24 AM Hello ,
I have an application that uses MSDE internally. Now I want to replace
that MSDE database by full SQL Server 2005. I have SQL server 2005
installed.
Is it possible to replace the MSDE instance that the application is
using, by SQL server instance without changing the application's
conf...more >>
Importing from another database on same server using SQL Server Express Posted by John Hackert at 10/29/2006 6:07:29 PM I haven't been able to solve this likely syntax problem despite
referring to these groups, the Books On Line, and reference texts:
Without the use of Data Transformation Services in SQL Server Express,
what techniques work to import/export data between databases under the
same server instance?...more >>
Can SQL Server 2005 developer and SQL Server 2005 express be installed on the same machine without issues? Posted by hidden at 10/27/2006 12:02:52 AM Can SQL Server 2005 developer and SQL Server 2005 express be installed on
the same machine without issues?
...more >>
Trouble connecting to MSDE SP4 on Windows 2000 Posted by crussell at 10/26/2006 1:01:01 PM Hello
The operating system on the server is Windows 2000 Server setup as a domain
server and the clients are all on Windows 2000. All are on the most recent
service packs. Using the Active directory on the server I have added all
users as Domain Admin's. I have also disabled all firewalls...more >>
Database Internals Posted by MATTBIONDI at 10/24/2006 6:18:02 PM Hello guys,
I am working in a simple work for my college where I have to choose a
database to talk about optimization, structures, transaction control,
recuperation, and distribution. I chose SQL Server, but I can't find anything
on the Internet. Where can I find this information or which d...more >>
Query 10 times slower (and results reordered!) from ASP.NET page than console app. Posted by wizofaus NO[at]SPAM hotmail.com at 10/24/2006 4:08:15 PM I have a chunk of code which is essentially
IDbCommand cmd = db.CreateCommand();
cmd.CommandText = "SELECT X, Y, Count(*) FROM Foo WHERE Z = 1 GROUP BY
X, Y";
using (IDataReader reader = cmd.ExecuteReader())
while (reader.Read())
{
// grab values from query
}
The database is...more >>
Open Connections - Can't Drop Posted by Charles A. Lackman at 10/23/2006 4:50:07 PM Hello,
I am using SQL Express and Visual Studion 2003. I am trying to DROP
DATABASE Customers using a Stored Procedure and also using ADO.NET.
Query:
IF EXISTS (SELECT name FROM sys.databases WHERE name = Customers) DROP
DATABASE [Customers]
ConnectionString:
RemoveConnectionString =...more >>
SQL Express 2005 - Endpoint Support? Posted by Vaughn Haybittle at 10/23/2006 12:00:00 AM Hi,
I am running Windows XP Pro with SP2. I would like to know if SQL Server
2005 Express supports endpoints? I have created a web application that get
data from an MSDE 2000 database using SQLXML (i.e. I get data using URL's).
I want to know if I can upgrade from MSDE 2000 to SQL 2005 E...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Express 2005 - Tables signature Posted by zoug at 10/22/2006 4:15:48 PM Dear all,
I got a probleme with some database in sql express 2005,
since yesterday, some of my database (not all) return an error when I try to
open tables :
ERRORLOG :
2006-10-22 15:54:21.35 spid53 Error: 33002, Severity: 16, State: 1.
2006-10-22 15:54:21.35 spid53 Access to tabl...more >>
client network utility & server network utility - what's the difference? Posted by Keith G Hicks at 10/22/2006 11:52:23 AM I'm confused about this. If I need MSDE installed on a server and have 10
workstations accessing it AND I don't want to use port 1433, what's the
process I need to go through to make that work right. I've fumbled around
with it and am not sure I follow the process. It seems logical to me that I
...more >>
Connect timeout?? Posted by perspolis at 10/21/2006 12:00:00 AM Hi all
I set the connection timeout property in my connection string but it dosen't
effect.
my connection time out in 30 sec..I set it to above 30
but it dosen't effect..
...more >>
Still Cannot Login sa Posted by Charles A. Lackman at 10/19/2006 10:59:43 PM Hello,
I installed SQL Express using the following Silent Install:
SQLEXPR.EXE /qb SECURITYMODE=SQL SAPWD=MyPassword ADDLOCAL=ALL
INSTANCENAME=SQLExpress DISABLENETWORKPROTOCOLS= 0 SQLAUTOSTART=1
I cannot login using SQLCMD - E or -U sa -P MyPassword or with
MyComputer\SQLExpress
Usi...more >>
sa not working Posted by Charles A. Lackman at 10/18/2006 10:32:21 PM Hello,
I installed SQL Express in a silent install using the following:
SQLEXPR.EXE /qb addlocal=all instancename=SQLExpress SAPWD=MyPwd
Disablenetworkprotocols = 0 SQLAUTOSTART=1
The install works just the way I want it to.
But when I try to connect to it using ADO.NET or from sqlcmd ...more >>
trouble updating "A" to sp4 Posted by Keith G Hicks at 10/18/2006 8:19:20 PM I have a customer who bought a Dell computer that has an instance of MSDE
already on it "MICROSOFTSMLBIZ." I guess this is for Outlook 2003 business
contact manager. I installed another instance of MSDE (with SQL
authentication) before I realzied that was on there and rather than giving
mine an ...more >>
command line uninstall of sql express 2005 Posted by paul at 10/18/2006 1:06:01 PM Another developer is writing the install/uninstall for our app and we're not
sure about the best way to uninstall the database component when the app is
uninstalled. Basically our app installs sql express 2005 ( + other .net stuff
) during install using the command line options and that works ...more >>
a faster way to update a big table Posted by netman Mo at 10/18/2006 6:27:20 AM hi
well I am working on a project that our database has 2, 8000 record table that they have triggers on the update of their feilds
our application must update these tables but it takes a long time to do this
I know there is something named bulk insert but I couldn't find sth similar to this...more >>
SQL2KSP4 Posted by Spike at 10/17/2006 6:11:01 AM Hi,
I'm trying to upgrade my default instance of MSDE (verified with SELECT
SERVERPROPERTY('Edition') ) with SQL2kSP4 using the following:
setup /upgradesp sqlrun /L*v c:\MyLog.log
I've tried specifying the instanceName(MSSQLSERVER) and AdminUser/Password
combination but whateverr I do ...more >>
how do I change client ports? Posted by Keith G Hicks at 10/16/2006 2:15:10 PM I am installing MSDE on a system and am using the free tool dba Mgr to
administer a few things. There's a server network utility where I can change
the port # just as with MS SQL server network utility. However, I need to
change the clients also. Since I'm not installing client tools from an MS
...more >>
Disable Windows Authentication mode in WDA Posted by gogaz NO[at]SPAM rediffmail.com at 10/16/2006 1:34:17 PM Hi,
I have installed MS SQL Server 2005 Express Edition, and SQL Web Data
Administrator on my Windows 2003 webserver with IIS 6.0
Everything works fine but I want to deny the users to log on WDA using
Windows Integrated authentication.
At the moment when i open http://ipaddress/webadmin i...more >>
MSDE transaction log full Posted by Zack at 10/13/2006 10:44:58 PM I'm getting the following error.
"Back up the transaction log for the database to free up some log space"
How can I fix it. I'm a newbie when it comes to MSDE, so I need detailed
instructions. Thanks.
...more >>
Uninstall/Reinstall Help! Posted by Kevin Thomas at 10/13/2006 2:31:14 PM System: IBM ThinkPad running Windows XP Pro 2002 SP2
Problem: MSDE and Microsoft SQL folders were manually deleted from within
C:\Program Files. Now I am unable to get MSDE or SQL to install
successfully again. I tried to re-install my original version of SQL and
MSDE, but the attempt fai...more >>
WMSDE and SQL Server 2005 Posted by Rose at 10/11/2006 10:39:01 AM I have a downstream WSUS server running WMSDE synchronizing with an upstream
WSUS server running WMSDE.
What if I want to move to SQL Server 2005 on the downstream server? Can I
load SQL server 2005 on the same machine and leave wmsde running for WSUS?
The server is capable of running S...more >>
SqlCommand and fun ?! Posted by cooltami NO[at]SPAM gmail.com at 10/11/2006 8:43:42 AM Hi,
Here is my sql statement, which includes two insert and one select.
string sql = "Insert into TestMultipleTran..TradeValueCountryPeriod
values ('H1',1994,'100','101',14521.20);" +
" Select * from TestMultipleTran..TradeValueCountryPeriod;" +
" Insert into TestMultipleTran..Tr...more >>
SQL Sever 2005 Express Client Question Posted by Joel at 10/11/2006 7:48:54 AM I downloaded and installed SQL server 2005 Express onto a Win XP Pro
Computer. If I want to access the database from another computer what
client do I install on the 2nd computer? (In 2000 it was the Client Network
Utility but I am not sure how to do it now).
Thanks
...more >>
SQLDMO SQLServer.Databases Posted by Marius_C at 10/10/2006 5:30:20 PM Hi,
I am using the SQLDMO SQLServer.Databases.Item("db name") to access a
database on a server in our company network. It takes over 2 minutes to get
a response (too slow !!!); the server is a MSDE, and contains 20 databases
in one instance.
Thanks,
Marius.
...more >>
Can not create a new instance Posted by Ian at 10/9/2006 5:08:01 AM I have SBS2003. I am trying to install Panda Antivirus. It tries to create an
MSDE instance and fails with "setup failed to configure the server ....". I
have been through the process of deleting the previous MSDE instance
completely yet the problem still occurs. I have tried to create a manua...more >>
can I use msde use for small workgroup Posted by SF at 10/8/2006 12:00:00 AM Hi,
I have an access database for 3-5 users. Currently, the size of database
increase which in turn reduce the database performance. I thing to put the
back end to SQL by using MSDE since my unit cannot afford the SQL Server
version.
Can I use msde to host data in a shared drive in the n...more >>
I'm unable to install SQL SERVER 2005 develop ed. and VISUAL STUDIO 2005 Posted by 3Dfelix at 10/5/2006 12:00:00 AM
I'm unable to install SQL SERVER 2005 develop ed. and VISUAL STUDIO 2005 in
the same computer.
I have tried to install several times from different ways and all was with
error.
I understand that I have to uninstall all previous versions os SQL and VS. I
done it.
I understand that first I...more >>
How to include SQL Express in Installation Package and change some option? Posted by Philip.Arbin at 10/4/2006 9:44:19 AM Hi, there,
I'm working on a windows application project which uses SQL Express as
database.
I found I can include SQL Server 2005 Express Edition in the installation
project as Prerequests,
that's cool.
But I need do more things, I want to change the "Authentication Mode" from
"Windows A...more >>
MSDE Authentication Failed Posted by ctowndu33 at 10/3/2006 10:12:01 AM I have an inherited box running Windows XP and two instances of MSDE on it.
We are now looking to do some initial work on getting these off. I can login
using osql with Windows Authentication to the one instance:
osql -S server\instance1 -E
and it works fine. The other instance, no matt...more >>
MSDE Install rolls back - not same as other posts Posted by Brian Aguila at 10/2/2006 10:45:03 AM Windows Server 2003 with SP1.
I'm trying to install MSDE Release A (no previous installations of MSDE
exist on this server). Just before the "Please wait while Windows configures
Microsoft SQL Server Desktop Engine" finishes, the 'Cancel' button disappears
and the installation rolls back. ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |