Drawing error when rendering report in PDF

Hi
We had run SQL Server Report Services Service PAck2 and after installing that we are not able to open reports in PDF format. it gives drawing error .

Any help in this regard is appreciated.What the exact error message ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||Hi Jens
The exact error message would be "A Drawing Error Occured"

As I had told we are having SQL Server 2000, SQL Server 2000 Reporting Services. Somebody in the forum suggested to install service pack2 which we did for earlier another issue where it was printing extra pages in both Excel and PDF. So after installing sp2 the PDF got messed up.

Any help in this regard is appreciated

Thanks|||

Hi,

This is probably an error in SP2, you can get a fix from Microsoft by contacting them on the mentioned ways here: http://support.microsoft.com/kb/912424/en-us

This is a PDF Error, probably a ressources not reachable or an out-of-memory error.

http://support.microsoft.com/kb/912424/en-us

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||Hi
Thanks Jens the link helped us solve the issue.There is another related issue which if you could show us a little direction in solving it. Here is the issue

We are working on SQL Server Reporting Services 2000. We designed a

report and exported the same into excel. The original report has lets

say one page information, then before printing when we see print

preview it shows up an extra blank page and similarly if the there are

two pages in the report ,in the preview we are seeing 4 pages ie two

extra blank pages. Any help to solve this issue would be appreciated.

The same thing we are exporting in PDF format also and here to same

issue.

We are in need of a solution. It would be of great help if you could help us in getting a solution to this issue.
We have SQL Server 2000 and SQL Server 2000 Reporting services and Microsoft Office 2003

Thanks
|||Thats a really common problem. You defined the report margins to big. If the report exceeds the page format it will break the report to multiple pages. So make sure that the visible area of your report (and the additional borders) does not exceed the format specified on the report properties. Sizing the report will let you keep your report on one page per report page. Its something like playing around with the margins and sizes to fit all your data on one page.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

DR - Master db restore

I am doing a DR test and running the command sqlservr.exe -c -m to get the server in single user mode. How long does this command normally run
Thanks
JessI am assuming you are running this in a command window. If so, it will run
until you hit Ctrl-C and answer yes to the prompt. When you start SQL
server this way it is starting as an application.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi,
As soon you run sqlservr.exe -c -m from command prompt the sql server starts
in Single user mode. One user can login to SQL server and perform all the
activities. After that you can close the sqlservr.exe which is running from
command prompt using CNTL and C key.
Alternately,
You can start the SQL server in Single user mode using
COntrol panel -- Admin tools -- Services , Select SQL server Services and in
parameters you can put -m and click the start button. This will also start
the SQL server in single user mode. Once the actitivty is completed you can
just restart the service to make it Multiuser.
Thanks
Hari
MCDBA
"Jess" <anonymous@.discussions.microsoft.com> wrote in message
news:3FAD59F2-DA04-490D-B131-EE5D92F6AB9C@.microsoft.com...
> I am doing a DR test and running the command sqlservr.exe -c -m to get the
server in single user mode. How long does this command normally run?
> Thanks,
> Jess|||When you run this from the command prompt, it should take a few seconds to
come up and while it is coming up, it will be writing things to the console
( command prompt), the last message shoujld be 'recovery complete' I think,
and then it stops writing...
The system is not hung.. the server is simply up and running. The server is
running as long as the command window is open... Go ahead and use Query
Analyzer or whatever to do your work, Then Ctrl-C on the command prompt
window to bring SQL back down.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jess" <anonymous@.discussions.microsoft.com> wrote in message
news:3FAD59F2-DA04-490D-B131-EE5D92F6AB9C@.microsoft.com...
> I am doing a DR test and running the command sqlservr.exe -c -m to get the
server in single user mode. How long does this command normally run?
> Thanks,
> Jess|||Thanks everyone!

Downside of SQL Server Clusters

Howdy,

We're interested in putting a SQL 2000 cluster together and want to hear from people who have run SQL Server clusters :

(1) Just how reliable are they in the real world?

(2) Which bits break ( i.e. hardware or OS or SQL Server )

(3) What configuration would you suggest and why?

Any help much appreciated

SG.After we had a hardware failure on our old SQL box, we've also been thinking of doing this.

I would think it would be more reliable with failover protection. We've looked into getting two Dell PE 1750's and the EMC AX100 running an Active/Passive Cluster. SQL 2000 Enterprise/Windows 2003 Enterprise.|||Single-instance (formerly known as Active/Passive) will give you what you're looking for. Check HCL thoroughly to make sure you're not introducing problems while implementing the solution.|||Thanks for that - what I'm after is peoples experiences with thier clusters.

What breaks & why...which part is unreliable...that sort of thing.

