Forum Replies Created

Viewing 15 posts - 2,776 through 2,790 (of 2,903 total)

  • RE: Veritas Backup Exec 9 - Agent for SQL Server

    YES! I have Veritas Backup Exec 8.6 and found a HUGE problem with it and the SQL Agent...

    If you meet these four conditions, BE 8.6 SQL Agent WILL NOT WORK...

  • RE: Sql timeout

    I can't help you with your post, but I can tell you that you posted it in a really improper forum. This is for JOB (ie. work) postings. Like: I'm...

  • RE: Installation problem

    Have you 'explored' the disk to see if that file is on the install disk? Have you looked on the server to see if that path and/or file exists? If...

  • RE: NOT IN Problem

    I haven't tested this, but...

    select a.colB

    from tableA a

    left join tableB b

    on a.colA = b.colB

    where b.colB IS NULL

    If I got it right, this should retrieve the parts (colb) from tableA when...

  • RE: changing the sa of MSDE

    Allen_Cui,

    MSDE doesn't have Enterprise Manager. It uses OSQL.

    Sthealth,

    Unfortunately I don't have the answer as I don't use MSDE...but I'm curious about it also so I'll post back if I find...

  • RE: Installation problem

    How many times have you tried this install and gotten the error? Have you tried cleaning the disk? I had a problem on one install and believe it or not,...

  • RE: Adding Virtual Server to Active Directory

    Our virtual servers DID NOT get added to the Active Directory. So, my sys admin and I are looking at adding them and wanted to know if anyone experienced any...

  • RE: Dynamic WHERE clause problems

    It looks to me that the issue you are having is running a query against more than one table. If so, here's an undocumented procedure that might help (from Guru's...

  • RE: SQL Server & Clustering

    Are you running the instances on a Virtual Server or are you running them on the actual nodes? Most likely you are running them on one or more virtual servers.

    When...

  • RE: Security Gotcha

    I have a two node active/passive cluster and when my sysadmin and I created the cluster we also created an account JUST for the cluster services. I've gotten rid of...

  • RE: Finding current table size

    sp_spaceused 'tablename' will provide the number of rows, disk space reserved, and disk space used by a table in the current database.

    See the BOL for more information on this stored...

  • RE: Transcender Questions

    Daniel,

    You might want to go to Transcenders web site and email them about it. I bought mine right from Transcenders themselves. I'm not sure how it works for getting the...

  • RE: GO

    Check out the BOL for GO. It signals the end of a batch statement.

    -SQLBill

  • RE: impossible to search "= N"

    Why are you trying to search for the equal sign (=) in BOL? = is used for ASSIGNMENT and reads right to left.

    A = B means "the value of B...

  • RE: impossible to search "= N"

    Search for UNICODE. The N' is the designator for UNICODE.

    -SQLBill

Viewing 15 posts - 2,776 through 2,790 (of 2,903 total)