| 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 DB Size Grown Very Large since creating email delete trigger Posted by lkath NO[at]SPAM plenco.com at 3/14/2006 8:55:41 AM I created a trigger on a table that sends me an email when records are
deleted from the table. I created the trigger about 2 weeks ago.
Since then my database has grown at a ridiculous rate. I have deleted
the trigger and no longer need it. Is there a way to get my database
closer to the size...more >>
MySQL vs SQL2000 Posted by anote_un NO[at]SPAM yahoo.com at 3/13/2006 7:57:42 PM Dear all,
I have an update statement
update ta100d inner join qryholiday
on (ta100d.effdate = qryholiday.effdate)
and (ta100d.empid = qryholiday.empid)
set ta100d.statwrk = qryholiday.ta01ma,
ta100d.statwrkdsc = qryholiday.usrdef
where ta100d.updusr = 'Y'
and ta100d.effdate >= '1060101'
...more >>
DATABASEPROPERTYEX(<databaseName>, 'status') returning NULL Posted by zart.cosgrove NO[at]SPAM gmail.com at 3/13/2006 10:54:28 AM Hi,
I'm having a problem with the DATABASEPROPERTYEX function... When I run
SELECT databasepropertyex(name, 'status') AS Status, *
FROM pdxmgr01.master.dbo.sysdatabases
order by dbid
I'm getting NULL for the Status column. When I look in BOL, there is
no value of NULL listed as a poss...more >>
Intermittent timeouts (same stored procedure) Posted by Mike Dow at 3/10/2006 2:21:00 PM Hi,
We have a call to the same stored procedure timing out a few times per
day. The sp is executed by some c# code using a SqlDataReader to
populate a collection class (all it's doing is assignments (no lookups
or anything) -- very fast operations on the mid-tier/c# side). Both
the middle t...more >>
Setting security permissions for users on subsets of data Posted by weegee NO[at]SPAM metronet.co.uk at 3/10/2006 9:33:43 AM Hi
I have built an application in SQL Server which is comprised of
Employee data. The data contains a category for Division.
Divisions are for example:
ECT
ECT Asia
PCT
However, I want to be able to put security on the data so that users
from each division only have access to their d...more >>
Slowness from morning to afternoon Posted by wasco_mike NO[at]SPAM hotmail.com at 3/10/2006 5:39:46 AM I'm supporting a SQL-based .NET application. What we found is that
since this product was installed, overall performance in the morning
was good, but afternoon performance is nothing short of awful. In
several instances, a mere lookup function consisting of about 130 total
records takes over a...more >>
help! Posted by robert at 3/9/2006 2:04:37 PM sorry if this is the wrong group.
i have admin priveliges on windows server 2k3 server with sql server 2k on
it. i want to be able to allow someone else (an account group rather than
individuals, preferrably) to be able to log on and still have access to the
sql server residing on this pc.
...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |