Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 1,535 total)

  • RE: Linked server error

    A ping and traceroute might give results that show you can access the server, however you have to bear in mind that it's possible that those ports are open throught...

  • RE: Lic/Permission

    Due to the fact that you could be using potentially all 8 cpus on either machine in an active/active cluster you would need to licence for 16. If you were...

  • RE: Linked server error

    Ask your network guys if there is a firewall between the machines and if there is what ports are open, they should also check to see if there are any denys...

  • RE: DTS Error: "Sql Server does not exist or access denied"

    Possibly you created the dts using Windows Authentication for the db connection, and from your machine you cannot authenticate against the SQL server using Windows Auth.

  • RE: Linked Server Update Problem

    Interestingly I am having the self same problem on SQL 2k SP3a on Windows 2000 Advance Server, MDAC 2.71, Oracle 8i.

    All the entries are set as Microsoft suggest. I wouldn't...

  • RE: Updating a field based on the value of another field

    If you want to update the lastname value to equal the value of a column that has the lastname value of king

     

    update Employees SET lastname = newlastname where lastname =...

  • RE: Port

    It works for me.

    Log into one of the physical nodes and go to the server configuration utility. Select the server that you want to change in the drop down...

  • RE: Citrix and SQL

    My belief is that Citrix will take 100Mb of RAM for each user connected. If you have only a couple of Citrix users that won't be an issue in the...

  • RE: Port

    Go to the Server Network Utility and change the Default port number under TCP/IP.

  • RE: Enterprise Admn: Backup a database option

    How 'bout this.....

     

    declare @IDENT INT, @sql varchar(1000), @DBNAME VARCHAR(200)

    select @IDENT=min(DBID) from SYSDATABASES WHERE [DBID] > 0 AND NAME NOT IN ('PUBS', 'NORTHWIND', 'TEMPDB')

    while @IDENT is not null

    begin

     SELECT @DBNAME...

  • RE: backup with Arcserve

    Yes the database will still be available for use. Don't forget to make sure to back up the system db's...

  • RE: Backup Log with truncate_only

    Looks fine to me.

  • RE: backup with Arcserve

    You should add a filter to the machine to exclude all *.mdf, *.ldf, *.ndf files. Make sure that you backup to disk the master, model, msdb and user databases that...

  • RE: Log Shipping - Do we still do Full Backups

    Indeed it would

  • RE: Point in Time Restore in disabled

    Your database was in full recovery mode?

     

Viewing 15 posts - 1,411 through 1,425 (of 1,535 total)