SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• SSIS 2005 two digit year

  Hello everyone, I am encountering a problem with a SSIS package. In the package I have a source tab…

  p.carloo

  3 replies

  14 years, 6 months ago

  By: Jeff Moden

• Looping through files(.txt) in the directory using sqlserver 2005(Very Urgent).

  Hi, Can any one please tell me how do I loop through the folder that has .txt files using SQLserver…

  sateesh.lingozi

  1 replies

  14 years, 6 months ago

  By: SQLRNNR

• Getting data within a time period

  Hello, I have to create a query based on the condition to display data based on ARRIVAL_SCHEDULE_DT…

  pwalter83

  62 replies

  14 years, 6 months ago

  By: pwalter83

• Detached database but didn't store the database files locations

  Hi Guys, Can you help me out of this. I detached the database, but didn't save the files location. …

  seven.srikanth

  2 replies

  14 years, 7 months ago

  By: seven.srikanth

• HashBytes function

  Has anyone used the HashBytes function of SQL Server 2005 yet.  I'm trying to use it and I'm g…

  Scott Rankin

  5 replies

  14 years, 7 months ago

  By: jshurak

• Odd TRACE SQL Trace line found in SQL Logs

  While going thru the log files today I came across what I would consider an odd entry; 2 to be exac…

  YSLGuru

  7 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• SQL - Any way to execute the code line by line??

  Hi All, Is there any way to execute the sql statements/procedure line by line (like having a break …

  thundersplash845

  6 replies

  14 years, 7 months ago

  By: Steve Jones - SSC Editor

• SQL 2000 to 2005 Upgrade

  Wow, my company has finally gotten on the ball and we are going to upgrade from SQL 2000 to 2005. F…

  jplum

  9 replies

  14 years, 7 months ago

  By: Ninja's_RGR'us

• How do I install SQL server 2005 enterprise on Windows 7

  Its giving me a lot of trouble , especially warnings in the form of IIS requirements, etc to instal…

  kulkarni.ameya

  4 replies

  14 years, 7 months ago

  By: Gail Shaw

• Linked Server - SSAS 2005 - RDP works - Local Doesn't Works?

  I have linked server setup from sql 2005 to ssas 2005/2008. If i RDP into the server,linked server …

  curious_sqldba

  3 replies

  14 years, 7 months ago

  By: clayton-770601

• Get data from another instance

  Hi, how can I get data from another instance. I am trying to use something like: select * from [DBM…

  dxu

  1 replies

  14 years, 7 months ago

  By: M&M

• blocked-process-report help

  Hi, Here is a blocked-process-report from our 2005 prod db. It is looks like the PK of one table in…

  waynezhang101

  4 replies

  14 years, 7 months ago

  By: waynezhang101

• SQL Server 2005 SP2 Database Mail Problem

  We recently upgraded our SQL Server 2005 (32 bit)(clustered) database instance to SP2. Everything s…

  Ned Smith

  8 replies

  14 years, 7 months ago

  By: homebrew01

• Create New Instance SQL Server database Engine

  Hello Friends, Please tell me how to create a new instance of sql server? by using command prompt..…

  shubham.saxena67

  1 replies

  14 years, 7 months ago

  By: Lowell

• SSMA for Oracle and SSIS

  Hi All, new to working with SSMA and SSIS...in SSMA for Oracle I have been able to migrate oracle d…

  bsmith-973822

  1 replies

  14 years, 7 months ago

  By: Mike Heath