Hi everybody!
Using SQL Server Enterprise Manager I can see general
information about DB, tables and indexes (Right click
over DB name and See option)
How can I print this information? or export it? Is there
any store procedure to get this information?
Thanks for your help.
LJ.Hi
Check out sp_help, sp_helpdb, sp_helptext in books online.
John
"LJ" <leyla.garcia@.unisabana.edu.co> wrote in message
news:07c901c34249$f638cfb0$a001280a@.phx.gbl...
> Hi everybody!
> Using SQL Server Enterprise Manager I can see general
> information about DB, tables and indexes (Right click
> over DB name and See option)
> How can I print this information? or export it? Is there
> any store procedure to get this information?
> Thanks for your help.
> LJ.sql
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Tuesday, March 27, 2012
DB and tables information
Hi there!
Using SQL Enterprise Manager I can see some information
about DB usage and tables and indexes (right click over
DB name and View option)
How ca I print or export this information? Is there any
store procedure(s) to get this information?
Thanks!
LJLJ,
SQL Profiler is great for determining the queries used by an application.
Here's the code that EM uses to populate the tables/indexes Taskpad view:
select
sysusers.name + N'.' + sysobjects.name as ObjectName,
sysindexes.name as IndexName,
sysindexes.rows,
case indid
when 1 then 1
else 0
end as IsClusteredIndex,
sysindexes.indid,
sysobjects.name,
sysusers.name
from
sysusers, sysobjects, sysindexes
where
sysusers.uid = sysobjects.uid
and
sysindexes.id = sysobjects.id
and
sysobjects.name not like '#%'
and
OBJECTPROPERTY(sysobjects.id, N'IsMSShipped') <> 1
and
OBJECTPROPERTY(sysobjects.id, N'IsSystemTable') = 0
order by
ObjectName,
IsClusteredIndex DESC,
indexproperty(sysindexes.id, sysindexes.name, N'IsStatistics'),
IndexName
Dan Farino
Sr. Systems Engineer
Stamps.com, Inc.
news.danATstamps.com
"LJ" <leyla.garcia@.unisabana.edu.co> wrote in message
news:00f801c3424b$0f0a4ea0$a301280a@.phx.gbl...
> Hi there!
> Using SQL Enterprise Manager I can see some information
> about DB usage and tables and indexes (right click over
> DB name and View option)
> How ca I print or export this information? Is there any
> store procedure(s) to get this information?
> Thanks!
> LJ
Using SQL Enterprise Manager I can see some information
about DB usage and tables and indexes (right click over
DB name and View option)
How ca I print or export this information? Is there any
store procedure(s) to get this information?
Thanks!
LJLJ,
SQL Profiler is great for determining the queries used by an application.
Here's the code that EM uses to populate the tables/indexes Taskpad view:
select
sysusers.name + N'.' + sysobjects.name as ObjectName,
sysindexes.name as IndexName,
sysindexes.rows,
case indid
when 1 then 1
else 0
end as IsClusteredIndex,
sysindexes.indid,
sysobjects.name,
sysusers.name
from
sysusers, sysobjects, sysindexes
where
sysusers.uid = sysobjects.uid
and
sysindexes.id = sysobjects.id
and
sysobjects.name not like '#%'
and
OBJECTPROPERTY(sysobjects.id, N'IsMSShipped') <> 1
and
OBJECTPROPERTY(sysobjects.id, N'IsSystemTable') = 0
order by
ObjectName,
IsClusteredIndex DESC,
indexproperty(sysindexes.id, sysindexes.name, N'IsStatistics'),
IndexName
Dan Farino
Sr. Systems Engineer
Stamps.com, Inc.
news.danATstamps.com
"LJ" <leyla.garcia@.unisabana.edu.co> wrote in message
news:00f801c3424b$0f0a4ea0$a301280a@.phx.gbl...
> Hi there!
> Using SQL Enterprise Manager I can see some information
> about DB usage and tables and indexes (right click over
> DB name and View option)
> How ca I print or export this information? Is there any
> store procedure(s) to get this information?
> Thanks!
> LJ
Sunday, March 11, 2012
DateTime format in Report manager (parameter)
Hi,
I would like the report manager to accept datetime parameters in a specific
format (European). I've set the report settings to the correct language, and
parameter input in the visual studio report designer works like it should.
But after deploying the reports, the way the datetime parameter has to be
inputted changed from European (dd/mm/yyyy) to US format (mm/dd/yyyy). The
dates on the report itself are shown correctly.
Is there a way to tell the report manager which datetime format it should use?
thx!
--
AndreasThe date format will be based on the locale requested by the client browser.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:1A293983-0517-46C4-9A70-153B59DB47F3@.microsoft.com...
> Hi,
> I would like the report manager to accept datetime parameters in a
> specific
> format (European). I've set the report settings to the correct language,
> and
> parameter input in the visual studio report designer works like it should.
> But after deploying the reports, the way the datetime parameter has to be
> inputted changed from European (dd/mm/yyyy) to US format (mm/dd/yyyy). The
> dates on the report itself are shown correctly.
> Is there a way to tell the report manager which datetime format it should
> use?
> thx!
> --
> Andreas
I would like the report manager to accept datetime parameters in a specific
format (European). I've set the report settings to the correct language, and
parameter input in the visual studio report designer works like it should.
But after deploying the reports, the way the datetime parameter has to be
inputted changed from European (dd/mm/yyyy) to US format (mm/dd/yyyy). The
dates on the report itself are shown correctly.
Is there a way to tell the report manager which datetime format it should use?
thx!
--
AndreasThe date format will be based on the locale requested by the client browser.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andreas" <Andreas@.discussions.microsoft.com> wrote in message
news:1A293983-0517-46C4-9A70-153B59DB47F3@.microsoft.com...
> Hi,
> I would like the report manager to accept datetime parameters in a
> specific
> format (European). I've set the report settings to the correct language,
> and
> parameter input in the visual studio report designer works like it should.
> But after deploying the reports, the way the datetime parameter has to be
> inputted changed from European (dd/mm/yyyy) to US format (mm/dd/yyyy). The
> dates on the report itself are shown correctly.
> Is there a way to tell the report manager which datetime format it should
> use?
> thx!
> --
> Andreas
Saturday, February 25, 2012
Dates and Differences between Query Analyzer and Enterprise Manager
Hey Everyone,
I am just starting to learn T-SQL and came across something that puzzled me when looking at dates.
If I enter this:
SELECT CONVERT(datetime, CONVERT(varchar, GETDATE(), 101)) AS Expr1
In Enterprise Manager I get this output
12/30/2002 - which is what I assumed that I should get
In Query Analyzer I get this output
2002-12-30 00:00:00.000 - which I did not expect
Does anyone know why there would be a difference and if so, how do I get Query Analyzer to format as 12/31/2002?
Thanks alot,
BrentTry only: SELECT CONVERT(varchar, GETDATE(), 101) AS Expr1|||The style parameter is used when converting to a character type from a datetime - so when you converted it back to a datetime in query analyzer it showed you what you asked for. This is the true format - em will jack with the format but the reality is different. em will see all zeroes for time as no time and only displays slashes (no dashes).
I am just starting to learn T-SQL and came across something that puzzled me when looking at dates.
If I enter this:
SELECT CONVERT(datetime, CONVERT(varchar, GETDATE(), 101)) AS Expr1
In Enterprise Manager I get this output
12/30/2002 - which is what I assumed that I should get
In Query Analyzer I get this output
2002-12-30 00:00:00.000 - which I did not expect
Does anyone know why there would be a difference and if so, how do I get Query Analyzer to format as 12/31/2002?
Thanks alot,
BrentTry only: SELECT CONVERT(varchar, GETDATE(), 101) AS Expr1|||The style parameter is used when converting to a character type from a datetime - so when you converted it back to a datetime in query analyzer it showed you what you asked for. This is the true format - em will jack with the format but the reality is different. em will see all zeroes for time as no time and only displays slashes (no dashes).
Subscribe to:
Posts (Atom)