Forum Replies Created

Viewing 15 posts - 1,831 through 1,845 (of 1,999 total)

  • RE: Execute Successful but No Records

    the problem is that your stored procedure is returning the nuber of rows inserted into you temp table as the first result (which the app will pick up)

    all you...

  • RE: SQL Server and NLB on Win2003 Standard

    we support several systems that fall into these categories.

    you were wondering if your front end application will work with a clustered active/active (load balancing) solution - most likely...

  • RE: Error 8646 - index entry not found

    try the query

    select name from sysobjects where id=2057058364

    this should tell you the table name

  • RE: Querying views

    can you post the view code.

  • RE: Performance Alert

    not as far as i'm aware.

    but what you could do is set the idle state in SQL AGENT as below 80% for 2 minutes.

    what you can then do is perform...

  • RE: Performance Alert

    from books on-line

    ***********************

    SQL Server Agent polls the performance counters at 20-second intervals.

    Important Using a frequency higher than 20 seconds increases the processing overhead for SQL Server.

    If a counter...

  • RE: The service did not start due to a logon failure

    what operating system are you running on ?

    has this problem just recently started happening and it was fine before ? or has it been since you changed the account?

  • RE: Please dont shoot me. Recovery and t. log backups

    from books on-line

    Before performing a log shipping role change, a maintenance plan for this log shipping pair must exist on the secondary server. A maintenance plan can be created using...

  • RE: Dealing with Time

    store them in a char(5) field???

  • RE: Please dont shoot me. Recovery and t. log backups

    i take it you want to make a change to the design of the database after you recover it, then you want to apply transactions from your old database.....?

    i don't...

  • RE: Server Crash during Back Up

    are there any notifications to operators on job completion/failure/success? - if so - is the exchange server available at that time?

    if it's not then SQL Mail throws a wobbly can...

  • RE: HELP! MSDE VERSION

    open up query analyzer and run the query

    select @@version

    make sure you run it with the output to text (not grid) and you'll see your version number

  • RE: Server Crash during Back Up

    are there any other jobs running against that database ?

    what size is the database? and does sp_who2 give you any info on whether there are locks ?

  • RE: Need Help with Stored Procedure and Input Parameters

    i agree, if your security settings aren't 100% correct you could get in real trouble with this.

    but in basic form your sp would have the following

    declare @strsql nvarchar(1000)

    set @strsql='select...

  • RE: SQL Transaction Log Filling

    is the database in simple or full recovery mode ? if it's full then you need to set up a transaction log backup job.

    then when the t-log has been...

Viewing 15 posts - 1,831 through 1,845 (of 1,999 total)