&&<Select All&&> Disappear On Server
Nov 28, 2007
Hello.
I have a parameter with multi value option.
When I run the report in Visual studio, The first value in the drop down of this parameter is (Select All).
When I check this option it check all the other values for this parameter and when I unCheck this value it uncheck all the ther values for this parameter.
The problem is thet when I'm publishing the report to the server and then open it in IE the (Select All) value does't appear and I only get all the other values.
Any body know how to fix this?
Thanks.
View 5 Replies
ADVERTISEMENT
Jul 20, 2005
Hello,What could possibly cause data in the SQL server database to beremoved, except being deleted manually? We had a couple of situationswhere data in certain records disappeared although the records werestill there. The data is entered and editted through the web interfacein ASP. The web interface is accessed by anyone who has an account inour database.I am more of a web programmer, not a SQL server administrator, so notvery familiar with SQL Server log or error tracking. If you cansuggest any way to track this kind of events (data disappearing), Iwould appreciate it very much.HB Kim
View 10 Replies
View Related
Feb 12, 2007
Is it not possible to execute one package and then design another package? I am executing one package and trying to design another package and just have a grey window in the control tool box that says:
"there are no usable controls in this group. Drag an item onto this text to add it to the toolbar"
Can I only get my controls by dragging when another package is executing? Where do I drag them from?
Thanks,
Kayda
View 4 Replies
View Related
Dec 21, 2006
Hallo all :
How to disappear the generic bar in the report, or to disappear some options (example export). I speak about the bar which in the top of the report or there are the numbers of pages.
Thank's.
View 4 Replies
View Related
Feb 17, 2004
I created a new database role to give a number of users select privilege only on some tables and every day I have to go back in and add the tables back to the role. Is there something I'm missing here?
View 8 Replies
View Related
Oct 7, 2015
I have questions regarding SQL 2008 r2 and Excel 2013.The below code users run from excel and it display all the data first time and when user click refresh under Data in excel the JOBID under JOB column disappear but all other column does not.
SELECT Ind_DHK_ProdRpt_view.Job, Ind_DHK_ProdRpt_view.suffix, Ind_DHK_ProdRpt_view.item, Ind_DHK_ProdRpt_view.description,
Ind_DHK_ProdRpt_view.qty_released, Ind_DHK_ProdRpt_view.[Current WC], Ind_DHK_ProdRpt_view.EndDate, dt.trans_Date AS IntoQue,
Ind_DHK_ProdRpt_view.co_num, Ind_DHK_ProdRpt_view.Bill_Name, Ind_DHK_ProdRpt_view.UsedHrs, Ind_DHK_ProdRpt_view.start_date,
[code]....
View 0 Replies
View Related
Jul 20, 2005
I has a strange question.My company is using a old system with Win NT 4.0 Server + MS SQL 7.0.The system is busy and handle a lot of SELECTs and INSERTs all the time.Sometimes, some transactions are blocked by some other transactions.For those INSERT transactions, we usually call a stored procedure and passparameters in to do the INSERT, at the end of the INSERT stored procedure,we always check @@ERROR = 0 and retrieve the @@IDENTITY (it is usually theauto number primary key) to confirm the INSERT is success. But the strangethings is, sometimes, @@ERROR is equals to 0 and I can get a value from@@IDENTITY but when I fetch the record by the primary key (the value of@@IDENTITY) it returns nothing!! The record is disappear and the primarykey is skipped! I found that this happens usually when the INSERT executeat the time when some other transactions are blocking. Anyone knows why therecord is disappear while @ERROR = 0 and the stored procedure can returnvalue from @@IDENTITY?? Anyone has such case happen in their server aswell? Please tell me some solutions on how to solve this, thank you x10000000 times.
View 10 Replies
View Related
Jan 8, 2007
Hi:
Did you have any experience that all publications and their related jobs suddenly disappear?
I had a transactional pull replication between two servers, and distributor and subscriber in the same box; publisher was an AA cluster server.
The schedule of pulling was once a week.
Last Friday morning everything was working perfectly, but I found all publications and their related jobs disappear around 5pm
I checked with the sysadmin and he said nothing was changed on that period.
Did you have any idea about it?
Did you have any idea that I can prevent this happen again or any alert I can set up to monitor who drop it, when it was dropped and so on?
It is a SQL 2000 box and system table doest not take trigger.
Thanks in advance
Theresa
View 2 Replies
View Related
Dec 27, 2007
I just got a new computer (it is running XP) and after installing Visual Studio 2005 and then SQL Server 2005, If I open up an existing SSIS package the lines around the components are missing. If I click on the component and then click off the line reappears. Has anyone experienced a similare issue?
View 1 Replies
View Related
Mar 11, 2008
Hi,
I am presenting some data fields value in the Page footer by using the referencing trick to textbox, exist in the body of the report.
Now the problem is while running localy i am getting all the field values as I want, but while exporting into PDF or printing the report I cant see those values in the footer.
while running the same report from report manager the arrangments of the textboxes in the footer got displaced.
Any help will be highly appreciated
Thanks
View 4 Replies
View Related
Dec 19, 2006
Creating a SQL Agent job to run a package works just fine. On the Step Properties, Set values tab, I can add variables and the values I want for them, no problem. The job runs just fine. If I want to go edit the values however, they're always gone.
Is there some security setting that hides the variables and their values which is on by default?
View 1 Replies
View Related
Jun 17, 2015
I have a few SQL instances on my server (jdjfdijdk)
They where called and organized like this:
MyServer - Database1
MyServer/BBserver - Database2
For some reason instance MyServer/BBserver has stopped and I couldn't make it start so I decided to reboot the server. After reboot the MyServer/BBserver was working but when open the other instance MyServer using Management Studio the Database1 disappear and the Database2 can be accessed by MyServer/BBserver and MyServer instances.
Even a backup made of Database1 and stored at
C:Program Files (x86)Microsoft SQL ServerMSSQL.2MSSQLBackup vanished.
How to recover Database1?
View 19 Replies
View Related
Nov 27, 2007
Hi,
On a report I have a textbox. When a user prints the report I don't want the textbox printing. Does anyone know any code which will set the visibility of the textbox to False when printing??
View 1 Replies
View Related
Oct 10, 2007
I install add-in and run fine for a while, then all of sudden I could not see Table Analyze tool and data mining tab at my ribbon. I re-run server configuration and re-connect to DMAddinDB (remote server, but I am the administrator), but data mining add-in and table analyzer still not showing at my ribbon.
Then I uninstall DMAddin, re-install it, go through configuration again, but still the tabs are not showing up.
Any idea you can help me get my add in back?
View 12 Replies
View Related
Jun 14, 2006
Guys,
anyone seen this before?
I've just finished me lovely big package.. decided to tidy it up and make it look nice...
(when will I ever learn?)
So I selected a few tasks, right clicked and selected "group". Named the group.....
And now all the connectors between the tasks in the group have disappeared.... tried ungrouping.. still not there...
The package still runs fine... the tasks are executed in the right sequence and all that... but the connectors are jut not visible...
If I try to recreate the connector I get an error dialog saying "Cannot create connector. Only one workflow can exist between the same two executeables.". So they must still exist...
It'd be ok to leave it as it is I suppose.. if I didn't now need to modify the precedence constraint on one of the connectors.... and I can't actually select the feckin connector..
Any suggestions? Any way to refresh the display? Have already exited the environment and come back in.. will try rebooting machine now anyway...
PJ
View 4 Replies
View Related
Mar 24, 2008
Follow-up to:
http://forums.asp.net/t/1237676.aspx
The update command seems to be deleting my data. If I set the Parameter "DefaultValue" to "NULL" then it updates that field to the literal string: NULL
WTH
Nick
<UpdateParameters>
<asp:Parameter Name="DevelopmentArea" Type="String"/>
<asp:Parameter Name="DevelopmentGoals" Type="String" />
<asp:Parameter Name="DevelopmentPlans" Type="String" />
<asp:Parameter Name="CurrentStatus" Type="String" />
<asp:Parameter Name="FutureState" Type="String" />
<asp:Parameter Name="DetermineFactor" Type="String"/>
<asp:Parameter Name="MentorRequested" Type="Boolean" DefaultValue="False"/>
<asp:Parameter Name="MentorList" Type="String"/>
<asp:Parameter Name="CheckPointDate" Type="DateTime" />
<asp:Parameter Name="DateUpdated" Type="DateTime" />
<asp:Parameter Name="PlanPKID" Type="Int32" />
</UpdateParameters>
View 6 Replies
View Related
Jun 5, 2007
Hi,
anyone has any idea how to make the parameters toolbar to be automatically hidden when the report is first being accessed and subsequently to show the parameters when clicked on the arrows ? I have some users who complained that the parameters list is too long, so they wish to hide it first when accessing the report. I know there's this called rc: Parameters=false but this will permanently hide the toolbar which i don't want.
By the way, i am using sql 2000 reporting services
View 1 Replies
View Related
Jun 3, 2006
Hi,
The column names I'm using often have underscores in them. I've noticed that, when writing script in the script component editor, the underscore characters mysteriously dissapear. Is this a known bug? (I can't find any reference to this by Googling)
Thanks in advance,
Lawrie.
View 4 Replies
View Related
Feb 1, 2007
I have scoured the internet looking for someone who has run into this issue with no such luck!
Product: Reporting Services 2005 Analysis Services 2005
Our users use Report Builder as an ad-hoc report tool. Data sources for Report Builder come from Report Servers and Analysis Servers.
I have run into issues where a user will select a source for their report that is based on an AS cube. When they select an attribute (field) from a selected entity in the Report Builder Explorer and drop it on the canvas, all entities except the one the field was selected from disappear.
For example:
A cube has a fact table called "Annual Income" with dimension of employee and demographics. In Report Builder, the entities would be listed in the left hand Report Builder Explorer window as
Annual Income
Employee
Demographics
If I select attributes from Employee or Annual Income, as usual, you will see the related hierarchies of the remaining entities. However, if I select an attribute from Demographics, then the Annual Income and Employee entities just disappear and all I can see is the Demographics entity and its attributes.
Has anyone run into this and if so, any ideas? This is becoming extremely frustrating. I have deleted and rebuild cubes, individual dimensions, and everything else I can think of.
Your responses are appreciated,
Scott
View 1 Replies
View Related
Aug 16, 2007
We have 10+ MSDE 2000 installations on the same network. Each install has a named instance and the
machines connect to eachother via VB application. We have a couple SQL 2000 Standard boxes and a SQL 2005
box all running on the same network with no issues. The problem we have recently run into is with a SQL
Express box. When the box is on the network OSQL stops finding the MSDE 2000 named instances on the
network and only the SQL Express named instance appears in the list. The second the SQL Express box is removed
from the network the named instances are visible. I monitored the UDP traffic and suspect there is an issue with the response from SQL Express to OSQL. Can't find any issues for this problem only report I found is if MSDE and Express are on the same machine.
SQL Express Response
.Q.ServerName;DDK7P4D1;InstanceName;SQLEXPRESS;IsClustered;No;Version;9.00.1399.06;;
MSDE Response
...ServerName;RED;InstanceName;SECOND;IsClustered;No;Version;8.00.194;tcp;4307;;Ser
verName;RED;InstanceName;THIRD;IsClustered;No;Version;8.00.194;tcp;0;;Server
Name;RED;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;4303;;
Any ideas?
Thanks, Kevin.
View 2 Replies
View Related
Aug 16, 2007
We have 10+ MSDE 2000 installations on the same network. Each install has a named instance and the
machines connect to eachother via VB application. We have a couple SQL 2000 Standard boxes and a SQL 2005
box all running on the same network with no issues. The problem we have recently run into is with a SQL
Express box. When the box is on the network OSQL stops finding the MSDE 2000 named instances on the
network and only the SQL Express named instance appears in the list. The second the SQL Express box is removed
from the network the named instances are visible. I monitored the UDP traffic and suspect there is an issue with the response from SQL Express to OSQL. Can't find any issues for this problem only report I found is if MSDE and Express are on the same machine.
SQL Express Response
.Q.ServerName;DDK7P4D1;InstanceName;SQLEXPRESS;IsClustered;No;Version;9.00.1399.06;;
MSDE Response
...ServerName;RED;InstanceName;SECOND;IsClustered;No;Version;8.00.194;tcp;4307;;Ser
verName;RED;InstanceName;THIRD;IsClustered;No;Version;8.00.194;tcp;0;;Server
Name;RED;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;4303;;
Any ideas?
Thanks, Kevin.
View 4 Replies
View Related
May 21, 2013
My company is new to MDS. I am trying to set an attritube in an entity to read only so the users can't change the value in that field. When I did that, the whole model disappeared. I thought I had deleted it by accident so I created a test model and tried to do the same. The test model disappeared. This time, before saving the new settings I took a snapshot. After saving I took another snapshot. You can see that the whole model is gone (zz_RN_Permissions_Test). I tried every other coworker with admin rights and nobody shows it on the Models list. The behavior on the Excel add-in is correct. I can't change any values on that column. But I need to keep the models available.
See before and after snapshots below.
View 8 Replies
View Related
Jul 31, 2014
I need to write a select statement that take the upper table and select the lower table.
View 3 Replies
View Related
Feb 23, 2015
I have the linked server connection created and works perfectly well. I mean I am able to see the tables while I am on my database.
how do I write a SQL statement to reference the linked server ?
I tried the following:
Select top 100 * from casmpogdbspr1.MPOG_Collations.dbo.AsaClass_Cleaned
Then I get the error message....
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "casmpogdbspr1" does not contain the table ""MPOG_Collations"."dbo"."AsaClass_Cleaned"". The table either does not exist or the current user does not have permissions on that table.
View 2 Replies
View Related
Sep 30, 2005
I am trying to install SQL Server Sep 2005 CTP - ENTERPRISE, there are
View 1 Replies
View Related
Jul 13, 2015
I need to investigate about what happened to our production server at the last weekend.i restored it to another server which is development. I restored it under a name "old_master_2015_07_10".
But if I run a query
SELECT *
FROM [old_master_2015_07_10].[sys].[servers]
it actually selects from master.sys.servers, not from my old_master... In order to prove it, I created a linked server in this, development server, and if I run SELECT * FROM [old_master_2015_07_10].[sys].[servers], it selects it. And in database selection drop-down box I also selected old_ master_ 2015_07_10. What I think it apparently recognizes familiar names like sys.servers and redirects the query to the master.
What I can do to select really from old_master_2015_07_10 database? I already thought about renaming sys.servers to something different, but did not do it not to break something in master in case if SQL Server will run it in master as well.
View 9 Replies
View Related
Mar 1, 2008
I created a linked server on server A to server B as follows...
USE master;
GO
EXEC sp_addlinkedserver
'B',
N'SQL Server'
GO
...in mgt studio (in a connection to A) from my local where as a person with sys admin rights on both A and B I'm having no problems connecting to either and running queries. When I run a query from a connection on A as select * from .[a db on B] .[an owner on B].[a table on B], I get an error that says Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.
I believe both A and B are in the same domain
the default behavior that I saw checked in the linked server's security properties was "connection will be made using the logins current security context".
when change the default and clicked and entered "this security context" as domainuserid and password, rerun the query, I get error Login failed for user 'domain nameuserid'.
is there a simple way to get this to work, at least for test purposes? I even tried playing with the login mappings but nothing seemed to work.
View 7 Replies
View Related
Oct 6, 2006
I need to back up a table from serverA to my machine
I guess I do: select * from databaseA.myTable into databaseB.mytabel
but how do I specify that databaA is in other server.
Thankse
View 2 Replies
View Related
May 18, 2007
I have a single form that the users can do lookups for items. We have two locations each with its own SQL Server and database. Trying to use an IF...THEN statement as they select the DB they want to query it then creates the connection string for that particular database. I haven't a clue on how to do this. If someone could point me to the documentation to do this I would really appreciate it. <%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDB" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Sub get_Dies(ByVal sender As System.Object, ByVal e As System.EventArgs)
Dim dbConnection As New SqlConnection
If ddlDatabase.SelectedValue = "db2" Then
??? dbConnection = "server=server2;Database=db2;UID=user;PWD=pass"
dbConnection.Open()
Else
??? dbConnection = "server=server1;Database=db1;UID=user;PWD=pass"
dbConnection.Open()
End If
Dim sqlString As String = " sql statement"
Dim dbCommand As New SqlCommand(sqlString, dbConnection)
Dim dbDataReader As SqlDataReader
dbDataReader = dbCommand.ExecuteReader(CommandBehavior.CloseConnection)
gvDies.DataSource = dbDataReader
gvDies.DataBind()
dbConnection.Close()
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Die Usage Lookup</title>
<link rel="stylesheet" href="/intranet.css" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
Find dies matching:
<asp:TextBox ID="tbDies" runat="server" /><br />
Select database:
<asp:DropDownList id="ddlDatabase" runat="server" AutoPostBack="true" OnSelectedIndexChanged="get_Dies">
<asp:ListItem Text="" Selected="true" Value="" />
<asp:ListItem Text="DB1" Value="db1" />
<asp:ListItem Text="DB2" Value="db2" />
</asp:DropDownList>
<asp:gridview ID="gvDies" runat="server" GridLines="none" >
</asp:gridview>
</div>
</form>
</body>
</html>
View 2 Replies
View Related
Jul 14, 2007
I have a table "tbNews" in my database with N_ID, N_Content...
eg:
N_ID N_Content
1 Hello
3 How are you?
14 Are you there?
23 Can you help me?
32 ABC
33 CDE
36 EFG
If I have my N_ID = n (with n=1,3...) , can I select my records with next 1,2 or pre 1,2
eg: I have my N_ID=23, -->can I have got N_ID=3, 14 or N_ID=32, 33 ?
N_ID N_Content
3 How are you?
14 Are you there?
or
32 ABC
33 CDE
Please help me have a Select clause!
Thanhs all.
View 3 Replies
View Related
Sep 24, 2004
Hi all, in SQL 2000 I can select data from a different server using the sintax
"select * from server_name.db_name.owner.table_name".
Can i do the same thing with a table function (e.g "select * from server_name.db_name.owner.MyFun_name()")?
Is there a way to do it?
Thank you all, Andrew
View 3 Replies
View Related
May 30, 2015
There is a column for Name with data type varchar 50 the input data is like Alok Kumar, Sunita kuamri, Rohit Gupta Like that. The column contains the data as Combination of First name and second name.I would like to write a select query for selecting first part of name like Alok, Sunit, Rohit and so on only, ignoring the second part of name.
View 3 Replies
View Related
Apr 29, 2008
Hello all,
I have two mult-value parameters in my report. Both of them working with selecting one or more values. But, when I test using "(Select All)" values for both parameters , only one parameter works. The "available values" for these two parameters are both from the data set.
select distinct ProductType
from Product
order by ProductType
Any suggestion? thx
View 12 Replies
View Related
