• Conversion of Oracle trigger to MS SQL

    How can I convert an Oracle trigger into MS-SQL?

    Jannat895 pointsBadges:
  • How to setup for the SQL Database Mail to link with Exchange?

    How to setup for the SQL Database Mail to link with Exchange?

    Zur5 pointsBadges:
  • disk activity is running at 100%

    24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

    Salmonthefish5 pointsBadges:
  • DTS: Export to Excel

    I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

    Stan100125 pointsBadges:
  • Connectionstring for paradox db password protected

    Hello everybody, Searching for answers I've found this interesting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...

    Starbasestarfleet20 pointsBadges:
  • Earning Badges Pays Off – Literally!

    We told you that payoffs were coming, and they're finally here! To kick off this exciting new phase of the IT Knowledge Exchange Badge Program, we're doing a site-wide reward for members who have been active within the past 6 months and have earned at least one badge: $10 Amazon.com gift card to...

    MelanieYarbrough6,345 pointsBadges:
  • Windows network problrem but not in all programs

    Hi, I have a PC that have network problems from windows. The PC can have acces to network when using programs almost any. I can reach my AS/400 using emulator or VB Programs I can print on network printers. It can send and receive mail (outlook expres), and get to the net using IE and a proxy...

    Jmthirion0 pointsBadges:
  • I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?

    I am using SQL Server 2005. How can I retrieve data from live server through the Internet using VB.Net 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Automate TSQL Query Output

    I want to have a stored procedure run on a schedule that automatically creates a database output file as a result and saves it to a specific location on my network. Can someone please tell me how to do this?

    Eabouzeid175 pointsBadges:
  • Copying a database to a newer version of SQL Server

    I have a database on my SQL Server that needs to be upgraded to SQL Server 2005 or SQL Server 2008, but when I try to copy it with the Copy Database Wizard, I do not have the option “Copy” listed under “Tasks”. I am using SQL Server Express, which I think may be my problem. Is this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Equivalent of CONNECT BY clause in SQL Server

    Does anyone know if there's a equivalent clause to CONNECT BY of Oracle in SQL Server? My co-worker told me to use a recursive CTE. Would that work? Thanks!

    ITKE977,970 pointsBadges:
  • Is their a RDBMS for the Macintosh Operating System

    Is their a RDBMS for the Macintosh Operating System. I am looking for something similar to Microsoft SQL Server for Mac. Ideally something that would interface with Microsoft Office for Mac.

    BarryCC15 pointsBadges:
  • How to install SQL 2005

    Hey what was minimum hardware required for SQL 2005?

    Roony5 pointsBadges:
  • Execute a view/query is slower in SQL Server 2005 than 2000

    Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query "select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely...

    Db23290 pointsBadges:
  • Convert Oracle code to Microsoft SQL code

    I've been given an Oracle DB that has some triggers and "LOAD DATA" jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?

    VelameLaCosa110 pointsBadges:
  • Error in running SQL Plus

    When running SQL plus of Oracle 9i, after giving user id and password protocol adapter error is there. I used both id an pw i.e. system and manager or scott/tiger

    Krshah5 pointsBadges:
  • Email Notification

    Hey I'm creating an application front end = vb.net and back end = SQL Server DB!! The application helps assign staff to jobs and when an assignment occurs I would like the staff to receive an email informing them that they have been assigned to a job. Can anyone help me out with how I would go...

    Keirameister5 pointsBadges:
  • Is there a tool to trace queries in Oracle?

    I've been working with SQL Server over the past year but now I need to migrate an application with an Oracle database. When I trace my application queries, I used the Profiler tool in SQL Server. What would I be able to use in Oracle?

    ITKE977,970 pointsBadges:
  • Help on Bulk insert and xp_cmdshell rename

    Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...

    GIG240 pointsBadges:
  • Connection issue from analysis to reporting

    I have a report pulling the data from analysis services and reporting in SSRS reports. when I try to render the report I can view the report in the local server.when I try to access the same link remotely, I am unable to access the data and I am getting the below error. An error has occurred during...

    GIG240 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.

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

Following