Ever See This? No Borders Or Icons On Tasks

Oct 3, 2007

I'm setting up a new computer, and opening an SSIS project I've worked on elsewhere. Here's what I'm seeing (see http://tkfiles.storage.live.com/y1pX-TdM6iRI3cSQsl2V4GLd5RAuX2ygIeBbMSb-VM7vTauMSqehrm7pFvpA6N2sFLQFrb4a-1iXnk):



The borders and icons come back if I resize the window by dragging an edge of the window. They disappear again if I maximize the window.

It's very odd, but I'm wondering if it means that something sinister is going on. I didn't set up all of the software on this machine, so I don't fully trust that it was set up correctly.

View 4 Replies


ADVERTISEMENT

Icons For Custom Tasks Won't Show Up.

Jul 31, 2006

All aspects of my custom task work well except for the icon!

I have included the .ico in the assembly as an "Embedded Resource" and the icon has both 16X16 and 32X32 images. I have edited the IconResource property of the DtsTask attribute as follows:

IconResource="MyNamespace.MyDLLName.MyIconName.ico",


Where the output assembly is called "MyNamespace.MyDLLName.dll".

Has anybody got this working before? The Icon just never shows (I get the default blue square task icon).

Thanks in advance.

View 7 Replies View Related

Gaps In Borders Between Columns...

Jul 20, 2007



I have a row in my report that has 6 columns. I want to outline the row with a border, but not the column lines in between. So, I went into BorderColor, changed the Default to white and my Top and Bottom colors as Black. The problem is that where the "white" column lines are, they are displaying 1pt gaps in my outline. I tried changing the BorderStyle to Zero, but it wouldn't take it.



See sample of the report here.



Any ideas?



Thanks,



James H.

View 6 Replies View Related

Column Chart Bar Borders

Jul 12, 2007

Can I add borders to my bars in the column chart? My bars don't appear to have any border, and I can't see a place to set one. I am using SSRS Express.



Thanks!



Michael

View 3 Replies View Related

Matrix Report: Surrounding Borders For Detail

Apr 9, 2008

I have the following report grouped by customer:



month
1
cust1 2008 50
2007 60
cust2 2008 100
cust3 2008 90

2007 80

I'd like to border the last detail row of every group, should look like this:



month
1
cust1 2008 50

2007 60
cust2 2008 100
cust3 2008 90
2007 80



Any suggestions!?

View 10 Replies View Related

Reporting Services :: Cannot Seem To Lose Most Double Borders

Aug 19, 2015

We run std 2008 r2.  On my col heading text boxes and data text boxes i'm purposely picking only borders above and left in an attempt to get rid of what looks like a double border between text boxes. 

The only places I see what appears to be a single thickness is the left of the 1st column hdg and data, and above any col hdg text box I set this way. 

Also, when I pick .5 instead of 1 pt thickness, ssrs always puts it back to 1 pt.

How can I get the appearance of single thickness borders instead double?

View 5 Replies View Related

Problem With Page Borders When Rendering Report In Html

Dec 28, 2007

Hello,

I created a report with borders in the page header, the page body, and the page footer. When I preview the report in report viewer it is exactly how I want it and it also prints and exports to pdf perfectly. There's only a problem viewing it in report manager. The borders in the page header and footer show up right but the body of the report's borders don't show up at all. The body of the report also is no longer aligned with the page header and footer because it's borders seem to be unrecognized in the report manager view. Has anyone experienced this problem and/or figured out what to do to fix this? Please let me know.

Thanks,
cbal4

View 4 Replies View Related

Icons

Aug 17, 2000

i installed sql server 7.0 and when i run Enterprise manager for SQL server (MMC snap in) i see that the SQL server has a little RED SQUIGGLY ACROSS the server icon. can anyone tell me what that means?????
thanks
uday

View 1 Replies View Related

Component Icons

Sep 5, 2007



Hi,
I'm trying to add an icon to a custom component but its not happening and I can't figure out why. I'm sure I've managed to do this in the past. Here's my DtsPipelineComponent attribute:




Code Snippetnamespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="MyComponent.ico"
)




MyComponent.ico is stored in the same folder as my project (i.e. at the same level as the .cs file and the C# project file).
In the application property page I've pointed the icon resource at MyComponent.ico

Everything compiles OK. But I see no icon in my component when I deploy it to the toolbox or use it in a package.

I've also tried changing the attribute to this:




Code Snippetnamespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="Jamiet.Ssis.MyComponent.ico"
)



Again, it compiles OK, but no icon!

Any ideas what I'm doing wrong?

Thanks
Jamie


View 5 Replies View Related

Icons In Enterprise Manager 7

Jul 20, 2005