Thanks.|||Hardware-related problems are the biggest in clustering. Other than that it's very stable and reliable, even for high volume OLTP systems (NASDAQ is running it, as you might know)|||We're running Windows 2003 cluster, with three instances, active-active-active. We migrated over from a single-instance install active-passive and find our new cluster much more robust, although not without problems:

Installation:

Can be a pain, but with all of the equipment in place, it's not too bad. We moved from a connected shared SCSI array to a SAN which involved a lot of preparation (thanks to Dell it went smoothly).

Installation of the cluster between nodes was a breeze, on either Windows 2000 or 2003.

SQL 2000 Advanced Server was/is our main problem. A lot of Knowledge Base article lookups were required to nail it down:

1. On Windows 2000 Enterprise, SQL 2000 Advanced install was uneventful until you get to MSDTC. Be careful to install MSDTC on each node ONE AT A TIME. Don't do this simultaneously. Once MSDTC is up and running, leave it alone.

2. On Windows 2003 Enterprise, it will complain that SQL 2000 Advanced can't be installed unless it has SP2 built-in, which does not exist. A Knowledge Base article was found where you have to run a resourcekit utility to work around the problem. Looking through the setup logs, as suggested by an official MS webinar "Troubleshooting SQL 2000 installation on Windows 2003 Cluster" helped but not much.

3. MSDTC on Windows 2003 Cluster is a pain. I still can't get it to work and my maintenance plans are broken. Installing MSDTC is totally different on 2003 Cluster vs. 2000 Cluster. Following the Knowledge Base instructions on installing MSDTC, my backups and tlogs still fail and MSDTC seems to run on only one instance, not shared among all three as it's supposed to be.|||3. MSDTC on Windows 2003 Cluster is a pain. I still can't get it to work and my maintenance plans are broken. Installing MSDTC is totally different on 2003 Cluster vs. 2000 Cluster. Following the Knowledge Base instructions on installing MSDTC, my backups and tlogs still fail and MSDTC seems to run on only one instance, not shared among all three as it's supposed to be.

A Knowledge-Base article Hotfix emailed to me seems to work and my first major backup was successful. Now waiting until midnight to apply the hotfix to the rest of the servers to see if my nightly backups and scheduled transaction log backups work...

I just wish this hotfix solution was available from the start, instead of having us waste a couple of weeks of troubleshooting.|||can you post some links to these particular articles because we are setting up a active/passive sql cluster using windows 2003

Thanks|||can you post some links to these particular articles because we are setting up a active/passive sql cluster using windows 2003

Thanks

No problem, Ebola:

