• Add/Rename SQL Server 2005 Server Name

    Hi experts, I have am trying to rename and add new server name to Microsoft SQL server 2005. I as using following steps for rename step 1. select @@servername ' for seeing current server name step 2. sp_dropserver 'ray' ' for deleting current server step 3. sp_addserver 'raynew', local ' for adding...

    itspirit55 pointsBadges:
  • Reg:Problem with SSAS

    Hi team, This is the first time i registered in such communities. I have a problem with SSAS. We planned for a migration from 2005 to sql 2008 which also involves cubes. I am trying to point out SSAS 2005 cubes to 2008 sql server. Is it possible to do this way or do I need to first migrate the...

    48102145 pointsBadges:
  • Halt audit trace if audit file doesn’t rollover

    I have a security requirement for SQL Server 2005 and 2008: "SQL Server shall be configured to halt if a failure in audit file rollover occurs". How do I accomplish this?

    VelameLaCosa110 pointsBadges:
  • Limiting SQL injection in SQL Server 2005

    I have a site in ASP and on the back-end in SQL Server 2005, but I keep finding SQL injection on my site. Is there code that will prevent SQL injection from getting onto my site?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Invalid String or buffer length ERROR

    I am trying to connect to SQL server 2005 express edition using JDBCODBC bridge driver. I have succesfuly configured the data source but when I use DriverManager.getConnection("jdbc:odbc:sql")-->sql is the data source name.. I catch this Exception.. Many thanks in advance

    1023965 pointsBadges:
  • error in creating new database using sql server

    I enter as the administrator, and when creating a new database a message always appear stating that permission denied in database master! what shall i do?

    Ladylynn15 pointsBadges:
  • Connecting SQL server 2005 with IAN connection

    how we can connect sql server2005 with lan area? what are all the settings and options want to change?

    Shajidjame5 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ssss12315 pointsBadges:
  • Calling stored procedure in a database to query data in another database

    Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData...

    Ncs5 pointsBadges:
  • load balancing in sql server

    Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

    Rabinarayan5 pointsBadges:
  • Can I install SQL Server 2005 32-bit on Vista 64-bit?

    I have a processor of 64-bit and windows vista SP1 64-bit. But i want to install sql server 2005 32-bit does it support or can i install it on 64-bit. shekhar.parate@wipro.com

    Shekhar085 pointsBadges:
  • Merge two companies into one network

    The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company "A" employees to log into...

    PatM5 pointsBadges:
  • SQL Server 2005 backup server

    Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

    NewnanIT1,110 pointsBadges:
  • What are basic differences between SQL Server 2000 and 2005?

    What are basic differences between SQL Server 2000 and 2005?

    Rupam5 pointsBadges:
  • Crystal Reports XI period in database name

    SQL Server 2005 database has a period in its name. For example, data.12. I call a crystal report from VS2008. I use ConnectionInfo object to pass connection info to a report. I get errors in formulas. Renaming DB resolves the issue. How can I get it to work with names like data.12?

    Fortuna35 pointsBadges:
  • SQL SERVER 2005 Performance Monitoring

    Hello, is there a free software tool to monitor sql server 2005 similar to Quest FogLight? Quest FogLight is just too expensive for my budget. I am an independent consultant and I want to be able to monitor my client’s sql server.

    Rick Martinez585 pointsBadges:
  • sql server 2005 do not show Add new administrator in Surface area Configuration

    Hi  all I haved a problem with the installation of SQL Server 2005 SP3 in a WIn xp OS.   I proceed to install the free application but when i try to check the permisions to create a DB i went to Configuration tools > SQL Server Surface area Configuration, but the screen did not present the...

    Mcom5 pointsBadges:
  • MVC Architecure and ASP.net programming

    Are Action Filters, model binding & validation new features in MVC?

    WeberK5 pointsBadges:
  • MS Project Server errors

    I have Ms Project server 2007(S1), project pro(2007), SharePoint Server 2007(language pack [Turkish]installed on Server 2003 with MS SQL server 2005. I have only one farm. I can see when I create a project on server and client side. however whenever I want to see preview of a task, it gives an...

    Mahirkarabacak15 pointsBadges:
  • How to open sqlserver2005 after installing

    I have installed Sqlserver 2005 into mys system and how can i set a username and password to that.I am the only user to that computer.

    Vasi40 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following