• 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.

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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"?

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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.

    SQL Server Ask the Experts2,585 pointsBadges:
  • 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?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft Visual Studio 2008 Express edition

    Hello everybody, i recently downloaded the Microsoft Visual Studio 2008 Express Edition. It has Visual Basic 2008, Visual C# 2008, Visual C++ 2008 and Visual Web Developer 2008 (all Express editions). The problem is i dont know where to start. I have programming background. i have programmed in C++...

    GK30 pointsBadges:
  • hi all

    last day i installed one new xp theam on my xp system. recently i noticed that "RUN" option deleted from my start menu. can anybody help me in this problem ? thanks in advance

    Squibc40 pointsBadges:
  • 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...

    Student0045 pointsBadges:
  • DB Triggers and JPA

    I have a physical file/table, on an iSeries, into which I drop a record containing UserID and Password. This action in turn fires a trigger that ends up calling the api QSYGETPH to verify the user's login credentials. This has been working for years under our previous architecture, wherein we...

    Rdgrimes0 pointsBadges:
  • Accessing MS SQL Server database from the iSeries

    How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting "host name not found" on as400. Thanks, Lan

    Lan1230 pointsBadges:
  • 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 from the other...

    Overtech65 pointsBadges:
  • SQL Server – SSIS

    what is SSIs in Sql Server?

    90497265505 pointsBadges:
  • mssql login script

    Hello, Can anyone give me a simplet powershell script to check login attempt to remote MSSQL database.For eg: if i have a database "db" in remote sql server say 192.168.1.10 which having username"test" and password as "password".If the login is successful its output should shows as "OK" in...

    LINSONAJ5 pointsBadges:
  • SQL server STD 05 between Sites

    besides buying Enterprise($$$$$.$$), how else can I keep these servers (sych'd, mirrored, ???) via a network link between cities? Server1(win-sql-05)DB <> Server2(win-sql-05)DB

    Multilanguage25 pointsBadges:
  • 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...

    ITKE342,685 pointsBadges:
  • Auditing users of STRSQL

    I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when starting up STRSQL? So...

    AS400 - Ask the Expert485 pointsBadges:
  • where clause condtion as a variable (SSIS 2005)

      Let's say we have this query   select * from customer where customerid = '1'   My question is can we create this "customerid = '1'" condition as a variable in SSIS and once it becomes a varible then I will extract the conditions for a column in table,

    SSISquestio5 pointsBadges:
  • ISA Server 2000 error 12202

    When I disable proxy in browser and have isa client installed and configured, I receive: ’ The ISA Server denies the specified Uniform Resource Locator (URL). (12202)’ What am i doing wrong

    123456300 pointsBadges:
  • The most-watched IT questions this week: Feb. 16, 2010

    1. JHite ran into an Outlook 2003 display name issue for contact with multiple email, and XENOPHON22, Mrdenny and Carlosdl helped out. 2. Windows Server 2003 is giving a member some installation trouble, and MrDenny offers some advice. 3. Can you block Exchange 2007 admins from viewing other...

    ITKE342,685 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