• SQL 2005 to .XML

    How do I automate 2 sql servers to replicate .xml files

    Camofa5 pointsBadges:
  • sql server 2005 slow

    Several times during the day SQL Server 2005 Express is becoming very very slow (actually freezes), even if there was no activitry at all. After restart it is normal again for a couple of hours, then freezes again.

    Vad20 pointsBadges:
  • ASP.net profile object

    I attempted to use the profile object as described in a training video; however when I hit f5(to execute the app in debug mode) the browser begins to opens up but I end up with the debugger telling me it cannot open SQL Server. According to the video the Profile object will default to "string" if...

    Alemap5 pointsBadges:
  • Setting up failover notifications in SQL Server 2005 cluster

    We are new to clustering. We have recently successfully implemented a four-node (active/passive config) SQL Server 2005 cluster. How can I be automatically notified when a node within the cluster fails over to the passive standby or other node within the cluster? Thanks, JGalt

    JohnGalt35 pointsBadges:
  • Command to display virtual nodes hosted by a physical server.

    We have a four node (N+1)SQL 2005 cluster. From a DOS prompt, is there a command that can be run on each of the physical servers that will show you if it is hosting one of the virtual nodes of the cluster?

    JohnGalt35 pointsBadges:
  • Error message in Query Analyzer on SQL Server 2005

    I am trying to run the following command in Query Analyzer on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • i5/OS vs MS sequel server 2005

    The powers that be would like to replace our 20 year old i5 home grown billing system with a .NET solution (partial) over MS SQL Server 2005. How do we convince the powers that be to keep & improve what they have or should we just surrender and start taking .NET classes?

    Soooyeah5 pointsBadges:
  • How to create new ramco test server?

    Plz help me,when i restore my sql database with ramco backup then my database is restore but problem is that front-end not lounch in my system.

    Amitshukla60 pointsBadges:
  • Can’t Upgrade to SQL Server 2005

    I am trying to upgrade a SQL Server 2000 SP4 standared edition running on 64bit Windows 2003 to SQL 2005. Since I am trying to upgrade, I am updating the Default instance. After selecting default instance, the wizard takes you to what components to upgrade; but the Database services is locked so it...

    Randym1,740 pointsBadges:
  • Receiving an error in Quality Assurance on SQL Server 2005

    I am trying to run the following command in Quality Assurance on SQL Server 2005: use temp alter user [MY-LP79EFIWXO93login_a] with login = [MY-LP79EFIWXO93login_b] However, I keep receiving this error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'login'. Do you have...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Copying a database from SQL Server 2000 to SQL Server 2005

    I am using the Copy Database Wizard to copy a database from SQL Server 2000 to SQL Server 2005. I gave it the data file path on the source server (ex. \SOURCEDBC$Program FilesMicrosoft SQL ServerMSSQLData), but it returns an error when I attempt to execute the package ("Access to the path...

    SQL Server Ask the Experts2,585 pointsBadges:
  • problem with sys.endpoints

    Hi, I have ms sql database created in 7.0; I had shift all the data files to a different server where ms sql 2005 is installed. I was able to start sql server from the 7.0 database by specifying the startup parameters. But when I try to connect thru sql mgmt. studio I am getting the "object not...

    Vsskmk5 pointsBadges:
  • SQL client number

    If I have 500 clients in an environment, does that mean I need 20 servers with SQL 2005 Enterprise--each with only 25 client availability?

    Cnotejunebug20 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005

    Hello All, I want to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option.

    ITHULK10 pointsBadges:
  • Giving login and database permissions to a group in SQL Server 2005

    I am running SQL Server 2005 Workgroup Edition on Windows Server 2003 Standard Edition. I have created a global security group called ACSSales and I would like to give login and database permissions to this particular group, rather than individual user permissions. How do I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Setting the ODBC in SQL Server 2005

    I use SQL Server 2000, and I am in the process of upgrading to SQL Server 2005. However, when setting the ODBC, the database option for SQL Server 2005 does not appear. Is there something I have to set first before the ODBC?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Limitations on databases per instance in SQL Server 2000 and SQL Server 2005

    Is there any limitation on the numbers of databases per instance that can run in either SQL Server 2000 or SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating data from Oracle 9i Database to SQL Server 2005

    I would like to migrate the data from all used-defined tables in Oracle 9i Database to SQL Server 2005. I know of options like Linked Server, SSIS, SSMA for Oracle and BCP. Which amongst these is the best way to achieve data migration?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2000 to SQL Server 2005 migration

    Hi, I am pretty new to the SQL Server DB. We are working on a project where in the db is migrated from SQL Server 2000 to SQL Server 2005. I was told that the migrated databases will consume more disk space on SQL Server 2005. Is that true? If so, what is the reason for that and how can we prevent...

    Vidukarth25 pointsBadges:
  • Converting data field into hours, minutes, seconds.

    How do I convert a field in SQL 2005 from seconds to hours, minutes, and seconds?

    Tonya5 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