does sql server support

Hi,

I am very new with SQL server and i have a web server some one asked me does SQL Server 2000 Express support full text search?

Please answer this question

Regards

SQL Server 2005 Express w/ Advanced Services supports FullText Search.

Check out this link:- http://msdn2.microsoft.com/en-gb/express/aa718379.aspx

SQL Server 2000 doesn't have an express edition per se. It has the MSDE version which doesn't support FTS.

|||

Hi,

is SQL Server 2005 Express w/ Advanced Services free? how can i download it or how much does it cost?

|||

You can download SQL Server 2005 Express with Advanced Services from this location. (I've added some additional links that you may find beneficial.

SQL Server 2005 Express Edition (Advanced/SSMS/BI Toolkit)
http://tinyurl.com/yelwr9 (SSMSE)
http://tinyurl.com/ovcx3(Advanced Services)

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F

SQL Server 2005 Express Video Learning
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1

does sql server support

Hi,

I am very new with SQL server and i have a web server some one asked me does SQL Server 2000 Express support full text search?

Please answer this question

Regards

SQL Server 2005 Express w/ Advanced Services supports FullText Search.

Check out this link:- http://msdn2.microsoft.com/en-gb/express/aa718379.aspx

SQL Server 2000 doesn't have an express edition per se. It has the MSDE version which doesn't support FTS.

|||

Hi,

is SQL Server 2005 Express w/ Advanced Services free? how can i download it or how much does it cost?

|||

You can download SQL Server 2005 Express with Advanced Services from this location. (I've added some additional links that you may find beneficial.

SQL Server 2005 Express Edition (Advanced/SSMS/BI Toolkit)
http://tinyurl.com/yelwr9 (SSMSE)
http://tinyurl.com/ovcx3(Advanced Services)

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F

SQL Server 2005 Express Video Learning
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1

sql

Does SQL Server 2005 Express support Web/Internet Replication to other SQL Server Express Client

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

Shabby wrote:

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

You have to sync to a SS2005 with IIS. Replication doesn't support sync between sql express.

Shabby wrote:

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

No Sql 2005 express cannot sync with sql 2005 express directly.

|||

SQL Server 2005 Express Edition supports being a replication subscriber only. See http://msdn2.microsoft.com/en-us/library/ms165700.aspx The publisher and distributor must be higher SKUs of SQL Server 2005. i.e. Enterprise, Standard, Workgroup. As for synching via IIS over the internet with merge replication, this is supported by the SQL Server 2005 Express client.

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

|||

Peng Song wrote:

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

does the client (subscriber) running on sql server express has to have IIS or only the publishing pc? thanks

sql

Does SQL Server 2005 Express support Web/Internet Replication to other SQL Server Express Cl

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

Shabby wrote:

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

You have to sync to a SS2005 with IIS. Replication doesn't support sync between sql express.

Shabby wrote:

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

No Sql 2005 express cannot sync with sql 2005 express directly.

|||

SQL Server 2005 Express Edition supports being a replication subscriber only. See http://msdn2.microsoft.com/en-us/library/ms165700.aspx The publisher and distributor must be higher SKUs of SQL Server 2005. i.e. Enterprise, Standard, Workgroup. As for synching via IIS over the internet with merge replication, this is supported by the SQL Server 2005 Express client.

Hope this helps,

Tom

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

|||

Peng Song wrote:

Express edition can only be used as a subscriber, including direct SQL replication or web sync. Please take a look at this link for replication features supported by various editions (http://msdn2.microsoft.com/en-us/library/ms143761.aspx).

Thanks,

Peng

does the client (subscriber) running on sql server express has to have IIS or only the publishing pc? thanks

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluation/features/choosing.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> > Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> > protocols by using the Virtual Interface Architecture (VIA), but it
> doesn't
> > say explicitly : whether SQL Server 2000 Standard Edition also supports
> VIA.
> > So I don't know do I have to buy the Enterprise Edition if I want to use
> SAN
> > as the storage area for my SQL 2000 application.
> > Can anybody help me on it because the Enterprise Edition is much
expensive
> > than the Standard Edition.
> >
> >
>

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.
No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evaluat.../choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>
|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different[vbcol=seagreen]
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive
>
sql

Does SQL Server 2000 Standard Edition does not support SAN ?

Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
protocols by using the Virtual Interface Architecture (VIA), but it doesn't
say explicitly : whether SQL Server 2000 Standard Edition also supports VIA.
So I don't know do I have to buy the Enterprise Edition if I want to use SAN
as the storage area for my SQL 2000 application.
Can anybody help me on it because the Enterprise Edition is much expensive
than the Standard Edition.No, Standard edition does not support SAN. Check
http://www.microsoft.com/sql/evalua...s/choosing.asp.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||To add to Dejan's response, the SAN acronym has 2 completely different
meanings depending on the context. SAN can refer to a Storage Area Network
or a System Area Network. All editions of SQL Server support Storage Area
Networks, which is a common data storage technology. You don't need
Enterprise Edition for this.
However, SQL Server Enterprise Edition is needed to support System Area
Network, which provides a high-speed network communication between different
servers.
Hope this helps.
Dan Guzman
SQL Server MVP
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c7kl9m$1i61212@.imsp212.netvigator.com...
> Microsoft web site says SQL Server 2000 Enterprise Edition supports SAN
> protocols by using the Virtual Interface Architecture (VIA), but it
doesn't
> say explicitly : whether SQL Server 2000 Standard Edition also supports
VIA.
> So I don't know do I have to buy the Enterprise Edition if I want to use
SAN
> as the storage area for my SQL 2000 application.
> Can anybody help me on it because the Enterprise Edition is much expensive
> than the Standard Edition.
>|||Thanks for your reply.
I mean 'Storage Area Network'.
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:ejil$OdNEHA.3052@.TK2MSFTNGP12.phx.gbl...
> To add to Dejan's response, the SAN acronym has 2 completely different
> meanings depending on the context. SAN can refer to a Storage Area
Network
> or a System Area Network. All editions of SQL Server support Storage Area
> Networks, which is a common data storage technology. You don't need
> Enterprise Edition for this.
> However, SQL Server Enterprise Edition is needed to support System Area
> Network, which provides a high-speed network communication between
different
> servers.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c7kl9m$1i61212@.imsp212.netvigator.com...
> doesn't
> VIA.
> SAN
expensive[vbcol=seagreen]
>

Does rolling a cluster create down time?

We have about 40 DB's blackening 40 web sites running on a single
SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to the
next I'm wondering exactly what sort of outage our clients would see. Since
the entire cluster rolls in under a minute would there just be a delay on
the web sites with data requests in response from the web/ODBC side or would
there be an ODBC failure. Also, with regards to active web sessions, would
clients mid transaction on the web pages need to restart their transaction
or would there be a short wait during the SQL roll and then they could
proceed with the transaction (or would they need to start all over again).
I guess I'm wondering if I need to add the 1 minute of roll time into our
annual downtime calculation if the clients see an application
failure/unavailability.
On the roll all client connections are lost and must be restarted. As for
what exactly happens, well that depends on the application. If the rows are
returned locally or if they are stored on the web server. And at what stage
in the process each client was in.
Bottom line, in most cases they either hit F5 (refresh) or never notice.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||What the clients see or how it affects their transactions depends solely on
how the client app was written. It must be cluster aware. By that I mean
it must be able to detect a connection failure and reconnect. It must also
be able to resubmit the current transaction as it will be rolled back on the
server side when the cluster comes back up.
Andrew J. Kelly SQL MVP
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||A cluster host transition is exactly like a SQL server stop-start. All
transactions are rolled forward or back at startup. The server is down
during the transition. The client application will see a connection timeout
or a query timeout or a broken connection. Whether the application traps
that or displays that to the end-user depends on the skill of the programmer
who wrote it.
Short answer, a cluster transition is downtime.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Mike B." <Autobahn97@.hotmail.com> wrote in message
news:eS8jOB3XEHA.3596@.tk2msftngp13.phx.gbl...
> We have about 40 DB's blackening 40 web sites running on a single
> SQL2k/Win2003 an A/P cluster. When I roll the cluster from one node to
the
> next I'm wondering exactly what sort of outage our clients would see.
Since
> the entire cluster rolls in under a minute would there just be a delay on
> the web sites with data requests in response from the web/ODBC side or
would
> there be an ODBC failure. Also, with regards to active web sessions,
would
> clients mid transaction on the web pages need to restart their transaction
> or would there be a short wait during the SQL roll and then they could
> proceed with the transaction (or would they need to start all over again).
> I guess I'm wondering if I need to add the 1 minute of roll time into our
> annual downtime calculation if the clients see an application
> failure/unavailability.
>
|||During the failover process, any active connections are broken. For Web browser users, a simple refresh of the Web page should create a new database connection. In a more traditional client/server application, or
one that relies heavily on a middle tier, application designers may want to consider checking to see whether the connection exists, and if not, reconnect. Therefore, whatever the user was working on when the server
went down may not be completed, unless the transaction completes before the server goes down or the transaction is handled within the application.
For more information, see the Knowledge Base article "Q273673 - Virtual Server Client Connections Must be Controlled by Clients" at:
http://support.microsoft.com/?kbid=273673
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Does anyone know of a web based SQL Query tool?

Hi

I want to be able t give my users access to our SQL server database via a eb application published o our web server. I have found one freeware tool but it only supports SQL Server 2000 and the developer doesn't returns any emails.

Has anyone come across a web ui SQL query tool either freeware or one that can be purhcase

thanks for your help

Marcus

Do you just want to have a tool sending out a query from a textbox and getting the results back in a grid or something ? Or do you want tome graphical designer for your users ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

search for

SQL Server Web Data Administrator

on microsoft website

|||

Here is the link to SQL Server Web Data Administrator

http://www.microsoft.com/downloads/details.aspx?FamilyID=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en

Sethu Srinivasan, Software Design Engineer, SQL Server Manageability
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

|||ASP Enterprise Manager http://sourceforge.net/projects/asp-ent-man/

Does anyone know of a tool that allows a SQL Server database to be

Does anyone know of a web based tool that allows a SQL Server database
to be
adminstered from the Internet? (in php)Does anyone know of a web based tool that allows a SQL Server database

Quote:

Originally Posted by

to be adminstered from the Internet? (in php)

It's not in PHP but you can have a look at
myLittleAdmin for SQL Server 2005
and myLittleAdmin for SQL Server 2000
on http://www.mylittletools.net

Both have a free lite edition

Best regards

|||Not sure if it's sufficient for your purpose but have a look at MS SQL
Server Web Data Administrator
http://www.microsoft.com/downloads/...&displaylang=en

Markus

does anyone know how to open access by todays date using sql

Hi
Can anyone point me in the right direction here, I would like to open
a table in access 2003 by date. I have an asp web page which needs to
read data from a table with each days today's date (which ever day
that is) then a new table is created with today's date.
Example:
I have a table called 17-may-2007 my ASP page reads this table for
24hours then tomorrow (12:00 midnight 18th) I will have a new table
called 18-may-2007 and the old table is left behind (As 17-may-2007)
so I need my sql statement to automatically open table by today's
date.
This is what I have so far but it does not work. Any ideas
'--Start of code--
Call BarGraphSQLData( _
"SELECT id, DataReading FROM DAY(CURRENT_TIMESTAMP) ORDER BY id" ,
_
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("db/data.mdb") & ";" , _
'--End of code--
Thanks
Trevor
You might get better responses if you posted this in an Access group.
Andrew J. Kelly SQL MVP
"Trev" <trevor-dustan@.lycos.co.uk> wrote in message
news:1179408317.732724.182460@.q75g2000hsh.googlegr oups.com...
> Hi
> Can anyone point me in the right direction here, I would like to open
> a table in access 2003 by date. I have an asp web page which needs to
> read data from a table with each days today's date (which ever day
> that is) then a new table is created with today's date.
> Example:
> I have a table called 17-may-2007 my ASP page reads this table for
> 24hours then tomorrow (12:00 midnight 18th) I will have a new table
> called 18-may-2007 and the old table is left behind (As 17-may-2007)
> so I need my sql statement to automatically open table by today's
> date.
>
> This is what I have so far but it does not work. Any ideas
> '--Start of code--
> Call BarGraphSQLData( _
> "SELECT id, DataReading FROM DAY(CURRENT_TIMESTAMP) ORDER BY id" ,
> _
> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("db/data.mdb") & ";" , _
> '--End of code--
>
> Thanks
>
> Trevor
>

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.
Steve,
You may find an explanation of this at:
http://support.microsoft.com/default...b;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>
|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/default...b;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> i've
statement.
>
|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the[vbcol=seagreen]
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
msg
> statement.
>

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.Steve,
You may find an explanation of this at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> >
> > sql2k, nt5.
> > I have a stored procedure drop and re-create webtask... this is the msg
> i've
> > got when running it.
> >
> > Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL
statement.
> > [SQLSTATE 42000]
> >
> > does anyone know what it's about? thank you.
> >
> >
>|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> > Steve,
> >
> > You may find an explanation of this at:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
> >
> > Hope it helps,
> > Russell Fields
> >
> > "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> > news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> > >
> > > sql2k, nt5.
> > > I have a stored procedure drop and re-create webtask... this is the
msg
> > i've
> > > got when running it.
> > >
> > > Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL
> statement.
> > > [SQLSTATE 42000]
> > >
> > > does anyone know what it's about? thank you.
> > >
> > >
> >
> >
>

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.Steve,
You may find an explanation of this at:
http://support.microsoft.com/defaul...kb;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/defaul...kb;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> i've
statement.[vbcol=seagreen]
>|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
msg[vbcol=seagreen]
> statement.
>

Does 2k5 Reporting Services need IIS?

I'd like to produce dynamic reports via SQL Server 2k5 Reporting
Services that can be rendered in a web browser. However, I don't want
anything to do with IIS or a web server. From what I've heard,
previous version of SQL Server Reporting Services needed IIS. Is this
true for 2k5?
Thanks,
BrettRS 2005 comes with WebForm and WinForm controls for showing reports. Also, t
hese can be client side
only (where the reporting engine is essentially built into the controls). Bu
t this is about as much
as I know. I suggest you post this to an RS forum, where you are more likely
to get a precise
response.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"brett" <account@.cygen.com> wrote in message
news:1142924193.608686.191110@.z34g2000cwc.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>|||Yes, Reporting Services runs inside IIS.
"brett" <account@.cygen.com> wrote in message
news:1142924193.608686.191110@.z34g2000cwc.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>

Does 2k5 Reporting Services need IIS?

I'd like to produce dynamic reports via SQL Server 2k5 Reporting
Services that can be rendered in a web browser. However, I don't want
anything to do with IIS or a web server. From what I've heard,
previous version of SQL Server Reporting Services needed IIS. Is this
true for 2k5?
Thanks,
BrettYes
"brett" <account@.cygen.com> schrieb im Newsbeitrag
news:1142925712.659616.140540@.t31g2000cwb.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>|||Also, VS 2005 comes with two controls. A winform and a webform control.
These controls can either work with RS or can run in local mode where no
server is required. It takes some more work, especially for subreports, jump
to report etc but it works quite well. In local mode you give it the report
and the data and then it renders it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"brett" <account@.cygen.com> wrote in message
news:1142925712.659616.140540@.t31g2000cwb.googlegroups.com...
> I'd like to produce dynamic reports via SQL Server 2k5 Reporting
> Services that can be rendered in a web browser. However, I don't want
> anything to do with IIS or a web server. From what I've heard,
> previous version of SQL Server Reporting Services needed IIS. Is this
> true for 2k5?
> Thanks,
> Brett
>

Documenting the Database

Hi all,

I need some asistance. I use the MSDE SQL server inside the Web matrix project. I am trying to print the database and its SQL commands in order to add it to my project's documentation.

Can any body tell me how to do this?

Thanx a lot in advace.You might want to try this -http://www.eggheadcafe.com/articles/20040913.asp.
s/Don

Documentation to get started

What is the best online documentation either on the Web or installed
with
SQL Server that I could use to get started? I want to jump in and
start
creating tables, etc for applications.

Also, what is the most recommended text for converting my DBA
experience from other database to SQL Server.

Thanks
Bill.Books Online, SQL Server's official documentation installed
with SQL Server, is a good place to start. There are many
good SQL Server books. One of them which I like is:

The Guru's Guide to Transact-SQL by Ken Henderson
(publisher: Addison Wesley).

Note that this is not an official endorsement!
--
Arun Marathe
Program Manager
SQL Server Query Processor
Microsoft Corporation

Disclaimers:
(1) This posting is provided "AS IS" with no warranties, and confers no
rights.
(2) Use of included script samples are subject to the terms specified at:
http://www.microsoft.com/info/cpyright.htm

"Bill" <bill_ralenkotter@.yahoo.com> wrote in message
news:96254b32.0309040631.21c23b1b@.posting.google.c om...
> What is the best online documentation either on the Web or installed
> with
> SQL Server that I could use to get started? I want to jump in and
> start
> creating tables, etc for applications.
> Also, what is the most recommended text for converting my DBA
> experience from other database to SQL Server.
> Thanks
> Bill.|||Bill

As you will soon find there are dozens of useful SQL Server Web sites.
These are two of the best ones to help get you started.

http://www.microsoft.com/technet/ne...rver&frame=true

http://www.sql-server-performance.com/

Hope these help

John|||Thanks for the links I will continue to look at them.

One thinkn in particular that I am after are instructions
for connecting to the DB right after it is installed.
I think there is a test database and I want to log into that.
I am probably not seeing these instructions on the installed
docs?

Thanks
Bill.

Document Map not appearing in Web Application

I have designed a report and everything is fine except when I view it in my vb.net application. When I view the report through the normal Reporting Services portal my document map appears fine without issue. However when I run it through my application the document map does not appear and the button is not available.

Here is the setup

I have a sql table that stores

* ReportID
* Title
* Keywords
* Serverpath

I then have an aspx page that simply has the webform report viewer with the following code. So I have a data grid populated from the reportinfo table with a Link on each title that passes the ServerPath to the reportviewer page. The URL that is genereated after I recently added the commands to the end of my report path through suggestion of another forum and that still didn't resolve the issue. Anyone out there have any suggestions on how to get the document map to show in the reportviewer webform?

The only thing I can think of is it has 3 parameters is there something special I am missing?

URL Genereated

http://perfectassistant.director-software.com/adminpages/reports/reportviewer.aspx?Path=/PAData/Student%20Information/Member%20Ensemble%20Listing%20Report&rc:Toolbar=True&rc:DocMap=true&rc:Area=Report

Page Load Code

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Not IsPostBack Then

Dim rptPath As String

rptPath = Request("Path")

Dim rs As New ReportingService

ReportViewer1.ServerReport.ReportServerCredentials = New ReportViewerCredentials("USERNAME", "PASSWORD", "")

ReportViewer1.ServerReport.ReportServerUrl = New Uri("http://SERVERNAME.com/reportserver")

ReportViewer1.AsyncRendering = False

ReportViewer1.ShowDocumentMapButton = True

ReportViewer1.DocumentMapCollapsed = False

ReportViewer1.ServerReport.ReportPath = rptPath

End If

End Sub

Document Maps don't show when you have the HTML viewer control set to AsyncRendering=false.

See this article for an explanation why (it has to do with the fact that we don't use frames):

http://msdn2.microsoft.com/en-us/library/ms252090.aspx

Do you see this problem ?

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
private string _connectionString = ConfigurationSettings.AppSettings["ConnectionString"];

protected void Page_Load(object sender, System.EventArgs e)
{
if (!(Page.IsPostBack))
GetData();
}

#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}

///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{

}
#endregion

private void GetData()
{
SqlConnection connection = null;
SqlCommand command = null;
SqlDataReader reader = null;
SqlParameter parameter = null;

try
{
connection = new SqlConnection(_connectionString);
connection.Open();
command = new SqlCommand("select * from nametable where id = @.id", connection);
parameter = new SqlParameter("@.id", SqlDbType.Int);
parameter.Value = 1;
command.Parameters.Add(parameter);
reader = command.ExecuteReader(CommandBehavior.CloseConnection);

if (reader.HasRows)
{
reader.Read();

nameTextBox.Text = Convert.ToString(reader["name"]);
}
}
catch (Exception ex)
{
// throw;
}
finally
{
if (reader != null)
((IDisposable)reader).Dispose();

if (connection != null)
{
if (connection.State == ConnectionState.Open)
connection.Close();

connection.Dispose();
}
}
}

private void UpdateData()
{
SqlConnection connection = null;
SqlCommand command = null;
SqlParameter parameter = null;

try
{
connection = new SqlConnection(_connectionString);
connection.Open();
command = new SqlCommand("update nametable set Name.name = @.Name where id = @.id", connection);
parameter = new SqlParameter("@.Name", SqlDbType.VarChar);
parameter.Value = nameTextBox.Text;
command.Parameters.Add(parameter);
parameter = new SqlParameter("@.id", SqlDbType.Int);
parameter.Value = 1;
command.Parameters.Add(parameter);

command.ExecuteNonQuery();
}
catch (Exception ex)
{

finally
{
if (connection != null)
{
if (connection.State == ConnectionState.Open)
connection.Close();

connection.Dispose();
}
}

protected void TextBox1_TextChanged(object sender, EventArgs e)
{
Label1.Text = nameTextBox.Text;
}
protected void updateButton_Click(object sender, EventArgs e)
{
UpdateData();
}
}

*** i keep getting this stupid message : Error1} expected *** pls help as i cant see where this needs to go..

your catch block in the UpdateData method has an unclosed open bracket.