Customize Prompt Message For Stored Procudure

Jul 23, 2005

Hello all,
I have a stored procedure that prompts the user for beginning date and
ending date to run a monthly report. The prompt says
Enter_Beginning_Date and Enter_Ending_Date. I want the prompt to say
Enter Beginning Date (Example:1-1-2003) or something like that. Is
there a way to do this?

CREATE PROCEDURE dbo.MonthlyReport(@Enter_Beginning_Date datetime,
@Enter_Ending_Date datetime)
AS SELECT incident, @Enter_Beginning_Date AS BeginningDate,
@Enter_Ending_Date AS EndingDate, COUNT(*) AS Occurances
FROM dbo.Incident
WHERE (DateOccured BETWEEN @Enter_Beginning_Date AND
@Enter_Ending_Date)
GROUP BY incident
GO

View 6 Replies


ADVERTISEMENT

Inconsistent Results From Stored Procudure

Jan 11, 2000

I have a stored procedure (see below), in which I would like to check if the create an identity column and make it a primary key succeeded. I check @@error after the exec statement. This used to pick up an error if the table already had an identity column. It has stopped doing that. Why? And, if this is not the way to capture the error after the exec statement, how do I do it?


CREATE PROCEDURE rasp_test3
/*
Written by Judith Farber Abraham
this procedure loops thru sysobjects looking for user tables.
If a user table, does it have a primary key?
If not, add an identity column to table and make it a primary key
*/
--would like to have sp in main db but use from all three
@fixDB nvarchar(50)--the db to which to add PKs

AS
Declare @TableName varchar(50)
Declare @TableID int
Declare @Msg varchar (50)
Declare @ColumnName varchar(50)
Declare @IndexName varchar(50)
Declare @MyCursor nvarchar(500)
declare @MyCursorC nvarchar(500)
declare @CName sysname
--Set @Msg = "********* Finished adding Ident fields *************"
/* */
/*
do for all user tables ( xtype = u )
*/
set @Mycursor = N'Declare SysCursor cursor for select Name, ID from ' + @fixdb +'.dbo.sysobjects where xtype = "u"'
execute sp_executesql @mycursor
open syscursor
Fetch next from SysCursor into @TableName, @TableID
/* -1 = no record; -2 = row deleted; 0 = got a row */
While (@@Fetch_status <> -1)
Begin
If (@@Fetch_status <> -2)
Begin /* have a user row (table) */
/* */
set @ColumnName = @TableName + 'ID'
set @IndexName = 'PK_' + @columnName

--only add ident and PK if no primary key in table
If not exists (Select * from Sysobjects where Parent_obj = @TableID and xtype = 'PK')

--add an identity column to user table and make it a Primary key

EXEC ('ALTER TABLE ' + @tablename + ' ADD ' + @columnName + ' INT IDENTITY CONSTRAINT ' + @IndexName + ' PRIMARY KEY ' )
--
Begin
--if error, assume already ident column, so find column name & make PK
print @@error
if @@error <> 0 print "jerror occured"
--set @MycursorC = N'Declare SysCursorC cursor for SELECT c.name
--FROM syscolumns c, sysobjects o
--WHERE ((c.id = o.id) AND (c.status = 128)) AND (o.name = ' + @tablename + ')'
--execute sp_executesql @mycursorC
--Open SyscursorC
--Fetch next from SysCursorC into @CName
--print @cname
--close syscursorc
--deallocate syscursorc
--Exec ('ALTER TABLE ' + @tablename + ' ADD ' + @columnName + ' INT IDENTITY CONSTRAINT ' + @IndexName + ' PRIMARY KEY ' )
--select @cname=c.name
--print c.name
End

End
Fetch next from SysCursor into @TableName, @TableID
End
--Print @Msg
Close SysCursor
Deallocate SysCursor
Return

Thanks for any help,
Judith

View 3 Replies View Related

Return Stored Procudure Values

Nov 5, 2005

I have a quick question for you about SQL stored procedures. If I'min a stored procedure and want to call another stored procedure andreturn values from the second stored procedure what is the procedure?I know you do the following to run the second stored procedure and passin any parameters:EXEC GetAuthorBooks @AuthorIDSo if I wanted the GetAuthorBooks to return all the books for an authorand then populate a temp table in the original stored procedure, how doI return those records, and populate the temp table?What do I have to add to this line: EXEC GetAuthorBooks @AuthorID?

View 4 Replies View Related

Prompt When New Message Is Submitted