Problem Installing named instance of SQL 2000 on 2003 Cluster (http://support.microsoft.com/default.aspx?scid=kb;en-us;815431)
I forgot to mention our problem with installing SQL 2000 instances, but this link gets around both issues regarding SP2 and installing instances...

MSDTC - How To Install on a Windows 2003 Cluster (http://support.microsoft.com/default.aspx?scid=kb;en-us;301600)

DB Maintenance Failures - MSDTC Hotfix (http://support.microsoft.com/default.aspx?scid=kb;en-us;827452)
The hotfix did the trick after running it on all three servers, by the way. All backups are working. The only trick about the hotfix was to delete the MSDTC Resource and recreate it if you already tried creating one before the hotfix.

Hope this helps and let me know if you run into any issues outside of these.|||Not to bring back a thread from the dead but today I got our Active/Passive SQL cluster up and running. Thanks to SunStroke for the DTC link.

I found it worked better to install SQL 2000 on one node at a time.

If anyone is wondering here is a hardware list. It was a relatively smooth install.

Node 1
Dell PE 1850
Windows 2003 Enterprise
dual xeon 3.0 ghz
3 GB ram
Raid 1 PERC
Qlogic HBA (Fibre Channel)
Dual port Intel 1 Gb Network

Node 2
Dell PE 1850
Windows 2003 Enterprise
dual xeon 3.0 ghz
3 GB ram
Raid 1 PERC
Qlogic HBA (Fibre Channel)
Dual port Intel 1 Gb Network

Dell EMC AX100 DP
4 active 250 GB Drives in RAID, 1 spare.

Downloading Reporting services

Hello,
I have downloaded an eval version of Reporting services
from microsoft.com . But the file is corrupted and will
not run on my pc. Can any one help where can I get the
latest and greatest version other than microsoft.com ?
Thanks a lot for your help.
- SThis link details how you can get a version of RS besides downloading.
What problem were you seeing running the downloaded version?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sunil" <sunilor@.hotmail.com> wrote in message
news:244801c49cc6$44b5cf80$a401280a@.phx.gbl...
> Hello,
> I have downloaded an eval version of Reporting services
> from microsoft.com . But the file is corrupted and will
> not run on my pc. Can any one help where can I get the
> latest and greatest version other than microsoft.com ?
>
> Thanks a lot for your help.
> - S|||Forgot to post the link. :)
http://www.microsoft.com/sql/reporting/howtobuy/default.asp
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sunil" <sunilor@.hotmail.com> wrote in message
news:244801c49cc6$44b5cf80$a401280a@.phx.gbl...
> Hello,
> I have downloaded an eval version of Reporting services
> from microsoft.com . But the file is corrupted and will
> not run on my pc. Can any one help where can I get the
> latest and greatest version other than microsoft.com ?
>
> Thanks a lot for your help.
> - S

Downloading data from our Informix server

Our entire sales database sits on an Informix server and users run their reports directly to this server.

Because of the volume of data - upwards of 7 million rows in some tables we are finding performance is becoming an issue. We realise that Informix is not the best for running queries and so are looking to replicate to a SQL server and use that as a reporting server.

My chosen method is DTS using ODBC which works fine. However due to the sheer volume of data to be downloaded each night (over a 512K wan link) we only want to download changed data.

Is there any way we can get SQL2000 to download only change data - i.e a differential download or something? We don't have a unique field in the table (for whatever reason) such as sales date or transaction ID (shops might upload old / back-dated transactions for example due to a systems failure).

If I do have to download all the data every night is my method the most efficient or is there some other approach I could use?

Ultimatly the aim here is to relieve the Informix server of the reporting overhead so any alternative ideas are welcome!

Many thanksHi
The normal way of doing this sort of thing would be replication - this would give you your "differential downlaod".
I am not sure what one can do repl wise between informix & mssql but would be worth checking it out...
Des
(otherwise can use tracking tables which record max id last copied & copy only from there each day - use vars in DTS package, seeded by values in the tracking tables)|||Which version of informix are you running - believe it or not informix is very good at running queries, so I would first check to see if either the queries are not optimized correctly, check for poor database design and also look at the onconfig file to make sure the server itself has the appropriate settings.

To solve the transfer issue - probably you best method is to dump the data and use sql server to bulk copy (bcp) or bulk insert the data. You can use some identifier within Informix such as a date/time stamp to find the changed records - however, I go back to there is probably something either designed poorly or misconfigured on your informix box that is causing this poor performance.

Download SQL query analyser

Hi, my client need to be able to run some queries on my
db.
Is there anywhere they can by or downlad JUST the sql
query analayer?
M@.)If you are talking about MSDE which does not contain GUE environment, you
could use OSQL. It is command line utility to run query.
Regards
---
All information provided above AS IS.
"Matt G" <matt@.3ainteractive> wrote in message
news:01b501c39f1c$f36d40b0$a401280a@.phx.gbl...
> Hi, my client need to be able to run some queries on my
> db.
> Is there anywhere they can by or downlad JUST the sql
> query analayer?
> M@.)|||Yes, get the developer edition of SQL Server (49.95). See
http://www.microsoft.com/sql/howtobuy/development.asp
You can't download Query Analyzer for free. However, you can install client
tools (EM, QA etc) from official media if you have your licensing in check.
"Matt G" <matt@.3ainteractive> wrote in message
news:01b501c39f1c$f36d40b0$a401280a@.phx.gbl...
> Hi, my client need to be able to run some queries on my
> db.
> Is there anywhere they can by or downlad JUST the sql
> query analayer?
> M@.)sql

Double Quote in database record

In my asp.net page when I run a query against the database the datagrid get populated with only the records that starts with the first letter for example A good day. But none of the records that starts like this "A fine day" or "A nice day" displays in the datagrid. I tried to replace the Double Quote but it still returns only the records without " quotes. My query looks like this:

Dim queryString As String = "SELECT [Articles].[AN], [Articles].[Department], [Articles].[ArticleHeading], [Articles].[AccessLevel], [Articles].[Status] FROM [Articles] WHERE (([Articles].[AccessLevel] <> 'SysAdmin') AND ([Articles].[Status] = 'Enable') AND (REPLACE([Articles].[ArticleHeading], 'chr(34)', '')) like @.ArticleHeading) ORDER BY [Articles].[ArticleHeading]"

You need to do the replace on both the column AND the value you are comparing, otherwise they will never be equal.
eg.

Dim queryString As String = "SELECT [Articles].[AN], [Articles].[Department], [Articles].[ArticleHeading], [Articles].[AccessLevel], [Articles].[Status] FROM [Articles] WHERE (([Articles].[AccessLevel]<> 'SysAdmin') AND ([Articles].[Status] = 'Enable') AND (REPLACE([Articles].[ArticleHeading], 'chr(34)', '')) like REPLACE(@.ArticleHeading),'chr(34)') ORDER BY [Articles].[ArticleHeading]"|||

