• documents on sql server upgrade from 2000 to 2005

    Hello, If anyone has following documentation on SQL SERVER UPGRADE FROM 2000 TO SQL SERVER 2005, I will appreciate. 1) Pre-Checklist for the Upgrade 2) Process for the Upgrade 3) Post Check list for the Upgrade Thank you so much. If you kindly email me at cqldba@gmail.com, will appreciate thanks Sam

    Pslsql10 pointsBadges:
  • ROW_NUMBER in SQLServer

    In Oracle, I can use the analytic ROW_NUMBER function to assign sequence numbers to output rows, re-starting the sequence as certain values change (e.g., there's a separate count for each deptno in this example:) SELECT deptno , ename , ROW_NUMBER () OVER ( PARTITION BY deptno ORDER BY ename ) AS...

    FrankKulash1,240 pointsBadges:
  • Need to create SQL DTS Package

    We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also i want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script??

    JimmyIT1,725 pointsBadges:
  • view and temp. table which one works better in T-SQL?

    please tell me which one performs better view or temp table ?

    HL5 pointsBadges:
  • SQL Server Command String

    What is the max length of the Command String that can be submitted to SQL Server?

    Hank103925 pointsBadges:
  • Problem with MSSQL? .NET application? or Win Server?

    Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem........MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application that fetches data from...

    georgesmith55 pointsBadges:
  • SQL Server Schema Best Practices

    I am in the process of establishing a "sandbox" database for a mix of users with SQL development skills. I have done this before with Oracle but not with SQL Server. What I would like to do is build a database whereby each user has their own play area. We are running SQL Server 2005 so I thought of...

    MortimerSchnurd0 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • Triggers

    I was a cobol/db2 programmer for many, many, many years, and I now have the opportunity to work with SQL Server. That’s the good news…the bad news is NO training. I will have to learn this on my own. Do anyone have any suggestion on how to get started. My first project is to identify all of the...

    Mainframe dino0 pointsBadges:
  • database sql,with vb coding,first time running not fast

    we have an accounting package written in visual basic 6.0 and sql database,the problem is when we open the database the first time,it takes lot of time,but when we open it after, it will be very fast and remain fast ,even when we quit the application and restart it.

    Micus20050 pointsBadges:
  • SQL Server Tools do not show up

    Greetings, I have my laptop running MS SQL 2005. I upgraded from XP to Vista. When XP was installed, I had SQL 2005 Express and SQL Server 2000 running parallel. After installing Vista (clean) I decided to just go with SQL 2005. I installed SQL 2005 Express. Later, I installed the full server, and...

    Taersious15 pointsBadges:
  • Using MAX data types in SQL Server

    I'm new to using large data types (varchar(max))and after reading an article (Using MAX data types in SQL Server) I have a few questions. I am trying to understand how you insert such a long string (up to 2 billion char) in the database table? I am assuming this would include storing Word...

    Hank103925 pointsBadges:
  • Dynamic updates to a DNS Server

    What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?

    1111100 pointsBadges:
  • What is NAT port forwarding?

    Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.

    1111100 pointsBadges:
  • DHCP relay Agent in DELL switches

    I have windows 2003 servers and Dell 62XX series switches (level 3 switches) and Vlans. As I understand in order for a computer to be able to receieve an IP Address via dhcp I need relay agent. This series of switches supports DHCP Relay my question is how would i assign computer to a specific...

    Dimchik0 pointsBadges:
  • Default User Profile

    I am in the unenviable position of administering an existing Windows2000 network consisting of one computer running Windows2000 server and three workstations running Windows2000 professional. They are configured as a domain. I would like to be able to set up a default user profile that would have a...

    Skyhawk8060 pointsBadges:
  • The time is wrong in one of my Domain controllers…………..

    Hi, There is something wrong in my domain from one week ago!!! I have two domain controller,the first dc name is DC and second is Mail,both of them is GC and the OS is Win 2003 server R2 sp1 I set the time of Mail and other clients by GP acording the time of DC: (net time \dc /set /y) I have some...

    Aliyani265 pointsBadges:
  • Lost Global Catalogue

    My Windows 2003 PDC recently died but prior to this I had transfered the operations master roles including schema master to my BDC. I was convinced my BDC was a Global Catalogue server but didn't get a chance to check before my PDC died. This happened just before I went away for 2 weeks and I only...

    ITBird15 pointsBadges:
  • Excel 2003 Cell has formula but empty Value or text

    Hya I have a formula into Excel worksheet cell this value comes from out side Excel. sometimes there is a number and sometimes it contains nothing. I have used isblank isempty when the cell is empty and they return true (due to the formula inside the cell) do u thing i can chek if the cell is empty...

    JonsIL45 pointsBadges:
  • SQL 2005 with running 2 Databases

    Can we install one instance of SQL 2005 on one server but running two different databases?

    Stemdriller5 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