• SQL Export to Excel file column?

    I need to create a SSIS Package in which the data is export to Excel file the problem is the date and time column in sql there is one column and i need to separate it into two column can any body help e i thid? thank in advance

    Shamilh10 pointsBadges:
  • MS Project Server errors

    I have MS Project server 2007 (S1), Project pro (2007), SharePoint Server 2007 (language pack [Turkish] installed on Server 2003 with MS SQL Server 2005. I have only one farm. I can see when I create a project on server and client side. however whenever I want to see preview of a task, it gives an...

    Mahirkarabacak15 pointsBadges:
  • Restrict a script to reduce SQL injection attacks

    I want to reduce SQL injection attacks. How can I restrict a script to execute one query at a time?

    SQL Server Ask the Experts2,585 pointsBadges:
  • What is DBMS in SQL Server?

    Can someone tell me what is DBMS in SQL Server?

    Yaswanthh5 pointsBadges:
  • I know SQL, should I learn Oracle database?

    I know SQL but I'm not master in that. I know only basics of SQL. Can I start to study Oracle database directly? If so please suggest me some good way to learn.

    Prcvjr220 pointsBadges:
  • MySQL vs. Oracle

    what is the major two comparison of mysql5.0 and oracle 10g?

    Mysql10 pointsBadges:
  • Setting database security to prevent restoring databases on other SQL Servers

    Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • can VS 2005 support Oracle 10g?

    can VS 2005 support Oracle 10g data base? i need the MS Report service (SSRS) to be used to make report and the data base is Oracle 10g.please replay to me

    KPL5 pointsBadges:
  • Read Only access to a SQL Database? Best way?

    We're trying to prevent hacks on our site. We've been down several times and the idea came up that we could prevent the SQL Injections by making an account for just the public-facing side of the site that has Read Only set for it. This is a Microsoft SQL 2000 server BTW. Our hosting company...

    Kwoodall10 pointsBadges:
  • SQL Server 2005 backup

    How to take backup of live site in SQL Server 2005?

    Amin4rmOvexTechnology250 pointsBadges:
  • Microsoft ISA Server 2000 – Firewall service deliberately stopped – Want to allow ping.

    Hi. This may seem really stupid, and well it is. I have a customer who is running ISA 2000 primarily as a web cache. It is not used for security in any way, in fact, users can just turn off their proxy settings and access the internet, so security is not really an issue here. The box is 4 years...

    Macleodp5 pointsBadges:
  • Send a email with attachment?

    How do I send a email with attachment in a SQL script using SQL 2000?

    Mistp00120 pointsBadges:
  • SSRS 2008 R2 Trendlines

    I cannot find out how to add trendlines to my SSRS 2008 R2 report. TechNet refers to a 'Values' area and an option to 'Add Calculated Series'. The 'Values' area I see does nothing on a "Right-click" and the option to "Add Calculated Series" I cannot find anywhere.

    NHSNick30 pointsBadges:
  • Linking and unlinking SQL data

    How do link data from a SQL view?

    lsizemore5 pointsBadges:
  • Calling an Oracle stored procedure from SQL Server

    Is it possible to call an Oracle stored procedure from SQL Server?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Calling an Oracle stored procedure in SQL Server

    I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure 'PROCEDURE_NAME' on remote server 'ORCL'. [OLE/DB provider...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server as SAP BW database

    I'm looking for resources on using SQL Server has the BI/BW database.  Benchmarking information would be helpful.

    HWayne5 pointsBadges:
  • Passing an array into a Stored Procedure

    Is there a possibility of passing an array into a Stored procedure? I'm using Java and SQL Server 2000.

    Khperi5 pointsBadges:
  • Defrag SQL Database

    To my understanding, a normal defrag application will not defrag a SQL database. How would this be done, how would you defrag a SQL database? What applications could you use and/or what commands would you use? Kind Thanks.

    CyberJ0 pointsBadges:
  • Calling a SQL Server 05 Stored Procedure from Oracle

    Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!

    Nikkipom795 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