I am getting an error i don't understand.  I would like for someone else to try and repeat it if possible.  I am on
Sql2005sp2.
The goal is to take a string and split it based on a delimiter.  The following is the split function.  You may recognize
the form.  I found it from this ...

I am trying to gather some recommendations to improve the performance of our
Sage CRM System. One issue I am looking at currently is the views the
supplier has implemented to build filtered lists for the e-newsletter system.
Basically the view joins together 4 to 5 tables ...

I need to change table ownership - but am being told schemas have to
be changed in SQL 2005.
Now seeing an error: Invalid object name 'dbo.address1'.  Currently
that table is called 'admin.address1'

TableName : TableX
Column 1 : name (single line)
Column 2 : Comments (multiple line)
In "Column2" i have comments which are all about roughtly 20 lines but

Imagine a database with a bad naming convention you wish to clean up -
having some columns with the same names as the table and the
identifier columns named as ID_<table name>.
Writing a script to rename tables, columns and constraints using

I'm very new at SP.  I can do some simple things but this is beyond my skills and it would really help me out.  Here is the scenario.  I have two DBs on the same SQL 2005 server.  I need to move data from one DB with a certain date to another DB.
DB1 =  Moxy60 (The Stored ...

My application is going to have excessive insert/delete operations on a
table. around 100 records inserted and then deleted in 2-3 min.
What would be the best table/index settings for this table?
Thank you,

I have the follwoing in many views, I think it would be wise to create a
function (scalar??) so that I can reuse it in the future.
SELECT ...
CASE WHEN dbo.tblEvents.EventDate BETWEEN '20061001' AND

If I have two different data bases on the same server, is it possible to
create a relationship between fields in tables between the two different DBs?

I'm attempting to compare information in a uniqueidentifier field using a
select statement and am having fits trying to get it to work.
Here's a sample of my SQL statement.
SELECT Organization.TreatAsTypeOf_ENUM, Organization.OrganizationID,

I have 2 tables with a one to many relationship. I want to return all
rows from the 1st table (manager table) regardless so I use a left
outer join with the 2nd table (work item table). I also need to put a
WHERE clause in the 2nd table to filter work item type BUT still

I am new to writing SQL CLR code and was woundering if its possible for the
follow
Having a SQL CLR Dll which contians handers for triggers. When a trigger
event is fired by the database being updated, can you then fire a event to a

I have a table a really long varchar column:
given a search string, i'd like to return a string starting at postion
20 characters before and after that string. Basically everything
around that string.

Why do I have to be a SysAdmin to use the debugger !?!?!
Seems like everyone should be able to use it.
I'm tired of spending hours putting Print statements in my code. Surely
there has to be a better way!

I am trying to move data from a flat file to an Oracle database using
SSIS from SQLServer 2005 (yeah, I know, but it is replacing a more
complex process!)
I have a Data Flow with the flat file as the source, and Oracle (using