Jul 31, 2006

Hey everyone I dont know if this is the right area to post this but here it goesAn easy expamle of this that everyone is really fimaler with is myspace. When a new database entry is submitted then on the admin page it will say like new message(s).. how can I do this. It doesnt have to be per member. It is only going to be on the admin page.

View 1 Replies View Related

Stored Procudure With Multiple Select... Incorrect Syntax Near 'storedProcedure'

Mar 8, 2004

Hi,

Im fairly new to writing stored procudures so I thought you lot might be able to help with this problem.

I have a stored procudure which looks like this:

CREATE PROCEDURE usrCienet.spAdminAgencyActivate_Select
(
@strAgencyId CHAR(6)
)

AS

DECLARE @idAgency INT

SELECT @idAgency = idAgency FROM tblAgencies WHERE strAgencyId = @strAgencyId;

SELECT strName, strAddress1, strAddress2, strCounty, strCountry, strPostcode, strTelephone, strFax, bitActive, bitHeadOffice, bitFinanceBranch
FROM tblBranches
WHERE fk_idAgency = @idAgency

SELECT strFirstName, strSurname, strUsername, bitActive
FROM tblUsers
WHERE fk_idAgency = @idAgency

GO

It basically first declare's and sets @idAgency using the first small select statment, then uses that parameter to run two more selects queries which I want sending to a dataset. Now within the Query Analyzer this works fine. But in my asp.net page it trows up this error:

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'spAdminAgencyActivate_Select'

Now the code im using in the asp.net page is as follows:


Dim objSqlConnection as New SqlConnection(ConfigurationSettings.AppSettings("strCon"))
Dim objSqlCommand_Select as New SqlCommand("spAdminAgencyActivate_Select", objSqlConnection)

objSqlCommand_Select.Parameters.Add(New SqlParameter("@strAgencyId", SqlDbType.Char, 6))
objSqlCommand_Select.Parameters("@strAgencyId").Value = "tes001"

Dim objSqlDataAdapter as New SqlDataAdapter(objSqlCommand_Select)

Dim dsActivateAgency as New DataSet()

objSqlConnection.Open()
objSqlDataAdapter.TableMappings.Add("Table", "tblBranches")
objSqlDataAdapter.TableMappings.Add("Table1", "tblUsers")
objSqlDataAdapter.Fill(dsActivateAgency)
objSqlConnection.Close()


Can anyone help? I believe the error is in the stored procedure somewhere, because if I change the stored procedure so no parameters are being passed to it then it starts working. This is what I comment out and change for it to to get it working, but obviously this is not satisfactory as a final result because the parameter is hard coded in the stored procedure. Im just showing this to see if it gives anyone a clue!!

CREATE PROCEDURE usrCienet.spAdminAgencyActivate_Select
--(
--@strAgencyId CHAR(6)
--)

AS

--DECLARE @idAgency INT

--SELECT @idAgency = idAgency FROM tblAgencies WHERE strAgencyId = @strAgencyId;

SELECT strName, strAddress1, strAddress2, strCounty, strCountry, strPostcode, strTelephone, strFax, bitActive, bitHeadOffice, bitFinanceBranch
FROM tblBranches
WHERE fk_idAgency = 1

SELECT strFirstName, strSurname, strUsername, bitActive
FROM tblUsers
WHERE fk_idAgency = 1

GO

Thanks in advance for any help!!

- Carl S

View 1 Replies View Related

Passing A List Of Numbers To A Stored Procudure, Having A Size More Than 8000 Characters

Aug 1, 2007

Hi..

I m working on MS SQL Server 2000.
I am trying to pass a list of numbers to a stored procedure to be used with 'IN()' statement.

I was doing something like..

Create Procedure proc

(

@Items varchar(100) --- List of numbers
)
AS Begin

Declare @SQL varchar(8000)
Set @SQL =
'
Select Query......
Where products IN (' + @items + ') '
'
Exec (@SQL)


This stored procedure is working fine, but when i m adding more required stuff to that, the size exceeds 8000, & it gives the error "Invalid operator for data type. Operator equals add, type equals text."

Can any1 please help me out with this ASAP??






View 4 Replies View Related

Prompt User From Stored Procedure?

Feb 7, 2006

I have a stored procedure that moves specific data from several tables from a database on one server to several others (using a bunch of openrowset queries). I don't have an app to call this procedure - it's usually runs from the query analyzer and the parameter values for the procedure are passed in from there.

