• SQL and T-SQL

    If you are used to programming in SQL, will there be any issues with switching to T-SQL?

    lprice230615 pointsBadges:
  • SQL Server 2008 R2 replication

    Good Day. I configure Transactional Replication using SQL Authentication. The subscription account was added to the PAL and it belongs to the Sysadmin group and database_owner role. When I clicked on the VIEW SUBSCRIPTION STATUS and the result shows that the synchronization is working. I also...

    ABSA5 pointsBadges:
  • SQL system date

    I have a beginner SQL question. I'm new to using SQL on the iSeries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How do I get it and how can I convert the dates to...

    RonKoontz1,780 pointsBadges:
  • Download VB, Oracle and Java

    Can I download VB, Oracle and Java for my practice?

    Kiaskala10 pointsBadges:
  • Setting up SQL Server 2005 memory

    My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set 'lock page on memory', but Task Manager show only 4.50GB only and performance monitor show SQL server manager - total memory on 4GB. Expert: Do I setup memory wrong?

    Maylee6330 pointsBadges:
  • SQL Server 2005 memory issue

    SQL server 2005 running on Windows XP. The memory grows steadily then SQL (system) hangs when memory gets to 1.7 GB and then the server must be re-started. What could cause this?

    Uphs25 pointsBadges:
  • Transfer data from DB2 file to SQL Server file

    I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou

    HABDOU5 pointsBadges:
  • DB2 (AS/400) data transfer to SQL Server 2005

    How do I do a Data transfer from DB2 (AS400) TO SQL SERVER 2005?

    Hamadaeg15 pointsBadges:
  • Save log view in Event Viewer

    Howdy folks, If I create a new log view in event viewer and filter the results, is there any way to save this view? Every time I close event viewer I have to re-create it. Probably just MS by design.... Is there any way to script it?

    TheVyrys0 pointsBadges:
  • SQL Server 2005 information

    What exactly does SQL Server 05 do and if I'm looking out for a job in this field, is there any exam which I have to take?. I'm new in this and have less knowledge about SQL. Please help. Thank you.

    Naughtyrohit15 pointsBadges:
  • SQL Server 2005: SQL statement in a variable

    Can anybody help me? "HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE". FOR EXAMPLE : TO ASSIGN A STRING IN A VARIABLE, WE DO LIKE THIS: DECLARE @A AS VARCHAR(20) SET @A='HAI' PRINT @A OUTPUT: HAI SIMILARLY HOW TO ASSIGN A SQL-STATEMENT IN A VARIABLE.

    Narendar30 pointsBadges:
  • LAN connectivity problem with Compaq notebook

    I have a Compaq EVO n1020v notebook. This works fine in our office LAN and sometimes it does not at all. Office LAN is a workgroup with ICS enabled in win 2K server. If I check the IP of the notebook it shows the IP of the LAN but never connects to the internet, can't access LAN...

    BinooDas123410 pointsBadges:
  • SQL Error: Primary filegroup is full

    Hi, I'm getting an error primary filegroup is full. create a space by deleting unneeded files,dropping objects in the filegroup. I have disk space 30gb, then also the error. Please help

    Yesu85 pointsBadges:
  • Issue with passing data between two SQL Server databases

    I am having an issue to passing data between two SQL Server databases. I can not simply use Import/Export functions or Data Transfer Functions from SSIS because I was asked to transfer “20%” data with more than 15 criteria among 400 tables. Also we are not allowed to use the linked server,...

    274703110311274715 pointsBadges:
  • Passing data between two databases in SQL Server

    Is it possible to have a stored procedure in a SQL Server database look at tables in another SQL Server database by sending the second database name as a parameter to the stored procedure?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Writing a SQL Query

    Is it possible to write a query that goes through the entire database to search out a particular phrase to delete it, instead of going table by table? This is on a SQL 2005 Database that was injected. The following appears throughout the database tables: <script...

    Bosco32225 pointsBadges:
  • Upgrading with Windows 2003 Server

    We have 10 WIN2K servers in our environment. 3 of these servers are domain controllers. The rest are member servers. We would like to upgrade with WIN2003 server. Does any one have any tips or pointers on how to go about this task. Is the upgrade process straight forward or should we think about...

    Crackerjack50 pointsBadges:
  • SQL sub query or where exists

    I am working on with SQL server 2003 and using winsql to access and run the query. In the following query I am trying to get the data for a Part (PMPRNO) that the Material (PMMTNO) is from the supplier "AMER NAT" an has a status (MBSTAT) of "20". One other parameter is I only want to see the data...

    Bartbart50 pointsBadges:
  • What is the key for this relation?

    Please look at the ERD http://www.mepopo.com/image/1/38504 If I mapping the ERD into relational database schema R(k1, k2, k3, a, b) (which is before normalization). What will be the key for R? Thanks a lot! Jean

    farfrom15 pointsBadges:
  • Compile Program for previous system level

    Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using "CREATE PROCEDURE" command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this...

    Ketan19305 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