Forum Replies Created

Viewing 15 posts - 2,296 through 2,310 (of 2,494 total)

  • RE: Issues with SQL Server Standard in Test and EE in Prod???

    If you get any problems in Production that are related to EE functionality, you will not be able to test any fixes for these on a SE instance.  Also, as...

  • RE: Windows Authentication with EM

    In SQL2000 there are 2 ways to get new objects automatically created with the owner dbo. 

    1) If the account creating the object is a member of the sysadmin SQL...

  • RE: Will SQL Server 2005 run on windows 2000 server?SQL Server 2005

    We will not know for certain until the product goes RTM. 

    My understanding is that SQL2005 is dependant on .Net framework V2, which in turn needs W2003 SP1 or XP...

  • RE: When an account was last used

    No.

  • RE: Unable to access 64 bit data from 32 bit management studio.

    Don't forget you are running a beta - things that should work may not do so.

    Try downloading and using the June or September CTP, as these have fixed a lot of...

  • RE: Data type for Gender

    I would go for char(1).  Many poorer countries do not perform gender assignment surgery for those babies whose bits are not obvious. 

  • RE: Moving distmdl.mdf and distmdl.ldf files...

    This is not a critical database, so use the same process you would for any user database that needs to be moved.

    The easiest way normally is to detach the database,...

  • RE: SQL Mail

    You need to log on as the SQL service account and create a Outlook mail profile.  Mail profiles are personal to the account that created them, so the profile you...

  • RE: 64-bit Review

    My place is working on the assumption that during 2007 all new software will be released in 64-bit format only, and vendors will only market 64-bit servers.  If you look at...

  • RE: Operating System Command Job step Default Directory

    As phillcart says, you get a default directory of \system32 because cmd.exe lives there.

    You could try copying cmd.exe to your preferred location, and ensure that location is in the PATH...

  • RE: Rolling back bad data

    It sounds like you are trying to use the database technology to overcome an application problem.

    It may well be possible to use a log sniffer (e.g. Log PI, etc) to...

  • RE: What language to learn?

    I agree with Chris Hedgate.  If you are mainly a Windows shop then one of the .Net languages should be your first priority.  C# would be my choice, unless your...

  • RE: SQL Server Need to be dedicated server?

    Before you get a new box, there are some things you can do on your current box and software.

    First, increase your RAM.  If any of your applications can use AWE...

  • RE: \Windows 2003 and Agent Proxy :(

    Good point about TEMP.  We have created a TEMP directory away from the C: drive (Ours is P:\TEMP), and set the environment variables to use this for W2003, SQL Server...

  • RE: System Object

    You can be too proud or too ignorant to ask questions in a forum, but you can never be too good to ask questions.  Even if you end up posting...

Viewing 15 posts - 2,296 through 2,310 (of 2,494 total)