reporting services training?
Sat, 19 Apr 2008 13:06:01 -0700
Hi,
I'm reviewing training possibilities for MS Reporting services.
Does anyone have trainers they'd recommend?
This training from Hands On Technology Transfer, Inc. (HOTT) looks good.
~
http://www.traininghott.com/CourseAll/SQL-Server-2005-Reporting-Services-Training-Course.htm
Has anyone had ex ...
|
Management Studio & XML Viewer
Fri, 18 Apr 2008 13:59:10 -0700
Anybody can help me get the "XML Viewer" in Management Studio (2005)
Here is what I mean by XML Editor
When you 'execute' a SELECT statement that contains XML column, the cells in
this columns have an hyperlink, which on clicking launches a XML VIEWONLY
Editor.
On one of my machine, this is enabled but no ...
|
MSSQL Viewer
Fri, 18 Apr 2008 10:31:34 -0400
What is a good way to view the interaction with a SQL DB Live. I am looking
to see a table and the data that is in the table.
I am using MSSQL 9 but the DB is in Version 8. Any help would be great
...
|
SQL2005...Alert on Data file size.
Thu, 17 Apr 2008 08:52:10 -0500
I have a db with multiple data files, some are larger and will need to grow
faster then others. We don't want to use autogrow due to the expected size
down the road and no control of the growth timing. I have looked at the
alert that can be created for data files from within SQL but it is a
cumulative of a ...
|
Creates Script feature uses dbo.sp_executesql (ARRG!)
Tue, 15 Apr 2008 12:34:43 -0700 (PDT)
Why does my SQL Management Studio use dbo.sp_executesql with my CREATE/
ALTER Script feature? It's a pain to have all of the single quotes and
what not in there... why doesn't it just scriptout the CREATE PROC
stement for example instead of :
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[ ...
|
Visual Studio Debugger - Nothing Happens
Tue, 15 Apr 2008 10:20:03 -0700
I open Visual Studio Business Intelligence studio or Visual Studio 2008,
connect to SQL Server 2000 database. Select stored procedure to debug. Right
click and use menu item "Step Into Stored Procedure". Fill dialog box with
arguments.
It appers to work, but I never get a debugger on the first line of the
...
|
SQLCMD issues
Tue, 15 Apr 2008 12:01:58 +0300
Hi folks
I am having the following issue with SQLCMD script.
Here's the script:
:setvar x 0
print $(x)
if $(x) = 1
begin
print 'x=1'
:exit(select $(x))
end
else
print 'x <> 1'
My problem is that when SQLCMD encounters (or detects) the :exit statement,
it doesn't executes the PRINT statemen ...
|
|
|
Dear Friends,
Mon, 14 Apr 2008 22:35:26 -0700 (PDT)
We are coming on the heels of a very successful beta program with
passionate feedback. We are launching a superior cost effective
product Secure Auditor aimed at a providing unified digital security
solutions from single console. It is a single tool for compliance,
forensics, and penetration testing and asset id ...
|
Using MS SQL Server Mangement Studio to Copy Table
Mon, 14 Apr 2008 16:03:28 -0500
Is there a way within the Manager to copy TableA in to a new TableB within
the same database?
I have a table that is very similar to a new one I need to create. It would
be nice if there was a copy/paste/rename feature with in the manager.
Can this be done?
Thanks,
Tom Woods
...
|
Troubleshooting with Dashboard Reports and DTA
Fri, 11 Apr 2008 06:00:01 -0700
Hi,
My organization has implemented a project for a customer based con MS
Dynamics AX and a SQL 2005 DB. Now the project is already in production and
we have a 12 Gb Database...
The performance was very slow in some operations, so I used the Dashboard
reports for troubleshooting. When this operations wer ...
|
