Forum Replies Created

Viewing 12 posts - 1,336 through 1,347 (of 1,347 total)

  • RE: Need help with complex query

    have you tried it with inner joins instead of outer joins?

  • RE: DTS Permissions


    Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)

    Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]User does not have permission to alter database 'WebDB'.

    [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER DATABASE statement failed.

    [Microsoft][ODBC SQL...

  • RE: DTS Permissions

    it's not set to drop tables, just replace existing data. I tried changing some options and still doesn't work. and giving create table or db_ddladmin doesn't work either. Only dbo.


  • RE: Running SQL Server on a SAN?

    in my experience the SAN guys just cut up the space to make their life easier and repeat things like the SAN has cache to make up for the shared...

  • RE: can someone help me with a query?

    thanks, works perfectly


    i changed it a little and here is the final one i'm using




  • RE: importing data from a website

    thank you


    i'll be trying this in the next few weeks and will compare it to simply having SSIS jobs scheduled and downloading data manually

  • RE: Packets by the SPID

    have you looked into products from wild packets and other companies?

  • RE: Active- Passive Cluster to Active- Active Cluster

    you need to set up the disk volumes for the other instance and run SQL 2000 Ent set up again to create a new instance. Then transfer any DB's you...

  • RE: Running multiple backups at the same time

    we run veritas and i have changed all the backups to be SQL jobs that use xp_cmdshell to call a batch file that calls the veritas executable with the backup...

  • RE: Disk sizes for SQL

        I'm new to the SQL stuff and come from an exchange backround. I got some great performance improvement from taking the public folder databases and putting them on separate servers.



  • RE: Veritas Backup

    Where I work we ship SQL databases daily to another remote EMC unit via SRDF and backup daily copies to tape via Veritas 5.1 enterprise Server or whatever it's called....

  • RE: SQL Server on Veritas Cluster

    If you have a problem with SQL, is Microsoft going to support it on Veritas? I'm a new DBA, but one of the last things I did in my past...

Viewing 12 posts - 1,336 through 1,347 (of 1,347 total)