Problem removing replication

Running SQL Server 2000. I removed the subscription and publication from a
database but the database is still showing that it is being replicated. I
have checked the tables in the distribution database and that database is not
listed. Anyone lese ver have this problem or now of a solution.
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200610/1
The sp_dboption procedure will give you this information. Alternatively you
can use:
select name, databasepropertyex (name,'IsMergePublished') from
master..sysdatabases
select name, databasepropertyex (name,'IsPublished') from
master..sysdatabases
When you use sp_dboption you pass the database name as the parameter.
The output will look something like this:
The following options are set:
published
select into/bulkcopy
merge publish
trunc. log on chkpt.
auto create statistics
auto update statistics
If they are listed, you use sp_dboption to reverse the flag.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
"masmith via droptable.com" <u27472@.uwe> wrote in message
news:6834f742682f8@.uwe...
> Running SQL Server 2000. I removed the subscription and publication from a
> database but the database is still showing that it is being replicated. I
> have checked the tables in the distribution database and that database is
> not
> listed. Anyone lese ver have this problem or now of a solution.
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...ation/200610/1
>
|||Thank you worked wonderful
Paul Ibison wrote:[vbcol=seagreen]
>The sp_dboption procedure will give you this information. Alternatively you
>can use:
>select name, databasepropertyex (name,'IsMergePublished') from
>master..sysdatabases
>select name, databasepropertyex (name,'IsPublished') from
>master..sysdatabases
>When you use sp_dboption you pass the database name as the parameter.
>The output will look something like this:
>The following options are set:
>--
>published
>select into/bulkcopy
>merge publish
>trunc. log on chkpt.
>auto create statistics
>auto update statistics
>If they are listed, you use sp_dboption to reverse the flag.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...ation/200610/1

Problem on report designer

Hi all.

I have the problem on showing the records in my report.
I explain how i designed the report. I made the report in Business Intelligence Project. The report I am achieving is the Personal Information of all employees.
After creating a query/dataset, I dragged the fields to the textboxes. I am trying to show 1 employees' record in each page.
My report looks like this...

EMPLOYEES PERSONAL INFORMATION

Employee Name : <There is a photo Image here>
Age : _
Address: _
Telephone #:_
Province:_
BirthPlace:__
Birthdate:

Gender:__WEIGHT:_
Civil Status:__Height:_
Relgion:_Hair Color:_
Nationality:Eye Color:__

IN CASE OF EMERGENCY PLEASE CONTACT
Name:_
Address:_
telephone:__

EDUCATIONAL BACKGROUND
EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Elementary..............Harvard....1990-1992
High School.............LaSalle....1992-1995
College.................UP.........1995-2000

__
Run Time: 2/3/2007
Page No. : 1

I used dot above just for spacing and alignment but not included in my actual report.

I used table for EDUCATIONAL BACKGROUD.

My problem is: when i ran the report, it can't automatically creates report for all employees. It only shows the first employee in the database.

Any suggestions and guidance please.

Thanks.
-Ron-

You say you are using textboxes... Are these textboxes in a List control or the Details section of a Table control?

BobP

|||

its on the list control. I only used table in EDUCATIONAL BACKGROUND.... Is it possible to show all the records in textboxes(on the list control)? If not, any suggestion of how could I design this report...

thanks.

-Ron-

|||

I think you should put all the information in your table.

You will have a detail row for each row on your page. For example:

Detail Row 1: EMPLOYEES PERSONAL INFORMATION
Detail Row 2:
Detail Row 3: Employee Name : __
Detail Row 4: Age : __
...
...
Detail Row v: EDUCATIONAL BACKGROUND
Detail Row w: EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Detail Row x: Elementary..............Harvard....1990-1992
Detail Row y: High School.............LaSalle....1992-1995
Detail Row z: College.................UP.........1995-2000

Instead of putting spaces in there to make them align, I would have the SCHOOL, FROM-TO, and DEGREE in their own columns.

Hope this helps.

Jarret

|||

If table is the only solution for this. Ok, i have to use it... If there is any suggestion please tell me.

Thanks.

-Ron-

|||

EMPLOYEES PERSONAL INFORMATION

Employee Name : <There is a photo Image here>
Age : _
Address: _
Telephone #:_
Province:_
BirthPlace:__
Birthdate:

Gender:__WEIGHT:_
Civil Status:__Height:_
Relgion:_Hair Color:_
Nationality:Eye Color:__

