Forum Replies Created

Viewing 15 posts - 2,536 through 2,550 (of 6,105 total)

  • RE: Tape backups....

    Sounds like you all need to coordinate your backups. Basically, there should be one backup strategy coming out of SQL Server, regardless of writing to disk or tape. Seems like...

  • RE: Cannot start AWE

    When you check the application and system event log for the server, do you see any error messages about not being able to contact a domain controller, just in general?...

  • RE: Connection Issues

    Is the certificate installed for SQL Server now expired? How about the certificate for the CA that issued that certificate?

  • RE: Audit Log

    Yes. In the case of an INSERT, just look to use the inserted tablespace. In the case of a DELETE, use deleted. When you're firing a trigger on an UPDATE,...

  • RE: Problem with xp_cmdshell and VBscript

    1) If your user account which is running xp_cmdshell is a member of the sysadmin fixed server role, has the SQL Server service account changed recently?

    2) If it isn't, is...

  • RE: Which RSS News Feed Aggegator do you use?

    I'll check out both Sharpreader and RSSBandit. As for Sage within Firefox, tried it and wasn't all that satisfied. I'm using Wizz RSS right now and while I like it...

  • RE: Is it Possible to use MSDE as Subscriber ???

    Yes, it is possible. Here is a KB article which describes how to use replication with MSDE:

    How to use replication with SQL Server 2000 Desktop Engine...

  • RE: Audit Log

    You can take one of two approaches.

    One, you can put triggers on key tables where you want to monitor data changes. This is the most intrusive, but the cheapest, option.

    Two,...

  • RE: Sql Server is automatically logging out users?

    When you're logged on through Enterprise Manager or Query Analyzer, do you see the same behavior with respect to your connection in SQL Profiler?

  • RE: SQL Profiler

    Look at creating a server side trace using the SQL Server stored procedures and functions. This will run and can write to a trace file on the server without ever...

  • RE: Hyperthreading - will it be fixed with a service pack

    I haven't seen a hotfix announcement for this. It would probably take someone within Microsoft or privy to development within Microsoft to comment on whether or not one is planned....

  • RE: Trouble restoring Master DB

    It depends. MSDB also contains SQL Server Agent job information as well as any DTS packages not stored n the file system. So you may need to restore msdb if...

  • RE: Trigger on a system table

    Shas3,

    A long time ago, in a galaxy not so far away, Robert Marda experimented with triggers on system tables and posted the results in these very forums. His results showed...

  • RE: Grant, Revoke, Deny

    GRANT = User or role has been explicitly given access.

    DENY = User or role has been explicitly denied access. This trumps any GRANT.

    REVOKE = This is the "undo." It will...

  • RE: Simple Log Shipper

    Basically it's all about a manual process to move log backups and get them applied. Here's one such article from back in the SQL Server 7 days (the core concepts...

Viewing 15 posts - 2,536 through 2,550 (of 6,105 total)