Forum Replies Created

Viewing 15 posts - 1 through 15 (of 18 total)

  • Reply To: Server Side SSMS

    For the last 7 years, we 've been deploying on Windows Server Core, and now more recently, Linux.

    We don't have the opportunity for local tools, other than limited commandline based...

  • RE: ALTER USER WITH LOGIN renames the user

    And it turns out this behaviour is "documented" in BOL

    http://msdn.microsoft.com/en-us/library/ms176060.aspx

    Looks like my offline copy hasn't had the change applied to it.

  • RE: In Case of Breach

    This happened to one of our customer facing products. The database wasn't exactly hacked, but it was effectively the same.

    A subscriber figured out how to work trick the application...

  • RE: usp_createsnapshot

    Sorry, I made typo in my previous post.

    There are no instances nodes under HKLM\Software\Microsoft\Microsoft SQL Server.

    However, I did find it under:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1

    It would appear that the 32bit version of...

  • RE: usp_createsnapshot

    Wilfred van Dijk (7/9/2008)


    I don't know why the registry check isn't working on your server. Do you have a different instancename? Have you checked your registry?

    It's a standard default instance...

  • RE: usp_createsnapshot

    Snapshots are supported on Developer Edition, not just Enterprise Edition.

    Also, the call to master..xp_regread doesn't work with my x64 install. Can't find the path in the registry.

  • RE: SQL Server 2000 SP3a Support is Ending

    Support for the RTM (service pack 0) release of SQL Server 2005 finishes on the same day.

     

    Dave

     

  • RE: how to apply sp1 to SSIS

    I had a similar problem, but trying to apply SSRS after SP1+hot-fixes had been applied.

    in the end, I scheduled a weekend maintenance window, backed up the databases, rebuilt the server,...

  • RE: How to replace a MSDN version with a Volume License version of SQL Server 2005

    In my dealings with Microsoft, as long as I can prove I actually own the licenses to match what's deployed (in a sense that the servers are deployed for production...

  • RE: Creating Foriegn Key

    First off, I'm assuming that TableA exists

    Can you post the DDL for the columns of the two tables?

     

  • RE: How to replace a MSDN version with a Volume License version of SQL Server 2005

    Functionally the two editions are exactly the same.  There are no limitations, no timebombs.

    If you really do want to replace it, backup master and the other databases to another location. ...

  • RE: Running a Query Using a Text File for Input

    whereas my solution was to write an application in C++ which lets me use a placeholder in a sql file, and specify a tab delimited text file to provide the...

  • RE: SQL Server 2005 Service Pack 2

    Ouch!  I've done over 100 SP2 installs (including the betas), and never once had the installer fail in such a manor.

    Are you installing using local administrator account, or domain/enterprise admin...

  • RE: SQL Server 2005 Service Pack 2

    Todd,

    Are you getting an error during the installer phase, or after?  Does any kind of dialog come up?  I'm assuming nobody is trying to use the system while the update...

  • RE: Upgrading to Sql server 2005

    Which edition (Workgroup, Standard, Enterprise)?

    What licensing model (per client or per Processor)?

    Do you have a Select Agreement with Microsoft and if so, do you have SA (Software Assurance) on your...

Viewing 15 posts - 1 through 15 (of 18 total)