Programming SQL

Replication Script-Out 2008 Full?
I am trying to come up with tactics for creating a single script to enable replication between two SQL Server 2008 named instances on the same computer. The replication exists on a test machine and I would like to "carbon copy" that replication setup to multiple development server virtual machines. I already have... 2 Feb 2010 17:35

Like search in SQL server 2008 x64 BUG?
I am having problem with a like search in SQL server 2008. It works in x86 but not in x64. The server has collation Sami_Sweden_Finland_100_CI_AS Steps to reproduce: SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON SET ANSI_PADDING ON GO CREATE TABLE dbo.forsakringsgivare2( namn varchar(40) COLLATE Sami_Sweden... 26 Jan 2010 18:57

Creating a view with concatenated columns
I have a table with about 20 columns and I am trying to create a view of it that includes about 10 columns. The problem is that in the process, I am trying to concatenate some fields into one field and I am unable to get any thing working. Below is one example of my attempts to tackle this. Any ideas will be h... 22 Jan 2010 12:58

collect rows of damaged data
Hi, I have to repair overflowed column contents in a SQL Server 2005 database. I would like to write a C++ program (with OLEDB) for fix the problem (on future databases also). I had found http://support.microsoft.com/kb/923247 but the solution does not work on my environment. There is a double precision flo... 22 Jan 2010 08:25

kb923247
Hi, I have to repair overflowed column contents in a SQL Server 2005 database. I would like to write a C++ program (with OLEDB) for fix the problem (on future databases also). I had found http://support.microsoft.com/kb/923247 but the solution does not work on my environment. There is a double precision flo... 21 Jan 2010 10:04

SQL Help
I have a table that will contain a chargekey and a clientkey Table Temp( Chargekey int, Clientkey int) When I select from the table I will get chargekey Clientkey 6233 459 6245 459 6589 459 I want to insert the chargekeys to a comments field in another table and I want it to look like ... 21 Jan 2010 11:12

Capturing First Error Message
Hi All, For the following code, I am getting two difference errors. I need to capture the first error message. Please advise how to capture the first error message. I need to log this info in Error_Log table. CODE ===== drop table authors go CREATE TABLE Authors ( AuthorID INT NOT NULL PRIMARY KEY, Name... 21 Jan 2010 11:12

very useful info
Thanks, very useful info Victor Arquero wrote: Get Database File Space Information 06-Jan-10 Hi David, Good day. You may try this ... SELECT Name, Filename, CONVERT(Decimal(15,2),ROUND(a.Size/128.000,2)) [Currently Allocated Space (MB)], CONVERT(Decimal(15,2),ROUND(FILEPROPERTY(a.Name,'SpaceUse... 21 Jan 2010 02:24

Date filtering
For some reason the date filtering is not working for the below query. Thanks for any assistance in advance. SELECT wli.Create_Date, wli.Event_id, p.Full_Name INTO #WLLegalCases FROM dbo.evWLlegalintake wli INNER JOIN Patient_Elg pe ON pe.Patient_Key = wli.Patient_Key --This join may bring in too many cou... 21 Jan 2010 13:29

Problem Using a UDF in a Constraint to Enforce Non-overlappingDate Periods
Alex Kuznetsov has an interest solution to this problem: http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/03/08/storing-intervals-of-time-with-no-overlaps.aspx -- Plamen Ratchev http://www.SQLStudio.com ... 20 Jan 2010 17:27