HELP!...VB.NET killed SQL Server

Hi,
Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
2000. After the install SQL Server will not run. SQLAgent fails with the
error "1068: The dependency service or group failed to start". When I try to
start MSSQL service I get a message it started then stopped because it may
not have anything to do.
I was planning to install SP3 of SQL Server 2000, so I tried that, but it
fails to install because (it seems) it needs SQL Server to be running.
Any ideas? Right now I desperately need SQL Server but not VB. So, I
guess my next move is to un-install VB.NET, which is going to be a royal
pain, and that may not even work because such a big install cannot be truly
uninstalled. After that I would fall back to an OS restore point.
Help, please!
Tim
> When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tim" <Tim@.discussions.microsoft.com> wrote in message
news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
> Hi,
> Yesterday I installed VB.NET on my machine. I had been runnng SQL Server
> 2000. After the install SQL Server will not run. SQLAgent fails with the
> error "1068: The dependency service or group failed to start". When I try to
> start MSSQL service I get a message it started then stopped because it may
> not have anything to do.
> I was planning to install SP3 of SQL Server 2000, so I tried that, but it
> fails to install because (it seems) it needs SQL Server to be running.
> Any ideas? Right now I desperately need SQL Server but not VB. So, I
> guess my next move is to un-install VB.NET, which is going to be a royal
> pain, and that may not even work because such a big install cannot be truly
> uninstalled. After that I would fall back to an OS restore point.
> Help, please!
> Tim
|||Thanks! I ran the SQL Server setup program with the option "Rebuild
Registry" and now it seems fine. Thanks again!
Tim
"Tibor Karaszi" wrote:

> Can you post the SQL Server errorlog file? Assuming it is only a few rows, of course...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tim" <Tim@.discussions.microsoft.com> wrote in message
> news:D3C2B8A5-17F9-448D-8EA0-19F5A4119907@.microsoft.com...
>
>

help!...sp1 or sp2

After I install SP1 of SP2 for reporting services, I get the following
error:
The version of the report server database is either in a format that is
not
valid, or it cannot be read. The found version is 'C.0.6.54'. The
expected
version is 'C.0.6.43'. To continue, update the version of the report
server
database and verify access rights. (rsInvalidReportServerDatabase)
I am currently running RS enteprise edition with SQL server 2000
Standard edition.
When I used to have RS std. edition with SQL server 2000 std.edition,
I've applied both service packs and didn't get the error.
Can you help me with this problem?
Thanks,If you already installed SP2, you can not install SP1 afterwards and
you do not need to.
Service Packs are cumulative - they contain everything from prior
service packs.
bevarg wrote:
> After I install SP1 of SP2 for reporting services, I get the following
> error:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.54'. The
> expected
> version is 'C.0.6.43'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
> I am currently running RS enteprise edition with SQL server 2000
> Standard edition.
> When I used to have RS std. edition with SQL server 2000 std.edition,
> I've applied both service packs and didn't get the error.
> Can you help me with this problem?
> Thanks,

HELP!... SQL Log Gone. How do I recover Database

As the subject says...
I will admit to some stupidity. I inadvertently deleted
the log file.
On top of that, it appears my backups have failed, so no
back up.
Data file still exists.
Please tell me there is a way to recover.
Thanks in advance.
SvenI would give MS PSS a call if it's important to get it back.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
But if all else fails here is something you can try:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
Andrew J. Kelly
SQL Server MVP
"Sven Hansen" <svenhansen@.shaw.ca> wrote in message
news:079001c3af02$a07d2fa0$a101280a@.phx.gbl...
> As the subject says...
> I will admit to some stupidity. I inadvertently deleted
> the log file.
> On top of that, it appears my backups have failed, so no
> back up.
> Data file still exists.
> Please tell me there is a way to recover.
> Thanks in advance.
> Sven|||If you have the data file, then you can bring back your
database by using "sp_attach_db" coomand.
Look in BOL, for syntax and more info. Its very easy.
Good Luck!
-SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>As the subject says...
>I will admit to some stupidity. I inadvertently deleted
>the log file.
>On top of that, it appears my backups have failed, so no
>back up.
>Data file still exists.
>Please tell me there is a way to recover.
>Thanks in advance.
>Sven
>.
>|||Since you have only data file, use this syntax
Example:
EXEC sp_attach_db @.dbname = 'pubs',
'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
SQL Server will automatically attach a new log file.
Good Luck!
SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>As the subject says...
>I will admit to some stupidity. I inadvertently deleted
>the log file.
>On top of that, it appears my backups have failed, so no
>back up.
>Data file still exists.
>Please tell me there is a way to recover.
>Thanks in advance.
>Sven
>.
>|||You saved my life... and likely my job... :)
Thank you.
The script worked perfectly.
Take care and thanks again.
Sven
>--Original Message--
>I would give MS PSS a call if it's important to get it
back.
>http://support.microsoft.com/default.aspx?scid=fh;EN-
US;sql SQL Support
>http://www.mssqlserver.com/faq/general-pss.asp MS PSS
>But if all else fails here is something you can try:
>http://www.sqlservercentral.com/scripts/scriptdetails.asp
?scriptid=599
>Restoring a .mdf
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Sven Hansen" <svenhansen@.shaw.ca> wrote in message
>news:079001c3af02$a07d2fa0$a101280a@.phx.gbl...
>> As the subject says...
>> I will admit to some stupidity. I inadvertently
deleted
>> the log file.
>> On top of that, it appears my backups have failed, so
no
>> back up.
>> Data file still exists.
>> Please tell me there is a way to recover.
>> Thanks in advance.
>> Sven
>
>.
>

