Forum Replies Created

Viewing 15 posts - 466 through 480 (of 597 total)

  • RE: Monthly contest

    I post answers if I think I can help someone or contribute to a discussion.  I have asked questions if I thought someone could help me.  Points aren't a factor. ...

  • RE: sp_detach_db

    You will get a violation only if SQL Server is up.  If SQL Server is not running you can copy/move anything you want.  Of course if you move (as opposed to...

  • RE: Resetting SQL Server from Single User Mode

    See BOL on startup options.  I believe you need the -d, -e and the -l options showing where is the master, error and log files.  If you leave them out...

  • RE: Cannot login after default database is deleted

    I don't think you can prevent access to master.  Everyone has access to master, whether its the default db or not via the guest account - which can't be dropped.

  • RE: sp_detach_db

    This may be just terminology but if you stop SQL Server and move the files (As opposed to copying them) what happens when you start up SQL Server and the...

  • RE: Resetting SQL Server from Single User Mode

    I assume you have tried attaching with sa as well and are unable.  You may need to rebuild master. (Rebuildm.exe)  SEE BOL also before attempting this:

    If a current backup of master...

  • RE: Migrating SQL Server Jobs

    I've had this problem before as well.  Try putting the following before the generated job scripts to see if this fixes things:

     

    SET QUOTED_IDENTIFIER ON

    GO

    SET ANSI_NULLS ON

    GO

  • RE: Migrating SQL Server Jobs

    I didn't refresh my screen so I didnt see your post noeld. 

  • RE: Migrating SQL Server Jobs

    In EM right click on the Jobs tab and select All Tasks, Generate SQL Script.  Generate the script and execute in in the msdn database for your new server. 

  • RE: Migrating SQL Server Jobs

    What about other stuff - tables stored procs etc.  Are you not bring this over as well? 

    One method is just to create a script from the job(s) and execute that...

  • RE: Passing a comma delimited string to a function for a IN() clause

    David Hardin wrote a great script to convert an array into a table which can then be joined to your other tables.  I use the script often.  see

    http://www.sqlservercentral.com/scripts/contributions/100.asp

  • RE: Cant auto start service!

    Check the Event log (and possible SQL Sever log) for errors.  The Application file in the event log should provide more clues as to why this won't start.

  • RE: Cannot login after default database is deleted

    The default database for sa should be set to master which should (hopefully) always be there. It would be cool if a user could change their default database but then...

  • RE: SQL Server 2K Backup History

    I use the following when creating a test version of a database based on the most recent back up. 

     declare @physical_device_name nvarchar(128)

    declare @backup_start_date datetime

    declare @db varchar(128)

    set @db = 'dbname'   ...

  • RE: How to close all sleeping processes

    If this is a .NET application  is the connection object being closed and set to NOTHING?  If so you'll just have to wait the 2-3 minutes for the connection to...

Viewing 15 posts - 466 through 480 (of 597 total)