I deleted an important database by accident!

I just got a new job at a new company, and I had a network terminal
with sql server which accessed a list of databases. One of them was
the database I was expected to work with.
The first day I opened some stored procedures and some tables to get a
feel of how the database worked.
The next day, the database was gone.
I am new to SQL Server (though I've read books on it) and I wonder if
I deleted the database by mistake. For instance, I double clicked on
some of the stored procedures to open them. Perhaps that runs them
instead of opening them and they delete the database? (Some of the
procedures I clicked on were 'system procedures')
I would think that it would not be simple to delete a database by
mistake - I would expect at least a message saying "are you sure"?
Monday I come back to face the music - so does anybody know how this
could happen?
-- MarvinHi
No , If you double click on stored procedure that won't drop the database as
you describe that.
Yes , if ou delete the db via EM , it always asks you "are you sure...."
bit not if you run DROP DATABASE... via QA.
Also , if some users were connected to the db you also get a message that
'db is in use..."
<COHENMARVIN@.lycos.com> wrote in message
news:67a8223a-4a1c-4eff-9ea8-9eb32417a0b8@.8g2000hse.googlegroups.com...
>I just got a new job at a new company, and I had a network terminal
> with sql server which accessed a list of databases. One of them was
> the database I was expected to work with.
> The first day I opened some stored procedures and some tables to get a
> feel of how the database worked.
> The next day, the database was gone.
> I am new to SQL Server (though I've read books on it) and I wonder if
> I deleted the database by mistake. For instance, I double clicked on
> some of the stored procedures to open them. Perhaps that runs them
> instead of opening them and they delete the database? (Some of the
> procedures I clicked on were 'system procedures')
> I would think that it would not be simple to delete a database by
> mistake - I would expect at least a message saying "are you sure"?
> Monday I come back to face the music - so does anybody know how this
> could happen?
> -- Marvin

I deleted an important database by accident!

I just got a new job at a new company, and I had a network terminal
with sql server which accessed a list of databases. One of them was
the database I was expected to work with.
The first day I opened some stored procedures and some tables to get a
feel of how the database worked.
The next day, the database was gone.
I am new to SQL Server (though I've read books on it) and I wonder if
I deleted the database by mistake. For instance, I double clicked on
some of the stored procedures to open them. Perhaps that runs them
instead of opening them and they delete the database? (Some of the
procedures I clicked on were 'system procedures')
I would think that it would not be simple to delete a database by
mistake - I would expect at least a message saying "are you sure"?
Monday I come back to face the music - so does anybody know how this
could happen?
-- Marvin
Hi
No , If you double click on stored procedure that won't drop the database as
you describe that.
Yes , if ou delete the db via EM , it always asks you "are you sure...."
bit not if you run DROP DATABASE... via QA.
Also , if some users were connected to the db you also get a message that
'db is in use..."
<COHENMARVIN@.lycos.com> wrote in message
news:67a8223a-4a1c-4eff-9ea8-9eb32417a0b8@.8g2000hse.googlegroups.com...
>I just got a new job at a new company, and I had a network terminal
> with sql server which accessed a list of databases. One of them was
> the database I was expected to work with.
> The first day I opened some stored procedures and some tables to get a
> feel of how the database worked.
> The next day, the database was gone.
> I am new to SQL Server (though I've read books on it) and I wonder if
> I deleted the database by mistake. For instance, I double clicked on
> some of the stored procedures to open them. Perhaps that runs them
> instead of opening them and they delete the database? (Some of the
> procedures I clicked on were 'system procedures')
> I would think that it would not be simple to delete a database by
> mistake - I would expect at least a message saying "are you sure"?
> Monday I come back to face the music - so does anybody know how this
> could happen?
> -- Marvin

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

sql

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

I can't deploy a Cube

I have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company (VALLEY).

I have created a Cube with the wizard to test Analysis Services 2005 and see the result after the deployment. The cube works with a database called ROI on the server VALLEY,

But, when I try to deploy the cube, I have this error message:

" the user XXXX don't have permission to modify the object or the object does not exist"

I don't know if I must configure some specific access.

Could you help me please, I search a solution since 2 days with any results.

Betty

Betty,

This is probably one of two things:

- Your impersonation information is not correct, for the AS server

- The user, specified in the impersonation config, is not a member of the SQLSERVER2005MSOLAP... group.

Post back if this still does not fix the issue...

|||

Where can I add the user into the SQLSERVER2005MSOLAP group?

And can you confirm than the impersonation information corresponds to the login and password to connect to the database or not?

I have create a cube with the database of the tutorial and i can't deploy it too so I think it' not a problem with the impersonation information but if I'm wrong, say it.

Betty

|||

You can add the user to the group through the Local Users and Groups menu.

( right click "My computer" -> MANAGE -> expand Local Users and Groups -> click Groups )

The group should be named something like SQL2005OLAPUSERS$<Boxname>$mssqlserver depending on set up. This was OLAP Administrators in SQL 2000, I believe.

The impersonation credentials may or may not be be the same to connect to the DB, but I would recommend trying whatever username/password you are using to connect to Analysis Services through Visual Studio.

Tell me if that helps,

Tristan

|||

Sorry but all that don't resolve my problem

|||I got the same error. Connect to Analysis services. Right click on the analysis services server. Go to security and add yourself using the domain/user id.|||

i have installed the client version of Sql Server 2005 on my machine and the server version is Installed on a server of my company.

But, when I try to deploy the cube, I have this error message:

Error 1 The project could not be deployed to the "company server name" server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0

i dont know is it configaration mistake or the cube creation mistake

Could you help me please

i can not make query for any information in arabic language

HI,

i work on Sql Developer Edition when i select for any Company name in arabic it does not get any data ,why? although my data are inserted by arabic language,please help me asap,thank you

and my code like this

use today

select CatID from dbo.tbl_Categories
where CatName like '%???????%'

Try to set the default collation to "Arabic_CL_AS"

|||

hi,

please tell me from where can i set that? or if i use specific syntax please send it to me,thank you.

|||try this:

alter table tbl_Categoriesalter column CatNamevarchar(100) COLLATE Arabic_CI_AI

Note the collation provided for this column. Collation is used by SQL Server to store data for different languages. Have a look at COLLATE or COLLATION in BOL. You can use

select *from ::fn_helpcollations()

to check all the installed collations on your server.

Hope this will help.

|||

How to change default collate in SQL
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36707

|||

Hi,

by the way i finished from added may data to database in arabic language i made import from Excel file but the problem is when i make query on arabic data i recieved no row selected how is?,thank you

|||

hi,

i still face the problem, by the way i finished from added my data to database in arabic language i made import from Excel file but the problem is when i make query on arabic data i recieved no row selected how is?,help me,thank you

|||

First of all, you can run the alter table query I provided earlier any time whether your table contains data or not. One more thing is that you can use collation at the time of writing select query too, the syntax is below:

select *from <table name>where <column name>like'<value>' collate Arabic_CI_AI

Now the comparison will be made using the Arabic_CI_AI collate for this select. As I've told earlier there are so many collates to choose from ( even for Arabic ), which differ in some way or another. Choose the collate you want to use and either alter the table permanently or at the time of selecting the values. Just go and have a look at BOL for COLLATE.

Hope this will help

|||

hi,

i altered my table with Arabic_CI_AI after that i write your syntax but still no new :S,thanks

|||

How can I reach all the possible collation options for Arabic?

This is my SQL statement which returns NO VALUES:

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '%?%' COLLATE Arabic_CI_AI)

I also tried

SELECT ArtistID, Name
FROM dbo.Artist
WHERE (Name LIKE '%?%' COLLATE Arabic_CL_AS)

as was suggested in one of the forum replies, but it gives an error message saying :
"Invalid Collation" with an error source: " .NetSqlClient Data Provider"

Thanks.

i am geeting an idea

any one please help me
In our company we maitain a table for cheques issued for
example the description is
cheques_issued(chq_no int, reciever_name varchar(30))
we ha ve so many number of records in this table with
defferent chq numbers.
one day our senio manager came to me and given a list of
100 numbers collected from the recievers and asked me to
find out how many of the numbers in the list of 100 given
by him are not there in the table.
is there any method to find it direectly trough a querry?
if i create a temp table i hve to use 100 insert
statements to send 100 values into temparary table and
compare the temp table with cheques_issued table. This is
problematic for me.
please give me any solution.Once you have your 100 numbers in a #temp table (called #temp100 here),
there are plenty of ways. Let's assume this DDL and sample data:
CREATE TABLE cheques_issued(chq_no INT)
INSERT cheques_issued VALUES(1)
INSERT cheques_issued VALUES(2)
INSERT cheques_issued VALUES(3)
INSERT cheques_issued VALUES(4)
CREATE TABLE #temp100(chq_no INT)
INSERT #temp100 VALUES(1)
INSERT #temp100 VALUES(2)
INSERT #temp100 VALUES(3)
INSERT #temp100 VALUES(4)
INSERT #temp100 VALUES(5)
INSERT #temp100 VALUES(6)
INSERT #temp100 VALUES(7)
You could get your results using a simple NOT IN
SELECT COUNT(*) FROM #temp100 WHERE chq_no NOT IN (SELECT chq_no FROM
cheques_issued)
Or a NOT EXISTS
SELECT COUNT(*) FROM #temp100 WHERE NOT EXISTS (SELECT chq_no FROM
cheques_issued WHERE chq_no = #temp100.chq_no)
Or a LEFT JOIN
SELECT COUNT(*) FROM #temp100
LEFT OUTER JOIN cheques_issued c
ON #temp100.chq_no = c.chq_no
WHERE c.chq_no IS NULL
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"kalyana chakravarthi" <kalyannow@.yahoo.com> wrote in message
news:05d001c3c069$3a4a6900$a401280a@.phx.gbl...
> any one please help me
> In our company we maitain a table for cheques issued for
> example the description is
> cheques_issued(chq_no int, reciever_name varchar(30))
> we ha ve so many number of records in this table with
> defferent chq numbers.
> one day our senio manager came to me and given a list of
> 100 numbers collected from the recievers and asked me to
> find out how many of the numbers in the list of 100 given
> by him are not there in the table.
> is there any method to find it direectly trough a querry?
> if i create a temp table i hve to use 100 insert
> statements to send 100 values into temparary table and
> compare the temp table with cheques_issued table. This is
> problematic for me.
> please give me any solution.
>

hyperthreaded processors running on win2k

My company is currently deploying new hardware for our new hosting site. We
have all new servers. 4 of them are running Win2k standard server and are
web servers, and 3 of them are win2k advanced servers running SQL Server
2000.
These servers have dual Xeons, so if hyperthreading is on, win2k sees 4
procs.
We have been working on tracking down speed issues for quite a while and
recently realized (by accident) , that the webservers run WAY faster when
hyperthreading is turned off. We are using MS Application Center Test for
load testing, so that's how we determined the performance gain.
I've been trying to find a clear cut answer about whether or not you should
use hyperthreading on win2k server, but I haven't found one. Although I have
seen several references to this issue and seen posts of people saying to
shut if off. It seems win2k doesn't know the difference between logical and
physical processors, so maybe that's why it's not good for win2k. ?
Does anyone know where I could find more info on this? We're going to turn
off hyperthreading on the webservers obviously because they perform better,
but I'm wondering if we will see performance gains by also shutting of
hyperthreading on the win2k SQL Servers. ?
Any insight into this would be great.
Thanks.
Personally, I have had fairly good experience with Hyperthreading. First,
make sure you are on build 816 or later. There were some significant
HT-friendly modifications in that build. The easiest way is to download the
818 security hotfix and apply it. That way, you do not have to open a case
to get it. Regardless, you must be on SP2 or higher to get SQL to count the
processors correctly for licensing purposes.
Finally, 2 virtual HT processors run about 20-30% faster using SQL than the
same processer set to non HT. SQL still counts them as full processors for
parallelism, meaning that you can over-parallel a query and drag system
performance down. I manually set MAX DEGREE OF PARALLELISM (MAXDOP) to no
higher than the actual physical processor count.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mark" <maxmann@.kc.rr.com> wrote in message
news:uyOJwARJEHA.1312@.TK2MSFTNGP12.phx.gbl...
> My company is currently deploying new hardware for our new hosting site.
We
> have all new servers. 4 of them are running Win2k standard server and are
> web servers, and 3 of them are win2k advanced servers running SQL Server
> 2000.
> These servers have dual Xeons, so if hyperthreading is on, win2k sees 4
> procs.
> We have been working on tracking down speed issues for quite a while and
> recently realized (by accident) , that the webservers run WAY faster when
> hyperthreading is turned off. We are using MS Application Center Test for
> load testing, so that's how we determined the performance gain.
> I've been trying to find a clear cut answer about whether or not you
should
> use hyperthreading on win2k server, but I haven't found one. Although I
have
> seen several references to this issue and seen posts of people saying to
> shut if off. It seems win2k doesn't know the difference between logical
and
> physical processors, so maybe that's why it's not good for win2k. ?
> Does anyone know where I could find more info on this? We're going to
turn
> off hyperthreading on the webservers obviously because they perform
better,
> but I'm wondering if we will see performance gains by also shutting of
> hyperthreading on the win2k SQL Servers. ?
>
> Any insight into this would be great.
> Thanks.
>

hyperthreaded processors running on win2k

My company is currently deploying new hardware for our new hosting site. We
have all new servers. 4 of them are running Win2k standard server and are
web servers, and 3 of them are win2k advanced servers running SQL Server
2000.
These servers have dual Xeons, so if hyperthreading is on, win2k sees 4
procs.
We have been working on tracking down speed issues for quite a while and
recently realized (by accident) , that the webservers run WAY faster when
hyperthreading is turned off. We are using MS Application Center Test for
load testing, so that's how we determined the performance gain.
I've been trying to find a clear cut answer about whether or not you should
use hyperthreading on win2k server, but I haven't found one. Although I have
seen several references to this issue and seen posts of people saying to
shut if off. It seems win2k doesn't know the difference between logical and
physical processors, so maybe that's why it's not good for win2k. ?
Does anyone know where I could find more info on this? We're going to turn
off hyperthreading on the webservers obviously because they perform better,
but I'm wondering if we will see performance gains by also shutting of
hyperthreading on the win2k SQL Servers. ?
Any insight into this would be great.
Thanks.Personally, I have had fairly good experience with Hyperthreading. First,
make sure you are on build 816 or later. There were some significant
HT-friendly modifications in that build. The easiest way is to download the
818 security hotfix and apply it. That way, you do not have to open a case
to get it. Regardless, you must be on SP2 or higher to get SQL to count the
processors correctly for licensing purposes.
Finally, 2 virtual HT processors run about 20-30% faster using SQL than the
same processer set to non HT. SQL still counts them as full processors for
parallelism, meaning that you can over-parallel a query and drag system
performance down. I manually set MAX DEGREE OF PARALLELISM (MAXDOP) to no
higher than the actual physical processor count.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mark" <maxmann@.kc.rr.com> wrote in message
news:uyOJwARJEHA.1312@.TK2MSFTNGP12.phx.gbl...
> My company is currently deploying new hardware for our new hosting site.
We
> have all new servers. 4 of them are running Win2k standard server and are
> web servers, and 3 of them are win2k advanced servers running SQL Server
> 2000.
> These servers have dual Xeons, so if hyperthreading is on, win2k sees 4
> procs.
> We have been working on tracking down speed issues for quite a while and
> recently realized (by accident) , that the webservers run WAY faster when
> hyperthreading is turned off. We are using MS Application Center Test for
> load testing, so that's how we determined the performance gain.
> I've been trying to find a clear cut answer about whether or not you
should
> use hyperthreading on win2k server, but I haven't found one. Although I
have
> seen several references to this issue and seen posts of people saying to
> shut if off. It seems win2k doesn't know the difference between logical
and
> physical processors, so maybe that's why it's not good for win2k. ?
> Does anyone know where I could find more info on this? We're going to
turn
> off hyperthreading on the webservers obviously because they perform
better,
> but I'm wondering if we will see performance gains by also shutting of
> hyperthreading on the win2k SQL Servers. ?
>
> Any insight into this would be great.
> Thanks.
>

hyperthreaded processors running on win2k

My company is currently deploying new hardware for our new hosting site. We
have all new servers. 4 of them are running Win2k standard server and are
web servers, and 3 of them are win2k advanced servers running SQL Server
2000.
These servers have dual Xeons, so if hyperthreading is on, win2k sees 4
procs.
We have been working on tracking down speed issues for quite a while and
recently realized (by accident) , that the webservers run WAY faster when
hyperthreading is turned off. We are using MS Application Center Test for
load testing, so that's how we determined the performance gain.
I've been trying to find a clear cut answer about whether or not you should
use hyperthreading on win2k server, but I haven't found one. Although I have
seen several references to this issue and seen posts of people saying to
shut if off. It seems win2k doesn't know the difference between logical and
physical processors, so maybe that's why it's not good for win2k. ?
Does anyone know where I could find more info on this? We're going to turn
off hyperthreading on the webservers obviously because they perform better,
but I'm wondering if we will see performance gains by also shutting of
hyperthreading on the win2k SQL Servers. ?
Any insight into this would be great.
Thanks.Personally, I have had fairly good experience with Hyperthreading. First,
make sure you are on build 816 or later. There were some significant
HT-friendly modifications in that build. The easiest way is to download the
818 security hotfix and apply it. That way, you do not have to open a case
to get it. Regardless, you must be on SP2 or higher to get SQL to count the
processors correctly for licensing purposes.
Finally, 2 virtual HT processors run about 20-30% faster using SQL than the
same processer set to non HT. SQL still counts them as full processors for
parallelism, meaning that you can over-parallel a query and drag system
performance down. I manually set MAX degree OF PARALLELISM (MAXDOP) to no
higher than the actual physical processor count.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mark" <maxmann@.kc.rr.com> wrote in message
news:uyOJwARJEHA.1312@.TK2MSFTNGP12.phx.gbl...
> My company is currently deploying new hardware for our new hosting site.
We
> have all new servers. 4 of them are running Win2k standard server and are
> web servers, and 3 of them are win2k advanced servers running SQL Server
> 2000.
> These servers have dual Xeons, so if hyperthreading is on, win2k sees 4
> procs.
> We have been working on tracking down speed issues for quite a while and
> recently realized (by accident) , that the webservers run WAY faster when
> hyperthreading is turned off. We are using MS Application Center Test for
> load testing, so that's how we determined the performance gain.
> I've been trying to find a clear cut answer about whether or not you
should
> use hyperthreading on win2k server, but I haven't found one. Although I
have
> seen several references to this issue and seen posts of people saying to
> shut if off. It seems win2k doesn't know the difference between logical
and
> physical processors, so maybe that's why it's not good for win2k. ?
> Does anyone know where I could find more info on this? We're going to
turn
> off hyperthreading on the webservers obviously because they perform
better,
> but I'm wondering if we will see performance gains by also shutting of
> hyperthreading on the win2k SQL Servers. ?
>
> Any insight into this would be great.
> Thanks.
>

hypertext links & SQL 7 databases

I have arrived at a site and been thrown this curve ball.
This company have an Access 97 application which
successfully stores hypertext links. A consultancy came
into to try and Xfer all the functionality to SQL 7 (a
financial decision & because it's there!!). The
consultancy's conclusion was for the company to upgrade
SQL from 7 to 2000 in order for hyperlinks to be stored
(or used) successfully. The consultancy did not give a
definite reason for their conclusion & the company person
involved needs a reason why SQL7 is not a viable option.
Anyone out there know why?
I have trawled the KB and searched the web for answers
without success.
Thanks in advance,
Euan.
There is no such thing as a hyperlink datatype in either SQL 7 or SQL 2000.
You're going to have to code the <a href=> part yourself, either in the
query or in the front-end application.
http://www.aspfaq.com/
(Reverse address to reply.)
"Euan" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c4a0b7$afb4d660$a301280a@.phx.gbl...
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
|||Hi
Neither SQL 7 or 2000 have a "hyperlink" data type. You would have to store
it in a char/varchar field and it would be up to the application to display
it as a hyperlink.
Regards
Mike
"Euan" wrote:

> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
>

hypertext links & SQL 7 databases

I have arrived at a site and been thrown this curve ball.
This company have an Access 97 application which
successfully stores hypertext links. A consultancy came
into to try and Xfer all the functionality to SQL 7 (a
financial decision & because it's there!!). The
consultancy's conclusion was for the company to upgrade
SQL from 7 to 2000 in order for hyperlinks to be stored
(or used) successfully. The consultancy did not give a
definite reason for their conclusion & the company person
involved needs a reason why SQL7 is not a viable option.
Anyone out there know why?
I have trawled the KB and searched the web for answers
without success.
Thanks in advance,
Euan.There is no such thing as a hyperlink datatype in either SQL 7 or SQL 2000.
You're going to have to code the <a href=> part yourself, either in the
query or in the front-end application.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Euan" <anonymous@.discussions.microsoft.com> wrote in message
news:002901c4a0b7$afb4d660$a301280a@.phx.gbl...
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.|||Hi
Neither SQL 7 or 2000 have a "hyperlink" data type. You would have to store
it in a char/varchar field and it would be up to the application to display
it as a hyperlink.
Regards
Mike
"Euan" wrote:
> I have arrived at a site and been thrown this curve ball.
> This company have an Access 97 application which
> successfully stores hypertext links. A consultancy came
> into to try and Xfer all the functionality to SQL 7 (a
> financial decision & because it's there!!). The
> consultancy's conclusion was for the company to upgrade
> SQL from 7 to 2000 in order for hyperlinks to be stored
> (or used) successfully. The consultancy did not give a
> definite reason for their conclusion & the company person
> involved needs a reason why SQL7 is not a viable option.
> Anyone out there know why?
> I have trawled the KB and searched the web for answers
> without success.
> Thanks in advance,
> Euan.
>