Help!. Images not Displaying

Hello
i have made a report and inserted some company logo in the report header ,,,
from the image wizard i selected Embeded type ,, But when i run the port in
asp.net by calling its webservice ,,,images are not shown.
Plz help me to solve this problem
ThanksHi Malik,
Please look at following link. "_" in the machine name may be the
culprit. Use the IP instead of machine name. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Malik Asif Joyia" wrote:
> Hello
> i have made a report and inserted some company logo in the report header ,,,
> from the image wizard i selected Embeded type ,, But when i run the port in
> asp.net by calling its webservice ,,,images are not shown.
> Plz help me to solve this problem
> Thanks
>
>sql

HELP!!-Urgent

"I've created a customer table and I want to give each customer a
unique id e.g 'ES001' But sql server won't let me I've looked at
various books to no avail.

My second question is when I delete a row from a table which had an ID
of 2 when I put in a new row it gives the new row and ID of 3 how do i
make it give the row an ID of 2."You can use a view, trigger or a calculated column to derive a
meaningful surrogate key from your data, or you can generate it in your
application. What exactly do you have a problem with? What do you mean
by "sql server won't let me"?

As for your second question, the whole point of an IDENTITY key (I
assume that's what you are referring to) is that it is internal,
auto-generated and meaningless. If you care about what the value should
be then you shouldn't use IDENTITY. If you are just trying to number
each row then why put that information in the table at all - just
display the numbers when you query it or print a report.
--
David Portas
SQL Server MVP
--|||Salim (s_aboobaker@.hotmail.com) writes:
> "I've created a customer table and I want to give each customer a
> unique id e.g 'ES001' But sql server won't let me I've looked at
> various books to no avail.

CREATE TABLE customers (id char(5) NOT NULLL,
...
CONSTRAINT pk_customers PRIMARY KEY (id))
go
INSERT customers (id, ...)
VALUES ('ES001', ...

> My second question is when I delete a row from a table which had an ID
> of 2 when I put in a new row it gives the new row and ID of 3 how do i
> make it give the row an ID of 2."

INSERT tbl (id, ...)
VALUES (2, ...)

As David said, don't use IDENTITY if you want to specify the key values
yourself.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Ehere to begin? You are doing everything wrong because you do not
understand the basic concepts of RDBMS. A table is not a file; it
models an entity in reality. To find a unique identifier, you need to
look at your data model.

**by definition** the IDENTITY extension in T-SQL can never be a key.
It is a sequential numbering that id derived from the state of the
hardware at the time of insertion. It has nothing whatsoever to do
with your data model or the reality being modelled.

What you have is a file system written in SQL. We used to re-use fixed
length preallocated records in a lot of the early disk OS, just like
you are trying to do.

Please get a book on the basics before you learn all the kludges that
people will give you and learn to do it right.|||--CELKO-- (jcelko212@.earthlink.net) writes:
> Ehere to begin? You are doing everything wrong because you do not
> understand the basic concepts of RDBMS. A table is not a file; it
> models an entity in reality. To find a unique identifier, you need to
> look at your data model.
> **by definition** the IDENTITY extension in T-SQL can never be a key.
> It is a sequential numbering that id derived from the state of the
> hardware at the time of insertion. It has nothing whatsoever to do
> with your data model or the reality being modelled.

Where do you get all the crap from?

This is the original post?

"I've created a customer table and I want to give each customer a
unique id e.g 'ES001' But sql server won't let me I've looked at
various books to no avail.

My second question is when I delete a row from a table which had an ID
of 2 when I put in a new row it gives the new row and ID of 3 how do i
make it give the row an ID of 2."

No talk of IDENTITY, no talk about files. In fact it is obvious that
ES001 has nothing to do with IDENTITY.

> What you have is a file system written in SQL. We used to re-use fixed
> length preallocated records in a lot of the early disk OS, just like
> you are trying to do.
> Please get a book on the basics before you learn all the kludges that
> people will give you and learn to do it right.

All I can say to unexperienced people who are following this group is
to put Joe Celko in your kill files. He can't read the posts he replies
to properly. He repeats misconceptions about SQL Server all over again.
His examples are full of sloppy errors. His tone against unexperienced
users is unacceptable.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||s_aboobaker@.hotmail.com (Salim) wrote in news:d84b91a3.0501280315.1f9a13c4
@.posting.google.com:

> "I've created a customer table and I want to give each customer a
> unique id e.g 'ES001' But sql server won't let me I've looked at
> various books to no avail.
> My second question is when I delete a row from a table which had an ID
> of 2 when I put in a new row it gives the new row and ID of 3 how do i
> make it give the row an ID of 2."

Somebody's not getting their money's worth out of *this* consultant.

HELP!!-Jump to URL

I input for "Jump to URL".
But I don't want to open URL on same page.
Is it possible to open new window for that URL page after click one which
have a "Jump to URL".Yes it is, something like this:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?%2fJBOSC%2fJLRRS%2fworkorder%2fwondetail&WON=" & Fields!COL2.Value &
"','_blank'))"
"Ken" wrote:
> I input for "Jump to URL".
> But I don't want to open URL on same page.
> Is it possible to open new window for that URL page after click one which
> have a "Jump to URL".
>
>

HELP!!:about the MS association rules

When i use the MS association rules ,i don't know how it is worked on the background .I stuy the Fp-Growth algorithm , but there're some questions , I don't kown what's the meaning of transcation database. who can give me one example ? thanks .I know we can store the data in relation database,but in basket Analysis ,how a transaction stroed in relation database?

In the context of Association Rules/Market Basket Analysis, we are talking about the contents of the "basket" when we refer to the transaction table. In a relational database, you'd typically have a master table containing information about customers (for instance) and a detail table that has a foreign key relationship with the master table and holds the associated purchases for each customer.

The more common approach for market basket analysis is to model each transaction (containing multiple items) as a case so your transaction table would have a composite key comprising the transaction id and item id, with multiple rows for each transaction id, comprising all items that were bought together as part of that single transaction. From the point of view of SQL Data Mining, you would use the same table as the "case table" as well as the "nested table" containing the associated items for each transaction.

See this article for an example: http://www.aspnetpro.com/newsletterarticle/2004/10/asp200410ri_l/asp200410ri_l.asp.

|||

hi, Raman Iyer ,your answer is helpful for me,thanks .This problem I had resoved several days ago ,but when i looked at the article your offerd for me, i also got much help.thank you.

there is another problem in my study, I had write the Fp_Growth algorithm, and had got the Fp itemsets ,but when i wanted to display these itemsets into association rules , i met the problem. I stored the itemsets in relation database,for example :

ItemsetsID

Itemid

itemsetsCount

1

I1

3

1

I2

3

2

I1

4

2

I3

4

3

I1

3

3

I2

3

3

I3

3

4

I2

3

4

I3

3

……………

…………

……………

it means there're 4 itemset (I1,I2 : 3),(I1,I3 :4 ),(I2,I3 : 3 )and(I1,I2,I3 : 3),and the |D|=10(|D|means the num of the transaction )

Count(I1)=7

Count(I2)=6

Count(I3)=7

Count(I1,I2)=3

Count(I1,I3)=4

Count(I1,I2,I3)=3

Count(I2,I3)=3

so i want to get the rules like this ,

Interesting = support(left+right)/(support(left)*support(right))

Ruleid

Left

Right

Support

Confidence

Interesting

1

I1

I2

0.3

3/7

0.3/(0.7*0.7)

2

I2

I1

0.3

3/6

0.3/(0.7*0.6)

3

I1

I3

0.4

4/7

0.4/(0.7*0.7)

4

I3

I1

0.4

4/7

0.4/(0.7*0.7)

5

I1

I2,I3

0.3

3/7

0.3/(0.7*0.3)

6

I2

I1,I3

0.3

3/6

0.3/(0.6*0.4)

7

I3

I1,I2

0.3

3/7

0.3/(0.7*0.3)

8

I1,I2

I3

0.3

3/3

0.3/(0.3*0.7)

9

I1,I3

I2

0.3

3/4

0.3/(0.4*0.6)

10

I2,I3

I1

0.3

3/3

0.3/(0.3*0.7)

11

I2

I3

0.3

3/6

0.3/(0.6*0.7)

12

I3

I2

0.3

3/7

0.3/(0.7*0.6)

what the type can i store the rule in my relation database , just like the table 2? and what's the tool or technology can i use to display these rules in my webpage , owc?or reporting service? Are there any article that i shoud read , can you give me some advice? thank you