I tried it but still it does not produce the right results.

My code:

Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT [Articles].[AN], [Articles].[Department], [Articles].[ArticleHeading], [Articles].[AccessLevel], [Articles].[Status] FROM [Articles] WHERE (([Articles].[AccessLevel] <> 'SysAdmin') AND ([Articles].[Status] = 'Enable') AND (REPLACE([Articles].[ArticleHeading], 'chr(34)', '')) like (REPLACE(@.ArticleHeading, 'chr(34)', ''))) ORDER BY [Articles].[ArticleHeading]"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand

dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dbParam_articleHeading As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_articleHeading.ParameterName = "@.ArticleHeading"
dbParam_articleHeading.Value = Request.QueryString("Alphabet")& "%"
dbParam_articleHeading.DbType = System.Data.DbType.String
dbCommand.Parameters.Add(dbParam_articleHeading)

|||What are you trying to do with: REPLACE([Articles].[ArticleHeading], 'chr(34)', '') ?|||Some records starts with a double qoute and a need to list all for example that starts with A but that needs to include something like "A nice day"|||

Using a sql query I manage to get the right results but what do I need to do in asp.net to get the right results. My SQL code that replaces the ":

SELECT *
FROM Articles
WHERE (REPLACE(ArticleHeading, '"', '') LIKE 'A%')
ORDER BY ArticleHeading

|||

Change:

REPLACE([Articles].[ArticleHeading], 'chr(34)', '')

To:

REPLACE([Articles].[ArticleHeading], chr(34), '')

Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
ShyamSee if this helps:
http://msdn.microsoft.com/library/d...
lrguidance.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>

> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. [url]http://vyaskn.tripod.com/" target="_blank">http://msdn.microsoft.com/library/d...skn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>|||Ill keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> http://msdn.microsoft.com/library/d...clrguidance.asp
>|||Hi Vyas,
Thanks for the Link.But,it gives a better picture
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me i
n
this regard,it would bemuch appreciated. Thanks in advance.Let me know if an
y
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:

> See if this helps:
> http://msdn.microsoft.com/library/d...clrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam
See if this helps:
http://msdn.microsoft.com/library/de...lrguidance.asp
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam
|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>
http://msdn.microsoft.com/library/de...lrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
|||Ill keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> http://msdn.microsoft.com/library/de...lrguidance.asp
>
|||Hi Vyas,
Thanks for the Link.But,it gives a better picture
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me in
this regard,it would bemuch appreciated. Thanks in advance.Let me know if any
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:

> See if this helps:
> http://msdn.microsoft.com/library/de...lrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

Dotnet Code can be run in SQLServer in 2005-WHY?

Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
ShyamSee if this helps:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shyam" <Shyam@.discussions.microsoft.com> wrote in message
news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
Hi,
I had recently undergone training in YUKON.As the first class begun,i came
to know that in 2005 version,it is possible to execute DOTNET Code in SQL
Server.I was surprised by this. My trainer answered that,it was due to
performance,scalability and many other "ABILITY" terms...
Could someone please give me better answers on this as to why there is a
necesary to run dotnet code inside SQL Server? Any article/URL would be
appreciated greatly.
Thanks,
Shyam|||Hi Vyas
If I remember well you have promised us to put some .NET code examples on
your site some time ago :-)
We are still waiting for....:-)
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
> See if this helps:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>|||I´ll keep them up on www.sqlserver2005.de domain is still moving to another
provider :-(
Cheers, Jens.
"Uri Dimant" <urid@.iscar.co.il> schrieb im Newsbeitrag
news:eSYnjj7eFHA.256@.TK2MSFTNGP14.phx.gbl...
> Hi Vyas
> If I remember well you have promised us to put some .NET code examples on
> your site some time ago :-)
> We are still waiting for....:-)
>
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%23v%23vle7eFHA.1404@.TK2MSFTNGP09.phx.gbl...
>> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
>> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
>> Hi,
>> I had recently undergone training in YUKON.As the first class begun,i
>> came
>> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
>> Server.I was surprised by this. My trainer answered that,it was due to
>> performance,scalability and many other "ABILITY" terms...
>> Could someone please give me better answers on this as to why there is a
>> necesary to run dotnet code inside SQL Server? Any article/URL would be
>> appreciated greatly.
>> Thanks,
>> Shyam
>>
>|||Hi Vyas,
Thanks for the Link.But,it gives a better picture :)
I've another question based on this. I'm not very familier with Dotnet
Coding,since i've be dealing only with SQL Server 2000 as DBA. Now,Yukon has
more support for Dotnet with CLR integration.Can you please tell/advice me,
is it necessary for me to learn about Dotnet to survive in future as a SQL
DBA? If so,upto to what extent should i know in dotnet. I know it might not
be very revelent question,since dotnet is very vast.But,if you can help me in
this regard,it would bemuch appreciated. Thanks in advance.Let me know if any
links are available.
Regards,
shyam
"Narayana Vyas Kondreddi" wrote:
> See if this helps:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sqlclrguidance.asp
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Shyam" <Shyam@.discussions.microsoft.com> wrote in message
> news:BDA7FB31-094B-4D30-8B94-7257F8CCB272@.microsoft.com...
> Hi,
> I had recently undergone training in YUKON.As the first class begun,i came
> to know that in 2005 version,it is possible to execute DOTNET Code in SQL
> Server.I was surprised by this. My trainer answered that,it was due to
> performance,scalability and many other "ABILITY" terms...
> Could someone please give me better answers on this as to why there is a
> necesary to run dotnet code inside SQL Server? Any article/URL would be
> appreciated greatly.
> Thanks,
> Shyam
>
>

