• 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:
  • Update from another table and multiple criteria

    update PHYS_COUNT_TAG set COUNT_QTY= (SELECT qty from MC_PART_LOCATION where MC_PART_LOCATION.part_id = PHYS_COUNT_TAG.PART_ID and MC_PART_LOCATION.location_id = PHYS_COUNT_TAG.LOCATION_ID) The above does not work with the error Msg 4104, Level 16, State 1, Line 4 The multi-part identifier...

    MyDanes35 pointsBadges:
  • SQL installation

    What is an Instance Name? What is an Instance ID?

    BlessedOne10 pointsBadges:
  • Backup and Restore different SQL Server 2012 Editions

    Does anyone know if it is possible to backup a database on a SQL Server 2012 Enterprise Edition and restore it to a SQL Server 2012 Business Intelligence Edition using SQL Server Management Studio? I would like to go the other way as well.

    TLMercer45 pointsBadges:
  • Forget SQL Server Password?

    Last week, I have forgotten SQL Server password and I am not able to get any solution from anywhere. It’s very important for me. Please give me such software that helps me to reset or recover SQL password. Thanks in advance!

    ClientsQuery10 pointsBadges:
  • MSSQL logs

    Hi everyone, I'm wondering if someone could help me in getting the logs in MSSQL? or possibly using script? I need to get the logs from an application. This application has a backend database MSSQL. There's no other way in getting the logs but to get the logs directly with the database. I need to...

    jezz341195 pointsBadges:
  • VarChar to Numeric in SSRS

    I am trying to convert from a varchar to numeric format using the "Expression" in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to "Sum" the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The...

    tonyhid10 pointsBadges:
  • Flowchart and algorithm

    How can I find a flow chart and algorithm of a program that finds the minimum of three values?

    melkamu15 pointsBadges:
  • SQL server native webservices and PHP

    Hi, I have a SQL server 2008 database and I need to query it from PHP running in a Linux box. I thought that using webservices was our best option. I am trying to use native HTTP SOAP in SQL server. Following some tutorials, I made first an SP USE [Basededatos] GO /****** Object: StoredProcedure...

    Claubolson35 pointsBadges:
  • Is there a query to search text of all SQL Server database objects that reference a specific table/instance?

    We want to migrate to SQL Server 2005. We need to find all database objects such as Stored Procedures, Views, Triggers, User Defined Functions accessed specific tables, DTS packages that reference a specific table/instance. Is there a query that will allow me search the text of all?

    SQL Server Ask the Experts2,585 pointsBadges:
  • MSDTC promoting a transaction only in some environments

    We have a service which uses LINGTOSQL to process some updates on a remote SQL box.  On some machines everything is fine and it works without DTC enabled.  On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn't been enabled...

    Bee1075 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 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