SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Write blob field to Windows File system

  I am new to SQL Server. I have a jpeg stored in varchar(max) field in SServer Table. I need to use …

  billyusa

  8 replies

  14 years ago

  By: Oliiii

• After SQL 2005 Upgrade my SQL Version is still 8.0

  I have recently upgraded one of my database servers to SQL 2005 from SQL 2000. After the upgrade I …

  cmorris 6147

  9 replies

  14 years ago

  By: cmorris 6147

• Reporting Services permissions problem

  If anyone has any suggestions how to deal with this, they'd be greatly appreciated ... We just disc…

  s.c.simmons

  4 replies

  14 years ago

  By: s.c.simmons

• 2005 installation on local machine - reporting services issues

  i currently have SS2005 installed on my local windows 7 machine. since installing sql server, i ha…

  justintime

  6 replies

  14 years ago

  By: justintime

• dropping from a column

  I want to drop results from a column ex: ...where pi.pay_id = lpa.pay_id and pi.business_date betwe…

  jess.

  5 replies

  14 years ago

  By: jess.

• Burst a record to multiple copy based on a field of that record

  We need help to burst a single record into multiple copies of that source record The number of copy…

  kclee11

  2 replies

  14 years ago

  By: kclee11

• Recommendation for Partitioning Table

  Hi, Can any one give me the recommendation to partition the table in sql server 2005 1. After how m…

  nikhil.desai1

  4 replies

  14 years ago

  By: PaulB-TheOneAndOnly

• Can I convert rows to columns?

  Greetings Experts, I need a miracle of some sort. I have the following query: SELECT a.deptcode, c.…

  simflex-897410

  4 replies

  14 years ago

  By: Sean Lange

• Linked Server to Tab Delimited Text File Issue

  Hi I am having an issue with a linked server I have configured to a tab-delimited text file. The fi…

  doug.milostic

  1 replies

  14 years ago

  By: doug.milostic

• How can we Upload files to SFTP server using SQLSERVER 2005 Stored procedures.

  Hi All, How can we Upload the files to SFTP server using SQLSERVER 2005 Stored procedures. I need t…

  Sarath Vellampalli

  5 replies

  14 years ago

  By: Lowell

• Use @return_value to UPDATE a table

  Hello, I am trying to update a table using the returned value from a stored procedure, but I am not…

  donato1026

  22 replies

  14 years ago

  By: donato1026

• SQL - Query takes long time to execute...

  Hi All, The below query works fine without the function(countDocumentFunction) in subquery and in m…

  thundersplash845

  10 replies

  14 years ago

  By: Johan Bijnens

• System DBs default location

  I'm having this problem: We are still using SQL2005, and I noticed, that installing SQL2005 does no…

  FreeHansje

  3 replies

  14 years ago

  By: FreeHansje

• The feature(s) specified are not valid for this edition of SQL Server

  Hello, The above error appears when performing an installation of SQL 2005 Standard edition on W2K3…

  Sven Abels

  1 replies

  14 years ago

  By: MiguelSQL

• Query text to get in insert/update/delete trigger

  All, I want to get the text of query that is just inserted/updated/delete (DML Statements). Query t…

  samwids

  11 replies

  14 years ago

  By: ajoiner