General

• Topics

  Started by

  Posts

  Last post

• Bizarre issue while using datetime variable instead of harcoded value

  Hi, I am facing a bizarre issue while testing a query, When i test with hardcoded date value, the q…

  jyz

  10 replies

  10 years, 11 months ago

  By: miraeg77

• SQL developer

  Hi, I am looking to deep dive myself in SQL development. Currently I am doing the DBA work in a pro…

  dharshi_friend

  2 replies

  11 years ago

  By: Mark Eckeard

• Unable to open a DTS Package. Help!

  Hi all. I'm currently working with SQL Server 2K, and I've installed Analysis Services as well as S…

  pfriedl

  10 replies

  11 years ago

  By: v_varghese

• DTS package and a single global parameter

  I've got a SQL2000 DTS that will restore data from a backup (think TodayDatabase and RestoreDatabas…

  mountcrumpit

  1 replies

  11 years ago

  By: mountcrumpit

• 13 pages of reactions in 1 file

  Hi all I found an interesting thread about linking SQL Server with other database applications. Thi…

  SpeedSkaterFan

  5 replies

  11 years, 1 month ago

  By: SpeedSkaterFan

• Having Problem in restoring transaction log backup

  Hi, While restoring a database, which was damaged due to hardware failure. I Got the following Erro…

  ComITSolutions

  9 replies

  11 years, 2 months ago

  By: Gail Shaw

• Command to execute Copy,Delete etc instead of XP_cmdShell

  Dear All, We are having legacy Sql server data in Sql 2000 and moving to Sql 2012.Have found usage …

  srajinigandh

  5 replies

  11 years, 2 months ago

  By: srajinigandh

• Linked server does not return all rows

  I have a SQL database of stock items and I want to update the price of these items from Sage Line 5…

  steve-204902

  18 replies

  11 years, 2 months ago

  By: Pedro s

• AS Cube Processing Fails

  Hello First let me give some back ground information on this issue. My company has a very old serve…

  katuil

  3 replies

  11 years, 3 months ago

  By: lavinbalaji0

• How to find when the database was last accessed?

  Hi, We have a lot of SQL 2000 databases and planning to decommission the ones which are not used an…

  farushaik

  1 replies

  11 years, 3 months ago

  By: Snigdha Vartak

• running command line in DTS package

  Hi, i have a csv file that i run through an EXE application. i need to be able to run this as part …

  jamie.lawrence

  8 replies

  11 years, 3 months ago

  By: jamie.lawrence

• Unicode output from varchar data columns

  This is a bit odd - I have a table in SQl Server 2005 Standard Edition defined like so: CREATE TABL…

  jk_in_San_Diego

  7 replies

  11 years, 4 months ago

  By: Koen Verbeeck

• Syntax error in Dynamic SQL - SQL Server 2000

  Hi all, I am having problems debugging the following scrip containing dynamic SQL. Can anyone tell …

  Seyed

  5 replies

  11 years, 4 months ago

  By: Seyed

• Stored Procedure Repeating Last Line Of Loop

  I have various stored procedures that generate and email reports. They always duplicate the last li…

  skempf

  4 replies

  11 years, 4 months ago

  By: Sean Lange

• Neighboring counties

  I need some data that lists neighboring counties. Does anyone know of any 3rd party software that …

  Susan-322874

  7 replies

  11 years, 4 months ago

  By: Lowell