Re: per T-SQL alle Tabellen anzeigen?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Frank Kalis (nospam_at_insidesql.de)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 06:49:08 -0800

"Andi E" wrote:

> super, danke
>

Du solltest besser auf die INFORMATION_SCHEMA Views zurückgreifen. Diese
sind durch den ANSI Standard definiert, während die Systemtabellen des SQL
Servers sich theoretisch auf Service Pack Ebene ändern können.
-----------------------
--Frank
http://www.insidesql.de
-----------------------

Relevant Pages

  • Re: sp_ActiveDirectory_Start problem
    ... > I have two Windows 2003 servers that both have SQL 2000 on them with ... If I run the stored procedure ... > only difference that I can see on the servers is that on the one that ... > despite me having run the identical service pack 4 download from MSDN ...
    (comp.databases.ms-sqlserver)
  • sp_ActiveDirectory_Start problem
    ... I have two Windows 2003 servers that both have SQL 2000 on them with ... If I run the stored procedure ... despite me having run the identical service pack 4 download from MSDN ...
    (comp.databases.ms-sqlserver)
  • Re: Service pack issue
    ... but you can get away with different service pack levels in most ... my distribution and Subscriber servers are SP3a. ... I cannot update SQL SP ... for the publisher because the applications is not certified SQL SP3a. ...
    (microsoft.public.sqlserver.replication)
  • RE: SQL Server 2005 faulure when updating to SP1
    ... I do understand you don't want to re-install SQL 2005. ... When installing the Service Pack, the Indexing Service is disabled and I ... Please check the ACL ... The installation continues and then at the end states that everything ...
    (microsoft.public.sqlserver.setup)
  • Re: sql 2005 active/passive cluster options
    ... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
    (microsoft.public.sqlserver.clustering)