• Can I transfer a SQL license/install to a new server

    We are in the process of upgrading on of our db applications to a new version. This version will require a replication server, meaning we will need a SQL server. Ether 2003 or 2008.  We will need to have a full working test environment before rolling out live with it. Can we transfer our "test"...

    swinehart68031,050 pointsBadges:
  • VIEW_TABLE_USAGE SQL 2005

    In MS SQL 2005, when I select * from VIEW_TABLE_USAGE, I get incomplete results. At least one object that is used in at least one of the views is not listed. View "PTP__MARA_MARC" uses two tables and one view, but VIEW_TABLE_USAGE only lists one table and one view.  Can you please help?

    44444Dave5 pointsBadges:
  • Upgrading for database structure

    hello everyone  Maybe my previous question was not the correct question to ask. I am in the middle of making an application upgrade which includes DB structure upgrade with keeping Data "data loss is not accepted here". I have a complex DB structure in my application which depends "in some...

    Mshafie70 pointsBadges:
  • Where does the WPHOST file get stored in our Novell server?

    Where does the WPHOST.db file gets stored .Does it get stored in our local disc.If yes then where.And where is the novell address book gets stored it gets stored in our local disc or is present at the server side

    Sanchaita15 pointsBadges:
  • SQL and Dates

    Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||'/'||SUBSTR(BMDTOR,7,2)||'/'||SUBSTR(BMDTOR,3,2)))/30 AGE,...

    jschultz385 pointsBadges:
  • Application Upgrade and Data migration

    Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, ...)  structure according to Database engine used.  My question now is , what is the best practice to migrate old...

    Mshafie70 pointsBadges:
  • Crystal Reports 8.5 iMIS 10.6 database

    I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to...

    Mystic15 pointsBadges:
  • DBCCShrinkDatabase as Security Cleanup Measure?

    Recently a private document wasposted to a publicly accessible SharePoint site. The file was deleted and removed from the search index by running an intermediate crawl of the content database. Now the client wants to shrink the database, which is just under a 1Tb in size and sits on a SAN, claiming...

    KansasCoder40 pointsBadges:
  • SQL Server project in VB 2005

    A form contain two text field (Name,Address) three buttons (Save,Modify,Delete). A test.mdf file in sql server. I want total source code of that sample project Pl help me about that. Thank you prit

    PRITH5 pointsBadges:
  • how to use databases made in access or excel in sql

    how to use databases made in access or excel in sql   importing readymade databases in sql

    Dragan1525 pointsBadges:
  • SQLCMD does not create a log file

    I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).

    Harv200250 pointsBadges:
  • Server Timeout on initial web connection to SQLServer

    We run a couple of websites (hosted on different webservers) that connect to an SQL Server. The data was recently moved to another SQL Server (called SQLCLUSTER) and now the first time the site is accessed, it takes over 20 seconds to bring up the page. If I don't set the Connection Timeout in the...

    Ajmo25 pointsBadges:
  • IT Knowledge Exchange’s iPad Contest Starts Today!

    Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or...

    MelanieYarbrough6,345 pointsBadges:
  • SQL Server 2000 Log Shipping

    Hi I have an issue with my logship server (SQL 2000). I logship every 10 mins from production to backup server, all has been working fine, until today when a network issue caused a logfile which i use to restore was corrupted. I need to make the Logship DB Live to retrieve some data I run ...

    KH155 pointsBadges:
  • SQL SERVER 2005 Storage Performance

    We have an IBM server xSeries 460 with a QLogic FC HBA card 4gb on the server with a PCI-X 266MHz bus speed (16 CPU 667MHz FSB, 32GB RAM). The HBA card connects to a Brocade 5000 switch then to the SAN Controller then to a Cisco 9124 Switch then to SAN Drives all through FC. On the IBM server we...

    Rick Martinez585 pointsBadges:
  • Storage Area Network Configuration IOPS

    I have a SAN with a RAID 10 (16 Drives) and a stripe size of 512. I want to align the disks for better SQL Server performance, the problem is that the OS is already installed on a non-aligned drive and SQL Server is running in production using non-aligned drives. My current 8 drives starting...

    Rick Martinez585 pointsBadges:
  • GDG restoration from tape backup

    hi, can anyone please tell me iwant to restore generation which is multi-volume (G0001V00) from tape on dasd with renameu option.and i have tried with first creation with base gdg nad without base also. i m getting this error(G0001V00 IS A MULTIVOLUME DATA SET ).can anyone share the jcl. I m trying...

    Djainpune5 pointsBadges:
  • How do you set a SQL Server job step status?

    I am running SQL Server 2005. I have a job that has six steps to load a database table from an external source. The external source is required to send the file nightly. In system testing I found this is not always the case. I created a batch 'step' (Step 3) to check if the file has been sent (see...

    Redwine20 pointsBadges:
  • Running Multiple SQL statements through JCL

    I need to run multiple sql statements seperatd by ';'. I want the execution to continue for all the SQL statements even if any of the SQLs throws out error. Is it possible?

    Vmfquest5 pointsBadges:
  • Stored Procedures in SQL Server 2005

    Will you please explain me about Stored Procedures in Sql server 2005

    Rajanarina110 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