Loading a new database from an Old one
I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I’m not sure how to cope with PK’s that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner [...]

Answer Question   |  March 2, 2010  4:16 PM
Database structure, SQL Server 2008, SSIS

Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM?
Is SQL Server an application that I should run within a VM? Can I monitor it while it is on a VM? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

Answer Question   |  March 3, 2010  3:40 PM
SQL Server Virtualization, Virtual Machines, VM

How to read data from a stored procedure in RPGLE
How do I read data from a stored procedure?

Answer Question   |  March 2, 2010  1:30 PM
RPGLE, RPGLE Stored Procedures, Stored Procedures

Documenting column in SQL table in QADBIFLD (AS400)
When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this column. Now my question: How can text-documenation [...]

Answer Question   |  March 2, 2010  10:12 AM
AS/400 SQL, Documentation, QADBIFLD, SQL, SQL generated files, SQL tables

how to give report name dynamically – SSRS 2005
I created report in ssrs 2005. i added ms report viewer in c# windows application and from smart tag i gave the report name. It display the report but how to give name dynamically, for example i want to put the report name through textbox and want to show the report at runtime.

Answer Question   |  February 26, 2010  10:54 AM
C#, SSRS 2005, SSRS reports

Sql server 2005 – query
How to write quary to calculate second highest salary in Emp Table using  “Top” Keyword

Answer Question   |  February 25, 2010  6:39 AM
SQL Server 2005, SQL Server Query

Free working space on primary hard disc
when large files (*.mdb, *.mdf) stored on server are opened on client PC – where do they open – client’s memory or server memory? – I check properties of C: to check free space available – but after opening few large files, I do not see any change in property window of C: for free [...]

Answer Question   |  February 25, 2010  10:45 PM
Hard disks, SQL Server, VS 2005 and .NET 2.0, Windows Server 2003, Windows XP

CPU and RAM recommendations for our data warehouse
We run a DWH with 3 databases. The first DB, called Staging, is the “input buffer”, copies the operational data, seven source systems, 12 parallel Extraction Jobs running SSIS packages. Mostly full refresh 40 GB data every night. Second DB is called catalog. Data is transformed using about 1,500 views and tables, 120 GB. Third [...]

Answer Question   |  February 25, 2010  7:57 PM
RAM, SAN, SSIS Package

Upgrading a 2000 database beyond Service Pack 2
We have SQL Server 2000 SP2 on Windows Server 2003. My database cannot be upgraded beyond SP2, is there anything that I can do to make it “work”?

Answer Question   |  February 24, 2010  7:50 PM
service pack 2, SQL Server, SQL Server Service Packs

Storing encrypted files on an SQL Server 2000
We are doing our final year project as a secured electronic voting system. To finish this project, we are in need of storing our votes in an encrypted form to provide security and, to do so, we are using back-end as SQL Server 2000. Is this possible or must we change our back-end?

Answer Question   |  February 24, 2010  7:47 PM
Encryption, SQL Server, SQL Server 2000

Looping through a Database
http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1111272_mem1,00.html In the above article, it shows how to loop through each database. My question is, how would I loop through each database so that I can then use the sp_foreachtable? I am trying to use the following on each database on a server. “execute sp_MSforeachtable @command1=’DBCC DBREINDEX ([?], ””, 100)’”

Answer Question   |  February 25, 2010  7:42 PM
Looping, Servers, SQL Server

Removing and adding new space to databases.
The scenario: SQL_SVR_A (2000)has x amount ‘too much’ SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn’t have enough space. What is the best method to, first, remove the disk space and keep all DBs in-tact and secondly, how to add new space to ServerB, keeping the DBs in-tact, [...]

Answer Question   |  February 24, 2010  7:38 PM
SAN, SQL Server, SQL Server database

Merging MDF files on SQL databases after restoring from a backup
I recently restored our SQL Server database from a backup, but unfortunately I used a Wednesday backup instead of Thursday, and it is now Friday. Is there a way to merge MDF files, to join all the data together because, as of now, we are missing Thursday’s data.

Answer Question   |  February 24, 2010  7:34 PM
MDF, SQL Server, SQL Server database

Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000
Hello, I’ve got a SQL Server 2000 SP4 database that I am considering switching from Bulk-Logged to Simple recovery model. The reason is, there are no transaction log backups happening so the log is just growing to an unmanageable size (40+ GB). I also want to minimize/shrink the log file. What is the easiest (but [...]

Answer Question   |  February 24, 2010  4:52 PM
SQL Server 2000, SQL Server transaction logs, Transaction logs

Using SQL and Postgre on the same machine
We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

Answer Question   |  February 24, 2010  9:21 PM
Database API, Postgres, PostgreSQL, SQL, SQL Server 2000, Tomcat

Monitoring log files in a SQL Server 2000 database
I have an intermittent problem with a SQL Server 2000 database. The job, to truncate the log files, doesn’t start on time, and the transaction fills up preventing users from logging in. I would like to monitor the log such that I can send an alert when the log reaches e.g. 80% full.

Answer Question   |  February 24, 2010  9:18 PM
SQL Server 2000, SQL Server 2000 Database, SQL Server database, SQL Server logs

MSDE for adminDB
Ever since I installed Diskeeper Administrator 2009 on my PC (it runs XP Pro, svc pk 3), every time I print something, I get some “MSDE for AdminDB” pop-up that says “Setup has detected that your current SA password is set to blank. Please use sp_password to set a strong SA password and restart setup [...]

Answer Question   |  March 1, 2010  8:27 PM
BLANKSAPWD, Diskeeper, Diskeeper Administrator 2009, MSDE, MSDE for AdminDB, SA password

Database management plan wizard
I installed Microsoft SQLSERVER 2008 management studio Express with advanced services. I am trying to work with Database management plan wizard. What is the navigation for that? and i don’t find management plan folder under management in SSMS express…Do i need to install sql server enterprise manager to get management plan wizard?

Answer Question   |  February 23, 2010  8:24 PM
Database management plan wizard, SQL Server 2008, SQL Server 2008 administration

Database Best Practices for index values
I’m more of a .NET than a database guy, but sometimes we just do what we’ve got to do.  Please bear with me if this is an elementary question. One of the apps I’m working on now will have to parse data from another system and store the values in the database.  The data coming [...]

Answer Question   |  February 19, 2010  4:09 AM
ASP.NET, SQL Server, SQL Server 2008

Intel’s Open Port IT Scavenger Hunt has launched: Win a laptop and other great prizes.
Think you’ve got the smarts to navigate Intel’s Open Port community for answers to questions about Intel products? You could win a brand new 2010 Core vPro-based laptop, among other prizes. If you’re an IT Knowledge Exchange member, we’ll also give you 200 bonus Knowledge Points and send you a free sticker just for participating. [...]

Answer Question   |  February 18, 2010  11:14 PM
AS/400, Contests, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Point Challenge, Microsoft Windows, Mobile, Networking, Security, SQL Server