Forum Replies Created

Viewing 15 posts - 76 through 90 (of 128 total)

  • RE: Error 1069?

    Reboot the server. Have a look in Control Panel and see if the SQL Services exist and under what account they are running under. Start them if they aren't started.

  • RE: Server/Client Network Utility

    Just a bit more detail. Server network utility define what network protocols you can use to connect to the SQL Server eg TCP and port 2020.

    Client network utilities define what...

  • RE: Truncate log on checkpoint

    In a production environment it is the businesses call on its recoverability - not the DBAs, in line with the SLAs. But as the DBA you need to understand what...

  • RE: SQL Service won''''t start - corrupt model db?

    If you can start SQL Server in minimal mode from the command line (-f) then use the script that is on the install CD to recreate the model DB. Problem...

  • RE: Error 80004005

    There ae a large number of reasson for this error. Search the microosft knwoledge base for 80004005 - example KB306586

  • RE: SQL MAIL - URGENT

    Any attachmentst to the email that may be blowing up size? Had something similair when Exhange didn't like anything greater than 1 Mb

  • RE: index defragmentation

    Every table should have a clustered index

  • RE: Can I install SQL Server Ent. Edition on top of Std. Edition ?

    Upgrade path is very simple. I did this on 8 production servers  - with a reboot (not required - biut I did just to make sure) and then reapplied SP3a and...

  • RE: sql mail

    With SQL 6.5 the SQL Mail component was not as seamless as it is now. Make sure that the SQL Services are running under their own account and the Outlook...

  • RE: How to perform structure backup in SQL Server 2000

    I had a client who wanted this sort of recovery. All I could end up doing was backing up the database, restoring it to another replica database, truncating all tables...

  • RE: Database size growing too fast

    Check to see if the data file or the log file is growing. If the log is growing them it may be because the recovery mode is full and the...

  • RE: Weekend Task needs to run without users logged in

    The only way to get exclusive use of a tabe is to use a tablockX locking hint.

    You will not be granted the lock until all other users have finished accessing...

  • RE: Identity and Primary Keys

    You don't need the ID column as the customer code as a primary key will enforce unqiueness and not null.

    You can make an identity column larger - just change it...

  • RE: Restoring the backup of a database on a different server

    This will be made easier if the FURTEMP server has the same disk config as FURSQL, then you don't even need to change the physical file location when you restore.

  • RE: SQL Server Data and Object Encryption

    You can encrypt stored procs and views - although it can be unencrypted with readily available scripts. Yukon has better encryption techniques - but who can wait that long

Viewing 15 posts - 76 through 90 (of 128 total)