IN CASE OF EMERGENCY PLEASE CONTACT
Name:_
Address:_
telephone:__

EDUCATIONAL BACKGROUND
EDUCATIONAL LEVEL SCHOOL FROM-TO DEGREE
Elementary Harvard 1990-1992 BSCS
High School LaSalle 1992-1995 BSIT
College UP 1995-2000 BSIT

__
Run Time: 2/3/2007
Page No. : 1

The report above is my expected result of my report. Until now dont get it yet. Could someone help me please. I have the problem on displaying the EDUCATIONAL BACKGRUND. EDUCATIONAL BACKGRUND of a person is dynamically created.

My table in EDUCATIONAL BACKGRUND

empno educlevel school fromto degree

1 elementary UP 2001-2002 BSCS
1 high school UP 2001-2002 BSCS
1 college UP 2001-2002 BSCS
2 elemntary UP 2001-2002 BSCS
2 college UP 2001-2002 BSCS
3 elem UP 2001-2002 BSCS
3 high UP 2001-2002 BSCS
3 college UP 2001-2002 BSCS
3 master UP 2001-2002 BSCS

I tried to use only 1 table for my whole report but i need to group the EDUCATION BACKGROUND. and the group appears in the first row of the table. How could i set the group to the last row? please guide me of what i am doing if it is correct or not. Thanks.

2nd option i tried. I used different table for EDUCATION but it will occur vry bad output.

-Ron-

|||

Hello Ron,

You will need to setup your report to group by empno, then the detail row would show the educlevel, school, fromto, and degree. The group header section is where you will need to place all of the 'static' report information (everything down to where the education levels are listed). You can then right-click on your group header and select 'Insert Row Below' and keep doing this for every row in your report (up to the education levels). It should look something like this:

Group Header Row 1: EMPLOYEES PERSONAL INFORMATION
Group Header Row 2:
Group Header Row 3: Employee Name : __
Group Header Row 4: Age : __
...
...
Group Header Row y: EDUCATIONAL BACKGROUND
Group Header Row z: EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Detail Row 1: Fields!educlevel.Value...Fields!school.Value...Fields!fromto.Value...Fields!degree.Value

Hope this helps.

Jarret

|||

Thanks Jarret...i appreciate your help... :)

-Ron-

Problem on report designer

Hi all.

I have the problem on showing the records in my report.
I explain how i designed the report. I made the report in Business Intelligence Project. The report I am achieving is the Personal Information of all employees.
After creating a query/dataset, I dragged the fields to the textboxes. I am trying to show 1 employees' record in each page.
My report looks like this...

EMPLOYEES PERSONAL INFORMATION

Employee Name : <There is a photo Image here>
Age : _
Address: _
Telephone #:_
Province:_
BirthPlace:__
Birthdate:

Gender:__WEIGHT:_
Civil Status:__Height:_
Relgion:_Hair Color:_
Nationality:Eye Color:__

IN CASE OF EMERGENCY PLEASE CONTACT
Name:_
Address:_
telephone:__

EDUCATIONAL BACKGROUND
EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Elementary..............Harvard....1990-1992
High School.............LaSalle....1992-1995
College.................UP.........1995-2000

__
Run Time: 2/3/2007
Page No. : 1

I used dot above just for spacing and alignment but not included in my actual report.

I used table for EDUCATIONAL BACKGROUD.

My problem is: when i ran the report, it can't automatically creates report for all employees. It only shows the first employee in the database.

Any suggestions and guidance please.

Thanks.
-Ron-

You say you are using textboxes... Are these textboxes in a List control or the Details section of a Table control?

BobP

|||

its on the list control. I only used table in EDUCATIONAL BACKGROUND.... Is it possible to show all the records in textboxes(on the list control)? If not, any suggestion of how could I design this report...

thanks.

-Ron-

|||

I think you should put all the information in your table.

You will have a detail row for each row on your page. For example:

Detail Row 1: EMPLOYEES PERSONAL INFORMATION
Detail Row 2:
Detail Row 3: Employee Name : __
Detail Row 4: Age : __
...
...
Detail Row v: EDUCATIONAL BACKGROUND
Detail Row w: EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Detail Row x: Elementary..............Harvard....1990-1992
Detail Row y: High School.............LaSalle....1992-1995
Detail Row z: College.................UP.........1995-2000

