• Can I restore a SQL 2000 backup to a new SQL Server 2005?

    Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

    TeachMeIT975 pointsBadges:
  • Upgrading from SQL 2000 to SQL 2005

    Will you need to purchase a new server to upgrade SQL 2005?

    Noles15 pointsBadges:
  • Running Profiler, an update statement show reads but no writes?

    Example: last 3 columns are write, rowcount,reads [table] [tbody] [tr] [td]75072[/td] [td]SQL:StmtCompleted[/td] [td]UPDATE UserHdr SET LastActivity = '29-Aug-2010 01:23:24 AM' WHERE UserKey = 'M'[/td] [td]205[/td] [td]2010-08-29 01:23:24.393[/td] [td]The FactorSoft Program[/td] [td]12695[/td]...

    Manodak15 pointsBadges:
  • SQL Server 2005 error after development

    I developed an application and when we moved it to the clients site we started getting this error from their SQL 2005 box: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...

    TeachMeIT975 pointsBadges:
  • High Disk usage on SQL Server 2005

    We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions. Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high...

    Jsql155 pointsBadges:
  • Upgrading SQL Server 2000/2005 to 2008 with VMWare and EMC SANs

    Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?

    SQL2K8Dude5 pointsBadges:
  • SQL Server 2008 Restore error message

    I get this error when trying to restore a 30 mg database "Callback:SQL Server 2008: Out of memory on restore" and then get the error ""There is insufficient system memory in resource pool ‘internal’" Anyone have any ideas?

    Kmmc1122334455665 pointsBadges:
  • Indexing in Microsoft SQL

    What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?

    TeachMeIT975 pointsBadges:
  • SQL Server 2005 maintenance plans

    I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?

    TeachMeIT975 pointsBadges:
  • Connect to remote SQL server from MySQL

    we have read only access to a remote sql server. the requirement is to read few tables from sql server and load to mysql tables (installed on Unix box). Please suggest the possible ways of achieving this.

    Nitibansal5 pointsBadges:
  • Problems running AS400 stored procedure from SQLServer 2005 SSIS execute SQL task

    I need to run a stored procedure (with two input parameters ) that has no output, on an AS400. When I try using the IBM DB2 UDB for iSeries IBMDA400 OLE DB provider, I get the following error [Execute SQL Task] Error: Executing the query "CALL TPSDTA50GQ.PMCTESTTP('PETER', 4)" failed with the...

    PeterJC15 pointsBadges:
  • Database Security: SQL Server 2005 security login

    Like Oracle Logins how can we create Logins in Sql Server 2005? Please help me..........

  • Using mdf file in website

    When you've developed e website with vis stud, including an aspnetdb.mdf file and a database file for the webcontent, how can you use these mdf files on the isp server where sqlserver 2005 is running? A normal connectionstring in the web,sonfig file gives an error about the attachdbfilename being a...

    Makoe5 pointsBadges:
  • Updating SQL express to SQL 2008 R2 on server 2008 with sharepoint 2007

    At present we are running a Windows 2008 Server which has Sharepoint 2007 installed and houses our exchange server.  Apparently only the Express version of SQL server was installed initially and now the 4GB database limit is affecting our intranet. Have been advised that we need to update to SQL...

    Weboneau5 pointsBadges:
  • Microsoft Retail Management System and SQL Server “Write” error

    I am running Microsoft Dynamics Retail Management System POS 2.0 on Microsoft XP platform.  Store Operations Administrator and Manager are working with no problems.  I know I am networked properly.  When I open the POS I get the following:  "Open-Incorrect Function", I can click OK and sign on...

    Cls5 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:
  • Exclude Login from SQL Audit Trace

    I'm working on a stored procedure to capture SQL Server 2005 Audit events.  There is an Application login/user that generates a LOT of rows because it is constatntly hitting the database. I'm using something like: exec sp_trace_setevent @TraceID, 14, 11, @on How do I EXCLUDE a specific login...

    VelameLaCosa110 pointsBadges:
  • Crystal Report Not Coming on Screen

    I am calling one crystal report from VB, it is running well on server. but when I run the same at client side, report comes on a screen for a second and disappered. Output is splash for a sec and return it to calling form. Can you please suggest me the possible reason with solution.

    ManishPatelRaymond5 pointsBadges:
  • Joining 3 tables in SQL Server 2005

    Here are the 3 simple SELECT queries i have but i want to merge them all into 1 singl query.

    Macha19735 pointsBadges:
  • Crystal Reports – Rounding Nearest 1/8 Mile

    I'm trying to create a report that will estimate our cost to a taxi vendor. I have the exact mileage, however I need to round to the nearest 1/8 of a mile. Does anyone have any idea how to do that either is Crystal Reports formula or SQL?

    Sarahtaj5 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