by Mike M » Fri, 19 Jul 2002 22:40:59
I'm curious if anybody uses the dt_*** stored procedures
in their development environment.
If so,
1. Were you able to find documentation about their usage?
Or did you feel your way around? I've looked in MSDN and
SQL Server Books On-line with no success.
2. Has it been a success process for your developers?
Thanks,
Mike
by R Padayache » Sat, 20 Jul 2002 00:10:48
Quote:>-----Original Message-----
>Hello,
>I'm curious if anybody uses the dt_*** stored procedures
>in their development environment.
>If so,
>1. Were you able to find documentation about their usage?
>Or did you feel your way around? I've looked in MSDN and
>SQL Server Books On-line with no success.
>2. Has it been a success process for your developers?
>Thanks,
>Mike
>.
by Mike M » Sat, 20 Jul 2002 13:25:12
What about usage of the version control stored procedures?
dt_addtosourcecontrol
dt_checkinobject
dt_checkoutobject
dt_isundersourcecontrol
Cheers,
Mike
Quote:>-----Original Message-----
>The database diagram info is in the dt_properties table,
>but it's in an image column. The dt_ stored procedures
>relate to it.
>I haven't found any useful information on the dt_ objects.
>>-----Original Message-----
>>Hello,
>>I'm curious if anybody uses the dt_*** stored procedures
>>in their development environment.
>>If so,
>>1. Were you able to find documentation about their
usage?
>>Or did you feel your way around? I've looked in MSDN
and
>>SQL Server Books On-line with no success.
>>2. Has it been a success process for your developers?
>>Thanks,
>>Mike
>>.
>.
by Barry McAusli » Sat, 20 Jul 2002 16:00:05
Barry
Quote:> Hmm...ok.
> What about usage of the version control stored procedures?
> dt_addtosourcecontrol
> dt_checkinobject
> dt_checkoutobject
> dt_isundersourcecontrol
> Cheers,
> Mike
> >-----Original Message-----
> >The database diagram info is in the dt_properties table,
> >but it's in an image column. The dt_ stored procedures
> >relate to it.
> >I haven't found any useful information on the dt_ objects.
> >>-----Original Message-----
> >>Hello,
> >>I'm curious if anybody uses the dt_*** stored procedures
> >>in their development environment.
> >>If so,
> >>1. Were you able to find documentation about their
> usage?
> >>Or did you feel your way around? I've looked in MSDN
> and
> >>SQL Server Books On-line with no success.
> >>2. Has it been a success process for your developers?
> >>Thanks,
> >>Mike
> >>.
> >.
I have two questions. The first is every time I link to a table in SQL
server from an outside application it names the table dbo.tablename. Can I
change that dbo to something else?
Second, I have users connecting to my SQL server through Access. Sometimes,
even though they only have one application open the server shows them with
four connections. Is there any way to limit the number of connections?
Thanks.
Len
3. Copying data from databaseA.dbo.table1 to databaseB.dbo.table1
5. granting dbo so objects are owned by dbo
7. Avoid seeing dbo.sysalternates,dbo.sysconst
8. SQLXML 3 .0 Registry/NumThreads
10. DBO but no DBO
13. dbo.sysalternates, dbo.sysconstraints, INFORMATION_SCHEMA etc