Instead of putting spaces in there to make them align, I would have the SCHOOL, FROM-TO, and DEGREE in their own columns.

Hope this helps.

Jarret

|||

If table is the only solution for this. Ok, i have to use it... If there is any suggestion please tell me.

Thanks.

-Ron-

|||

EMPLOYEES PERSONAL INFORMATION

Employee Name : <There is a photo Image here>
Age : _
Address: _
Telephone #:_
Province:_
BirthPlace:__
Birthdate:

Gender:__WEIGHT:_
Civil Status:__Height:_
Relgion:_Hair Color:_
Nationality:Eye Color:__

IN CASE OF EMERGENCY PLEASE CONTACT
Name:_
Address:_
telephone:__

EDUCATIONAL BACKGROUND
EDUCATIONAL LEVEL SCHOOL FROM-TO DEGREE
Elementary Harvard 1990-1992 BSCS
High School LaSalle 1992-1995 BSIT
College UP 1995-2000 BSIT

__
Run Time: 2/3/2007
Page No. : 1

The report above is my expected result of my report. Until now dont get it yet. Could someone help me please. I have the problem on displaying the EDUCATIONAL BACKGRUND. EDUCATIONAL BACKGRUND of a person is dynamically created.

My table in EDUCATIONAL BACKGRUND

empno educlevel school fromto degree

1 elementary UP 2001-2002 BSCS
1 high school UP 2001-2002 BSCS
1 college UP 2001-2002 BSCS
2 elemntary UP 2001-2002 BSCS
2 college UP 2001-2002 BSCS
3 elem UP 2001-2002 BSCS
3 high UP 2001-2002 BSCS
3 college UP 2001-2002 BSCS
3 master UP 2001-2002 BSCS

I tried to use only 1 table for my whole report but i need to group the EDUCATION BACKGROUND. and the group appears in the first row of the table. How could i set the group to the last row? please guide me of what i am doing if it is correct or not. Thanks.

2nd option i tried. I used different table for EDUCATION but it will occur vry bad output.

-Ron-

|||

Hello Ron,

You will need to setup your report to group by empno, then the detail row would show the educlevel, school, fromto, and degree. The group header section is where you will need to place all of the 'static' report information (everything down to where the education levels are listed). You can then right-click on your group header and select 'Insert Row Below' and keep doing this for every row in your report (up to the education levels). It should look something like this:

Group Header Row 1: EMPLOYEES PERSONAL INFORMATION
Group Header Row 2:
Group Header Row 3: Employee Name : __
Group Header Row 4: Age : __
...
...
Group Header Row y: EDUCATIONAL BACKGROUND
Group Header Row z: EDUCATIONAL LEVEL.......SCHOOL.....FROM-TO......DEGREE
Detail Row 1: Fields!educlevel.Value...Fields!school.Value...Fields!fromto.Value...Fields!degree.Value

Hope this helps.

Jarret

|||

Thanks Jarret...i appreciate your help... :)

-Ron-

Problem installing SQL Server 2005 Express Edition

I have downloaded a free set of SQL Server 2005 Express edition. This set up has been installed successfully on my machine but it is showing me following links.

SQL Server Instance=SQLExpress

User Id=sa

Password=admin12

Start --> Microsoft Sql Server 2005 -->Configuration Tools --->SQL Server Configuration Manager

--->SQL Server Eroor and Usage Reporting

---->SQL Server Surface Area Configuration

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

dineshpatil:

But I don't find any option to start SQL Server 2005 express edition. Please help me out how to start SQL Server 2005 express edition?

You can use the SQL Server Surface area configuration to start/stop services like your SQL instance.

If you want a GUI interface then you need to install SQL Server Management Studio.

|||

Dear Jimmy,

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

|||

http://msdn2.microsoft.com/nl-nl/express/bb410792(en-us).aspx

|||

dineshpatil:

Thanks for your reply. I have started SQL Server instance service. Is SQL Server Management Studio is free?
If it is free, Please provide me URL path from where I can download?

Yes it is free and you can download it here

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

dineshpatil:

Is there any other way with which I can run or access Microsoft SQL Server 2005 Express Edition?

Your Express database is already installed so you can use it right away. You can either connect from the VS IDE, but if you want a GUI to the database then you need to use the SQL Management tool another 3rd party tool or rely on Visual Studio's server explorer.

|||

Thanks guys. Now it is working fine.