• Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?

    What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

    NewnanIT1,110 pointsBadges:
  • Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard

    I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it's shows not...

    SQL815 pointsBadges:
  • Rolling back a SQL server 2005 database.

    We need to roll back a copy of our database 5 hours. We are running sql 2005 on a windows 2003 server. How can we do this? We do not want to effect production data but want to report against the 5 hour old data.

    Karl Gechlik9,860 pointsBadges:
  • SQL Server 2005 & 2008 on a Cluster in Production

    Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because...

    Lorisj3325 pointsBadges:
  • How to roll back service pack in SQL server 2005

    HOW TO ROLL  BACK SERVICE PACK IN SQL SERVER  2005 

    Venkatdbait35 pointsBadges:
  • Maximum memory on a 64-bit operating system?

    I need to install a new SQL server and we are buying a 64-bit OS. What's the maximum amount of memory that the operating system can hold/support/make use of?

    ITKE352,395 pointsBadges:
  • SQL Server 2005 multi-instance cluster

    I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?

    DbaDave25 pointsBadges:
  • sql server 2000 in server

    Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg - aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer as the same...

    Radhaisgoodenough5 pointsBadges:
  • SQl Server Replication Internals

    Can someone please explain me the internals of SQL Server replication. I need to know what happens when a new data is inserted, which all views and triggers get initiated and how the whole process works. Thanks.

    Shahi5 pointsBadges:
  • Database restore

    I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in time,...

    Thedbaed5 pointsBadges:
  • Is having the auto create statistics on in a database a good thing?

    Hello I have a 250GB database and the auto create statistics is on is that a good thing?

    Rick Martinez585 pointsBadges:
  • SQL Server Database Restore

    When i restore a database from server1 to server2 as stand by/read-only mode the database restores with a database owner "domainrmartinez". How can i restore a database from server1 to server2 and the database owner as "sa"?

    Rick Martinez585 pointsBadges:
  • SQL autonumbering problem

    I have a sequel db of users which is periodically updated by exporting to access, making changes, then re-importing amended table. After re-importing, the records are duplicated, and the autosequence jumps to over 10,000. I only have 682 records. (That is the highest index number used.) Why does...

    Chippy0884,625 pointsBadges:
  • SQL Server transactions TSQL question.

    Does a list of Transact SQL statements, that cannot be used within transactions, exist please? Is it available on the Web?

    Fdemid25 pointsBadges:
  • SQL Server tables – What account created the object

    Is there a way to see who created or droped a table in sql server?

    Rick Martinez585 pointsBadges:
  • Database maintenance task (full back up) fails on SQL Server

    Hi My daily maintenance job fails due to the below error from last 20 days regularly Executing the query "BACKUP DATABASE [shipment] TO DISK = N'D:\backup\shipment.bak' WITH NOFORMAT, NOINIT, NAME = N'shipment', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Write on...

    GIG240 pointsBadges:
  • SQL Server Management Studio

    SQL Server management studio will no longer run on my client PC. It ran fine for about 12 months, but now warns with: Evaluation Period has expired..... I am only running the mgmt piece only. How do I get this ability back on my pc?

    Ssutton910 pointsBadges:
  • SQL Server query

    how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?

    Hodhod5 pointsBadges:
  • Attaching files to row information in SQL server

    I'm a new babie in the use of SQL server. Infact i've never used it though i use SQL and Mysql but just as a beginner. Now i find myself in a company where I have to create a database for 180,000 records. whereas, each of these records have 5 documents to be attached against it. Please how can i go...

    Phunmie10 pointsBadges:
  • Cannot connect to SQL Server via LAN

    I try to add a new server registration using Enterprise Manager in a client machine to the SQL database in the server machine. I somehow keep getting 'Access denied' or registration failed. Then I can finally add the server registration after I open the shared folder at the server. Can anybody...

    MissBelle5 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