Programming SQL

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Unspecified error".
I want to update with same tables an online sql server with local data of a software. The online and local tables structures are the same, the name of the table also. I receive this error: Errore -2147217900 OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Unspecified error". ... 16 Mar 2010 10:16

Select on current date
Hi all, having a table in SQL Server 2000 with a DateTime field and some values like: ReferenceDate 2009-05-26 22:30:00.000 2009-05-27 12:30:00.000 2009-05-27 22:10:00.000 2009-05-30 22:40:00.000 2009-05-31 14:55:00.000 how can I write a Select that gets records that have DateReference = getdate()? S... 16 Mar 2010 13:58

PIVOT with dynamic where clause (how to)
Hi folks, I am having problems figuring this one out: The pivot below is intended to be used in statistics (how does each operator (employee) perform). My problem is that I need for it to by dynamic, so that a date interval can be chosen before presenting the result. The date is in [Shipment].[ArrivalDate]. ... 16 Mar 2010 18:37

Trigger Modify Record Date
I want to create a simple trigger to put in a timestamp when the record was last modified. This works when I am updating a record in SQL Server, but if I am using an external source, such as MS Access, the trigger does not update the record with the modify date. The trigger should run, irregardless of where th... 15 Mar 2010 20:44

Could not find stored procedure - fails on first attempt only
Hi all, I have a sp that fails to execute the first attempt after it is created. After the first attempt all other attempts succeed. I'm using sql server 2005. I do not know if it is related or not, but the sp that fails the first time is dropping and creating other stored procedurs. The error... 15 Mar 2010 14:39

BUY FAKE PASSPORTS OF AUSTRALIA,FAKE AUSTRALIAN PASSPORTS FOR SALE! FAKE UNITED STATES(USA) PASSPORT
How to become to rich ? AUTOMATED FOREX SYSTEM http://hotmail.zulutrade.com YOU OPEN ACCOUNT AND ADD A SIGNAL PROVIDER from PERFORMANCE... http://hotmail.zulutrade.com --- frmsrcurl: http://msgroups.net/microsoft.public.sqlserver.programming/BUY-FAKE-PASSPORTS-OF-AUSTRALIA-FAKE-AUSTRALIAN-PASSPO... 15 Mar 2010 11:14

Testing database
Assuming a company that releases software to the public, what methods do you use to manage testing/development database. This can sound pretty simple but when you have a team of developers it can get pretty complicated. Do you have a single database that everyone develops in or seperate databases on each machin... 16 Mar 2010 03:33

UDF Error
I am trying to create a UDF to extract the domain name out of a full email address, as follows: CREATE FUNCTION dbo.udf_GetDomainName (@FullEmail VARCHAR(75)) RETURNS Varchar(75) AS Begin DECLARE @domainname VARCHAR(75) Declare @delim CHAR(1) SET @delim = '@' SELECT @domainname = SUBSTRING(@domain... 15 Mar 2010 05:43

Chris Daten Seminar in Mid-May in Scotland
I have been informed that Chris Date will be running a two-day seminar in Scotland in May entitled "SQL and Relational Theory--How to Write Accurate SQL Code--and know it!". See http://www.justsql.co.uk/chris_date/cjd_edin_may_2010.htm for more information. ... 14 Mar 2010 04:24

How to tell when a transaction has been rolled back?
I have a CLR stored procedure that uses a transaction to insert a row into a table. I need to tell somehow by looking at my sample data whether or not the rollback has actually happened. The only thing I have to go on is the HeadlineID int identity(1,1) not null column. Is this possible? 1. Run the stored proc... 15 Mar 2010 13:30