| Groups | Blog | Home |
|
March 2003 April 2003 May 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 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 SQL Express on Windows 2000 Pro Posted by rlg at 11/14/2005 11:01:28 AM Good day,
I was just reading the minimum requirements for the SQL Server 2005
versions and was floored to discover that SQL Express will not run on
Windows 2000 Professional
(http://www.microsoft.com/sql/editions/express/sysreqs.mspx). Could
this be a typo?!?!?
SQL Server 2005 Workgroup a...more >>
Get Column Names as Row Value Posted by Hiten at 11/14/2005 5:38:20 AM Friends,
I have a wierd query, atleast wierd for me. I have a stored
procedure where I am passing parameters and updating a record. It may
happen that not every column values is being updated. Before firing the
update statement I want to have name of columns, that are going to
chan...more >>
Case Sensitivity in 2005 express Posted by cwertman NO[at]SPAM yahoo.com at 11/13/2005 6:59:52 PM I am trying to figure out how to make a column in SQL 2005 Express case
sensitive.
I am a little lost on where to set it to what
as
a
has a different meaing / value than
A
and so on and so forth.
Collation ? But which and where to set ?
Thanks
Chris
...more >>
How to restore Values to Table based on some Query Posted by vinoth NO[at]SPAM gsdindia.com at 11/12/2005 4:17:07 AM Hi,
I have a table called A and another Table Called B.
A table has the following Column and Values
ID One Two Three
----------------------------------------------
10 test01 test02 test03
11 test11 test12 test13
12 test21 test22...more >>
Nice monitoring tool for SQL Servers Posted by cutebaby at 11/10/2005 8:36:09 AM Need monitoring tool for the SQL Servers what can monitor 15-20 SQL
Servers together and at least check the following:
- structural integrity/other DB errors;
- query blocking;
- DB/Log size increasing. It would be perfect if tool can help to find
out the reason why it have happen;
- it w...more >>
running too many statements. is there a better way? Posted by Dica at 11/9/2005 10:07:16 AM say i want to produce a report for a video rental store showing all
customers and how many movies they rent from each genre. i want a report
that looks like this:
[Customer Name] [Drama] [Action] [Comedy]
Rick B 2 17 0
Tracey K ...more >>
Client does not reconnect to SQL Server after Network interruption Posted by microteq at 11/9/2005 5:39:05 AM Hi,
Our VB.NET program onnects to SQL Server SP4 via OLEDB. When we open a
connection and then we have a network interruption of min 10secs during
the open connection (what happens sometimes at the customer site), we
get a General Network Error when we try to execute the next query. Even
when...more >>
Limits of SQL Server MSDE? Posted by NetPerson at 11/9/2005 5:34:23 AM What are the performance limits and how do they manifest themselves?
Our school is running a database on MSDE (about 3 years old) and users
are complaining of performance degradation - freezing, hiccups, etc.
The main .ldf is now 2.3GB big which I understand to be above the
limit. I never see m...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDE Table Creation Posted by shiljo.ap NO[at]SPAM gmail.com at 11/8/2005 10:15:38 PM I got MSDE in my web control panal with database name and admin user. i
don't know how to create table or select from the table.
i need snipt codes to create a table.
thanks in advance
...more >>
reattaching woes on SQL 2000 SP3a Posted by RTL at 11/8/2005 12:00:00 AM Hello all,
One of our databases ate up about 9GB of a partition which caused havoc with
several network processes (like cannot print,etc). Normally, I detach the
database, delete the log file and then reattach and let it recreate the ldb
file. All has been working great.
The problem is that...more >>
Performance problem with real time application Posted by Kurzweil at 11/8/2005 12:00:00 AM We are using Sql Server 2000 on a dual processor machine.
On one sql connection there is a real time application executing 5 queries
every 100 milliseconds.
On a second sql connection there are queries that take 2 seconds to execute
every 10 minutes or so.
The problem we have is that when...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |