Is it possible to integrate with VSS?

Hi all,
Is there a way to integrate with Visual SourceSafe? Since i want to keep
track the changes of functions, sp, schema... etc.
Thanks
Martin
Hi
You may want to use SMO (SS2005),DMO(SS2000) objects library to keep track
the changes.
"Atenza" <Atenza@.mail.hongkong.com> wrote in message
news:eQnEm4GMGHA.2916@.tk2msftngp13.phx.gbl...
> Hi all,
> Is there a way to integrate with Visual SourceSafe? Since i want to keep
> track the changes of functions, sp, schema... etc.
> Thanks
> Martin
>
|||this means that i have to write my own program to integrate with VSS, rite?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:Okuj4FHMGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Hi
> You may want to use SMO (SS2005),DMO(SS2000) objects library to keep track
> the changes.
>
>
> "Atenza" <Atenza@.mail.hongkong.com> wrote in message
> news:eQnEm4GMGHA.2916@.tk2msftngp13.phx.gbl...
>

Is it possible to integrate with VSS?

Hi all,
Is there a way to integrate with Visual SourceSafe? Since i want to keep
track the changes of functions, sp, schema... etc.
Thanks
MartinHi
You may want to use SMO (SS2005),DMO(SS2000) objects library to keep track
the changes.
"Atenza" <Atenza@.mail.hongkong.com> wrote in message
news:eQnEm4GMGHA.2916@.tk2msftngp13.phx.gbl...
> Hi all,
> Is there a way to integrate with Visual SourceSafe? Since i want to keep
> track the changes of functions, sp, schema... etc.
> Thanks
> Martin
>|||this means that i have to write my own program to integrate with VSS, rite?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:Okuj4FHMGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Hi
> You may want to use SMO (SS2005),DMO(SS2000) objects library to keep track
> the changes.
>
>
> "Atenza" <Atenza@.mail.hongkong.com> wrote in message
> news:eQnEm4GMGHA.2916@.tk2msftngp13.phx.gbl...
>

Is it possible to integrate with VSS?

Hi all,
Is there a way to integrate with Visual SourceSafe? Since i want to keep
track the changes of functions, sp, schema... etc.
Thanks
MartinHi
You may want to use SMO (SS2005),DMO(SS2000) objects library to keep track
the changes.
"Atenza" <Atenza@.mail.hongkong.com> wrote in message
news:eQnEm4GMGHA.2916@.tk2msftngp13.phx.gbl...
> Hi all,
> Is there a way to integrate with Visual SourceSafe? Since i want to keep
> track the changes of functions, sp, schema... etc.
> Thanks
> Martin
>|||this means that i have to write my own program to integrate with VSS, rite?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:Okuj4FHMGHA.2828@.TK2MSFTNGP12.phx.gbl...
> Hi
> You may want to use SMO (SS2005),DMO(SS2000) objects library to keep track
> the changes.
>
>
> "Atenza" <Atenza@.mail.hongkong.com> wrote in message
> news:eQnEm4GMGHA.2916@.tk2msftngp13.phx.gbl...
>> Hi all,
>> Is there a way to integrate with Visual SourceSafe? Since i want to keep
>> track the changes of functions, sp, schema... etc.
>> Thanks
>> Martin
>sql

Is it any functions similar to "START WITH" and "CONNECT BY" in MS SQL?

Hi all,
I am looking for some functions which are used as "Start with" and "Connect
By" in Oracle. Please help! Thx a lot.
Regards,
ThomasHello, Thomas
If you are interested in recursive queries for processing a tree-like
data structure, you should take a look at CTE-s (Common Table
Expressions) and Recursive CTE-s in Books Online and other MSDN
articles:
http://msdn2.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
Razvan|||Hi,
There is no equivalent of start with and connect by of oracle in sql
server,
got thorugh this links,
credit - vyaskn
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
Handling hierarchical data in Sql Server =>
http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
Thanks,
Sree
Razvan Socol wrote:
> Hello, Thomas
> If you are interested in recursive queries for processing a tree-like
> data structure, you should take a look at CTE-s (Common Table
> Expressions) and Recursive CTE-s in Books Online and other MSDN
> articles:
> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
> http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
> Razvan|||> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
This information has not been updated for SQL 2005. Did you not follow the
links Razvan posted? It is certainly possible to accomplish this using
CTEs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<gsreejith@.gmail.com> wrote in message
news:1138965840.226876.87400@.g49g2000cwa.googlegroups.com...
> Hi,
> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
> credit - vyaskn
> http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
> Handling hierarchical data in Sql Server =>
> http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
> Thanks,
> Sree
>
> Razvan Socol wrote:
>> Hello, Thomas
>> If you are interested in recursive queries for processing a tree-like
>> data structure, you should take a look at CTE-s (Common Table
>> Expressions) and Recursive CTE-s in Books Online and other MSDN
>> articles:
>> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
>> http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
>> Razvan
>|||So, Should explicitly say for Sql Server 2000... :)
I have not tried CTE yet
Anyway thanks for correcting.
Thanks,
Sree

Is it any functions similar to "START WITH" and "CONNECT BY" in MS

Hi all,
I am looking for some functions which are used as "Start with" and "Connect
By" in Oracle. Please help! Thx a lot.
Regards,
ThomasHello, Thomas
If you are interested in recursive queries for processing a tree-like
data structure, you should take a look at CTE-s (Common Table
Expressions) and Recursive CTE-s in Books Online and other MSDN
articles:
http://msdn2.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/msdnmag/i...TSQLinYukon/#S7
Razvan|||Hi,
There is no equivalent of start with and connect by of oracle in sql
server,
got thorugh this links,
credit - vyaskn
s.htm" target="_blank">http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
Handling hierarchical data in Sql Server =>
http://vyaskn.tripod.com/hierarchie...r_databases.htm
Thanks,
Sree
Razvan Socol wrote:
> Hello, Thomas
> If you are interested in recursive queries for processing a tree-like
> data structure, you should take a look at CTE-s (Common Table
> Expressions) and Recursive CTE-s in Books Online and other MSDN
> articles:
> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
> http://msdn.microsoft.com/msdnmag/i...TSQLinYukon/#S7
> Razvan|||> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
This information has not been updated for SQL 2005. Did you not follow the
links Razvan posted? It is certainly possible to accomplish this using
CTEs.
Hope this helps.
Dan Guzman
SQL Server MVP
<gsreejith@.gmail.com> wrote in message
news:1138965840.226876.87400@.g49g2000cwa.googlegroups.com...
> Hi,
> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
> credit - vyaskn
> s.htm" target="_blank">http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
> Handling hierarchical data in Sql Server =>
> http://vyaskn.tripod.com/hierarchie...r_databases.htm
> Thanks,
> Sree
>
> Razvan Socol wrote:
>|||So, Should explicitly say for Sql Server 2000...
I have not tried CTE yet
Anyway thanks for correcting.
Thanks,
Sree

Is assembly code replaceable?

I'm watching a webcast on CLR functions/procs and have a question:

If I create an assembly for my database using some .dll, is that .dll now locked by SQL Server?

I'm concerned of a situation where developer says the assembly code is bad. Developer presents new version of .dll .

- Will I get "Access denied, file is in use" when I try to replace the .dll ? Even if the assembly is used in a derived table column?

Thanks.

The file is not present on the file system. The assemblies is loaded into the database so it has to be placed here. The only thing that could possible cause problems is that you can′t drop an assembly which is used by depended procedures / functions etc.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

In addition, if you would like to deploy a newer version of a dll you previously registered with the server (using create assembly statement), you can have a look at alter assembly statement.

-Mat

|||

Good, I like that the file is no longer needed once uploaded into the database.

The ALTER ASSEMBLY statement looks promising, but is there anything that could hold an assembly-level lock because it's in use, preventing one from updating it?

Is there any sort of testing on dependents before being able to alter an assembly? For instance, I change an assembly method signature from one to two inputs, but database function expects to use one and only one. Another example, I remove a class that corresponded to a database type.

|||

Extensive work has been made in ALTER ASSEMBLY to make sure that it doesn't break any dependencies, including Function/Procedure/Triggers entry-point, UDTs, computed column definitions, persisted CLR expressions, or any schema-bound database code in general, so you should not have any issues there.

The ALTER ASSEMBLY statement will take an exclusive lock on your assembly, and so it will have to wait until the current users of this assembly are done. This is not very different than when you modify other database objects.

Hope this helps!