dotnet 3.5 runtime for synchronisation of sql server

Hi,

I downloaded orcas and created an application which also has sql server synchronisation, now if i wish to run it on another m/c, where can i get the runtime for 3.5, I searched but could not find it.

Thanks

arnab

It is available form here: http://www.microsoft.com/downloads/details.aspx?FamilyID=75fef59f-1b5e-49bc-a21a-9ef4f34de6fc&DisplayLang=en and here http://www.microsoft.com/downloads/details.aspx?FamilyId=E3715E6F-E123-428B-8A0F-028AFB9E0322&displaylang=en

dont see my database

I can see my database in my Query analyser, but not in my Entreprise manager. The application is run on a remote machine. Do you have any idea why it is like this, and how can I solve this?This sounds like a refresh, or account permissions issue. For the former, disconnect and reconnect, for the latter make sure the same account is used in both the QA connection and the EM connection.

Don't Run Script If Database Exists

Hi there
I want to add a bit to my SQL script which will check whether the
database exists before running the script. I am aware of the syntax for
checking for the database and dropping the database if necessary, but I
want to keep the database if it exists. The trouble is that because I
need GO statements in the script, I cannot put an IF EXISTS around the
whole thing?
Would anyone be able to help?
Thanks
DaveIf you run the script using ISQL or OSQL, you can issue a RAISERROR with *st
ate* of 127, which will
terminate the script (not only the batch). If you run from somewhere else, y
ou can use the technique
that instpubs.sql does, i.e., issue an error with a high *severity* level so
that *SQL Server*
terminates the connection.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Bungle" <dave@.court-technologies.com> wrote in message
news:1106556674.118686.293460@.f14g2000cwb.googlegroups.com...
> Hi there
> I want to add a bit to my SQL script which will check whether the
> database exists before running the script. I am aware of the syntax for
> checking for the database and dropping the database if necessary, but I
> want to keep the database if it exists. The trouble is that because I
> need GO statements in the script, I cannot put an IF EXISTS around the
> whole thing?
> Would anyone be able to help?
> Thanks
> Dave
>

Don't run report straight away

When accessing a report via a url, is it possible to wait until the user
clicks the 'View Report' button, rather than running the report straight away
with whatever default parameters have been set?
FredNo. If all the parameters have defaults then the report will run. The only
thing you can do is to leave one parameter without a default.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:1333BECB-C529-4F38-8DF7-AEEBC57842FE@.microsoft.com...
> When accessing a report via a url, is it possible to wait until the user
> clicks the 'View Report' button, rather than running the report straight
away
> with whatever default parameters have been set?
>
> Fred

don't prompt user for parameters error

I am trying to run a report in RS using url parameters. I want to prompt the
user for two parameters, but I want to hide the other six parameters (the
values are set in the url and the user should not be able to change them).
When I am in RS in Properties and Parameters I can set each parameter to
prompt user or not prompt user. If I set any of them to not prompt user
(uncheck the checkbox) I get the following error:
The report parameter 'nodeID' is read-only and cannot be modified.
(rsReadOnlyReportParameter)
This error shows for the one parameter that is selected not to prompt, or
for the first one in the list if I set them all to not prompt.
What am I doing wrong? Is there some other way to hide these parameters?
Thank you for your help!
Sharlynleave the prompt in VS.net, deploy and change the properties in the report
manager. check "prompt user" but leave the string blank.
"SharinDenver" wrote:
> I am trying to run a report in RS using url parameters. I want to prompt the
> user for two parameters, but I want to hide the other six parameters (the
> values are set in the url and the user should not be able to change them).
> When I am in RS in Properties and Parameters I can set each parameter to
> prompt user or not prompt user. If I set any of them to not prompt user
> (uncheck the checkbox) I get the following error:
> The report parameter 'nodeID' is read-only and cannot be modified.
> (rsReadOnlyReportParameter)
> This error shows for the one parameter that is selected not to prompt, or
> for the first one in the list if I set them all to not prompt.
> What am I doing wrong? Is there some other way to hide these parameters?
> Thank you for your help!
> Sharlyn
>

