• 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:
  • Copying databases in SQL Server 2005 and SQL Server 2008

    In SQL Server 2005 and SQL Server 2008, the CREATE DATABASE function creates a new database and copies all the tables that are present in the model database. Is there a function where I can do the same from a template database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Explaining features in SQL Server 2005

    I have a presentation to give on business intelligence using SQL Server 2005. Can you assist me by explaining the features Data Integration, Data Analysis, Data Reporting and Data Mining in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Saving the results of a SQL Server 2005 table query in a XML file

    I have data in a table on a SQL Server 2005, and I need to query this table and save the results in a XML file that conforms to a given XSD. Is there an easy way of doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    How to sent SQLMAIL in SQL Server 2005, through SSIS job, when my particular field is updated in database, can we sent SMS also through the SSIS script.

    Deepanshu35 pointsBadges:
  • CASE sintaxis error in SELECT

    In the middle of a large storage procedure I have a working SELECT 01 (see below) which at a couple of points uses CASE statement. I need to expand the most inner CASE to get SQL Server check for several values instead of one. Currently CASE I am talking about looks like (it is in the middle of...

    Jzurbo775 pointsBadges:
  • SQL Server

    What is a tempDB in SQL Server?

    Sai5 pointsBadges:
  • Converting the nvarchar datatype in SQL Server 2005

    SQL Server 2005 automatically converts all the fields with the nvarchar datatype to nvarchar(MAX), which I can’t use with formula functions in Crystal Reports. Is there a way to stop this conversion to nvarchar(MAX)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQLServer2005 CopyDatabase Wizard error

    Using the CopyDatabase wizard to copy from one SQLServer2005 server to a new SQLServer2005 server node, I got an error in the <Configure the Package> step, that says: "While trying to find a folder on SQL an OLE DB error was encountered with error code 0x80004005 (Login timeout expired)"....

    Tito70475 pointsBadges:
  • SQL Server 2005 Reporting Services (Web Service)

    I have installed SQL Server 2005 reporting services, its works fine but the web service is not working. my web service is running under network service and its as priviledge to run. When i browse it after a few minutes it says page cannot be displayed. Any help would be appreciated.

    George5512505 pointsBadges:
  • Password policies for SQL Server 2005 (Yukon)

    What are the password policies within SQL Server 2005 (Yukon)?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server 2005 Maintenance Plans – overwrite vs. append

    I am trying to create a maintenance plan, but when I use the backup database widget, it defaults to 'append existing...'. I want 'oversrite existing...'. Can anyone help me find where that is set? Thank you Carla

    Cecrane10 pointsBadges:
  • RAID Levels on SAN

    When deploying SQL Server 2005 Enterprise whether it is 32-bit or 64-bit versions using a SAN backend, does the Storage Methodologies regarding RAID1 (VRAID1) or RAID5 (VRAID5) change? There are differences of opinions in our organization regarding this issue. From the DBA Standpoint we strive to...

    ROWENS07150 pointsBadges:
  • Creating View With Xml file and table in sql server 2005

    Hi, I have an Active Directory Xml File and I have archived Table with Active Directory With Limited Information like(GUI,FName, Userid) I like to create a view By left join active directory file and archived table. Thanks for reply in advance Please reply to this question

    1 letters5 pointsBadges:
  • How to manage memory for SQL 2005 x64 on 64-bit WS2003 Ent

    I have a Windows 2003 Enterprise 64-bit server running SQL 2005 x64 with 32GB RAM. The SQL database is acting as a transaction database. What is the best way to manage memory on this server? Should I adjust the paging file? If so, to what? Any ideas are appreciated!

    Jean.young5 pointsBadges:
  • Not able to coonect to SQL Server 2005 from Front End in windows Vista Home Basic

    Im not able to connect to SQl Server 2005 installed in my local PC to .net application.But im able to open SQL server 2005 seperatley & able to create tables.Im getting connection failed error while trying to connect.Please give slution for this.

    Karanam5 pointsBadges:
  • Toggling a case sensitive query in SQL Server 2005

    It appears that my queries of stored procedures, tables, columns, etc. are case sensitive in SQL Server 2005. Is there a “case sensitive” option that I can toggle on and off?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Refusal to recognize SQL Server 2005 Express on a client PC

    I have installed SQL Server 2005 Express with about 10 client PCs. I also have Microsoft Access 2003 on the front-end linking to it using System DSNs. On one of the PCs, it refuses to recognize the SQL Server when I try to create a DSN. It does, however, see a different SQL Server that was...

    SQL Server Ask the Experts2,585 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