SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• I got burned today at a SQL Server Interview!

  The guy asked me: What is an index? --> I answered fine and said there's clustered and non-clust…

  Mark Markov

  357 replies

  5 years, 8 months ago

  By: Steve Jones - SSC Editor

• xp_dirtree - permission ok but no results returned

  Hi Gurus, I am using Windows Authentication and Trusted Connection when I connect to SQL Server. I …

  davidku

  6 replies

  5 years, 8 months ago

  By: Maurice Pelchat

• Conversion failed when converting the varchar value ', ' to data type tinyint.

  I have data that looks like this: ID   | NAME32   |  1461  …

  seubanks00

  5 replies

  5 years, 9 months ago

  By: drew.allen

• Convert data to ANSI 837 version 5010

  Hi frienda, I have a table with some data. I would like to convert that data to ANSI 837 (versio…

  a2zwd

  1 replies

  5 years, 9 months ago

  By: daniarchitect

• Excel import truncates at 255 characters

  Hi Everyone, I am trying to import some product data from a xls spreadsheet (provided by an externa…

  Bevan Keighley

  11 replies

  5 years, 10 months ago

  By: benigemperle

• Equivalent of 'DECODE' in sql

  Hi all, 🙂 Can anyone provide me with correct syntax for' 'DECODE' function equivalent in …

  kiran-670359

  15 replies

  5 years, 10 months ago

  By: rachit.agarwal2011

• Failed to notify ''operator name'' via email?

  Following command sends email fine: EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@bod…

  A J-145309

  74 replies

  5 years, 10 months ago

  By: Wilson Cucaita

• Problem with Maintenance Plan Cleanup Task

  Hi, Sorry if this has been covered in other posts (I have been looking around) and I just haven't s…

  Chris Stride

  1 replies

  6 years, 1 month ago

  By: sizal0234

• How To Create dynamic column in Sql

  Hi, I have got the situation to add column name dynamically with the data type of int. I have tried…

  shalini_pdi

  7 replies

  6 years, 1 month ago

  By: Jeff Moden

• Help with this error

  I am trying to determine a problem in some software I'm running: I type the following: Select &nb…

  jadwalke

  2 replies

  6 years, 2 months ago

  By: jadwalke

• Help with creation of Trigger to capture failed INSERTS

  Hello. I want to create a trigger on a table on INSERT. So when an INSERT attempts to happen on the…

  wak_no1

  6 replies

  6 years, 3 months ago

  By: wak_no1

• Create a Dynamic Table using a cursor

  Hi, I have a table that contains one column with nvarchar. Let's say this is the table: Reasons_T …

  adi.cohen

  6 replies

  6 years, 3 months ago

  By: lpfaff

• Conversion failed because the data value overflowed the data type used by the provider.

  Hi all, This is a follow up to a previous post from aprox 2 years ago. http://www.sqlservercentral.…

  Alex Kirwan

  15 replies

  6 years, 3 months ago

  By: Sue_H

• Connectivity with the Server, how to fix????

  Hi all, I spent one week on this problem and still stuck here. Could anyone spend a little time and…

  Freeman -984098

  4 replies

  6 years, 3 months ago

  By: rahul 45649

• Generate pdf file by using Reporting Service from C#.net

  Hi, I trying to generate pdf file by using the report from Reporting. I found the C# code as follow…

  Si Thu

  2 replies

  6 years, 4 months ago

  By: derekwalters77