The procedure currently skips over recipient tables that are already populated with the data that's being moved. I want the ability to either skip the table or delete the existing records from the recpient table data based on the user's response. Therefore, I somehow need to prompt the user to get a response when the data already exists in the existing table.

Is there any way to prompt the user from a stored procedure, or do I have to re-develop the procedure in DTS or write and application?

View 2 Replies View Related

How To Insert A Identity Key Through Store Procudure?

Apr 25, 2007

I want to insert 3 values to sql database through store procudure
 
--- a store procudure is like this--
 ALTER PROCEDURE dbo.FreeExperience
@identity ,
@name nvarchar(20),@gender int,
AS         begin           Insert into list(cid,name,gender)                       values (@identity,@name,@gender)
        end RETURN
-----------------------------------------------------------
the cid is a identity value . it will +1 automatically when user insert a new data..
if i ingore this column in store procudure it will cause error (becuase this column is not allow null)
please help. thanks

View 11 Replies View Related

How To Customize The Primary Key Id

Jan 10, 2008



Hi to everyone,

By the way, I'm not sure if, I am in the right related forum to address this questions.
My problem is how to customize a primary key id of the table.
Example. I have a two tables customer and product, and my customer table has a customer id. I want to customize my customer id, which for example the starting id will starts CUS-0001...CUS-002 and so on.
And same also to my product table, product id will starts PROD-001..PROD-002 and so on. the digits of my id's is auto incremented.
Thank you for the time of reading my questions.
Your response is highly appreciated..

View 3 Replies View Related

Sendmail Task - How To Customize ?

May 15, 2007

I have a sendmail task following a data flow task. How can I set "To" attribute on the sendmail task before running it ? for example, read a config table and detemrine who the mail should be sent to...

View 1 Replies View Related

Customize Report Manager

Apr 30, 2008

Hi,
Is it possible to customize the report manager web site so that I can set the report output format to excel by default.
Currently, to get the excel report user has to first select the report criteria and then click the "view report" button which renders the report in HTML format and then only the export to excel option appears.

Is there a way we can get the report exported to excel in one go.

Thanks,
Rajiv

View 1 Replies View Related

Customize Report Manager

Sep 17, 2007

I would like to use Report Managers interface for choosing reports.
But all of the reports uses different dsu(datasourceuser) and dsp(datasourcepassword) depending on which user that is logon.
I would like to call the interface from a webapplication(where they have the current dsu & dsp).

Is there a way to customize Report Manager to save the dsu & dsp so users don't have to login for each report?
Or could I make a clever transformation from the Windows userid?

Or any other ideas??

View 1 Replies View Related

Using InScope() For Customize Subtotal

Jan 22, 2008

Hello All:

I have the following data:

2000 2001

Child Teen Adult Child Teen Adult
Region1 25 40 35 33 55 12
Region2 50 10 40 20 10 70

Total 75 50 75 53 65 82

and I need the following data

2000

Child Teen Adult Child%
Region1 25 40 35 25/(25+40+35)
Region2 50 10 40 50/(50+10+40)

Total 75 50 75 75/(75+50+75)

I was able to get the Child% column and Total row, except for the cell (75/(75+50+75) ) using InScope() operator.
Can any one help me in this regard.


Thanks,
Vishnu

View 4 Replies View Related

Customize Report Filters

Dec 12, 2007



Can I customize the report filters?

I need to use the data from another table (in a Drop Down control) to filter the data of my report instead of having a simple textbox.

How can I do this?

View 7 Replies View Related

How To Customize Auto Generated Userid?

Feb 3, 2008

Hello everyone,i have a web form to take user details.as soon as the submit button is clicked the form is submitting and the new row is being added into the sqldatabase.its fine ..but in the newly added row, i want the user id(primary key and auto generating) to display in different manner.in mytable column(userid),instead of userid auto displaying 1,2,3,4 ...i want it to display in this way.these are all primary keys of rows added.todaydate-username-1 eg(2.2.2008-jack-1)todaydate-usernaem-2 eg(2.2.2008-zak-2)todaydate-usernaem-3 eg(2.3.2008-leme-2)any idea how to achieve this.?thanks.jack.     

View 9 Replies View Related

Transact SQL :: How To Customize Where Statement Based On UDT

May 20, 2015

Display customized data based on customized where statement from UDT.

The UDT is a parameter inside of a stored procedure.

Problem:

A parameter from a stored procedure is
@communication communications readonly

This parameter is a User-Defined Table Types (UDT) It contains criteria based on end-user's selection from a filtration functionality from a webpage.

