|
SQL reporting services - issues
Hi,
i've been making for some time now a series of reports in reporting
services,
mainly because it's free and fairly easy to use...
but, still I encountered some problems:
when using matrixes in reports, the subtotals come in very handy, however, I
can't seem to manage
changing any layout (color,bold,bord ...
Fri, 14 Jan 2005 14:31:03 +0100
|
Customizing Agent Mail Backup Content
Hi,
I was wondering if there is a way to customise e mail alerts that are sent
after a backup is taken of a database ?
I currently receive the following e mail alert format
JOB RUN: 'Northwind backup' was run on 14/01/2005 at 11:06:06
DURATION: 0 hours, 0 minutes, 0 seconds
STATUS: Succeeded
MESSAGES: ...
Fri, 14 Jan 2005 05:21:03 -0800
|
Detecting Tables with no recent activity
Is there an efficent way to determine which tables in a SQL Server database
have had no activity reccently. This includes inserts, updates, deleted
and/or selects.
Are there any tools or techniques to find these tables?
All help appreciated! ...
Fri, 14 Jan 2005 01:05:03 -0800
|
Profiler and set fmtonly On issue
Hello Eliassal,
To turn off this feature, you may try to set Command.prepared in ADO to
False.
Since it appears that this is an ADO related request and would best be
address in the ADO newsgroups, I have provided the link below:
Microsoft.public.data.ADO
If you need further assistance on this ...
Fri, 14 Jan 2005 06:31:59 GMT
|
Profiler with Object ID
I cannot get Profiler to work with just ObjectID and/or ObjectName. I want
to just trace commands that access a certain table/stored proc. Is this a
bug and/or is there a work around?
Thanks,
Steve
...
Thu, 13 Jan 2005 13:37:56 -0500
|
SLEEPING status in Enterprise Manager
Hi,
I started execution of one huge UPDATE statement in Query
Analyzer, and when I check Current Activity in Enterprise
Manager for my connection, I see sleeping status, and
still, command is running and getting processor/IO time...
What's the catche here? Isn't it suppose to have RUNNING
status?
Tnx,
O ...
Thu, 13 Jan 2005 10:11:14 -0800
|
Agent Mail
Hi All,
I have already posted this question in a different forum it was recommended
that I post it here instead.
I am having a problem setting up sql agent mail. I am running in with a
groupwise mail system but I have it running POP3 so I should be able to use
the agent mail.
The problem I am havin ...
Thu, 13 Jan 2005 07:05:02 -0800
|
Profiler and set fmtonly On issue
Hi,
why do I have a lot of
set fmtonly On, the sql phrase and then set fmtonly Off
example :
SET FMTONLY ON Select PROD_VAT_CODE From Product Where PROD_MANF_SKU =
'Q2477A#401'
SET FMTONLY OFF
I know that turning it on means retuns columns info with no data back. So it
is called when c alli ...
Thu, 13 Jan 2005 06:27:01 -0800
|
Different dates returned from Enterprise Manager and Query Analyse
We have a table with an 8 Byte DateTime column.
Query Analyser says the date in the column is
2005-10-31 23.59.59.990
Enterprise manager sayes the value is:
01/11/05
We have no adea which date is the correct one...
We are running SqlServer 2000 with SP3
Anybody have any ideas???
Thanks.
220 276 ...
Thu, 13 Jan 2005 03:51:02 -0800
|
Save Query Results to Word
Export MS-SQL and Oracle Query Results to a Word Document
Jan. 12, 2004, Providence, RI: SchemaToDoc Enterprises is pleased to
announce the release of a new software product: QueryToDoc.
QueryToDoc lets users write queries against MS-SQL and Oracle
databases, view the results, and then automatically save th ...
12 Jan 2005 20:29:02 -0800
|
database backup schedule not working
I'm running SQL server 2000 on a Windows Server 2003. I'm trying to schedule
a backup for my databases but it's not sticking. I went under Backup
Database, selected the local disk as a backup destination, clicked on
Schedule and setup my schedule.
Everything looks fine until I say OK and then if I go b ...
Wed, 12 Jan 2005 11:45:05 -0800
|
Scheduling a .sql file through "jobs"
This is going to be a stupid, easy question; but I'm a SQL Server Newbie, so
here goes...
I have a .sql file that I need to schedule to run through SQL Server. The
actual SQL in it is too large to be pasted into the Exec Transact-SQL screen
on the scheduler. Is there a way to just call the .sql file from ...
Wed, 12 Jan 2005 09:43:03 -0800
|
cribe Report Generator - version 1.0 released
Gestalt Corporation announces the release of the production version of
Scribe.
Scribe is a report generator that can:
- produce reports from one or more relational databases,
- e-mail the reports as PDF attachments or HTML-formatted content,
- publish them over the Web in PDF or HTML format,
- sched ...
Wed, 12 Jan 2005 17:39:39 GMT
|
Index Tuning Wizard doesn't work
Hi,
I was running profiler trace for few days with the
intention to run index tuning wizard against trace files.
However, it fails with the following message:
"The workload does not contain any events or queries taht
can be tuned against current database. Check to see that
the trace contains valid events ...
Wed, 12 Jan 2005 08:32:54 -0800
|
Microsoft SQL Server Best Practices Analyzer
Should this tool be installed and run in a production server????
--
MM
barney@newsgroups.nospam ...
Wed, 12 Jan 2005 08:21:02 -0800
|