Forum Replies Created

Viewing 15 posts - 3,076 through 3,090 (of 3,366 total)

  • RE: SQL Server Business Intelligence Development Studio

    It is not part of VS 2005, it is in your SQL Server CD under Management Tools, it is the second Management Studio in your SQL Server setup files.  Copy...

    Kind regards,
    Gift Peddie

  • RE: Unicode support in 2005 - turn on or off?

    I am thinking the problem maybe related to .NET types being Unicode by default, here is a page that shows all the code pages with associated Locale ID so that...

    Kind regards,
    Gift Peddie

  • RE: sql express 2005 - Profiler tool

    There is Profiler in SQL Server 2005 but just not in Express.  Hope this helps.

     

    Kind regards,
    Gift Peddie

  • RE: using xp_cmdshell with SQL 2K5 Express

    Yes there is with a lot risk because you can enable it with sp_configure but it runs with server control permissions so you run it at a lot of risk....

    Kind regards,
    Gift Peddie

  • RE: list of transactions running in sql server

    I am assuming you are using the standard Express get the Advanced from the link below and you should get a decent Management Studio where you can see your code,...

    Kind regards,
    Gift Peddie

  • RE: The Certification Debate

    I have both MCDBA and MCSE I got the MCSE because when I was through with then hard MCDBA I had only one exam left for MCSE so I took...

    Kind regards,
    Gift Peddie

  • RE: A Global Reach

    (Our multi-ligual is English and Spanish.  The reason all of our fields are nvarchar is that varchar is NOT SUPPORTED on the mobile.)

    The .NET Char is Unicode by default so...

    Kind regards,
    Gift Peddie

  • RE: Converting Julian to Calendar

    All you need is covered in the links below the second includes manual converter from the Military and a UDF to do it for you.  Hope this helps.

    http://www.minisolve.com/TipsJulianSQL.htm

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64762

     

    Kind regards,
    Gift Peddie

  • RE: understanding this query ( and UNION ALL)

    To add to the previous poster you got it in the first chapter because the writer himself probably does not understand the complexity of it, these are the new virtual views...

    Kind regards,
    Gift Peddie

  • RE: sql developer jacksonville,fl

    Ya right greedy blank blank deleted.  LOL  

     

    Kind regards,
    Gift Peddie

  • RE: Data import from SQL Server in OWB

    I think you would need DTS for that move your data into temp table because a text file SQL Server sees null values so then move it from temp table to your...

    Kind regards,
    Gift Peddie

  • RE: SQL Sever 6.5 and 7 Dates?

    I don't know 6.5 release but I know 7.0 was late 1998, both products are like day and night and not related, that almost killed the MCDBA program because the books...

    Kind regards,
    Gift Peddie

  • RE: Confused with the order of server and database collations

    The server collation will not affect your database collation if you do column level collation and use collation precedence in your DML(data manipulation language) in SQL Server 2000/2005 but I...

    Kind regards,
    Gift Peddie

  • RE: Restore backup problems

    When you copy it to that location and choose restore from device there should be an ellipse in the wizard click on it for SQL Server to create the file...

    Kind regards,
    Gift Peddie

  • RE: Restore backup problems

    You need to put the .bak in the Backup sub folder in  Microsoft SQL Server folder in programs and let SQL Server create the file path for you in the...

    Kind regards,
    Gift Peddie

Viewing 15 posts - 3,076 through 3,090 (of 3,366 total)