SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Primary/Foreign Key relationships between tables in 2 Databases

  Looking for some Database Guru's to help me out. Using SQL Server 2005 Enterprise is it possible t…

  moojjoo

  10 replies

  15 years, 2 months ago

  By: Kurt W. Zimmerman

• joining 2 sql servers for querying

  Hi, I want to join 2 tables on 2 different servers,..by applying a join condition...I added tha…

  Skybvi

  6 replies

  15 years, 2 months ago

  By: Skybvi

• Send Email using OPEN QUERY

  I have code to check for new product and then send an email to me of the product that is in the dat…

  donato1026

  7 replies

  15 years, 2 months ago

  By: donato1026

• Log files

  HI every one, I want to know about the transaction log files and tracefiles..??? How they are usefu…

  shivacharan.singh

  1 replies

  15 years, 2 months ago

  By: Steve Jones - SSC Editor

• Sharepoint Instance Left Behind After Uninstall

  Hello, Recently I unistalled Sharepoint thru Add/Remove on a win 2k3 std server. Now, Veritas back…

  foscsamuels

  1 replies

  15 years, 2 months ago

  By: foscsamuels

• Non Disclosure Agreements (What's the point?)

  I have been with my company for over 10 years and the last 7 years my job has been that of a DBA. …

  Steve-3_5_7_9

  27 replies

  15 years, 2 months ago

  By: spaghettidba

• Error in My Function Syntax

  ALTER Function [dbo].[fn_InvoiceList] (@CustName nvarchar(50), @InvoiceDate datetime) RETURNS TABLE…

  wahid kalo

  1 replies

  15 years, 2 months ago

  By: Gail Shaw

• Count for Order

  Tbl.Order OrderID | OrderDate | RequiredDate | OrderStatus --------------------------------------…

  azwa

  1 replies

  15 years, 2 months ago

  By: Dave Ballantyne

• Bulk insert data from .csv or .xls on a remote database

  Hello, I have a SQLServer database on a web server and would like to INSERT data from a .csv or .xl…

  ahmet erispaha

  2 replies

  15 years, 2 months ago

  By: ahmet erispaha

• Beginning Stored Procedure question

  Hello Forum, I have what I think is a very basic Stored Proc question, i think. I am trying to do …

  gregory.perry2

  6 replies

  15 years, 2 months ago

  By: jvanderberg

• Beginning Stored Procedure question

  Hello Forum, I have what I thing is a very basic Stored Proc question, i think. I am trying to do …

  gregory.perry2

  4 replies

  15 years, 2 months ago

  By: LutzM

• Foreign Key References Invalid Table

  Hey. I'm trying to create some tables in my database but I'm getting some errors... The one which i…

  Mybowlcut

  8 replies

  15 years, 2 months ago

  By: rock on dude

• PASSING A NULL VALUE AS A PARAMETER

  Hi everyone. I've got a question (no surprise there). I have a query that I would like to search by…

  iklektic

  2 replies

  15 years, 2 months ago

  By: Mike01

• Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

  Hi, I am getting this error. Please help me to find a resolution for this. This error has raised on…

  Yashwanth

  8 replies

  15 years, 2 months ago

  By: harjit.guram

• Syntax problem - Msg 4145

  I wrote this code : select Name, count(ID) from Players Join Brands on PlayerID where UnsubscribeDa…

  rea_wag

  3 replies

  15 years, 2 months ago

  By: Dave Ballantyne