SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• management studio

  I have sql server 2005 standard and sql server 2008 express installed. I also have management studi…

  Goonch1

  4 replies

  13 years, 10 months ago

  By: Goonch1

• CoCreateInstance failed for SQLOLEDB.dll for impersonated user

  For SQL Server 2005 Windows Version: 2003 SP2 32bit application in C++ Problem: CoCreateInstance f…

  s_v_joshi

  1 replies

  13 years, 10 months ago

  By: spaghettidba

• Database Mail Issue

  Hi, I am trying to set up Database Mail for my first time, in SQL Server 2005. It's probably worth …

  emilyaanderson

  16 replies

  13 years, 10 months ago

  By: Ant-Green

• Problem with SYNONYM and stored procedures that have parameters

  Does anyone know if you can use a SYNONYM to call a procedure that has input parameters. It would …

  LeeFAR

  7 replies

  13 years, 10 months ago

  By: ejoell 66477

• Access Encrypted Data using Linked Server

  Hi, I have two SQL SERVER 2005 servers namely SERVER 1 & SERVER 2. Using "linked server", the…

  SEKHAR ANANTH

  1 replies

  13 years, 10 months ago

  By: Jack Corbett

• Stored procedure to create delimited string

  Ive found this site quite useful in the past for problem solving but couldn't find anything to help…

  MrRedLion

  1 replies

  13 years, 10 months ago

  By: Jack Corbett

• Performanence issue on select query

  sql server 2005 stand : Select query talking 1.2 min for 7,80,000 records . I am getting performan…

  solomon.jernas

  12 replies

  13 years, 10 months ago

  By: sami.sqldba

• Update table values (primary key restriction)

  Hi, I have a requirement to update the values in a table thru SSIS, however, there is a primary key…

  pwalter83

  4 replies

  13 years, 10 months ago

  By: sami.sqldba

• Moving data from staging table original table

  create table stagingtable ( idint not null primary key, namevarchar(10), cityvarchar(100),…

  Nagaram

  2 replies

  13 years, 10 months ago

  By: sami.sqldba

• triggers on update/delete/insert

  Dear All, For the purpose of duplication (this is intentional)i have created a duplicate table insi…

  Gangadhara MS

  1 replies

  13 years, 10 months ago

  By: spaghettidba

• Database Properties file path change

  Hi, I want to change the file path in sql 2005 server from default to custom. When you right click…

  sql4us

  1 replies

  13 years, 10 months ago

  By: Meet George Jetson

• HOW TO RESOLVE ERROR 10055

  hi when i am using link server i am getting error 10055 please help me i have windows 2003 platfor…

  gajananhatkar

  1 replies

  13 years, 10 months ago

  By: MarkusB

• Simple SQL (SET) statements taking time in our recent trace file

  Hi All, Please find the attached screen grab to see the simple SET statements in our production tra…

  Suresh Arumugam

  10 replies

  13 years, 10 months ago

  By: Ninja's_RGR'us

• Is this possible? Two questions by a newbie.

  Hello, everyone! I have got two questions. The first question: Is it possible in SQL Server 2005 to…

  Bouben

  14 replies

  13 years, 10 months ago

  By: Evil Kraig F

• SUM of a single column in SELECT

  Hi, Does anyone know how can I get the SUM of a single column within a SELECT statement ? The probl…

  pwalter83

  2 replies

  13 years, 10 months ago

  By: pwalter83