Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 2,436 total)

  • RE: hardware: new server choice

    It sounds like a case of champagne tastes on a beer budget to me. £5000 is less than 10k US. But anyhow, it sounds like you mught be able to...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Sql Mail and Lotus Notes

    I do not have the specifics but it is possible (and probably very painful) to get it to work with LotusNotes. I think you'll still need Outlook but you'll also...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: mmc.exe application Err..same tricky problem which I already raised

    Have you tried just reinstalling EM yet ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Linked Server Problem - Sybase

    I've never really worked with a Sybase linked server but have worked directly with Sybase servers and databases for quite a while. You say that you have a 'new' server....

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: "Null"

    For #1 please give the SQL that produced the informational/error message.

    For #2, quite simply stated, "SQL Server will not run <period>"

    The model database is used to create all databases, and...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Indexes problem

    1) No. There is not any data information in the sysindexes table.

    2) No.

    3) There may be a DBCC command but I am not sure.

    However in SQL 2005 DDL triggers will...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Remove BOL from PROD boxes

    Infiltration via the web application is a separate security issue to be dealt with (SQL injection or whatever other means). I feel that one has to balance the ROI vs....

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: application create SQL logins?

    Just one addition. If your applcation requirements dictate a rapid creation of these logins then a regularly scheduled tasks may not be fast enough (e.g. every 5 minutes).  One could...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Remove BOL from PROD boxes

    All documented concerns aside, the auditor needs an education in the 'reality' of what a DBA does. The vast majority of the time one operates remotely from a desktop or...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Determining objects in secondary datafile

    Question Paul, does the alogorithm rotate from one file to the next within the filegroup based on extent allocation or allocation unit allocation ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Changing IP address of DB Server

    Bill's solution is a 'standard' at our shop. All applications use a DNS alias to connect to database servers thus freeing up the tech area from changing IPs when servers...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: SQL Server 2000 Upgrade from Standard to Enterprise edition

    Here's a system table map to assist you a bit further ...

    http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

    sysservers and sysremotelogins are the primary tables yopu need to look at. sysxlogins will not help you much...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Star Trek is Here

    Live long and prosper ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: 20gb temp file and they say "its ok"

    The 'noticable' delay on startup is probably hardware (disk) related. I've got 25 SQL Servers with tempdbs ranging in size from 1 Gb to 16 Gb. All tempdbs are set...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Linked server to Windows 2003 box

    I also use linked servers and such for enterprise monitoring. My environment is mixed Win2K SP4 & Win2K3 SP1, clusters and non-clustered servers, SQL Server on all machines is SQL2000...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 1,636 through 1,650 (of 2,436 total)