Four example of filtration critera based on four end-users' selection that is located inside of a table below.

Each UDT table contains different criteria:

Number Criteria
------ --------
1 Phone
3 Email

Number Criteria
------ --------
1 Phone
2 Cellphone
3 email

Number Criteria
------ --------
4 None

Number Criteria
------ --------
2 Cellphone
1 Phone

Is it somehow possible to use the criteria's value as a column name in the where statement? I want to filtrate the data of the table datatable based on id, name and the UDT's criteria.

I was enable to apply the criteria inside of a variable by looping the UDT's table but the next thing is to paste it in the where statement after "id=1 and name" below

select *
from datatable
where id = 1 and name = 'Cost'

How should I do it?

[URL] .....

create table datatable (id int,
name varchar(100),
email varchar(10),
phone varchar(10),
cellphone varchar(10),
none varchar(10)
);

[Code] .....

View 4 Replies View Related

Specifying Different Stylesheet In URL To Customize ReportManager Interface

May 7, 2007

Thanks in advance to anyone who can provide insight into this...



I am trying to specify a different stylesheet (other than ReportingServices.css) in the URL for running the ReportManager application; I am using the "rstylesheet=<stylesheetname>" parameter in the URL. However, it seems that no matter which format of stylesheetname I use (i. e, just the stylesheet file name with no extension, stylesheetname + ".css" extension, "/reports/styles/<stylesheetname>", etc.), the ReportManager application only uses the built-in ReportingServices.css stylesheet.



Is there some "magic" to specifying the name of an alternate stylesheet with the "rstylesheet" URL parameter, or does this just not work?



Thanks again!

View 12 Replies View Related

Customize Report Parameter Layout?

Nov 7, 2007

Hi,

I'm trying to deal with a way to change the report parameter's default layout.

currently it seems to default to two columns, that's fine until you have a large screen and the "View Report" button is all the way to the right and you have a big chunk of whitespace.

For Example:
Parameter 1 Parameter 2 <View Report>
Parameter 3

I'd like it to show up instead as:
Parameter 1 Parameter 2 Parameter 3 <View Report>


anyone ever tried this before?

View 4 Replies View Related

Customize The SQL Reporting Services Page

May 5, 2008

Is it possible to customize the SQL Server Reporting services home page to add our company Logo and custom title etc...?
Thank you,


View 3 Replies View Related

Return Only One Message From Stored Procedure...

May 7, 2008



I have a stored procedure which checks to see if a user's email address exists before it inserts a new record. If it does it should return a message that notifies the user they are already subscribed. If they are not a different message should be returned stating that a new subscription has been created. This procedure works and is shown below.

The problem I am having is with the first SELECT statement. How can I get the procedure to show just one message and not the results from the first SELECT statement too?



CREATE PROCEDURE sp_InsertSubscription
@SubscriberFirstName VARCHAR(50),
@SubscriberLastName VARCHAR(50),
@SubscriberEmailAddress VARCHAR(50),
@SubscriberZipCode INT,
@IsActive BIT,
@SubscriberOptIn BIT,
@AdditionalOffersOptIn BIT,
@Msg VARCHAR(50) OUTPUT

AS
BEGIN
SET NOCOUNT ON;

-- Check to see if email address exists first
SELECT @@ROWCOUNT FROM Subscriber WHERE SubscriberEmailAddress = @SubscriberEmailAddress

IF @@ROWCOUNT > 0
BEGIN
SET @Msg = 'This email address is already subscribed'
SELECT @Msg AS 'User'
RETURN
END

-- Insert statements for procedure here
INSERT INTO Subscriber (SubscriberFirstName,
SubscriberLastName,
SubscriberEmailAddress,
SubscriberZipCode,
IsActive,
SubscriberOptIn,
AdditionalOffersOptIn,
SubscriberSignUpDate)

VALUES (@SubscriberFirstName,
@SubscriberLastName,
@SubscriberEmailAddress,
@SubscriberZipCode,
@IsActive,
@SubscriberOptIn,
@AdditionalOffersOptIn,
GETDATE())


IF @@ROWCOUNT > 0
BEGIN
SET @Msg = 'New user subscription created'
END

SELECT @Msg AS 'User'
END
GO




If the user's email address does not exist I get

(No column name)

User
New user subscription created

If the user's email address does exist I get

(No column name)
0

User
This email address is already subscribed

