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

    ITKE351,905 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...

    ITKE351,905 pointsBadges:
  • SQL 2008 stored procedures and execution plans

    Hi, Is it any significant difference in performance between stored procedure with many parameters (some of them can be null sometimes) and creating many stored procedures that will contains only subset of this parameters ? Thx,  

    Bink15 pointsBadges:
  • a question about IMPORT/EXPORT from the SQL 2005 Migration

    In our original SQL 2000 DTS jobs, we call Stored Procedures and run BCP commands to Import/Export clients files. In our new environment we can not have the Admin right and permission for BCP. We tried to use BULK INSERT login from a special SSIS login name, but that login name is not our regular...

    906315 pointsBadges:
  • Multiple databases on a server – SQL

    My queries Can PostgreSQL(as database for a Jboss application) and MS SQL(as database for a tomcat application).Are there any known conflicts/issues ? Best regards

    Rajg5 pointsBadges:
  • varchar(max) size limit

    I have defined a table field with datatype of varchar(max) but it only stores upto 8k characters, I thought (max) upped this limit to 2g character. How can I get it to store more than 8k characters?

    Niranjan5635 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