Use this function:

ALTER function [dbo].[fnSplit1](

@parameter varchar(Max) -- the string to split

...

You can set up client aliases under the configuration manager.

try this:

select *

from sys.tables t

Where NOT EXISTS( select * from sys.foreign_keys

Where t.object_id IN (Parent_object_id, Referenced_object_id) )

What does "transfered to another school" entail, in database terms?

The SOP way to allow someone to perform operations on data without giving them direct access to the data is through...

Vivien Xing (7/10/2008)

---

rbarryyoung (7/8/2008)

---

re-corrected version (sorry):

Alter Proc spLogin_OwnedObjects ( @login as SYSNAME ) As

/*

Display all objects in all DBs owned by the Login.

2008-07-06 RBarryYoung Created.

Test:

spLogin_OwnedObjects 'sa'

*/

declare @sql varchar(MAX), @DB_Objects varchar(512)

Select...

I am still not getting this. I write to and report from the same tables all of the time, why do you think that you need seperate tables for...

I think that the mathematically correct answer to this question is "infinity".

The problem is that...

You gotta love English. I almost started to reply with "But you didn't include the States' Capitals." Then I realized that you didn't mean the capital capitals ("Capital"),...

I gotta admit, I didn't realize that GO worked as anything other than a client tool batch seperator.

What have you tried so far?

Why can't you change the NText field to NVarchar(MAX)

Brian:

True, but you could buffer it with a service broker queue. Which sort of is an asynchronous process, I guess. Of course your method of polling from the...

David Naples (7/8/2008)

---

Actually, this isn't 100% true. If you are building SELECT statements, then yes, you will get multiple result sets. However, if you are performing actions (inserts, updates, etc.)...

Actually, it is not valid to...

re-corrected version (sorry):

Alter Proc spLogin_OwnedObjects ( @login as SYSNAME ) As

/*

Display all objects in all DBs owned by the Login.

2008-07-06 RBarryYoung Created.

Test:

spLogin_OwnedObjects 'sa'

*/

declare @sql varchar(MAX), @DB_Objects varchar(512)

Select @DB_Objects = '...

Thanks for the feedback Damien.