Forum Replies Created

Viewing 15 posts - 631 through 645 (of 1,884 total)

  • RE: Read Only Tables

    Agree with JB. INSTEAD OF Triggers are the first that I would use for the Hard Way and I have seen code using them. They can not be implemented in...

  • RE: Career advice for a junior data analyst/developer

    Sean,

    You may include your previous experience on the separate line as "consulting" for for your current employer, which well describes your contributions. I would certainly get a certification, it really...

  • RE: parsing address

    Daniel,

    It is not an easy task unless you define a lot of rules in a kind of a dictionary or table. While it is easy to replace spaces with |...

  • RE: Update Statistics failing

    Why do you need to Update Statistics on msdb?

  • RE: Update Statistics failing

    Brian,

    CREATE STATISTICS topic in BOL says:

    "Computed columns can be specified only if the ARITHABORT and QUOTED_IDENTIFIER database options are set to ON. "

    http://msdn2.microsoft.com/en-us/library/ms188038.aspx

    SQL Server 2005 Books Online 

  • RE: Replacement of SQL servers that are attached to a SAN

    One thing that may fail in this approach is if you have local accounts as logins to SQL Server then when you replace the server and re-create this new local...

  • RE: Question of the Day for 28 Jul 2006

    I probably did not have my cofee yet. I am running a query from Management Studio 2005 towards 2000 Northwind database without grouping and I looked up that EmployeeID =...

  • RE: Problem seeing remote SQL Server 2005

    I would try if you can create an ODBC source from your workstation using named Pipes. It will show you if you can connect at all. Your error message talks...

  • RE: Determining the logging mode with a script

    It is easier to ask the server sysadmins to submit you the list of logging modes then to give you the access to their servers to run...

  • RE: Optimal tempdb file location

    I would not go as far as that. Make sure the recovery Model is Simple for TempDB. There are some other recommendations by Microsoft books:

    - You may want to put...

  • RE: Question of the Day for 24 Jul 2006

    Brian,

    1. In the companies where the responsibilities are split to the point that server admins don't have the database access, then in these companies it is very unlikely that a DBA will...

  • RE: How do i turn off polling??

    C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\en\Microsoft.SqlServer.Smo.xml

    This config file contains settings for the target servers (multi-server administration) if you are asking about enlisted servers. You have to search this doc for the keyword...

  • RE: Question of the Day for 24 Jul 2006

    They will be able to get access to the secure data anyway:

    1. By Changing the password for SQL Server Startup account. By Default (and by the question this is the default...

  • RE: Time run times of programs

    The Profiler traces can show Start Time and End Time for statements and batches

  • RE: Cannot Delete Fulltext catalog from DB

    Alex,

    I would not delete the folder. Because you have SQL Server pointing to this folder.

    I read the message again. It says "The specified object cannot be found". It is just...

Viewing 15 posts - 631 through 645 (of 1,884 total)