Forum Replies Created

Viewing 15 posts - 256 through 270 (of 692 total)

  • RE: sql job does not run

    Is the schedule also enabled?  Is SQL Agent running?

    I have the same type situation with homegrown logshipping.  I accomplish this by updating a "control" table on Server B when Job...

  • RE: SQL server logs - recycling

    That really depends on how active the log is.  For example, if you are taking transaction logs every 10-15 minutes, or are auditing successful logins, you might want to recycle...

  • RE: How to find NOT TOP 3? (Next rows after row 3)

    You said the query for HugeDerivedTable has a parameter in it, which would seem to invalidate my suggestion.  But, without knowing the parameter, and how it affects the derived table,...

  • RE: What is FCB for invalid file ID means??

    Wow! Such kind words about the forum and no responses to your query for nearly 22 hours?!?!  Well, it seems responses have slowed due to the holiday season.  I know absolutely...

  • RE: log size control

    If you do that, you'll need to change to full recovery model, then take your full backup, so that your tlog backups can associate with the full backup.

    Steve

  • RE: log size control

    If you wish to continue to do the maintenance, it shouldn't be a problem to leave the file large, as long as you can accept the large log size.  It...

  • RE: Security - Windows Authentication

    The only thing that jumps out at me is the periods in the group name.  I know the spaces are ok, we have some like that.  But maybe the periods...

  • RE: Security - Windows Authentication

    Well, lets see.

    Assumptions -

    The Windows Group has login rights to the server.

    The ODBC connection is set up to use Integrated Security.

    The Windows Group has been properly granted access to SQL...

  • RE: How does adding a column impact dependent objects?

    You could run into problems in a procedure that is performing inserts.  If the column names aren't explicitly called out, all columns will be assumed, and your insert will fail.

    Steve

  • RE: SQL Admin Newbie - SQL Server Agent

    Yep.  SQL Agent handles all the scheduling within SQL.  It must be running for any automated job to execute via its schedule.

    Steve

  • RE: Restoring to another server

    I assume that you are trying to "open any table/view" from EM.  Have you tried a select query from QA?

    By the way, about the comma, I can't tell you how...

  • RE: Restoring to another server

    If you pasted your restore command exactly as you were running it, your problem may be the missing comma at the end of the first move.

    Steve

  • RE: Convert positive to negative and vice versa

    Why????

    As Tyson said, just multiply by -1.

    positive values become negative ( 1 * -1 = -1).

    negative values become positive (-1 * -1 = 1).

    Thats what the original request was for!

    No...

  • RE: Passing data in job steps with Global temp table??

    Provided there is a share set up on the network resource, you can use the unc path.  Again, using xp_cmdshell, execute the "DOS" copy command -

    exec master..xp_cmdshell 'copy d:\test.txt

  • RE: date time field

    Please provide specific information about what you are trying to do.

    Steve

Viewing 15 posts - 256 through 270 (of 692 total)