Forum Replies Created

Viewing 15 posts - 16 through 30 (of 71 total)

  • RE: New Install -Developer Edition SSMS - cannot create an editor error

    It looks a Microsoft internal bug.

    Take as reference this note.

    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=464549&wa=wsignin1.0

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: Trouble Installing Cumulative Update 2

    You are trying to install a wrong CPU2, the correct one is

    Cumulative update package 2 for SQL Server 2008 Service Pack 1

    http://support.microsoft.com/kb/970315

    RTM

    ===

    Cumulative Update 2 contains hotfixes for the Microsoft SQL...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: "SQL Server 2008 edition upgrade" failed

    I agree with Henrico Bekker, uninstall and reinstall again, just take a full old backup of your system databases and users databases and document special setting done at instance levels...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: full rights to a SQL server 2008 without the ability to add new users

    You need to define your requirements very well, full user rights mean sysadmin role?? or what permissions??

    What activities the user needs to done??

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: SQL Server 2008 Setup requires .NET Framework 3.5 to be installed.

    Please provide more information about your environment, OS, Version, Service Pack, platform, etc.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: Memory Configuration of 64-bit SQL-2008 Instance with SQL-CLR enabled

    If this is a dedicate database server leave 4 GB for the OS System and 28GB to database server, please enable AWE setting and lock pages in memory rights to...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: sql server job fails

    Please, enable the step job loggin to get the complete error output and paste the output here to figure out the problem.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: Connecting to Server/Instance in Cluster.

    Review your SQL Network configuration, TCP IP ports, it looks like a conflict network, verify that both servers ports are different, after try to connect the servername plus port number.

    SERVERNAME,PORTNUMBER...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: How is SQL server accessing the file system?

    You can use linked server to copy one table from one server to another server and setting the security in better way and more simple to transfer the info from...

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: One account for many databases?

    You can create a generic user and add that user into every database needed by OLAP system.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: SQL Server 2008 Enterprise Evaluation edition setup process failed

    Reviewing the logs attached, it looks like there is another installation done in your machine an Express edition, you should uninstall any version before to install the enterprise version.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: data import

    You can save the import process into DTSX package and verify the workflow step by step too and detect any problem there.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: sp_OACreate fails

    Did you try to use sp_OACreate procedure to test the functionality? Try to use wscript.shell object.

    EXEC @hr = sp_OACreate 'WScript.Shell'

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: collation conflict

    You can use the COLLATE clause to force a collation.

    Please read this article for more information.

    http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/07/12/883.aspx

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

  • RE: SQL Server 2008 Enterprise Evaluation edition setup process failed

    Reviewing the logs attached, it looks like there is another installation done in your machine an Express edition, you should uninstall any version before to install the enterprise version.

    SNM

    Try Free Microsoft SQL Server Data Collector & Performance Monitor.

    http://www.analyticsperformance.com[/url]

    @nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

Viewing 15 posts - 16 through 30 (of 71 total)