Don't Auto Run with default parameters

Is there a way to not have a report run when all of the default parameters
are set?
We would like to give the users some defaults so they don't have to type as
much when they run a report.Unfortunately there is not. There have been many request for this feature.
If you can wait for Yukon then you could use the viewer control which you
could give this behavior.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alec Hardy" <AlecHardy@.discussions.microsoft.com> wrote in message
news:B3C08BBF-2D07-4941-A986-BA89E122E346@.microsoft.com...
> Is there a way to not have a report run when all of the default parameters
> are set?
> We would like to give the users some defaults so they don't have to type
> as
> much when they run a report.

domain account vs local account for SQLServerAgent

Hi there,

BOL notes that in order for replication agents to run properly, the
SQLServerAgent must run as a domain account which has privledges to log
into the other machines involved in replication (under "Security
Considerations" and elsewhere). This makes sense; however, I was
wondering if there were any repercussions to using duplicate local
accounts to establish replication where a domain was not available.
Anotherwords, create a local windows account "johndoe" on both machines
(with the same password), grant that account access to SQL Server on
both machines, and then have SQL Server Agent run as "johndoe" on both
machines. I do not feel this is an ideal solution but I have
circumstances under which I may not have a domain available; my
preliminary tests seem to work.

Also, are there any similar considerations regarding the MSSQLSERVER
service, or can I always leave that as local system?

Dave"Dave C." <metal@.rules.spam> wrote in message news:<Pine.LNX.4.44.0311061247410.17583-100000@.ccrma-gate.stanford.edu>...
> Hi there,
> BOL notes that in order for replication agents to run properly, the
> SQLServerAgent must run as a domain account which has privledges to log
> into the other machines involved in replication (under "Security
> Considerations" and elsewhere). This makes sense; however, I was
> wondering if there were any repercussions to using duplicate local
> accounts to establish replication where a domain was not available.
> Anotherwords, create a local windows account "johndoe" on both machines
> (with the same password), grant that account access to SQL Server on
> both machines, and then have SQL Server Agent run as "johndoe" on both
> machines. I do not feel this is an ideal solution but I have
> circumstances under which I may not have a domain available; my
> preliminary tests seem to work.
> Also, are there any similar considerations regarding the MSSQLSERVER
> service, or can I always leave that as local system?
> Dave

See "Setting up Windows Services Accounts" in BOL. There are a number
of things that can only be done with a domain account; in addition,
LocalSystem is a highly privileged account, so for both functionality
and security reasons, using a domain account is usually a good idea.

I'm not sure about using multiple local accounts if no domain is
available. I would guess that it would work, but password management
and synchronization could be awkward.

Simon

Does Update stats cause all stored procs to recompile

Do all stored procs in a database get recompiled once sp_updatestats is run
against a database ? Using SQL 2000According to the BOL, the procs should be recompiled (i.e. new plans should
be generated). See the following excerpt from the BOL:
Recompiling Execution Plans
... The conditions that cause a plan to be invalidated include:
a.. New distribution statistics generated either explicitly from a
statement such as UPDATE STATISTICS or automatically.
...
However, my test didn't seem to confirm this to be always the case. When I
ran UPDATE STATISTICS on pubs..authors, I did see the following simple proc
got recompiled:
create proc pr_authors
as
select au_id from authors where au_id = '172-32-1176'
More specifically, I didn't see SP:Recompile event class in SQL Trace, which
you would see if you do a sp_recompile authors.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u8Kvj9vgDHA.3144@.tk2msftngp13.phx.gbl...
> Do all stored procs in a database get recompiled once sp_updatestats is
run
> against a database ? Using SQL 2000
>|||If the structure of the table(s) that a stored procedure uses is
changed, or when the statistics of the table(s) is changed, then the
stored procedure is marked for compilation. The next time the stored
procedure is used it will be (re)compiled.
Gert-Jan
Hassan wrote:
> Do all stored procs in a database get recompiled once sp_updatestats is run
> against a database ? Using SQL 2000

Does this log backup overwrite?

The following command is run every 5 minutes:
BACKUP LOG [Skinstore] TO [Skinstore-Log-Diff] WITH INIT , NOUNLOAD , NAME = N''Skinstore Log Differential'', NOSKIP , STATS = 10, NOFORMAT , NO_TRUNCATE
I think it is overwriting the TRN file every time.Yes -- the INIT option makes it overwrite.
--
Adam Machanic
SQL Server MVP - http://sqlblog.com
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Jay" <nospam@.nospam.org> wrote in message
news:%23bXzE9l6HHA.3264@.TK2MSFTNGP02.phx.gbl...
> The following command is run every 5 minutes:
> BACKUP LOG [Skinstore] TO [Skinstore-Log-Diff] WITH INIT , NOUNLOAD , NAME
> = N''Skinstore Log Differential'', NOSKIP , STATS = 10, NOFORMAT ,
> NO_TRUNCATE
> I think it is overwriting the TRN file every time.
>|||Psssst! Wrong answer Hans!
I was really hoping to be told I'm a idiot and didn't RTFM right.
Thank you sir.
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:BEBE0224-CE84-4872-A44C-A77F784A57EC@.microsoft.com...
> Yes -- the INIT option makes it overwrite.
> --
> Adam Machanic
> SQL Server MVP - http://sqlblog.com
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23bXzE9l6HHA.3264@.TK2MSFTNGP02.phx.gbl...
>> The following command is run every 5 minutes:
>> BACKUP LOG [Skinstore] TO [Skinstore-Log-Diff] WITH INIT , NOUNLOAD ,
>> NAME = N''Skinstore Log Differential'', NOSKIP , STATS = 10, NOFORMAT ,
>> NO_TRUNCATE
>> I think it is overwriting the TRN file every time.
>|||You should really think about generating backups with a unique filename each
time. Appending to a single file can get pretty ugly since you can't delete
individual backups in the file. It's all or nothing.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Jay" <nospam@.nospam.org> wrote in message
news:%23hG$XGm6HHA.3900@.TK2MSFTNGP02.phx.gbl...
> Psssst! Wrong answer Hans!
> I was really hoping to be told I'm a idiot and didn't RTFM right.
> Thank you sir.
> "Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
> news:BEBE0224-CE84-4872-A44C-A77F784A57EC@.microsoft.com...
>> Yes -- the INIT option makes it overwrite.
>> --
>> Adam Machanic
>> SQL Server MVP - http://sqlblog.com
>> Author, "Expert SQL Server 2005 Development"
>> http://www.apress.com/book/bookDisplay.html?bID=10220
>>
>> "Jay" <nospam@.nospam.org> wrote in message
>> news:%23bXzE9l6HHA.3264@.TK2MSFTNGP02.phx.gbl...
>> The following command is run every 5 minutes:
>> BACKUP LOG [Skinstore] TO [Skinstore-Log-Diff] WITH INIT , NOUNLOAD ,
>> NAME = N''Skinstore Log Differential'', NOSKIP , STATS = 10, NOFORMAT ,
>> NO_TRUNCATE
>> I think it is overwriting the TRN file every time.
>>
>|||Actually, I've been here a month now and had initially only verified that
backups were being done. Why so little? Because, no one would ever overwrite
their log backup without having backed it up, or archived it first ... would
they?
I have since spoken to the guy that set it up (my boss) and he said he
thought that he was making a complete copy of the .ldf changes for the day
each time he wrote to the .trn. I literally had to stop myself when I heard
my tone in replying to him. Not a good idea to speak to your boss like
you're talking to an idiot.
Anyway, when drive space is available, I will be changing to my own backup
program that was based on RealSQLGuy's backup program. The only problem with
the program is that it assumes the job that puts it to tape will also be
removing old files. A situation that is not the case here.
Thanks,
Jay
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23tB8RCn6HHA.5012@.TK2MSFTNGP02.phx.gbl...
> You should really think about generating backups with a unique filename
> each time. Appending to a single file can get pretty ugly since you can't
> delete individual backups in the file. It's all or nothing.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23hG$XGm6HHA.3900@.TK2MSFTNGP02.phx.gbl...
>> Psssst! Wrong answer Hans!
>> I was really hoping to be told I'm a idiot and didn't RTFM right.
>> Thank you sir.
>> "Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
>> news:BEBE0224-CE84-4872-A44C-A77F784A57EC@.microsoft.com...
>> Yes -- the INIT option makes it overwrite.
>> --
>> Adam Machanic
>> SQL Server MVP - http://sqlblog.com
>> Author, "Expert SQL Server 2005 Development"
>> http://www.apress.com/book/bookDisplay.html?bID=10220
>>
>> "Jay" <nospam@.nospam.org> wrote in message
>> news:%23bXzE9l6HHA.3264@.TK2MSFTNGP02.phx.gbl...
>> The following command is run every 5 minutes:
>> BACKUP LOG [Skinstore] TO [Skinstore-Log-Diff] WITH INIT , NOUNLOAD ,
>> NAME = N''Skinstore Log Differential'', NOSKIP , STATS = 10, NOFORMAT ,
>> NO_TRUNCATE
>> I think it is overwriting the TRN file every time.
>>
>>
>|||One possible way is to base the backups on weekday, day in month or similar. Take the easy route,
day of week. You have a Monday file, a Tuesday file etc. The first backup of the day, you do INIT,
then the rest of the backups of the day you do NONIT. You now have a tail of 6 backup files
(excluding the current day). This will cut down number of physical files (nice of you have lots of
databases and frequent log backups). However, some SQL persons aren't that familiar with several
backups on same file, so they don't understand the WITH FILE = option of the RESTORE command...
Pretty much a matter of taste. And, remember that the code you write need to be understood and
maintained by somebody... ;-).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospam@.nospam.org> wrote in message news:ui%23tvhn6HHA.5984@.TK2MSFTNGP04.phx.gbl...
> Actually, I've been here a month now and had initially only verified that backups were being done.
> Why so little? Because, no one would ever overwrite their log backup without having backed it up,
> or archived it first ... would they?
> I have since spoken to the guy that set it up (my boss) and he said he thought that he was making
> a complete copy of the .ldf changes for the day each time he wrote to the .trn. I literally had to
> stop myself when I heard my tone in replying to him. Not a good idea to speak to your boss like
> you're talking to an idiot.
> Anyway, when drive space is available, I will be changing to my own backup program that was based
> on RealSQLGuy's backup program. The only problem with the program is that it assumes the job that
> puts it to tape will also be removing old files. A situation that is not the case here.
> Thanks,
> Jay
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23tB8RCn6HHA.5012@.TK2MSFTNGP02.phx.gbl...
>> You should really think about generating backups with a unique filename each time. Appending to
>> a single file can get pretty ugly since you can't delete individual backups in the file. It's all
>> or nothing.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Jay" <nospam@.nospam.org> wrote in message news:%23hG$XGm6HHA.3900@.TK2MSFTNGP02.phx.gbl...
>> Psssst! Wrong answer Hans!
>> I was really hoping to be told I'm a idiot and didn't RTFM right.
>> Thank you sir.
>> "Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
>> news:BEBE0224-CE84-4872-A44C-A77F784A57EC@.microsoft.com...
>> Yes -- the INIT option makes it overwrite.
>> --
>> Adam Machanic
>> SQL Server MVP - http://sqlblog.com
>> Author, "Expert SQL Server 2005 Development"
>> http://www.apress.com/book/bookDisplay.html?bID=10220
>>
>> "Jay" <nospam@.nospam.org> wrote in message news:%23bXzE9l6HHA.3264@.TK2MSFTNGP02.phx.gbl...
>> The following command is run every 5 minutes:
>> BACKUP LOG [Skinstore] TO [Skinstore-Log-Diff] WITH INIT , NOUNLOAD , NAME = N''Skinstore Log
>> Differential'', NOSKIP , STATS = 10, NOFORMAT , NO_TRUNCATE
>> I think it is overwriting the TRN file every time.
>>
>>
>

Does the Sql Server 2005 EVAL distribution support run of packages under DtExec?

I believe I have made a complete install of Sql Server 2005 on my dev. machine, including all client tools, and can run SSIS packages from the dev. environment.

However DtExec refuses to run any package and always throws the "insufficient version" error (as does the "RunPackage" component, probably for the same reason).

I have repeatedly attempted to find something more to install from the Sql Server 2005 eval release that will allow DTExec to run without the "insufficient version" error, but can find nothing else to install from the eval. The install wizard (and the "change" wizard) indicates everything is installed and will not build a list of any additional components to install.

Are we sure that DtExec will install and run from a sql server 2005 eval distribution?

Licenses are in the pipeline (not that pipleine) but we need to start testing our SSIS solution in the meantime.

p.s. Kudos to the dev. team, it really is an excellent tool!

Thanks,

Ken

This sounds like the SSIS services feature is missing, you may just have the workstation components. If running on a workstation OS, then this can be an issue-

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112469&SiteID=1

|||

Thanks for the reply Darren.

The O.S. is Windows 2000 Advanced Server, and to the best of my ability I have confirmed and reconfirmed that every possible installable component and piece of software provided in the Sql Server 2005 eval. distro. has been fully installed in the runtime environment in question.

I recently used the same Sql Server 2005 distro. to perform an identical install onto an XP Pro machine and DtExec seems to run fine.

So I will assume I have some kind of flawed installation on the win2k advanced server box and will try a complete deinstall and reinstall as my last resort.