I would like for the (No column name) to go away - I know this is coming from the first SELECT statement. How do I suppress that statement from being output, yet still get the @@ROWCOUNT variable set?

View 3 Replies View Related

Ack Message Not Picked Up By Stored Procs

Sep 25, 2006

Hi

I setup a message between 2 database on a local instance. The message is send to the target and the target did send a reply. However, the reply is not picked up by the initiator. I did a try but there was nothing telling me why it did not pick up the reply. there is nothing in the textdata of the brokerclassify event. I query the queue on the initiator, the message is there, but the stored proc attached to the queue is not doing anything it seems. What else can I check here,



thanks

P

View 1 Replies View Related

Stored Procedure Error Message...

Mar 6, 2007

Hi

I have trouble to get this stored procedure running and I tried to figure out where I did a mistake but I'm just lost, so if somebody could help me... Thanks!

The Error Message is 102, Level 15, State 1



SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE InsertNewDocumentTypeAndAddSystemFields



@varDocumentTypeName nvarchar(254),

@varNEWDocumentTypeID integer = 0,

@varTempID integer

AS

BEGIN

SET NOCOUNT ON;

INSERT INTO dbo.Document_Type_LookUP

VALUES(@varDocumentTypeName);



@varNEWDocumentTypeID = IDENT_CURRENT('dbo.Document_Type_LookUP')





-- Name or Title

INSERT INTO dbo.Document_Field

SELECT 'Name', SQLDataTypeID FROM SQLDataType WHERE SQLDataTypeName = 'string'



@varTempID = IDENT_CURRENT('dbo.Document_Field')

INSERT INTO dbo.Document_Type_Field_Link

VALUES(@varNEWDocumentTypeID,@varTempID)



-- Filename



INSERT INTO dbo.Document_Field

SELECT 'Filename', SQLDataTypeID FROM SQLDataType WHERE SQLDataTypeName = 'string'





@varTempID = IDENT_CURRENT('dbo.Document_Field')

INSERT INTO dbo.Document_Type_Field_Link

VALUES(@varNEWDocumentTypeID,@varTempID)

END

GO





Thanks in advance!

View 1 Replies View Related

Using Message Queues In Stored Procedures

Oct 11, 2005

Ok, I'm stumped.  I have a database which has a table that stores documents.  Each document has a primary key.  For years, I've been notifying an external program that a new document has arrived in the db by firing a trigger on the table.  Trigger calls xp_cmdshell, which calls an external program which enqueues a message on a message queue.

View 6 Replies View Related

Error Message And Stored Procedure

Mar 24, 2008



I have read many error message articles on the web but still cannot get this to work. I need to return the description of the error that is produced to a output variable (@ErrMsg).


In my stored procedure, I assign @SQLCode to @@Error. @SQLCode is also an output variable. I got the @SQLCode to return no problem, just the description is wrong.




Code SnippetIF @SQLCode <> 0
BEGIN
SELECT description = @ErrMsg
FROM master.dbo.sysmessages
WHERE error = @SQLCode
END






Can anyone shed some light on this? I have heard I have to assign the error information to another table and then pull the info from that table, but I don't know how to do that either. Help is greatly appreciated.

Thanks

View 6 Replies View Related

No Exception Message From CLR Stored Procedure

Aug 11, 2006

Hello everybody,



I've encountered a strange thing using a CLR Stored procedure:

The procedure throws an exception with no message inside... value = {" "}

Basically the procedure has a string as argument which contains a SQL statement that changes according to the users selections...

The results of the query are saved into a dataset for further processing.

Those resultsets can sometimes be very big (ex: 15000 records...). (For the record the procedure works fine for smaller datasets ex 6000 records and running the same query on the application server returns the expected resultset )

By Debugging the procedure I could determine that the failing point was when the dataset is filled...

Anyone having any idea??

The only information I have from this exception is the stacktrace:



at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.CloseInternal(Boolean closeReader)

at System.Data.SqlClient.SqlDataReader.Close()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteScalar()

at DataAccess.runScalar(String strSQL, Boolean isStoredProcedure) in c:InetpubwwwrootStatistixApp_CodeDataAccess.cs:line 114

Thanks in advance

Alaindlk

View 5 Replies View Related

Reporting Services :: Customize Column Grouping

Jul 6, 2015

I am working on one of the report. where I need to move the amount across column group.

My data is like this

Project Amount CurrentFiscalMonth DelaybyMonth
A 10 Jul 0
B 20 Aug 2
C 10 Sep 0

Report will be sum up the amount at CurrentFicalMonth grouping on column