Hello,apologizing in advance 4 propably asking a trivial question ...in my Server list in Enterprise Manager 7.0 in front of the name of myservers i have a small server symbol followed by an even smaller greentriangle in a circle (which, according 2 my information means "Serverrunning, currently not connected) followed by a vertical red zigzagline.But the context menue only gives me the optio "disconnect" whichindicates that im "connected"Here my question:what exactly is this symbol trying 2 tell me?1ce again apologies

View 1 Replies View Related

Displaying Windows Icons

Apr 17, 2007

Sir/Mam

I am creating a task manager functionality in c#.net 2003. I am checking only for open microsoft applications . If any microsoft application is opened ,it will display the application name for ex "Microsoft Word" in the listview control and its status "Running" . Now, I want to display the icon for Microsoft word or any other microsoft application, how should I display it in the ListView control.?

I have tried by taking it in the imagelist , because I have a class which returns the Windows Icons for these applications which are opened. But, I am unable to display it.

Please help me???


Thanks,
Shivanee.

View 1 Replies View Related

System Requirements And Icons

Dec 15, 2006

Hi all. First, please accept my apologies for any obvious questions, as im very new to this!Anyway, 2 small questions:
I dont have the 'server running' icon in the system tray... The little grey box with a green arrow. have i installed SQL incorrectly?
This leads my to my other question:- After installation (which, i think went fine), i learnt that SQL Server Express cannot run with more than 1 CPU. But i have a Duel-Core. Would this cause problems?

Again, sorry if if missed any previous posts on this.

Thanks
Adrian.

View 1 Replies View Related

What Do New Icons For Process Locks Mean?

Jan 31, 2008

SQL 2000 is easy to see what process is blocking and what processes are locked. I find 2005 confusing and can't find any documentation on what the new icons mean and or details on interpreting the object/process lock screens.

Thanks, Cindy

View 6 Replies View Related

SQL 2012 :: Execution Plan Icons

Apr 8, 2014

I want to find out more information about the execution plan. I saw Parallelism (Gather Streams) in the excution plan. In what situation we can see this icon?If in case if we need to avoid how can we avoid this?

View 5 Replies View Related

Dimension Usage Icons Playing Up

May 29, 2008

Hi,

I was wondering if anyone had come across an issue where the icons in the dimension usage tab of the cube are not being displayed properly, for example if you use a many-to-many the little blue infinity sign is missing. It is a little annoying.

SP2 with BIDS helper, not to sure if BIDS helper did it or SP2, sure it was fine before

Anyone know how to fix it?

Cheers
Matt

View 6 Replies View Related

Program Icons In Start Menu

Sep 16, 2006

Hello,

I´ve made a mistake on my part. I have deleted my complete program icons for "Microsoft SQL Server" in my start menu.

Is there a simple way to just renew all the icons in my start menu without reinstalling the complete sql server.

Thank you very much for any tips.

View 1 Replies View Related

Any Documentation On SQL Server State Icons Shown In MMC Console?

Feb 8, 2000

Does anyone know of any place I can find documentation on the meanings of the SQL Server state icons displayed in the MMC console for SQL Server 7.0? My server is showing the green running icon but also a vertical red squiggly line. I do not know what this red squiggly line means, and it concerns me. The databases all seem fine, and everything seems to be working, i just have this feeling like something bad is impending and I cannot find anything that tells me what it might be. Any help or suggestions would be greatly appreciated.

View 2 Replies View Related

More Of DBA Tasks

Apr 11, 2006

are there restrictions on what a DBA can do on a developer's edition?

i'm asking coz i get really bad connection problems when changing service accounts, client aliases, port numbers, connecting to different components like ssis, reporting services, database engine, etc...

in sql2000, changing these things are a breeze, is there some guidelines when making these changes in 2005?


TIA

--------------------
keeping it simple...

View 2 Replies View Related

DBA Tasks

Feb 21, 2008

Hi guys

Just want to know whether you guys do the following as a dba:

1. Setup a logging for tracking database as well as table size that containing size, indexing size. You can measure the growth.
2. Record for indexing for each database. I think this is over kill task.
3. Record database setup such as create statistic, update statistic etc.

These tasks can be automate to record every month for example and record this into Administration database for instance.

What else you guys record?

Thanks

View 3 Replies View Related

How To Run Only Certain Tasks

Mar 14, 2006

If I'm in the Data Flow tab in VS 2005, how can I select only certain components to run to test?  I tried highlighting the ones that I want to run but it's running all of them in the tab...some of the components I want to take out for testing then maybe put back in later.  If I delete the tasks I don't want to run, then I end up having to recreate them

View 11 Replies View Related

Where To Find The Web Tasks?

Dec 17, 2001

Where to look for the web assitant created jobs on the server?I created a web page using the web assistant which is suppossed to get updated each time a value changes in a particular table,but I can't find the task which I created ,where do i look for that?I didn't use this wizard previously.thanks for any help!
Sheila.

View 1 Replies View Related

DTS Custom Tasks

Oct 5, 2000

Would anyone be aware of anyplace I could find some good information on creating DTS custom tasks? I've come across a couple of articles from SQL Server Magazine, but nothing too substantive...
Better yet, if anyone has any success (great or small), I'd like to hear from you and hear some of the things you did, what your custom task does, difficulty.
I'm just trying to get an idea of how much work I have ahead of me....

Thank You...

View 2 Replies View Related

Scheduled Tasks

Sep 15, 1999

If I have 2 scheduled tasks set for the same time (perhaps accidentally), will the
SQL Executive start 1 and queue the other one until the first is complete and
then run the 2nd task? Or will they both be started simultaneously?

Thanks!
Toni Eibner

View 2 Replies View Related

Scheduled Tasks In 6.5

Feb 12, 1999

I have been running the following production job successfully for a long time.
It now fails, and the Task History Last Error Message displays 'No Message'.
The log file ( C:MSSQLLOGMaint_TombV50.txt) shows it ran successfully,
with a Return Code 0.

SQLMAINT.EXE -D TombV50 -RebldIdx 10
-CkDB -CkAl -CkTxtAl -CkCat
-UpdSts -Rpt C:MSSQLLOGMaint_TombV50.txt

It looks like SQL Executive burps for some reason.

Any ideas, comments, suggestions?

Thanks,
sb

View 1 Replies View Related

Scheduled Tasks

Jun 23, 1999

To all,
If I have a scheduled tasks that is owned by 'sa', how can I assign permissions to allow another user, even the database dbo, to register the SQL server and view the scheduled tasks?

Thanks in Advance,
Ed Molinari

View 1 Replies View Related

Schedule Tasks

Jun 5, 1999

Hello ,
I need create tasks, which will be wake up daily to backup 4 databases.
My questions are:
1. Can I create 1 task to backup all databases using TSQL command?
Ex: DUMP DATABASE test1 to test1_backup
DUMP TRANSACTIONS test1 to test1_backup with truncate_only
DUMP DATABASE test2 to test2_backup
DUMP TRANSACTIONS test2 to test2_backup with truncate_only
Etc.
If it’s possible can I just print this command to ‘Command:’ text box in the ‘New task’ window
without writing the TSQL command into a text file and execute it with the ISQL program through
CmdExec??????
2.If first doesn’t work: can I do the same job, but create for every backup own task and run the same
TSQL command for particular database. And if I can is it possible to schedule run all 4 tasks the same time or I should put time’s interval?
3. If 1. And 2. Are false. Give me your smart advice.

Thank you,
Sev

View 1 Replies View Related

Transfer Of Tasks

Jun 28, 1999

Is anybody knows how to transfer all the tasks in one server to another?
Our development database will be transferred/copied to a new production box
and that includes all tasks that we've created. We have almost a hundred
tasks defined and we don't want it create manually. If someone had done
this before, please give me a hint, i appreciate it very much!

Thanks.
vic

View 1 Replies View Related

DTS Workflow And Tasks

Jul 12, 2005

Hi all,

I've got a DTS job which has lots of tasks in it. I've also got quite a few flows of workflow and i've noticed that a task won't execute if it has both Failure and Success workflow pointing to it... It can have multiple failures pointing to it and it will execute but it can't have multiple successes or a combination of workflows...

Does anyone know a way to get around this or to change the 'AND' ing that seems to be on the workflow going into a task..

Thanks.

View 2 Replies View Related

How Often To Do Certain Maintanence Tasks.

Jul 29, 2004

Hi,

I just volunteered to be the database administrator of our new sql server. I am normally the programmer so I have little experience with database administration. There are some basics that I need some assistance with mainly when to perform various maintanence checks. For example, how often do I need to perform some of the dbcc commands that I have read about? How often do I check for data integrity, index fragmentation, rebuilding indexes, or defrag indexes?

I have to come up with a plan by tomorrow and I don't know if I have anything solid enough since I don't exactly know when to perform some of these tasks. :confused:

Thanks so much for your advice.

View 5 Replies View Related

Tasks To Automate

Mar 2, 2006

Can someone let me know any 10 things that are usally automated using the SQL Server Agent,

I mean besides backup what all can i automate

Thanks

View 1 Replies View Related

Plz Solve For This Tasks

May 13, 2006

could some one help in giveing solution for this tasks..
[CODE]
Task 1 : Get the first day and last day of the week


Ex: input : '04/12/2006'

Required ouput :

start_date End_date
04/09/200604/15/2006

Note :1. start_date should be sunday
2. end_date should be saturday




Task 2 -- Find the product sales week wise


Find the product sales week wise

Output Required:

gasstationID productClass week1 week2 week3 week4
-------------------- ------------ ----------- ----------- ----------- -----------
111 DSL 1 0 0 0
111 GAS 2 0 1 1
222 DSL 1 0 1 1
222 GAS 1 0 0 0


create table trial_sales(
gasstationIDbigint,
salesDatesmalldatetime,
gallonsbigint,
productClass varchar(4))


insert into trial_sales values(111,'11/01/2005',10000,'GAS')
insert into trial_sales values(111,'11/02/2005',1000,'GAS')
insert into trial_sales values(111,'11/02/2005',20000,'DSL')
insert into trial_sales values(222,'11/01/2005',10000,'GAS')
insert into trial_sales values(222,'11/02/2005',10000,'DSL')
insert into trial_sales values(111,'11/15/2005',1000,'GAS')
insert into trial_sales values(222,'11/15/2005',10000,'DSL')
insert into trial_sales values(111,'11/25/2005',1000,'GAS')
insert into trial_sales values(222,'11/25/2005',10000,'DSL')





Task 3 Display unique values


Display unique values in

create table t (colA varchar(25))

insert into t values('apple')
insert into t values('bat')
insert into t values('car')

ouput required:

a
b
c
e
l
p
r
t



Task : 4

I have a table in the database I am working with with the following columns:
(I have simplified this down for the sake of clarity)
int p1
int p2
int p3
int s1
date d1
string s1

There is no primary key and the table more resembles a log than anything.
e.g.

p1 p2 p3 s1 d1 s1
1 12 14 100 23May comment 2
1 12 14 800 22May comment 1
1 12 14 300 24May comment 3
1 12 15 100 22May comment 2
1 12 15 800 21May comment 1
2 12 15 100 23May comment 1

What I want to do is exttract the rows from the table where the combination
of p1 p2 and p3 is distinct/unique and the date is the most recent one for
all combinations of p1, p2, p3. So from the table above I would end up with
the resultset:

p1 p2 p3 s1 d1 s1
1 12 14 300 24May comment 3
1 12 15 100 22May comment 2
2 12 15 100 23May comment 1





Task 5


say i have the following data...
uId(int PK), productcode(int), quantity(int)
1,12,5
2,12,3
3,12,5
4,11,9


....and i have an order for productcode 12 with quantity of 6 products.
i need to select only enough rows to reach a quantity of 6.
in this case, i would want the first two rows which would give me a sum of
8.
how can i do this without looping through each record, getting the quantity
and exiting the loop when i have a sum >= 6?



Task 6

I have two tables as below, TABLE1 and TABLE2.


TABLE 1: Base

IDPNamePPrice
-------------------------------------
1A30
2B20

TABLE 2: History

IDLdateAmount
-------------------------------------
12005/8/750


The ID of TALBE1 is the primary key and the ID of TABLE2 is the foreign key.
What's the right T-SQL JOIN statement when I pass the date of 2005/8/7,
it will return the result as below:


LdatePNameAmount
------------------------------------
2005/8/7A50
2005/8/7Bnull


and when I pass the date of 2005/8/8, it will return the result as below:

LdatePNameAmount
------------------------------------
2005/8/8Anull
2005/8/8Bnull



Task : 7

Reverse the Name

create table sample_judge(
judge_namevarchar(50))
go

insert into sample_judge values ('J Smith')
insert into sample_judge values ('M Samuel')
insert into sample_judge values ('S Shan')
insert into sample_judge values ('K Anand')
insert into sample_judge values ('K K K K Anand')
insert into sample_judge values ('K R Shanth Anand')
insert into sample_judge values ('K R Shanth Anand Kumara Velu')

go

Expected Output :

Smith J
Samuel M
Shan S
Anand K
Anand K K K K
Shanth Anand K R
Shanth Anand Kumara Velu K R


[CODE]

thanks in adv
chakri

View 5 Replies View Related

Run Tasks Against Each Sql Server

Jun 18, 2008

Hi,

I would like to run several checklists against each sql server 2005 instance.

I can get a list of the sql server 2005 machines (Which are on the network) from a sql server table.

There is a another table which holds the list of the checks that need to be carried out against each sql server 2005 machine called tblCheckList.

The list of tasks in the table is briefly as follows:

1) get the path where the .mdf file is placed.
2) get the path where the .ldf file is placed
3) get the path where .BAK or .TRN are placed
4) get the path where the sql 2005 is installed
5) get the servicepack version
6) get the authentication
7) remove sample databases i.e. northwind or pubs, etc...
8) get the recovery model on UserDB
9) get the size of each database

...
...
...

The list goes on

Thanks

View 7 Replies View Related

Tasks To Automate

Mar 2, 2006

Can someone let me know any 10 things that are usally automated using the SQL Server Agent,

I mean besides backup what all can i automate

Thanks

View 10 Replies View Related







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