Forum Replies Created

Viewing 15 posts - 1,156 through 1,170 (of 1,412 total)

  • RE: sp_helptext

    For a procedure that returns a value that you want to store in a variable you would execute it like this:

    EXEC @variable = sp_whatever @parameter

    However, sp_helptext does not return any...

    March 25, 2003 at 3:33 am

    #452013

  • RE: Abnormal growth rate

    Are you inserting a lot of data into it? Are there a lot of transactions going on, and do you backup your log? Are you running Profiler (or just server-side...

    March 25, 2003 at 3:26 am

    #452012

  • RE: IE/internet stops with SQL2000

    quote:

    I downloaded the security tools and ran them and it fixed the problem.

    I would advice...

    March 25, 2003 at 1:33 am

    #452007

  • RE: SQL Server VS. Oracle

    quote:

    I basically agree that anything can be done in either one one way or another. However, there have been statements in this...

    March 25, 2003 at 1:26 am

    #452005

  • RE: edit server network library configuration

    Phill, that key is actually for your computer as a client to SQL Server instances. The key that controls which port SQL Server listens on is this (you need to...

    March 25, 2003 at 1:21 am

    #452003

  • RE: Update Trigger failing on mass updates

    quote:

    The Update trigger should get fired off 1000 times if I update 1000 rows at the same time.

    March 25, 2003 at 1:14 am

    #452002

  • RE: Slow performance by alert engine

    Mike, this is no problem at all. The Alert Engine SPID will stay connected and show up in your sp_who2 output even if it is not doing any specific job...

    March 25, 2003 at 1:08 am

    #452001

  • RE: SQL Server VS. Oracle

    Scorpion, thank you so much for the best post in this quite lengthy thread. Shows it was actually worth following the thread through 5 pages...

    In response...

    March 24, 2003 at 2:43 pm

    #451973

  • RE: the sql learning method

    I agree, if you are at this level you shouldn't be looking at memory counters and such. Pick up a good beginners book and start from the ground up, this...

    March 24, 2003 at 2:33 pm

    #451971

  • RE: audit triggers and @@identity woes

    As the others have said, the problam lies in th fact that @@identity returns the latest created identity-value in the current session. As Andy suggested you can use scope_identity instead...

    March 24, 2003 at 2:30 pm

    #451970

  • RE: ADO Requery command fails

    Do you have the same version of ADO on both servers?

    --

    Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

    http://www.sql.nu

    March 24, 2003 at 12:34 pm

    #451947

  • RE: SQLServerCentral Wish List

    One thing I would like is to have a 'Reply to posting'-functionality, so that you can show which individual post in a thread you are replying to. Not a big...

    March 24, 2003 at 12:33 pm

    #451946

  • RE: Restoring .BAK file from Network

    Jeff, I'll paste your email response to me here so that others can follow the discussion:

    quote:

    So if this was a bak file...

    March 24, 2003 at 12:26 pm

    #451944

  • RE: Restoring .BAK file from Network

    Have you tried specifying where to move the database files to? Otherwise I would expect the problem to that SQL Server does not have rights to read the backup files.

    --

    Chris...

    March 24, 2003 at 9:44 am

    #451908

  • RE: Changing length of User-Defined Datatype

    Tim, you really brought up some bad memories there...

    To continue your off-topic rant, I just remembered an old project where the customer decided that 'Articles' should...

    March 24, 2003 at 8:49 am

    #451895

Viewing 15 posts - 1,156 through 1,170 (of 1,412 total)