But, if the Project is being delayed say by as per the example its 2 months than the amount should be moved from Sep to Oct column for the particular project. User has done it using the Offset function in excel.

Fiscal month starts at July and ends at June. and data source is SSAS cube.

View 4 Replies View Related

Call Stored Procedure From MSMQ Message

Nov 28, 2007

Does anyone have any ideas or sample code for firing a stored procedure using an MSMQ message?

I have to assume XML is in there somewhere.
(ie. create XML formatted message with proc call as element?)

Just getting started on project, any help appreciated.


www.beyonder422.com

View 4 Replies View Related

How Do I Capture The Error Message From A Stored Procedure?

May 30, 2007

Greetings,



I am creating a package that has many SQL tasks. Each task executes a stored procedure. I need to capture any error messages returned by the stored procedures. Eventually, the error messages will be logged so that we can audit the package and know if individual tasks succeeded or failed.



I'm not sure where or how I can access a stored procedure message. What is the best way?



Thanks,

BCB

View 7 Replies View Related

Error Message While Creating Stored Procedure

Jan 10, 2008



I'm creating a simple stored procedure:


create procedure spzipcode
(
@TableName nvarchar(10)
)
as
select distinct customer_code
from @TableName
GO

When running the code above, I get the following error message:


Server: Msg 137, Level 15, State 2, Procedure spzipcode, Line 8
Must declare the variable '@TableName'.

I can't figure out what I'm doing wrong.

Does anyone have an answer:

View 6 Replies View Related

How To Customize View Of SQL Server Enterprise Manager On Startup?

Jul 23, 2005

Hi,I've managed to get a couple of shortcuts on my desktop that log meright into SQL Query Analyzer for whichever particular database I want(using the isql.exe command line options). Now, I want to do a similarcustomization for the SQL Server Enterprise Manager. I want to be ableto open SQL Server Enterprise Manager and have it pop me all the waydown into my particular database/tables view -> e.g. "Microsoft SQLServersSQL Server Group(LOCAL) (WindowsNT)DatabasesmyDatabaseName". I'm hitting a local db server...I've tried saving new consoles (.msc files), but that just doesn't seemto do anything. I've tried using bookmarks, also, and they just don'tdo anything at all when I select them.Any ideas??

View 1 Replies View Related

Reporting Services :: How To Customize SSRS Bar Chart Report

Jul 23, 2015

I have a requirement associated with SSRS bar chart.

Data in my DB is like shown below:

A
B
C

Opt1

Data1
10
Data2
20

Opt2

Data1
30
Data2
40

Opt3
Data3
50

Now I would like to build up a bat chart which should have:

Legends: Opt1, Opt2, and Opt3

Categories: 
Data1(showing bars with scores as 10 and 30),
Data2 (showing bars with score 20 and 40), 
Data3 (showing bar with scores 50 only)

View 3 Replies View Related

Customize Template.ini To Upgrade From Msde To Express Edition?

Jan 29, 2007

I need to create the script to upgrade the current named instance of sql 2000 desktop engine to sql server 2005 express edition. I am having difficulty preparing the template.ini and would appreciate help.

[Options]
INSTANCENAME=MY_INSTANCE
SQLBROWSERACCOUNT=NT AUTHORITYNETWORK SERVICE
SECURITYMODE=SQL
SAPWD=music
UPGRADE=SQL_Engine
SQLBROWSERAUTOSTART=1
RSCANINSTALLDEFAULT=0
RSCONFIGURATION=FilesOnly
RSSQLLOCAL=0

I get an error that this file is invalid..Any clues? I am trying to upgrade existing instance of msde 2k to sql express 2005 and uses sql authentication

View 2 Replies View Related

Problem : Can't Customize Style Sheets For HTML Viewer

Mar 15, 2007

Hi ,

Yesterday I Customize Style Sheets for the report manager. Today I tried to customize Style Sheets for HTML Viewer but it doesn't works. I have done all that steps :

- I include the <HTMLViewerStyleSheet> setting into the <Configuration> selection of the rsreportserver.config file and then specify the style sheet I want to use : <HTMLViewerStyleSheet>HtmlViewer2</HTMLViewerStyleSheet>

- My rsreportserver.config file is into the C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServer folder.

- The style sheet HtmlViewer2.css is located in the C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerStyles folder.

I'm using SQL Server 2005.

Can someone Help me ? I have been trying change the style of the toolbar all the day and i start to be desperate !

Thank you.



View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved