| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 HTML Reports Posted by Mr.Clean at 12/7/2005 8:58:36 AM I'd like to produce HTML reports from my MSDE tables.
Can I write a Stored Procedure to return HTML code as a file
from MSDE?
If possible, a short example would be appreciated....more >>
MSDE OSQL command Posted by Grant at 12/6/2005 4:14:34 PM Is there any books or website that will explain in depth about OSQL. Thanks.
...more >>
Problem opening SSMS Express Posted by David at 12/6/2005 3:08:33 PM Hi,
I experience a problem after installing "SQL Server 2005 Books On Line"
(December 2005) on my notebook, which have also an installation of SQL
Server 2005 Express Edition. Management Studio Express Edition (November
CTP) don't start...
If I try to open it, nothing happens. Anyone can help m...more >>
MSDE using nameinstance appears to be blocked on winXP Posted by Grant at 12/6/2005 11:09:30 AM
I have no problem connecting to MSDE using TCP but not nameinstance. Any
idea why?
...more >>
data recovery - pls help Posted by maxzsim via SQLMonster.com at 12/6/2005 7:57:57 AM Hi,
If i have some data on a table that's being deleted by an application and i
did not do backup but the recovery mode is "Full Recovery" can i somehow get
back the data ?
i know there's a deleted/ (created or updated) table but that's wtithin a
session isn't it ?
appreciate any a...more >>
SQL Server Service Manager: Not connected Posted by carlor at 12/6/2005 7:26:02 AM Hi,
I have just installed MSDE 2000a on my XP-Pro system because I need it to
install another application. I installed with the options sapwd and
instancename. The install completed and I rebooted. Now the SQL Server
Service Manager is showing up as "Not Connected - \\". When I click on the...more >>
SQL Express Stops running and wont start Posted by JC at 12/5/2005 3:32:04 PM Pardon me if this is not the group for SQL Express. There wasn't a choice for
it so MSDE was the closest.
I have a problem where SQL Express stops running and won't start. The only
solution I have found so far is to uninstall SQL Express and reinstall it.
There has got be a better way or so...more >>
Deploy MSDE using Command Posted by Grant at 12/5/2005 1:17:08 PM I am using VB6 to install MSDE and here is my syntax.
Setup.exe INSTANCENAME=NK SECURITYMODE=SQL SAPWD=NKM
It will install and show the progress bar all they way to about 4 second
left then freezes up. The log shows this as the last thing it did prior to
locking up "Executing "C:\Program...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDE database size limit, partitioning amd license Posted by Patrick Gibb at 12/4/2005 8:15:02 PM I understand MSDE has a 2GB size limit for individual databases.
If I use MSDE to create multiple databases to partition a large
"transactions" table (up to 2 GB per partition) and then join them together
with partitioned views, does this break the EULA?
In reality, only one or two partitions ...more >>
SQL Express - How does it run? Posted by Robert Jones at 12/4/2005 12:05:02 PM I have now successfully installed SQL Server 2005 Express Edition.
When I go to Start/All Programs/SQL Server 2005
all I see is
Configuration Tools
Configuration Manager 2005
SQL Server Error and Usage Reporting
SQL Server Surface Area Configuration
How do I actually run S...more >>
convert a datetime Posted by Andrew Chalk at 12/3/2005 11:55:48 PM If I issue:
SELECT CAST(CAST('2000-05-08 12:36:29.998' AS datetime) AS bigint) AS
Expr1
I get 36653 as the result.
If I issue:
SELECT CAST(CAST('2000-05-08 12:35:29.998' AS datetime) AS bigint) AS
Expr1
I get the same result even though the times differ by one minute.
Can a...more >>
SQL Server Express Minimum Hardware Requirements Posted by Robert Jones at 12/3/2005 10:00:23 PM I am installing SQL Server Express (2005) and have been given a warning that
my system does not meet the minimum hardware requirements.
I have the following:
768 MB RAM
17.5 GB Free Disk Space
Pentium III
800 Mhz Processor
Running Windows XP Professional SP 2
With Dot Net Framework 2....more >>
Sql Server Express Installation Posted by Sean Kenney at 12/1/2005 4:59:59 PM I have tried to install Sql Server Express on my machine ( Windows XP SP2 )
with no luck. I have installed VS 2005 Professional and at the end of the
setup it has the following error message:
The following components failed to install:
Microsoft Sql Server 2005 Express Edition x86
So the...more >>
Can I deploy a runtime version Posted by Tom Iarusso at 12/1/2005 12:32:02 PM Is is possible to deploy MSDE with a database in such a way that an end user
can only access that database via a custom application? In other words, I
don't want the end user to be able to use osql (or any other tool) to get
into the database, and I don't want them to be able to detach that d...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |