| 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 0 Blocking, but lots 'o locks...can that be right? Posted by EJO at 2/28/2007 1:12:14 PM TIA, because I really hardly know where to begin with this issue...
Currently have a SQL Server 2000 system being accessed as a backend to
a MS A2k mde. After about 6 years of working with relative pain-free
ease, my tiny db started preventing users from being able to update
one of the tables...more >>
Filtering across similar records using aggregate function Posted by Dave at 2/26/2007 10:09:13 PM Here is an extremely simplified copy of a table I have:
Field 1 Field 2 Field 3
1 4 E
1 4 B
1 4 H
1 5 Q
2 9 O
2 8 I
2 9 U
2 8 W
3 7 F
3 6 C
3 7 Q
3 7 Z
I would like to filter out the records that have the max value in
Field 2 within each group of equal values in Field 1.
Here i...more >>
unable to specify UNC path for restore through GUI?? Posted by KR at 2/23/2007 4:31:08 PM Hi,
After just installing sql 2005 on our test machine, I am trying to
restore a database using a backup file on the network. However, the
specify backup diagol box allows only for browsing to a file on the
local machine - I find no way to type a UNC path to choose the backup
file fro...more >>
Transaction log databseNAME_log.ldf keeps growing Posted by nygiantswin2005 at 2/23/2007 11:03:41 AM I have several Microsoft SQL 2000 Servers.
On each servers I notice that Transaction log files for database keeps
growing.
We also have Symantec Backup Exec 10d with SQL Server Agent.
The backup runs every night and it does a full backup of SQL Server
databases.
I don't understand why th...more >>
Quickly convert a single column table to a string? Posted by mark4asp at 2/23/2007 10:04:03 AM Is there a convenient way to convert a small single column table of
zero to six rows of VarChar(50) data to a single string via a
function. Each item is ideally separated by semi-colon space.
Do I need to use a cursor to do this?
...more >>
WebCasts @microsoft.com Posted by PFC Sadr at 2/22/2007 12:30:58 PM so I've gone to view a webcast at MSFT.com about a dozen times over
the past year.
and from what I see; their signin information just DOES NOT WORK.
you find the webcast you want; you click to view it.. and then it
sends you back to select a webcast again.
Plus-- if a webcast is previousl...more >>
Unintalling MS SQL server 2000---SP4 Posted by Lcuky at 2/22/2007 11:19:07 AM Hi,
I have applied SP4 on a testing box, but my application is not
compatible to SP4. I want to UNINSTALL not remove the SP4 from my
server.
kindly, suggest the procedure for the same.
Thanx in advance.
...more >>
why no CD burners or DVD burners for Backup?? Posted by PFC Sadr at 2/22/2007 6:18:34 AM
I just found this in a measure-up exam; it kinda surprised me; it
seems like a no-brainer
backups cannot be directly written to CD or DVD burners
why is this true?
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
C# SQL interface Posted by Jon Slaughter at 2/22/2007 2:29:54 AM I'm writing essentially a client based SQL interface(although the client
accesses it indirectly).
In the database there will be several different types of tables. Initially
I was only going to use one table structure but I felt that it would be more
productive to have it arbitrary.
Now ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |