|
|
|
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 |
Help With SQL Command Posted by Charles A. Lackman at 4/30/2007 1:17:26 PM I have the following Table
Table1
ID = Int
Division = VarChar
FirstName = VarChar
LastName = VarChar
This is an example of the Data (Select * From Table1)
ID Division FirstName LastName
1 E Chuck Martin
2 E Frank ...more >>
Removing SQLServer 2005 Express Registry Keys Posted by Andrew Chalk at 4/29/2007 10:36:10 PM MS update cannot install a Service Pack to SQL Server 2005 Express because a
component of an earlier version (a CTP, the Reporting Services component)
cannot be uninstalled. Can anyone tell me which set of registry keys I
should delete after removing SQL Server 2005 in order to reinstall on a ...more >>
error 21268 Posted by frank at 4/27/2007 1:08:03 PM I have msde version 8.00.760 and when I try a sqlmaint it tells me
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside
the
range of the specified query result set.
this refers to sql 200 sp2 .. when I try upgrade to service pack 3 it tells
I do not have sql 2000...more >>
MSDE 2000 behind WSUS server Posted by jschick NO[at]SPAM aafp.org at 4/26/2007 12:15:11 PM Hello,
I'm a network / server guy at heart who has been given a quasi-DBA hat
to wear lately, so bear with me.
I have a WSUS (localized Windows updates) server that uses MSDE 2000
as its back end. Since last weekend I started to get an error that
points to a database problem. For the curiou...more >>
How to find out what port an instance use Posted by KFX at 4/26/2007 8:04:00 AM I use MSDE 2000 and I want to connect over internet to the server. The
problem is that I use an instance and so the port is not 1433 as it applies
dynamically. How can I find out what port the instance use to listen? With
SQL Server I can use Server Network Utility. Does MSDE have a similar to...more >>
Only One User Not Able to Connect to System DSN Posted by Will at 4/25/2007 10:54:24 PM We have a United Parcel Service (UPS) application named Worldship 9.0
installed on a Windows 2003 server. Worldship creates a System DSN that
points to an SQL Server entry for its MSDE copy of SQL Server on the
installed computer. While it is hard to believe that a Billion dollar
public...more >>
msde 2000 save database schema Posted by Lee at 4/24/2007 3:21:33 AM Hi,
I am running MSDE 2000 and will shortly be moving to sql server. Is
there a way using osql to output a script to allow me to easily re-
create the database on sql server.
thnx in advance
lee
...more >>
Device activation error Posted by jim at 4/23/2007 1:28:03 PM Hello,
I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
removing MSDE 1.0, a database apparently was not properly detached after
attempting to attach (using sp_attach_db not attach w/ single file) this very
database to MSDE 2000.
The following error is rec'd:
"Ca...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL 2005 Express Installation Failed Posted by Dave F. at 4/19/2007 11:03:08 PM I cannot seem to install 2005 express on my computer. I am running an AMD
Athlon XP 2000+ CPU with 1 GB of RAM. I have over 100 GB of hard disk space
available. My OS is XP Media Center. The video card is a NVidia GeForce 4 MX
4000. Mainboard is a Micro-star KM2M-L(601-6738-010) K7, KM266, 1ch...more >>
Connect via sqldmo Posted by jim at 4/19/2007 8:36:03 PM Attempting to connect to MSDE 2000 via sqldmo w/ vb 6 app. For example,
oSqlServer.Connect sSrvName, "sa", sPswd
However, receiving the following error message "Not associated with a
trusted SQL Server connection"
I've looked on microsoft support, which offered a workaround for this error ...more >>
Restore a backup to a different db name and path Posted by Monica at 4/17/2007 8:16:02 AM I have the following situation:
Database1 on my sql server with the following path: C:\DBs
\Database1.mdf, etc... I made a backup of this database. Now I need
to restore this backup on a different pc into the following: Database2
with the following path C:\Customers\DBS\Database2.mdf, etc...more >>
Can't login with remote servers Posted by Dustin D''Amour at 4/16/2007 12:28:04 PM Able to connect just fine at the main server but when trying to get the other
servers to connect get the following error.
Using SQL Server 2005 Express Edition:
Connection Failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (...more >>
2005 Express Sync Posted by Julio Delgado at 4/16/2007 12:00:00 AM Hi,
Is there any way to keep 2 SQL 2005 Express instances in Synch. I know that
SQL 2005 Express doesn't support Replication between them. What other
options do I have without upgrading to SQL 2005 Server. Any 3rd party
application or options with in 2005.
One of the SQL 2005 Express wi...more >>
MSDE regualr maintenance - help Posted by Danny at 4/14/2007 10:29:15 PM Hi folks
New to MSDE...
1. What is the best options to use when doing backups?
option 1. OSQL -U sa -P password -S server -Q "BACKUP DATABASE db1 TO DISK
= 'c:\Backups\backup1.bck'"
option 2. OSQL -U sa -P password -S server -Q "BACKUP DATABASE db1 TO DISK =
'C:\backups\backup1.bck' WIT...more >>
Differences in ANSI SQL and MSDE Options Posted by Gold Panther at 4/13/2007 12:13:40 PM I have a database, and I want to run an update script on it. I
understand ANSI standard script. I've used Oracle 10g to learn
databases, and I've used C# for a while now with SQLCommand,
SQLConnection, etc. Now, I'm trying to update a SQL Server (I want to
say 2003 Compact...not sure). I hav...more >>
Forgot SA Password Posted by George Schneider at 4/10/2007 9:36:01 AM A former employee forgot to leave me with the SA Password for our SQL server.
Luckily I was able to to access query analyzer using windows authtincation.
I foud the ttable where the sa and users information is stored. Is there a
way to query the databse to get the password which is currentl...more >>
Waiting for Recovery? How long? Posted by Lee Fuller at 4/8/2007 10:15:22 AM We attached a database yesterday that has a 2.5GB LDF file. However,
this morning, no matter what we attempt to do with the database (even
just view the properties of the database) we are met with a dialog that
says (among other things)...
"Database 'BlahBlah' is being recovered. Wait...more >>
Sql Server 2005 Express Edition Silent Install with callback Posted by inpuarg at 4/6/2007 12:00:00 AM I 'm trying to install Sql Server 2005 Express Edition using c# .
I also want to informed about installation progress. For instance i
want to inform end user if any installation error return. I think i
need a callback... I have no problem about silent install but how can
i informed about instal...more >>
SQL 2005 Express Edition - Update (KB 921896) failing? Posted by Brian at 4/2/2007 3:22:09 PM Howdy All,
I hope Express Edition posts go here, if not can someone direct me to the
correct newsgroup?
I have used Microsoft Update to obtain the latest updates for (obviously)
all of MS products.
Everything worked fine until I come to this update, list as:
Microsoft SQL Server 2005...more >>
Restore database goes to error Posted by ilia at 4/2/2007 12:16:00 AM Hello everyone,
I'm just restoring database with the ordinary way. But one of my database
reports an error:
"Location: execsql.cpp:230
Expression: exception != se_OK
SPID: 52
Process ID: 572"
SQL Command looks like this:
"USE MASTER RESTORE DATABASE [SourceDB] FROM DISK = 'C:\Backu...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |