SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• If exists in boolean user defined function

  Good day to all I have a large table with nearly 1/2 million records. I've created an integer prim…

  Phunhog

  9 replies

  15 years, 2 months ago

  By: WayneS

• SQL agent Job Logging

  I have a job that keeps failing and when looking at the job history I cant make out that is actuall…

  MCHPIS

  5 replies

  15 years, 2 months ago

  By: MCHPIS

• Self Join update

  Hi, I have been trying to work out a query where I do a join on the same table. I know how to do th…

  sc-w

  7 replies

  15 years, 2 months ago

  By: sc-w

• Alter sys.sp_columns in the current database

  Hello to everyone. I'd like to change the stored procedure sys.sp_columns to make this change selec…

  alx.beneventi

  6 replies

  15 years, 2 months ago

  By: neven_mahovic

• Insert,Update and delete triggers in sql server 2005

  **********************Delete Trigger************************************/CREATE TRIGGER [dbo].[Log…

  Aditya-313343

  1 replies

  15 years, 2 months ago

  By: Gail Shaw

• ssis package implementation

  hi am database devolper i want one package which is take the connection string as user defined var…

  sankar.gajjela

  1 replies

  15 years, 2 months ago

  By: Henrico Bekker

• OpenRowSet csv 64 bit error

  I am trying to import a csv file using openrowset on SQL 2005, Server 2003, both 64 bit. The Issue:…

  bret_aylor

  3 replies

  15 years, 2 months ago

  By: steve-893342

• SQL Server 2005 installation error

  I got a error,when i install SQL server 2005 developer edition on windows vista ,on my desktop , i…

  Jay Pete

  1 replies

  15 years, 2 months ago

  By: Johan Bijnens

• Simple query for the Months of a year

  Hi everyone! I build a lot of reports based on months and years. I would love to be able to have a…

  iklektic

  29 replies

  15 years, 2 months ago

  By: Greg Edwards-268690

• SQL 2005 Standard and Express Together

  Can I install SQL 2005 Express on one machine and still connect to SQL 2005 Standard on another?

  ducksql@gmail.com

  3 replies

  15 years, 2 months ago

  By: ducksql@gmail.com

• Where CreatedOn = dateadd(day, -1, getdate()) {exclude weekend}

  Hi all, I have a report with a nested parameter where the WHERE statement incorporates a date selec…

  iklektic

  5 replies

  15 years, 2 months ago

  By: iklektic

• Sql Server Joins

  hi. I want Self Joins Query with one example table? :P:P:P:P:P:P:P Thanks, Sabeer.M

  sabeer

  6 replies

  15 years, 2 months ago

  By: Irshad Vaza

• Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. , but it works on the server

  I am attempting a select statement from a linked server table , using my credentials. When I run th…

  bret_aylor

  2 replies

  15 years, 2 months ago

  By: ColdCoffee

• Stored Procedure to Update a 'Set' of values instead of one-at-a-time

  I have a stored procedure that is currently doing an update based on the primary key value that is …

  andegre

  3 replies

  15 years, 2 months ago

  By: LutzM

• "error converting data type nvarchar to numeric"

  Hi, I have a report that's pulling data off a sql 2005. after our server upgrade, this report stop…

  joeshea123

  1 replies

  15 years, 2 months ago

  By: LutzM