Hide parameter for some users

I'm trying to decide whether I can use sql reports for my application, and
the main problem I've run into thus far is that my available parameters need
to change based on the user who is running the report. For instance,
low-level users should only be able to see data about themselves, whereas
managers should be able to select from a drop-down list of all users. Is
there any way to set the user prompt/visibility for a parameter based on the
role of the person running the report?The easiest way I can think of to manage this is to have two versions of the
same report. With the regular version, pass =User!UserID into the query
parameter. In the manager's version, populate the same parameter from a
drop-down list. Then set different permissions when you deploy the reports.
If you need to do it in a single report, you might be able to write some
custom code to pass in flags to the query and work out the difference
between managers and employees in your data source query.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"jgephart" <jgephart@.discussions.microsoft.com> wrote in message
news:36979870-6D83-4C49-B1E6-88D8CBC51678@.microsoft.com...
> I'm trying to decide whether I can use sql reports for my application, and
> the main problem I've run into thus far is that my available parameters
> need
> to change based on the user who is running the report. For instance,
> low-level users should only be able to see data about themselves, whereas
> managers should be able to select from a drop-down list of all users. Is
> there any way to set the user prompt/visibility for a parameter based on
> the
> role of the person running the report?|||Thanks, Jeff. This will affect a whole series of reports, so I don't really
want to maintain separate versions. I think I'm going to be able to go with
passing in User!UserID to the query that builds the drop-down list of users.
I can't hide the drop-down list, but at least I can make sure it's only
populated with a single user if that user doesn't have permission to see
other people's data.
"Jeff A. Stucker" wrote:
> The easiest way I can think of to manage this is to have two versions of the
> same report. With the regular version, pass =User!UserID into the query
> parameter. In the manager's version, populate the same parameter from a
> drop-down list. Then set different permissions when you deploy the reports.
> If you need to do it in a single report, you might be able to write some
> custom code to pass in flags to the query and work out the difference
> between managers and employees in your data source query.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---|||To protect it on the back side (from someone simply altering the URL to look
at someone else's data) you could always create a permissions table that
contains all of the usernames that each user is allowed to look at, and have
that table always be in the source query join, with User!UserID passed into
the query. We're doing a variation on this (a join to a parameterized UDF)
for our data security solution.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"jgephart" <jgephart@.discussions.microsoft.com> wrote in message
news:F5C7BDD7-4F0D-488C-80CB-7F81201B08A4@.microsoft.com...
> Thanks, Jeff. This will affect a whole series of reports, so I don't
> really
> want to maintain separate versions. I think I'm going to be able to go
> with
> passing in User!UserID to the query that builds the drop-down list of
> users.
> I can't hide the drop-down list, but at least I can make sure it's only
> populated with a single user if that user doesn't have permission to see
> other people's data.
>
> "Jeff A. Stucker" wrote:
>> The easiest way I can think of to manage this is to have two versions of
>> the
>> same report. With the regular version, pass =User!UserID into the query
>> parameter. In the manager's version, populate the same parameter from a
>> drop-down list. Then set different permissions when you deploy the
>> reports.
>> If you need to do it in a single report, you might be able to write some
>> custom code to pass in flags to the query and work out the difference
>> between managers and employees in your data source query.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---|||You could use linked reports instead, possibly in conjunction with the
My Reports feature. Linked reports are effectively shortcuts to a
report.
But, the nice touch is that you can set the parameters to behave a bit
differently, for instance there is a prompt user check box on each
parameter in the linked reports properties. This doesn't affect the
original report. If you update the original, the linked report will
reflect these changes too. Security can be set completely independantly
too.
Chris
Jeff A. Stucker wrote:
> To protect it on the back side (from someone simply altering the URL
> to look at someone else's data) you could always create a permissions
> table that contains all of the usernames that each user is allowed to
> look at, and have that table always be in the source query join, with
> User!UserID passed into the query. We're doing a variation on this
> (a join to a parameterized UDF) for our data security solution.sql

Hide my parameter

Hi,
When i run my report i don't want to see the parameters that i have given it.
How can i hide the parameters?
Greetings,
Mike KlaarhamerIf you are passing the parameters via URL then go to Report Manger and select
the parameters options under properties for that particular report. now, for
the parameter that you wish to hide, check the Prompt User to yes, and empty
the Prompt string.
Cheers
Priya
"Mike Klaarhamer" wrote:
> Hi,
> When i run my report i don't want to see the parameters that i have given it.
> How can i hide the parameters?
> Greetings,
> Mike Klaarhamer

hide field from user

I have an app that connects to sqlepress. When run the field are loaded from the db. There are some fields that I don't want some of the users to see. Is there a way to do this without hardcoding the 'username' in the applicaton ?

I looked at the explicit permissions for username for the particular table, but I don't understand some of the terms listed.

Alter

Control

References

View definition

Normally you do this by creating a View that exposes just the columns that you want to show to the users. I don't know of any way to control column level access by user, particularly if you don't tell SQL who the users is. I would say that you create specific groups to control access level, then build Views with the right set of columns for each group. Then you can call the appropriate View based on the group membership.

Mike

sql

hide duplicates.. another pdf bug?

I'm getting different views where I run the report from the Report Manager
and then after its exported to pdf. The results are the same when the report
is viewed from the Preview Mode in the Report Deisigner.
The Report has 3 groupings on data and I'm hiding some column values using
"Hide Duplicates". As menioned above, the "hide duplicates" functionality
works well in the Report Designer & Report Manager before exporting to pdf.
Is this a bug in the export functionality? How do I take care of this
discrepancy?
ThanksWhat is more exactlly the discrepancy? Are the textboxes still visible in
pdf? Could you send us the report and data to repro, please?
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"newmem" <""> wrote in message news:u9OR7jTXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> I'm getting different views where I run the report from the Report Manager
> and then after its exported to pdf. The results are the same when the
report
> is viewed from the Preview Mode in the Report Deisigner.
> The Report has 3 groupings on data and I'm hiding some column values using
> "Hide Duplicates". As menioned above, the "hide duplicates" functionality
> works well in the Report Designer & Report Manager before exporting to
pdf.
> Is this a bug in the export functionality? How do I take care of this
> discrepancy?
> Thanks
>

Hide a sub report from view

Is there any way to make a subreport hidden on the report server. For
instance report "A" contains subreport "B". I want the user to be able to
run report "A" that runs report "B", but I only want them to be able to see
report "A" in the report server folder.
Thanks,
--
JasonOn Mar 19, 7:38 am, JasonDWilson
<JasonDWil...@.discussions.microsoft.com> wrote:
> Is there any way to make a subreport hidden on the report server. For
> instance report "A" contains subreport "B". I want the user to be able to
> run report "A" that runs report "B", but I only want them to be able to see
> report "A" in the report server folder.
> Thanks,
> --
> Jason
You can try not letting the users have access to subreport B (via the
Report Manager permissions) and see if they can still access subreport
B via report A. If this does not work, then you will need to create
something custom that passes the User ID and another item/parameter to
the subreport to let it know that it is being called from report A:
The expression =User!UserID.ToString will get the current user and
then you would need to pass maybe a hidden parameter to subreport B
from report A (one that is not intuitive). That way, when subreport B
is called on it's own, the user will not know the parameter value it
needs. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Hidden User?

Did a remote backup of a database used to run a live website.
Restored the database to my local MSDE installation.
Now cannot access the local database using the user login FRED, which is the
same as the website, as I use it for local testing. Get error message:
cannot open user default database login failed.
Cannot see FRED the user anywhere, yet if I look under Roles, FRED is listed
as a db_owner.
If try and add FRED, get error saying User or Role already exists on this
database.
How can I reactivate FRED on my local server?
hi Kevin,
"Kevin" <kevgrim@.tesco.net> ha scritto nel messaggio
news:%23BNg60wdEHA.2520@.TK2MSFTNGP12.phx.gbl...
> Did a remote backup of a database used to run a live website.
> Restored the database to my local MSDE installation.
> Now cannot access the local database using the user login FRED, which is
the
> same as the website, as I use it for local testing. Get error message:
> cannot open user default database login failed.
> Cannot see FRED the user anywhere, yet if I look under Roles, FRED is
listed
> as a db_owner.
> If try and add FRED, get error saying User or Role already exists on this
> database.
> How can I reactivate FRED on my local server?
>
this problem is known as "orphaned users"... you can have a look at a
perfect article by Neil Boyl abot the matter at
http://www.sqlservercentral.com/colu...okenlogins.asp
the system stored procedure sp_chang_users_logins use is explained for
solving your trouble
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Hidden parameter

I am trying to set one of report parameters to hidden. When I run the report
I am getting an error that the hdden parameter is missing a value. Can
someone help?Are you assigning the parameter a default value?
Rodney Landrum
"Markgoldin" <Markgoldin@.discussions.microsoft.com> wrote in message
news:51EC9662-B240-4F57-9C7F-3C376BF7E237@.microsoft.com...
>I am trying to set one of report parameters to hidden. When I run the
>report
> I am getting an error that the hdden parameter is missing a value. Can
> someone help?sql

hi,Re: Unable to get SQLCMD utility to work properly.

I try to go to a command prompt to get this to run right with no luck. Is there something that I am not doing right? It gives me the help library, but thats about it. Also, I have dealt with Oracle in the past. And was wondering is there a way to access the SQLCMD utility on a workstation with a login of some kind?

--David

hi David,

SqlCMD accepts a list of parameters as described in http://msdn2.microsoft.com/en-us/library/ms165702.aspx and at http://msdn2.microsoft.com/en-us/library/ms170207.aspx you can find a tutorial about it's use...

usually you open a command prompt window and provide the appropriate connection parameters, like

c:\Document and settings\user>sqlcmd -E -S.\SQLExpress

this tries a trusted connection to the local SQLExpress named instance...

if you got it succesfully you get a prompt like
1>

qhere you can just type your Transact-SQL statements..

regards

Hi

Hi,

I have setup a linked server to a DB2 database using "Microsoft OLE DB Provider for ODBC Drivers",

the connections works fine i am able to run select queries.

but the number of rows returned from the two following statements are different.

select * from linkedserver...tablename

select count(*) from linkedserver...tablename

e.g. The First statement returns 116 rows, whereas the second query returns count as 144....

I am a bit confused ?

could anybody think of any possible reasons..

Cheers

ARAW012

Hi,

which SQL Server version are you using ? There was an issue with SQL Server 2000. Are you able to trace the queries that are actually executed at the DB2 database ? Did you already try to use the OPENQUERY method to pass the query (without any refactoring through the driver stack) through to the DB2 instance ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

i am using SQL server 2005 , and i am using the OPENQUERY method.

I only have read access to the DB2 database.

Thanks

|||The openquery and the "normal" Select behave different, because the OPENQUERY will issue a pass-through to the server instead of doing the interpreted Select query through the driver. So the results can differ according to the changes the driver will do in the middle. Perhaps someone with additional DB2 knowledge can help you here.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

hi

how to run a vb script file in vb.netPlease, move your question to VB forum.

Hi

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitiveExample: If have a Customers table and a record has last_name = "Bob", then:
Select * from customers where last_name = 'bob'
will return that record if it's case-insensitive, otherwise not.|||

Quote:

Originally Posted by sravani1227

This is sravani . I have a doubt .. What is MSSQL server case sensitive and MSSQL server case insensitive . I have to run installation shied on above two combinations of MSSQL server. Is it requires 2 times to instal the MSSQL server software seperately for case sensitive and case insensitive

Hi,
You don't need to install MSSQL server two times intead you have to change
default collation of your databse .
you will use COLLATE SQL_Latin1_General_CP1_CS_AS to make your search case sensitive.

Hey all / Running SQL 2000 and I need to re-index a db with a scri

I have the scripts but not sure how to run them... They are external scripts.
Trying to learn more about SQL Srvr.
You either open up Query Analyzer and paste the code in a window or use
oSQL. Both are documented in BooksOnLine but QA is probably easier for you.
Andrew J. Kelly SQL MVP
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:1BBC3024-B78C-436A-8A8B-424C6577AF0C@.microsoft.com...
>I have the scripts but not sure how to run them... They are external
>scripts.
> Trying to learn more about SQL Srvr.

Hey all / Running SQL 2000 and I need to re-index a db with a scri

I have the scripts but not sure how to run them... They are external scripts.
Trying to learn more about SQL Srvr.You either open up Query Analyzer and paste the code in a window or use
oSQL. Both are documented in BooksOnLine but QA is probably easier for you.
--
Andrew J. Kelly SQL MVP
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:1BBC3024-B78C-436A-8A8B-424C6577AF0C@.microsoft.com...
>I have the scripts but not sure how to run them... They are external
>scripts.
> Trying to learn more about SQL Srvr.|||Thanks Andrew
"Andrew J. Kelly" wrote:
> You either open up Query Analyzer and paste the code in a window or use
> oSQL. Both are documented in BooksOnLine but QA is probably easier for you.
> --
> Andrew J. Kelly SQL MVP
>
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:1BBC3024-B78C-436A-8A8B-424C6577AF0C@.microsoft.com...
> >I have the scripts but not sure how to run them... They are external
> >scripts.
> >
> > Trying to learn more about SQL Srvr.
>
>

Hey all / Running SQL 2000 and I need to re-index a db with a scri

I have the scripts but not sure how to run them... They are external scripts
.
Trying to learn more about SQL Srvr.You either open up Query Analyzer and paste the code in a window or use
oSQL. Both are documented in BooksOnLine but QA is probably easier for you.
Andrew J. Kelly SQL MVP
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:1BBC3024-B78C-436A-8A8B-424C6577AF0C@.microsoft.com...
>I have the scripts but not sure how to run them... They are external
>scripts.
> Trying to learn more about SQL Srvr.

HELP? Multiple processes

I have a foreach loop which contains a call to an Execute process task. I want the Execute process task to run once for each element in my foreach, but I need to run as many Execute process tasks as my server can handle. What is the best way to do this? Any help would be greatly appreciated.

What do you mean by "I need to run as many Execute process tasks as my server can handle?" Can you be more precise in what this means, and perhaps provide a little more context on what exactly you're trying to accomplish?|||

Unfortunately, the ForEach container does not currently support parallel execution of the loops. And since the Execute Process task waits for a return value from the executable it calls, you are stuck in a sequential mode.

You can work around this by using multiple ForEach loops, and dividing your workload between them. However, this may take a bit more manual tuning. Or you migh be able to launch the process asynchronously from a script task.

|||

This is a vendor api that generates the data I need for my warehouse. I have a exe that takes one parameter and populates the appropriate stage0 tables. Sometimes this api runs really fast and returns little, other times it take 20 minutes. I'd like to run as many occurences of this api as possible so as not to slow my loads.

|||This may not be an appropriate task for SSIS then. Can you call the EXE from a C# app that has a thread pool and then when all instances of the EXE have finished running, yuo can launch whatever SSIS packes need to run next?|||

I've condsidered running it this way by passing an array of parms and then threading. I appreciate the response. I was just hoping there was a simplier and easier to maintain solution.

Help:MS SQL 2000 SP4 dont run !

I have installed MS SQL 2000 Personal Edition on XP SP2 and It works !
I verified its version :
SQL Server 2000 Original Release 8.00.194 RTM

When I try to install SP4 after extracting locally I see the first windows for a moment and then nothing appens !

x86\setup\setupsql.exe process remain in task manager without make nothing.

Someone can help me ?Check windows event log & SQL error lgo for any information.
Also try to download the file again, make sure you're using correct SP4 file from MS.|||Thank you !

I have found only this warning in eventlog

SuperSocket info: (SpnRegister) : Error 1355.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

But I think it's because I have no SP4 installed .
When I try to install SP4 I have no message in any logs.
Process do nothing because, I suppose , It's waiting for a Dialog Window that I don't see :-(|||There was a problem on the Clustered environment previously as per KBA http://support.microsoft.com/?id=303411 , but yours it not that case. Anyway try downloading SP3a for SQL 2000 and apply, then use SP4.

BTW mention the filename of SP4 you're using to apply.|||I have the same problem with SP3.
File name is SQL2000-KB884525-SP4-x86-ENU.EXE
May be MSI ? I have 3.1
Or IIS ? I have 5.1
How can I remove IIS ?

Help:DTC-Firewall-SQL server clustering

Hello All
I am having trouble of DTC to get working thru firewall
The setup we have is
Two web servers load balanced. Componets run off the web servers. (OS:2000 Server
Two SQL server clusered.(OS: 2000 advanced server)
Web servers and SQL Servers are in different domain separated by firewall
Components do not work if I set "transaction required". If I changed it to "Transaction suported" or "not supported" some componets do work
I tried suggestions from kb article
DTCPing: http://support.microsoft.com/?id=30684
Initially DTCping had some problem but for testing purpose we opened all ports on firewall. It worked
I tried another config suggestion
http://support.microsoft.com/?id=25036
When I apply the registry entries for ports mentioned in this article, it disabled Clustering service. I was not able to get it back until I revert back registry settings
I tried DTCtester utility, it doesn't work
Does any one know why it must be disabling the clustering service? or Have any other suggestions on configuration for DTC thru Firewall
Thank
MilsThanks Jeff
I tried the procedure you mentioned. but it did not help
I have already tried the DTCping utility. At first it did not work but then I opened all the ports on firewall. now DTCping works.
DTCtester.exe utility still does not run, it gives error
Output of utility
****************
E:\netins>dtctester vssql01 uname Pw
Executed: dtcteste
DSN: vssql0
User Name: unam
Password: pw
tablename= #dtc1236
Creating Temp Table for Testing: #dtc1236
Warning: No Columns in Result Set From Executing: 'create table #dtc12365 (iva
int)
Initializing DT
Beginning DTC Transactio
Enlisting Connection in Transactio
Error
SQLSTATE=25S12,Native error=-2147168242,msg='[Microsoft][ODBC SQL Server Driver
Distributed transaction error
Error
SQLSTATE=24000,Native error=0,msg=[Microsoft][ODBC SQL Server Driver]Invalid cu
sor stat
Typical Errors in DTC Output Whe
a. Firewall Has Ports Close
-OR
b. Bad WINS/DNS entrie
-OR
c. Misconfigured networ
-OR
d. Misconfigured SQL Server machine that has multiple netcards
Aborting DTC Transactio
Releasing DTC Interface Pointer
Successfully Released pTransaction Pointer.
*********************************
One of the error description refers to multiple netcards. Our SQL server has multiple netcards.
Any idea if there's any specific configuration for SQL Server using multiple netcards
Thanks
Milin|||1. Are the ports still open. If not then you need to open ports 445, 135,137-9, plus the ones you set in DCOMCNFG
2. Do you have an entry in each server of the cluster's host file with an entry to the destination server. and likewise on the destination for each of the Clustered servers
3. Does DTCPing work both ways now also
Jef
MCDBA, MCSE+I|||Yes. All ports are still open in both directions
I have entries in hosts files of both servers. I can access these servers using network names from each other
DTCping work in both directions
Thank
mil|||Did you actually set the ports with DCOMCNFG and reboot or did you just try the reg hack
If not then set DCOMCNFG on all servers to use the proper ports and reboot all servers
Other than that I cannot think of anything else
Good Luc
Jeff|||Mil
I am sorry then. In all my experience once I have had DTCping working I have had DTC working as well
Jeff|||"mils" wrote:
> When I apply the registry entries for ports mentioned in this article, it disabled Clustering service. I was not able to get it back until I revert back registry settings.
Hi,
I have the same problem.
when i set the port by dcomcfg (or by registry), the nodes cannot start clustering services.
WhY '
How can i do ?
thanks in advance !!
Regards, Dario

HELP: sp_help and object browser report view column sizes differently

Hi,

I've run into a curious problem with MS SQL Server 8.0. Using sp_help and
SQL Query Analyzer's object browser to view the columns returned by a view,
I find that sp_help is reporting stale information.

In a recent schema change, for example, someone lengthened a varchar column
from 15 to 50 characters. If we use sp_help to find out about a view that
depends upon this column, it still shows up as VARCHAR(15), whereas the
object browser correctly reports it as VARCHAR(50).

Dropping and recreating the view fixes the problem, but we have quite a few
views, and dropping and re-creating all of them any time a schema change is
made is something we want to avoid. I tried using DBCC CHECKDB in hopes that
it would 'refresh' SQL Server's information, but no luck.

(if you're curious as to why I don't just use the object browser instead,
read boring technical details below)

Has anyone seen this before? Is there some other way (other than
re-creating every view) to tell SQL Server to "refresh" it's information?

Thanks!

-Scott

-------
Boring Technical Information:

The reason this is an issue for us (i.e., I can't just use the object
browser instead) is that our object model classes are built using standard
metadata query methods in Java that seem to be returning the same stale
information that sp_help is returning. These methods are a part of the
standard JDK, so we can't easily fiddle with them. Anyway, as a result, our
object model (at least with respect to views) may not match our current
schema!A view need to expose its columns and each columns datatypes in the system
tables, just like a table. However, in SQL Server, this information is not
refreshed when you modify an underlying object (like ALTER TABLE). This is
why sp_help will show you the old information, it picks it up from
syscolumns. Repro below:
USE tempdb
GO
DROP VIEW v
GO
DROP TABLE t
GO
CREATE TABLE t(c1 varchar(10))
GO
CREATE VIEW v AS SELECT c1 FROM t
GO
EXEC sp_help v
GO
ALTER TABLE t ALTER COLUMN c1 VARCHAR(20)
GO
EXEC sp_help v -- Here, the info is still old
EXEC sp_refreshview v
EXEC sp_help v

Note that you can use sp_refreshview to refresh the view definition.

QA's object browser doesn't pick up the meta-data from syscolumns, that is
why it can show current information. Here's what QA seems to be doing to
pick up the meta-data info:

declare @.P1 int
set @.P1=1
exec sp_prepare @.P1 output, NULL, N'SELECT * FROM [tempdb].[dbo].[v]', 1
select @.P1
exec sp_unprepare 1
--
Tibor Karaszi

"ScottyBaby" <scottseansmith2NO@.SPAM.hotmail.com> wrote in message
news:OOWdnchUCvygmzWiRTvUrg@.texas.net...
> Hi,
> I've run into a curious problem with MS SQL Server 8.0. Using sp_help and
> SQL Query Analyzer's object browser to view the columns returned by a
view,
> I find that sp_help is reporting stale information.
> In a recent schema change, for example, someone lengthened a varchar
column
> from 15 to 50 characters. If we use sp_help to find out about a view that
> depends upon this column, it still shows up as VARCHAR(15), whereas the
> object browser correctly reports it as VARCHAR(50).
> Dropping and recreating the view fixes the problem, but we have quite a
few
> views, and dropping and re-creating all of them any time a schema change
is
> made is something we want to avoid. I tried using DBCC CHECKDB in hopes
that
> it would 'refresh' SQL Server's information, but no luck.
> (if you're curious as to why I don't just use the object browser instead,
> read boring technical details below)
> Has anyone seen this before? Is there some other way (other than
> re-creating every view) to tell SQL Server to "refresh" it's information?
> Thanks!
> -Scott
> -------
> Boring Technical Information:
> The reason this is an issue for us (i.e., I can't just use the object
> browser instead) is that our object model classes are built using standard
> metadata query methods in Java that seem to be returning the same stale
> information that sp_help is returning. These methods are a part of the
> standard JDK, so we can't easily fiddle with them. Anyway, as a result,
our
> object model (at least with respect to views) may not match our current
> schema!|||Found it:

sp_refreshview - Refreshes the metadata for the specified view. Persistent
metadata for a view can become outdated because of changes to the underlying
objects upon which the view depends.

"ScottyBaby" <scottseansmith2NO@.SPAM.hotmail.com> wrote in message
news:OOWdnchUCvygmzWiRTvUrg@.texas.net...
> Hi,
> I've run into a curious problem with MS SQL Server 8.0. Using sp_help and
> SQL Query Analyzer's object browser to view the columns returned by a
view,
> I find that sp_help is reporting stale information.
> In a recent schema change, for example, someone lengthened a varchar
column
> from 15 to 50 characters. If we use sp_help to find out about a view that
> depends upon this column, it still shows up as VARCHAR(15), whereas the
> object browser correctly reports it as VARCHAR(50).
> Dropping and recreating the view fixes the problem, but we have quite a
few
> views, and dropping and re-creating all of them any time a schema change
is
> made is something we want to avoid. I tried using DBCC CHECKDB in hopes
that
> it would 'refresh' SQL Server's information, but no luck.
> (if you're curious as to why I don't just use the object browser instead,
> read boring technical details below)
> Has anyone seen this before? Is there some other way (other than
> re-creating every view) to tell SQL Server to "refresh" it's information?
> Thanks!
> -Scott
> -------
> Boring Technical Information:
> The reason this is an issue for us (i.e., I can't just use the object
> browser instead) is that our object model classes are built using standard
> metadata query methods in Java that seem to be returning the same stale
> information that sp_help is returning. These methods are a part of the
> standard JDK, so we can't easily fiddle with them. Anyway, as a result,
our
> object model (at least with respect to views) may not match our current
> schema!|||run to refresh the view when the metadata is outdated...

exec sp_refreshview 'viewname'

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net

"ScottyBaby" <scottseansmith2NO@.SPAM.hotmail.com> wrote in message
news:OOWdnchUCvygmzWiRTvUrg@.texas.net...
> Hi,
> I've run into a curious problem with MS SQL Server 8.0. Using sp_help and
> SQL Query Analyzer's object browser to view the columns returned by a
view,
> I find that sp_help is reporting stale information.
> In a recent schema change, for example, someone lengthened a varchar
column
> from 15 to 50 characters. If we use sp_help to find out about a view that
> depends upon this column, it still shows up as VARCHAR(15), whereas the
> object browser correctly reports it as VARCHAR(50).
> Dropping and recreating the view fixes the problem, but we have quite a
few
> views, and dropping and re-creating all of them any time a schema change
is
> made is something we want to avoid. I tried using DBCC CHECKDB in hopes
that
> it would 'refresh' SQL Server's information, but no luck.
> (if you're curious as to why I don't just use the object browser instead,
> read boring technical details below)
> Has anyone seen this before? Is there some other way (other than
> re-creating every view) to tell SQL Server to "refresh" it's information?
> Thanks!
> -Scott
> -------
> Boring Technical Information:
> The reason this is an issue for us (i.e., I can't just use the object
> browser instead) is that our object model classes are built using standard
> metadata query methods in Java that seem to be returning the same stale
> information that sp_help is returning. These methods are a part of the
> standard JDK, so we can't easily fiddle with them. Anyway, as a result,
our
> object model (at least with respect to views) may not match our current
> schema!|||"ScottyBaby" <scottseansmith2NO@.SPAM.hotmail.com> wrote in message news:<OOWdnchUCvygmzWiRTvUrg@.texas.net>...
> Hi,
> I've run into a curious problem with MS SQL Server 8.0. Using sp_help and
> SQL Query Analyzer's object browser to view the columns returned by a view,
> I find that sp_help is reporting stale information.
> In a recent schema change, for example, someone lengthened a varchar column
> from 15 to 50 characters. If we use sp_help to find out about a view that
> depends upon this column, it still shows up as VARCHAR(15), whereas the
> object browser correctly reports it as VARCHAR(50).
> Dropping and recreating the view fixes the problem, but we have quite a few
> views, and dropping and re-creating all of them any time a schema change is
> made is something we want to avoid. I tried using DBCC CHECKDB in hopes that
> it would 'refresh' SQL Server's information, but no luck.
> (if you're curious as to why I don't just use the object browser instead,
> read boring technical details below)
> Has anyone seen this before? Is there some other way (other than
> re-creating every view) to tell SQL Server to "refresh" it's information?
> Thanks!
> -Scott
> -------
> Boring Technical Information:
> The reason this is an issue for us (i.e., I can't just use the object
> browser instead) is that our object model classes are built using standard
> metadata query methods in Java that seem to be returning the same stale
> information that sp_help is returning. These methods are a part of the
> standard JDK, so we can't easily fiddle with them. Anyway, as a result, our
> object model (at least with respect to views) may not match our current
> schema!

See sp_refreshview in Books Online, which is intended for exactly this situation.

Simon|||Hi

Try looking at sp_refreshview. Previous posts have described ways to
do this for all tables if you need to write a procedure.

John

"ScottyBaby" <scottseansmith2NO@.SPAM.hotmail.com> wrote in message news:<OOWdnchUCvygmzWiRTvUrg@.texas.net>...
> Hi,
> I've run into a curious problem with MS SQL Server 8.0. Using sp_help and
> SQL Query Analyzer's object browser to view the columns returned by a view,
> I find that sp_help is reporting stale information.
> In a recent schema change, for example, someone lengthened a varchar column
> from 15 to 50 characters. If we use sp_help to find out about a view that
> depends upon this column, it still shows up as VARCHAR(15), whereas the
> object browser correctly reports it as VARCHAR(50).
> Dropping and recreating the view fixes the problem, but we have quite a few
> views, and dropping and re-creating all of them any time a schema change is
> made is something we want to avoid. I tried using DBCC CHECKDB in hopes that
> it would 'refresh' SQL Server's information, but no luck.
> (if you're curious as to why I don't just use the object browser instead,
> read boring technical details below)
> Has anyone seen this before? Is there some other way (other than
> re-creating every view) to tell SQL Server to "refresh" it's information?
> Thanks!
> -Scott
> -------
> Boring Technical Information:
> The reason this is an issue for us (i.e., I can't just use the object
> browser instead) is that our object model classes are built using standard
> metadata query methods in Java that seem to be returning the same stale
> information that sp_help is returning. These methods are a part of the
> standard JDK, so we can't easily fiddle with them. Anyway, as a result, our
> object model (at least with respect to views) may not match our current
> schema!

Help: Job Failed (Error)

Dear All,
I have a DTS Package. When I run the package manually, it works, but
when it is executed by scheduled job, it always fail.
The error message is :
"Executed as user: <DOMAIN>\<Username>. The step did not generate any
output. Process Exit Code -1073741819. The step failed."
Pls help me to solve it out.
Thanks
Robert LieSee if this helps you understand what's happening:
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:easHEE4kFHA.2472@.TK2MSFTNGP15.phx.gbl...
Dear All,
I have a DTS Package. When I run the package manually, it works, but
when it is executed by scheduled job, it always fail.
The error message is :
"Executed as user: <DOMAIN>\<Username>. The step did not generate any
output. Process Exit Code -1073741819. The step failed."
Pls help me to solve it out.
Thanks
Robert Lie

HELP: Crystal Report 8 with Acces 2003

Am I missing something?

I am trying to run a crystal 8 report, wich is feeded from a access 2003 database, this is done trough a vb 5 - program. It works all right on my computer (win 98) where Crystal Report 8 is installed.

But it doesn't work on my Win XP - computer (Here i don't want to install Crystal Report 8, because it has to run on other machines too), i am trying to install the needed files to make this work. So far I installed the following files:

[Files]
File1=1,,CRVIEWER.DL_,CRVIEWER.DLL,$(WinSysPath),$(DLLSelfRegister),$(Shared),1/28/2000 16:19:24,509328,8.0.0.371,"","",""
File2=1,,CRAXDRT.DL_,CRAXDRT.DLL,$(WinSysPath),$(DLLSelfRegister),$(Shared),1/28/2000 15:16:48,5550080,8.0.0.371,"","",""
File3=1,,IMPLODE.DL_,IMPLODE.DLL,$(WinSysPath),,$(Shared),11/18/1996 1:00:00,18944,1.0.0.1,"","",""
File4=1,,CRPAIG80.DL_,CRPAIG80.DLL,$(WinSysPath),,$(Shared),1/11/2000 7:09:56,618496,8.0.0.11,"","",""
File5=1,,sscsdk80.dl_,sscsdk80.dll,$(WinSysPath),,$(Shared),12/10/1999 15:24:30,974848,2.2.0.2,"","",""
File6=1,,P2SMON.DL_,P2SMON.DLL,$(WinSysPath),,$(Shared),12/15/1999 7:17:52,147456,8.0.0.15,"","",""

The strange thing is that it works allright when i use a report based , on a MS access 97 database. But when I use a report, based on a MS Access 2003 database, i get an error: "Unrecognized database format" , also i'm prompted for a password.

Does anybody know this problem?you need to redesign the report with Access 2003|||Dear Madhi

thanks for your reply, but i don't know what you exactly mean.

the report is designed with Crystal Report 8, in it there is a database connection with an MS Access 2003 mdb. As I said , this works on my win89 machine (with full crystal report on it), but not on my WinXp machine (with only the runtime files from crystal report on it.

You say that I have to redesign my report, but i'm sorry to say that I can't quit follow you there, could you be more specific?

thanks, paul|||Did you use Setup to install the application there?
If so, you need to add all the required dlls|||I think that i did that at first, but to be absolutely shure, i wil do that again.|||Mahdi

That was the problem, i didn't install all the required dll's. Now i have to sort out, wich dll was missing precisely . I wil post it here, as soon as i find out,

thanks