• 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:
  • 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:
  • Adding another level of security to SQL 2005 database

    We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security - requiring a SQL username and password along with a valid user name and password on the domain?

    NewnanIT1,110 pointsBadges:
  • SQL Server Disk Alignment

    What size should I set the Starting Partition Offset on the disks when running sql server 2005 32-bit enterprise edition, shuld it be 1024KB or 64KB?

    Rick Martinez585 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • SRS 2005 Export to EXCEL

    Is there anyway to turn off Wrap Text formating on report rows/colimns as it is exported to EXCEL from Reporting Services 2005

    Oldmickey65 pointsBadges:
  • Best tool for SQL Server 2000 – like golden is for oracle

    what db tools are there to query ms sqlserver 2000 database? i'm used to using benthic's golden for oracle databases - and would like a similar tool to use with sqlserver databases.

    Angeliamcdaniel5 pointsBadges:
  • Recovering database files from failed Brightstor 12 server

    We have a failed brightstor 12 server. I can recover the files from the hard drive but the server is dead. We will be rebuilding a new one. Can I recover the database files and import them? And if so where are they located?

    Troubleshooter24755 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