|
|
|
January 2003 March 2003 April 2003 May 2003 June 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 November 2007 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Find out the commands executed Posted by danjbart NO[at]SPAM yahoo.com at 7/19/2003 7:12:45 PM We have a stores database on SQL Server 2000. What I need to know is
the exact changes (or what ever the sql commands that are executed)
during a specific interval of time on the StoreDatabase.
e.g. between 10:15 AM and 10:30 AM.
Is there anyway I could do that?
Thanks for helping!
db...more >>
nolock hints Posted by Hassan at 7/19/2003 6:25:10 PM Do nolock hints only apply to select statements ?
Can they be used in delete/insert/update statements too that are against a
single table or based upon a join such as delete from table1 as a(nolock)
join table 2 as b on a.col1 =b.col1 ?
And if they can, what does that mean ?
Thanks
...more >>
Managed Code Interoperability Posted by Jim Bailey at 7/19/2003 10:42:38 AM Has anyone tried to utilize managed code from SQL Server 2000 ? I'd like to
utilize System.Encryption classes from SQL Server to encrypt/hash some data
(passwords etc).
I remember reading somewhere about accessing COM objects from from a script,
but if I wrap this thing in COM, I loose one of...more >>
Backing up with a low priority Posted by MJ at 7/19/2003 9:54:27 AM I perform a series of steps via the SQL Agent to backup a database to a file
and find that as the database grows it now consumes so much processor time
that clients recieve timeout errors. The database must be available 24/7 and
so is there a way to run the steps with a low priority therefore giv...more >>
SP with Table name as Variable Posted by Jonesgj at 7/19/2003 7:16:23 AM Hi,
I am trying to write a SP to simply count rows from a table. Its just a bit
of learning for me, and although I have written other SPs which pass values,
I am having trouble with this.
Here is the code I am testing in Query Analyser:
Declare @MyField varchar (128)
Declare @MyTable...more >>
Formatting string in WHERE Clause Posted by Corrie Taljaard at 7/19/2003 12:20:32 AM Hi ,
I'm having a problem formatting a string to be used in the WHERE clause.
Here is my code
DECLARE @Criteria varchar(700)
'The formatting that i tried without success
Using 2 ( ' ) hypens next to each other
SET @Criteria = ' ' + ''LSACONXB'' + ',' + ''ALTLCNXB'' + ',' +
''CAGECDXH''...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |