Field locked

Dear all,
We've got a very strange issue and we can't work out so any help will be
welcomed. Involved Access and Sql Server.
From Access db a specific field of a row is not be able be updated for the
developer (by hand) as well as by the end-user.
But the rest ones (other fields in the same row, below rows, and so on, no
problem at all)
That table is linked to Sql Server. Nothing amazing with that.
Message is the following: "Writing forbidden, that field has already locked
by another user". In a fact, nobody else is in that moment working with the
Access db or Sql Native info.
Looking for any clue with sp_lock, select object_id and analyzing the
problem from another workstation doesn't give us any solution.
Does anyone ever experienced this problem?
Thanks for any input and regards,Could it be that the column in question is referenced by a constraint in
SQL.
The following should tell you :- EXEC sp_helpconstraint tablename
HTH. Ryan
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:6B04EF91-6F68-44B1-BAFE-5009E483D932@.microsoft.com...
> Dear all,
> We've got a very strange issue and we can't work out so any help will be
> welcomed. Involved Access and Sql Server.
> From Access db a specific field of a row is not be able be updated for the
> developer (by hand) as well as by the end-user.
> But the rest ones (other fields in the same row, below rows, and so on, no
> problem at all)
> That table is linked to Sql Server. Nothing amazing with that.
> Message is the following: "Writing forbidden, that field has already
> locked
> by another user". In a fact, nobody else is in that moment working with
> the
> Access db or Sql Native info.
> Looking for any clue with sp_lock, select object_id and analyzing the
> problem from another workstation doesn't give us any solution.
> Does anyone ever experienced this problem?
> Thanks for any input and regards,|||Yes, it have constraints but no in the affected field.
Although I would remark that the datatype is 'text'
"Ryan" wrote:

> Could it be that the column in question is referenced by a constraint in
> SQL.
> The following should tell you :- EXEC sp_helpconstraint tablename
> --
> HTH. Ryan
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:6B04EF91-6F68-44B1-BAFE-5009E483D932@.microsoft.com...
>
>

Field List from a Stored procedure

I am writing a utility that creates Java code to access a database. I am looking for a way to get a list of fields and types that are returned by an sproc. Is there any easy way to get this from the master? Do you need to parse the SQL? This list would be like what Visual Studio.NET shows, or interdev if I remember correctly.

Thanks,

Larrynot sure what exactly you looking for. try sp_helptext sproc_name|||I am looking for a way to get a list of the columns that will be in the recordset returned by a stored procedure. I need column name and type information.

sp_helptext seems to return the full contents of the sproc, which would require that I parse this, and any linked procedures, to get the info I am looking for. This is what I am trying to avoid.|||Do your procedures do SELECT only? You can use sp_depends and retrieve the structures of all dependent tables, but this will also include fields that your procedure does not include. It'll be easier to go after views.|||The procedures I am interested in do selects only. But they pull from other procedures and views.|||I am looking for something like that as well. So far I am using sp_sproc_columns to fetch the list of params from a SQL Server stored procedure.

There's nothing that I've found that will return a vertical list of outputs though. Ultimately I would like to display the fields returned by the sproc and their data types. Hopefully I won't have to re-invent the wheel by having to parse the sproc text.

I'll post back if I find anything else.

Thanks,

Doug

Fiel Level Security

I have a form in an Access front-end that is fed by a SQL View. Update
security on the View is done on the SQL side.
The Question is how can I restrict (blank or hide) fields on the form based
on the users security access?
How do I read if the user has access to a specific field?
Any help will be greatly appreciated.Berny,
Check the Permissions() function in SQL Books OnLine, I think this is what
you need.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Berny" <BlancoB at msn Dot com> wrote in message
news:#T49zIv3DHA.3656@.TK2MSFTNGP11.phx.gbl...

quote:

---

> I have a form in an Access front-end that is fed by a SQL View. Update
> security on the View is done on the SQL side.
> The Question is how can I restrict (blank or hide) fields on the form

---

based

quote:

---

> on the users security access?
> How do I read if the user has access to a specific field?
> Any help will be greatly appreciated.
>

---

sql

Feedback from Tape Backups

Hi Folks,
I'm trying to find a way to get access to the STATS output from the BACKUP
command during automated backups.
When running the BACKUP command in QA it shows the output, line by line, as
the backup progresses. Is there any way I can get this information when the
BACKUP statement is run from a job? I thought the console tool might have
been the answer, but it doesn't show any progress messages.
Is the only option to use the Job/Step/Adv/Output to file option, and "tail"
the file?
TIA
J.
In this case, the client application is SQL Server Agent, more specific, the sub-component in Agent
that executes your TSQL job steps. And Agent isn't written to output this information "as it goes".
It might update the output file as information comes in (I haven't tested this), so I think that
this is probably your best bet. Another option is of course to schedule an EXE file that you wrote
and you have in your EXE file code to output the information to where ever you want it to go.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
news:eL976GjHFHA.1860@.TK2MSFTNGP15.phx.gbl...
> Hi Folks,
> I'm trying to find a way to get access to the STATS output from the BACKUP
> command during automated backups.
> When running the BACKUP command in QA it shows the output, line by line, as
> the backup progresses. Is there any way I can get this information when the
> BACKUP statement is run from a job? I thought the console tool might have
> been the answer, but it doesn't show any progress messages.
> Is the only option to use the Job/Step/Adv/Output to file option, and "tail"
> the file?
> TIA
> J.
>
>
|||Thanks Tibor
With regard to your comments on creating my own EXE, how would I go about
getting access to the messages - given that they are not returned as part of
a result set?
Cheers
J.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OU%23Lr5lHFHA.4060@.TK2MSFTNGP14.phx.gbl...
> In this case, the client application is SQL Server Agent, more specific,
the sub-component in Agent
> that executes your TSQL job steps. And Agent isn't written to output this
information "as it goes".
> It might update the output file as information comes in (I haven't tested
this), so I think that
> this is probably your best bet. Another option is of course to schedule an
EXE file that you wrote
> and you have in your EXE file code to output the information to where ever
you want it to go.[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
> news:eL976GjHFHA.1860@.TK2MSFTNGP15.phx.gbl...
BACKUP[vbcol=seagreen]
as[vbcol=seagreen]
the[vbcol=seagreen]
have[vbcol=seagreen]
"tail"
>
|||First I believe that you have to program asynchronously. Otherwise the command will be blocked until
it has finished. These are returned as messages, technically same way as PRINT and errors. I'm no
API expert, so you might want to investigate this further and possibly asking in a newsgroup
dedicated to the API you are using (ADO, ADO.NET etc).
The bigger problem is how your EXE will output to the screen. Remember that agent is a service (in
"NT") and a service has no Window context...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"J Hunter" <ms-nntp-nospam@.jshunter.co.uk> wrote in message
news:ePdMhboHFHA.236@.TK2MSFTNGP14.phx.gbl...
> Thanks Tibor
> With regard to your comments on creating my own EXE, how would I go about
> getting access to the messages - given that they are not returned as part of
> a result set?
> Cheers
> J.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OU%23Lr5lHFHA.4060@.TK2MSFTNGP14.phx.gbl...
> the sub-component in Agent
> information "as it goes".
> this), so I think that
> EXE file that you wrote
> you want it to go.
> BACKUP
> as
> the
> have
> "tail"
>
sql

Features request

Hi all.
I've been working with RS for a month or so migrating all our client-side
reports (MS Access) to server-side (RS). I have a bunch of them to be
converted yet but I think I have some experience and can do some suggestions
to a product that is a very good product to be the 1st version. I hope next
version in SQL Server 2005 improves some things like:
* Add the option to select a RGB color for using it as transparency for the
Image control: You can add transparencies to the images themselves when
using GIF or PNG formats. However when images are bitmaps, since bitmap
format does not have support for transparency layers, it would be usefull to
have that support from RS itself.
* Render to .SNP format (MS Access Snapshot format).
* Within the VS IDE, when you copy a group of controls and paste them in
another report, they are not located at the same X,Y positions as they were
in the original report, but at the middle/center of the space they have been
inserted into (parent). I think that report designers would prefer to paste
the copied controls in the place they were instead of another coordinates
that sometimes are not aligned to the grid either (even though align to grid
is active).
* When you copy a control named MyUserRenamedControl1 (a textbox for
instance) and paste into the same report, since that control name is already
used, the new control is named TexboxX (being X a free number that makes the
name unique in the report). I think that if report designers have renamed a
default name component to another name (for whatever the reason), the IDE
should try to keep the same name and add numbers to the end of the name that
the designer has selected. In this case the names of new controls should be
MyUserRenamedControl2, MyUserRenamedControl3, etc.
* Rounded corners for rectangles, components for circles, ellipses, oblique
text (number of degrees selectable). This might be of less use for many
people, mainly when they use RS to generate pure-listing reports. However if
you use RS to generate invoices or other kind of documents that need quality
and be visually attractive, this kind of improvements would help a lot.
Regards and congratulations for such a good work.Also, report headers and footers, to supplement page headers and
footers.|||Report headers and footers are equivalent to objects that appear before any
data regions.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Parker" <psmith@.iquest.net> wrote in message
news:1116090620.154601.166470@.g49g2000cwa.googlegroups.com...
> Also, report headers and footers, to supplement page headers and
> footers.
>

Feature Request: ANSI/MS Access Unique Key Implementation

Not sure if this is the right place to post this, but:

In a future release of SQL Server, could there be an option that would implement the ANSI/MS Access version of a Unique Key.

As I understand it, the implementation of Unique Key in SQL Server considers Null as one of the values, so that there can only be one entry in the field with Null.

In MS Access and, as I understand it, in the ANSI Standard, there is an option to ignore Null entries in a Unique Key field. In this implementation, there can be many instances where Null is used, but each non-Null value must be unique.

I am building a database and in one of my tables, the field identifies a predecessor record, which could be either Null or one of the other records in the table. In order to ensure that a record is only used once, I would have liked to use the Unique Key, but can't. So, I have had to build a second table, with triggers and foreign keys, and it is ugly. Would have been so much simpler with an ANSI Unique Key.

I understand that this would have to be an option, since there is existing code that probably depends on the current implementation of the Unique Key in SQL Server, but it would have been nice to have the option to use the ANSI Implementation.

Thanks,

Flavelle

Regards,

FlavelleLow priority - the workaround is to build a schema-bound view containing the column to be indexed where the content of the column includes only those non-Null value. A unique index can then be applied to the view.sql

Feasability of storing PDFs and WORD.DOC files in MSSQL?

I'm building a system when one can upload a document to the website.

I will be storing the document on the hard-drive for quick/easy access,
but I was also thinking of storing it in an existing database since most
of the sites information is all stored there.

As well there would be only one place to worry about backing up. And if
the file on the hard-drive was ever missing or became corrupted, I could
restore it form tha database. Is this feasable? Has anyone ever done this?

--
* Don Vaillancourt
Director of Software Development
*
*WEB IMPACT INC.*
phone: 416-815-2000 ext. 245
fax: 416-815-2001
email: donv@.web-impact.com <mailto:donv@.webimpact.com>
web: http://www.web-impact.com

/ This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright. If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
/
Don Vaillancourt wrote:

> I'm building a system when one can upload a document to the website.
> I will be storing the document on the hard-drive for quick/easy access,
> but I was also thinking of storing it in an existing database since most
> of the sites information is all stored there.
> As well there would be only one place to worry about backing up. And if
> the file on the hard-drive was ever missing or became corrupted, I could
> restore it form tha database. Is this feasable? Has anyone ever done
> this?

Sure it's possible to save any size binary object in the DBMS, but it is
not usually a performant use of a DBMS as a simple file store. I would
first consider a hardware solution for backups of read-only files. Either
just store copies on separate disks, or get a fancier RAID setup where
any one disk failure won't lose any data.
Joe Weinstein at BEA|||Don Vaillancourt (donv@.webimpact.com) writes:
> I'm building a system when one can upload a document to the website.
> I will be storing the document on the hard-drive for quick/easy access,
> but I was also thinking of storing it in an existing database since most
> of the sites information is all stored there.
> As well there would be only one place to worry about backing up. And if
> the file on the hard-drive was ever missing or became corrupted, I could
> restore it form tha database. Is this feasable? Has anyone ever done
> this?

I have not done this myself, but certainly it is a common scenario.

Storing the documents on disk makes for a simple implementation.
Storing them in the database requires a battle with the text/image
data types, which are somewhat difficult to use.

But as you note, storing in the database is safer. Backup is simpler,
and a file on directory can easily "disappear". And if all you store
is the file path, another problem is that you don't have two-phase
commit with the file system.

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||I know that technically I can store this info in the database and
retrieving it is not an issue.

My issue really is how manageable will the database be with tons of
PDFs, Word, etc. documents in it. Or how willing people would be
willing to manage such a beast.

Right now our databases are about 300MB each. I may decide to create a
second database, not sure, but the total number of documents may be at
the very least in the 1000's which would most probably create a database
about 5GB + overhead.

To some this may be an intimidating size to manage. It would certainly
fit on a tape backup.

I'm just wondering about other issues that may come up.

Erland Sommarskog wrote:
> Don Vaillancourt (donv@.webimpact.com) writes:
>>I'm building a system when one can upload a document to the website.
>>
>>I will be storing the document on the hard-drive for quick/easy access,
>>but I was also thinking of storing it in an existing database since most
>>of the sites information is all stored there.
>>
>>As well there would be only one place to worry about backing up. And if
>>the file on the hard-drive was ever missing or became corrupted, I could
>>restore it form tha database. Is this feasable? Has anyone ever done
>>this?
>
> I have not done this myself, but certainly it is a common scenario.
> Storing the documents on disk makes for a simple implementation.
> Storing them in the database requires a battle with the text/image
> data types, which are somewhat difficult to use.
> But as you note, storing in the database is safer. Backup is simpler,
> and a file on directory can easily "disappear". And if all you store
> is the file path, another problem is that you don't have two-phase
> commit with the file system.
>

--
* Don Vaillancourt
Director of Software Development
*
*WEB IMPACT INC.*
phone: 416-815-2000 ext. 245
fax: 416-815-2001
email: donv@.web-impact.com <mailto:donv@.webimpact.com>
web: http://www.web-impact.com

/ This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright. If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
/|||Don Vaillancourt (donv@.webimpact.com) writes:
> I know that technically I can store this info in the database and
> retrieving it is not an issue.
> My issue really is how manageable will the database be with tons of
> PDFs, Word, etc. documents in it. Or how willing people would be
> willing to manage such a beast.
> Right now our databases are about 300MB each. I may decide to create a
> second database, not sure, but the total number of documents may be at
> the very least in the 1000's which would most probably create a database
> about 5GB + overhead.
> To some this may be an intimidating size to manage. It would certainly
> fit on a tape backup.

Few of our customers that run our system have databases that small. My test
database alone is 600 MB.

And 5 GB in one database is easier to manage, than 300 MB in a database + a
lot of loose files.

However, if you are using MSDE the size could be a concern, since MSDE
has a size limit of 2 GB.

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||No MSDE for us. We tell how clients which version of whatever database
they must purchase in order to use our software.

Otherwise, from your experiences, my issue is really a non-issue.

Thanks for your input.

Erland Sommarskog wrote:
> Don Vaillancourt (donv@.webimpact.com) writes:
>>I know that technically I can store this info in the database and
>>retrieving it is not an issue.
>>
>>My issue really is how manageable will the database be with tons of
>>PDFs, Word, etc. documents in it. Or how willing people would be
>>willing to manage such a beast.
>>
>>Right now our databases are about 300MB each. I may decide to create a
>>second database, not sure, but the total number of documents may be at
>>the very least in the 1000's which would most probably create a database
>> about 5GB + overhead.
>>
>>To some this may be an intimidating size to manage. It would certainly
>>fit on a tape backup.
>
> Few of our customers that run our system have databases that small. My test
> database alone is 600 MB.
> And 5 GB in one database is easier to manage, than 300 MB in a database + a
> lot of loose files.
> However, if you are using MSDE the size could be a concern, since MSDE
> has a size limit of 2 GB.

--
* Don Vaillancourt
Director of Software Development
*
*WEB IMPACT INC.*
phone: 416-815-2000 ext. 245
fax: 416-815-2001
email: donv@.web-impact.com <mailto:donv@.webimpact.com>
web: http://www.web-impact.com

/ This email message is intended only for the addressee(s)
and contains information that may be confidential and/or
copyright. If you are not the intended recipient please
notify the sender by reply email and immediately delete
this email. Use, disclosure or reproduction of this email
by anyone other than the intended recipient(s) is strictly
prohibited. No representation is made that this email or
any attachments are free of viruses. Virus scanning is
recommended and is the responsibility of the recipient.
/

faulting module

Hello everyone! This is my first post so please bear with me. We have
recently re-vamped an Access application such that in each of our 5
locations
a local SQL server receives published updates from our main office server.
Remote servers also send their local updates to the master and they are in
turn propogated to all of the other remote servers. The new design works
great except for one annoying bug we have been chasing for two weeks:
"Faulting application msaccess.exe, version 9.0.0.2719, faulting module
mso9.dll, version 9.0.0.2720, fault address 0x0007ee2d." When a user gets
the
error, they hit close and it terminates Access. If they move the error off
the screen and continue working the application continues. They have
discovered this and have been doing so but the fact that the error appears
must be fixed. If anyone can point me in the right direction it would be
muchly appreciated. Thanks in advance!

- Mark
mweber_at_warrenlumber_dot_comMark A. Weber (mweber@.warrenlumber.com) writes:
> Hello everyone! This is my first post so please bear with me. We have
> recently re-vamped an Access application such that in each of our 5
> locations
> a local SQL server receives published updates from our main office server.
> Remote servers also send their local updates to the master and they are in
> turn propogated to all of the other remote servers. The new design works
> great except for one annoying bug we have been chasing for two weeks:
> "Faulting application msaccess.exe, version 9.0.0.2719, faulting module
> mso9.dll, version 9.0.0.2720, fault address 0x0007ee2d." When a user gets
> the
> error, they hit close and it terminates Access. If they move the error off
> the screen and continue working the application continues. They have
> discovered this and have been doing so but the fact that the error appears
> must be fixed. If anyone can point me in the right direction it would be
> muchly appreciated. Thanks in advance!

The one pointer I can give you is to post in comp.databases.ms-access
instead. This group is about SQL Server, and I can't see any relation to
SQL Server in your post.

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

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.aspsql

FastLoad OLEDB Destination with Oralce

Hi,

why Table or View – fast load option in Data Access mode is not listed when we connect Oracle Database in the OLEDB Destination.

Thanks

Jegan

When you switch data sources using an OLE DB destination, you are most probably using a different kind and version of the OLE DB provider. I'm guessing that in your case, you are using Microsoft's Oracle OLE DB provider? that `-fast load` option is a feature of the underlying OLE DB Provider, which in your case, I'm guessing is Microsoft's OLE DB provider (SQL Native Client). And that is probably not a feature of the underlying OLE DB Provider for Oracle that you are using, and thus, do not show-up as an option.

|||Thanks Deniz.

Faster than Access?

I currently have an Access database that has numerous forms, tables, reports, etc. Although it works fine over our LAN, it is very slow when accessed from a second site over our VPN. Will migrating this application to SQL Server give me faster response?
Ken
Probably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken
|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)
|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken

Faster than Access?

I currently have an Access database that has numerous forms, tables, reports, etc. Although it works fine over our LAN, it is very slow when accessed from a second site over our VPN. Will migrating this application to SQL Server give me faster response?
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
--
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken

Faster than Access?

I currently have an Access database that has numerous forms, tables, reports
, etc. Although it works fine over our LAN, it is very slow when accessed f
rom a second site over our VPN. Will migrating this application to SQL Serv
er give me faster response?
KenProbably not; it sounds like your response issues are due to network
latency. Data is still data whether it's being sent by SQL Server or
Access...
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken|||> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
In and of itself? Probably not. Your bottleneck is much more likely to be
the network as opposed to the data access layer.
While you can't just migrate your forms and reports to SQL Server, it is
likely that redesigning them might offer you the opportunity to improve
efficiency there...
http://www.aspfaq.com/
(Reverse address to reply.)|||If you can move your users to Terminal Services and connect to the machine
(assuming it's hosted on Windows Server) hosting the Access database (or at
least a machine on the LAN), the speed will increase dramatically. I had a
client with the same problem and it appeared the latency in copying the .mdb
file(s) over VPN was what was slowing the application down.
"Ken" <Ken@.discussions.microsoft.com> wrote in message
news:475A7CCC-3838-4216-8DCD-D67F7BCAF00E@.microsoft.com...
> I currently have an Access database that has numerous forms, tables,
reports, etc. Although it works fine over our LAN, it is very slow when
accessed from a second site over our VPN. Will migrating this application
to SQL Server give me faster response?
> Ken

Faster JOINs?

I've licensed a read-only database (no insertions, updates, or data
integrity issues) that comes in an Access MDB and so when I move the many
tables and data over to SQL Server, it's basically a flat file database
without indexes, relationships, constraints, etc. although the table rows
are in order. There are many relationships between the tables and the
queries I will be using of course use JOINs.
Although I don't know for sure, I intend to create indexes with SQL Server
on the tables because I would think this would speed up the queries
considerably (although the tables are in order). However, my question is,
does it make any sense to specify and create hundreds of relationships
between about a hundred tables as I'll be using JOINs quite a bit? Is it
faster to have these relationships already specified in the database, rather
than when the queries (soon to be SPs) execute?
Thanks for any discussion."Don Miller" <nospam@.nospam.com> wrote in message
news:%23bbZ7m2pFHA.3516@.TK2MSFTNGP15.phx.gbl...
> I've licensed a read-only database (no insertions, updates, or data
> integrity issues) that comes in an Access MDB and so when I move the many
> tables and data over to SQL Server, it's basically a flat file database
> without indexes, relationships, constraints, etc. although the table rows
> are in order. There are many relationships between the tables and the
> queries I will be using of course use JOINs.
> Although I don't know for sure, I intend to create indexes with SQL Server
> on the tables because I would think this would speed up the queries
> considerably (although the tables are in order). However, my question is,
> does it make any sense to specify and create hundreds of relationships
> between about a hundred tables as I'll be using JOINs quite a bit? Is it
> faster to have these relationships already specified in the database,
> rather
> than when the queries (soon to be SPs) execute?
>
The relationships will guide the index creation. An index is required on
the primary key side of the relationship, and suggested on the foreign key
side. If you create the relationships and supporting indexes, it may speed
up joins quite a bit.
David|||Ok, first:
The tables are only physically in order. This means naught to the
optimizer. You must add indexes to get performance out of any "ordering"
If you aren't going to update the database the go wild with indexes. as much
as you need.
Only if you can do it relatively painlessly. The optimizer won't use the
foreign keys for much if anything, but it will make it easier to build a
diagram of your tables and is great documentation. If FK's are named the
same as PK's then you could build a script for doing this pretty quickly
using the information schema.
Consider contacting the liscenser (sp?) and see if they want this. Maybe
you might make a buck for your troubles.
> The relationships will guide the index creation. An index is required on
> the primary key side of the relationship, and suggested on the foreign key
> side. If you create the relationships and supporting indexes, it may
> speed up joins quite a bit.
Definitely the primary keys, and most assuredly on the foreign key columns.
They may or may not be useful, depending on how the data is used, but for a
read only database, who cares. Indexes only hurt modification performance.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:OIgQc%232pFHA.208@.TK2MSFTNGP10.phx.gbl...
> "Don Miller" <nospam@.nospam.com> wrote in message
> news:%23bbZ7m2pFHA.3516@.TK2MSFTNGP15.phx.gbl...
> The relationships will guide the index creation. An index is required on
> the primary key side of the relationship, and suggested on the foreign key
> side. If you create the relationships and supporting indexes, it may
> speed up joins quite a bit.
> David
>|||First of all, thanks for taking the time to answer my questions. I'm
intrigued (and would like to save myself a lot of time) by your statement:

> If FK's are named the
> same as PK's then you could build a script for doing this pretty quickly
> using the information schema.
They are. Of course there are many FKs in many tables for one PK, I'm not
sure I know how to use the "information schema" or sysobjects? to keep them
straight. Also, is it possible to use a script to do the indexing as well
(e.g. every column with an "*ID" in the column name should be indexed)?
It sounds like one script could do all of this quickly. Could you point me
to examples of how this could be done? Thanks again.
"Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
news:uGK72f6pFHA.1028@.TK2MSFTNGP09.phx.gbl...
> Ok, first:
> The tables are only physically in order. This means naught to the
> optimizer. You must add indexes to get performance out of any "ordering"
>
is,
> If you aren't going to update the database the go wild with indexes. as
much
> as you need.
>
it
> Only if you can do it relatively painlessly. The optimizer won't use the
> foreign keys for much if anything, but it will make it easier to build a
> diagram of your tables and is great documentation. If FK's are named the
> same as PK's then you could build a script for doing this pretty quickly
> using the information schema.
>
many
rows
> Consider contacting the liscenser (sp?) and see if they want this. Maybe
> you might make a buck for your troubles.
>
on
key
> Definitely the primary keys, and most assuredly on the foreign key
columns.
> They may or may not be useful, depending on how the data is used, but for
a
> read only database, who cares. Indexes only hurt modification
performance.
> --
> ----
--
> Louis Davidson - http://spaces.msn.com/members/drsql/
> SQL Server MVP
> "Arguments are to be avoided: they are always vulgar and often
convincing."
> (Oscar Wilde)
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
> message news:OIgQc%232pFHA.208@.TK2MSFTNGP10.phx.gbl...
many
rows
is,
it
on
key
>|||There are information_schema views for tables, columns etc:
select * from information_schema.tables or .columns
From there you just make queries like:
select 'create index ' + table_name + '_' + column_name + ' on ' +
table_name + '(' + column_name + ')'
from information_schema.columns
where column_name like '%id'
The more complex you want them, the harder the script is to write, but they
payoff is pretty good if the output is complex.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Don Miller" <nospam@.nospam.com> wrote in message
news:uWOb7e%23pFHA.1028@.TK2MSFTNGP09.phx.gbl...
> First of all, thanks for taking the time to answer my questions. I'm
> intrigued (and would like to save myself a lot of time) by your statement:
>
> They are. Of course there are many FKs in many tables for one PK, I'm not
> sure I know how to use the "information schema" or sysobjects? to keep
> them
> straight. Also, is it possible to use a script to do the indexing as well
> (e.g. every column with an "*ID" in the column name should be indexed)?
> It sounds like one script could do all of this quickly. Could you point me
> to examples of how this could be done? Thanks again.
>
> "Louis Davidson" <dr_dontspamme_sql@.hotmail.com> wrote in message
> news:uGK72f6pFHA.1028@.TK2MSFTNGP09.phx.gbl...
> is,
> much
> it
> many
> rows
> on
> key
> columns.
> a
> performance.
> --
> convincing."
> many
> rows
> is,
> it
> on
> key
>

Fast Printing from Crystal report 9.0

Hi,
We have created an application in VB 6, MS ACCESS 2000 and all the reports we created in CRYSTAL REPORT 9.0. Now our customer is complaining that printing speed is very slow. IS there any way to fasten the printing speed of Crystal report ?Instal Generic Printer and adjust the report accordingly. in this case you will not able to print graphics line etc. but printing is very very fast. The printer driver exists in windows. i have also applied this thing in my projects (with crystal 8.0).|||Originally posted by jimman
Hi,
We have created an application in VB 6, MS ACCESS 2000 and all the reports we created in CRYSTAL REPORT 9.0. Now our customer is complaining that printing speed is very slow. IS there any way to fasten the printing speed of Crystal report ?

Hi,

Use Printer support fonts, you can find out the printer icon contains in the front of the font name.|||HI,

I think the best way to achieve fast printing is to print in DOS format; for this u will have to export the report into text file and using Bat file print this report..

try and see..

swapnil

Failure to authendicate domain/users

I have several access databases in mind to migrate to SQL server. I installed MS SQL 2005 Express on my machine. I will have procedures to run with authorizations beyond that of a common user, such as database administrative work where server agent is not available, I may rely on users' log-on prompt to do some maintenance work. However, I cannot get the EXEC AS 'Domain\User' to work. The procedures can be created OK. But whenever they are called, the following message shows up:

Msg 15404, Level 16, State 19, Procedure XXX, Line 0
Could not obtain information about Windows NT group/user 'Domain\User', error code 0xea.

I tried to tweak with the account under which the server service is running. There are three options under built-in account: Local system, Local service, and Network Service. My understanding is that Network Service will use the log-on of the current user of the computer. I have admin right of the computer. None of the three options work. Additionally, when I specify an account (my own account), it's the same thing.

The procedure xp_logininfo always fails when I query a specific domain\user.

The ADHelper is configured to run manually.

I could not think of other ways to get a possible solution. Any help is much appreciated.

hi,

try having a look at http://support.microsoft.com/kb/834124/en-us

regards

|||

Hi, there,

I did several times. The problem is that the article does not contain an explanation of state 19. It has explanations for state 21 and above. Do you have any idea what state 19 relates to?

Thanks,

Failure sending mail: Cannot access a closed Stream

Running Report Server SP2 and can't get reliable Subscription emails sent.
Keep getting the error"Failure sending mail: Cannot access a closed Stream"
As a test I subscribed to a report to run every 2 minutes and let it run all
night. Surprisingly, the email succeeded and was sent to me two times every
four hours and then would fail for another four hours. (Example emailed ok at
6:00pm and 6:02pm but then failed every two minutes until it was again
successful at 10:00pm and 10:02pm) This cycle continued all night.
I have seen multiple strings on this same error in other newsgroups and
google searches but never any solutions. Does anyone have anything I can try?
I am getting desperate. Thanks in advance.Any luck with finding a solution to this problem? We are also suffering
through the same situation. It seems to occur mainly with subscriptions that
have mulitple recipients listed. It also only occurs only every now and
then. Very hard to troubleshoot. It began after application of SP2.
"Dan Varozza" wrote:
> Running Report Server SP2 and can't get reliable Subscription emails sent.
> Keep getting the error"Failure sending mail: Cannot access a closed Stream"
> As a test I subscribed to a report to run every 2 minutes and let it run all
> night. Surprisingly, the email succeeded and was sent to me two times every
> four hours and then would fail for another four hours. (Example emailed ok at
> 6:00pm and 6:02pm but then failed every two minutes until it was again
> successful at 10:00pm and 10:02pm) This cycle continued all night.
> I have seen multiple strings on this same error in other newsgroups and
> google searches but never any solutions. Does anyone have anything I can try?
> I am getting desperate. Thanks in advance.|||No I have had no luck finding a solution. I too noticed that it was happening
with reports that had multiple subscriptions and recipients. My solution for
now was to delete all subscriptions and replace them with one subscription
that contains all the recipients. This subscription now runs fine once per
day and sends out the email to all the recipients. It seems the mail delivery
only has a problem when there are a lot a mail jobs occuring at different
times for a given report. Funny thing is that I see this error reproted on
other posts and never any answers. It's like nobody at Microsoft wants to
acknowledge this issue so I guess we have to live with it.
"John Marks" wrote:
> Any luck with finding a solution to this problem? We are also suffering
> through the same situation. It seems to occur mainly with subscriptions that
> have mulitple recipients listed. It also only occurs only every now and
> then. Very hard to troubleshoot. It began after application of SP2.
>
> "Dan Varozza" wrote:
> > Running Report Server SP2 and can't get reliable Subscription emails sent.
> > Keep getting the error"Failure sending mail: Cannot access a closed Stream"
> >
> > As a test I subscribed to a report to run every 2 minutes and let it run all
> > night. Surprisingly, the email succeeded and was sent to me two times every
> > four hours and then would fail for another four hours. (Example emailed ok at
> > 6:00pm and 6:02pm but then failed every two minutes until it was again
> > successful at 10:00pm and 10:02pm) This cycle continued all night.
> >
> > I have seen multiple strings on this same error in other newsgroups and
> > google searches but never any solutions. Does anyone have anything I can try?
> > I am getting desperate. Thanks in advance.

Failure Audit log

We have started seeing a lot of failure audits on our sql server after we
gave a couple of domain users access to the SQL DB. The users have
permissions to read/write to certain tables in some databases. Any idea what
is causing this?
Event Type: Failure Audit
Event Source: Security
Event Category: Object Access
Event ID: 560
Date: 5/5/2005
Time: 1:08:00 PM
User: <<DOMAIN\KNOWN_USER_NAME>>
Computer: <<SERVER_NAME>>
Description:
Object Open:
Object Server: SC Manager
Object Type: SC_MANAGER OBJECT
Object Name: ServicesActive
Handle ID: -
Operation ID: {0,<<000000000>>}
Process ID: 844
Image File Name: C:\WINDOWS\system32\services.exe
Primary User Name: <<SERVER_NAME>>$
Primary Domain: SAGO
Primary Logon ID: (0x0,0x<<000>> )
Client User Name: <<KNOWN_USER_NAME>>
Client Domain: SAGO
Client Logon ID: (0x0,0x<<00000000>> )
Accesses: READ_CONTROL
Connect to service controller
Enumerate services
Query service database lock state
Privileges: -
Restricted Sid Count: 0
Access Mask: 0x20015
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.Based on my experience, this error usually occurs when a user
(DOMAIN\KNOWN_USER_NAME) makes a connection via a MMC and they do not have
the permissions to perform this action.
Can you identify what actions were performing at that time this error was
logged? In addition, is there any business impact casued by this error? Do
the domain users have any difficulty doing their job?
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Failure Audit log
>thread-index: AcVWbUHfZOaL7esET9Wrkqq2v6XWfA==
>X-WBNR-Posting-Host: 128.194.92.153
>From: "examnotes" <stech@.nospam.nospam>
>Subject: Failure Audit log
>Date: Wed, 11 May 2005 14:06:10 -0700
>Lines: 44
>Message-ID: <DA088796-FBED-4CCB-B9FC-2A2370CEACF0@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.security
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:4976
>X-Tomcat-NG: microsoft.public.sqlserver.security
>
>We have started seeing a lot of failure audits on our sql server after we
>gave a couple of domain users access to the SQL DB. The users have
>permissions to read/write to certain tables in some databases. Any idea
what
>is causing this?
>Event Type: Failure Audit
>Event Source: Security
>Event Category: Object Access
>Event ID: 560
>Date: 5/5/2005
>Time: 1:08:00 PM
>User: <<DOMAIN\KNOWN_USER_NAME>>
>Computer: <<SERVER_NAME>>
>Description:
>Object Open:
> Object Server: SC Manager
> Object Type: SC_MANAGER OBJECT
> Object Name: ServicesActive
> Handle ID: -
> Operation ID: {0,<<000000000>>}
> Process ID: 844
> Image File Name: C:\WINDOWS\system32\services.exe
> Primary User Name: <<SERVER_NAME>>$
> Primary Domain: SAGO
> Primary Logon ID: (0x0,0x<<000>> )
> Client User Name: <<KNOWN_USER_NAME>>
> Client Domain: SAGO
> Client Logon ID: (0x0,0x<<00000000>> )
> Accesses: READ_CONTROL
> Connect to service controller
> Enumerate services
> Query service database lock state
> Privileges: -
> Restricted Sid Count: 0
> Access Mask: 0x20015
>
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>
>|||Wang,
You are right in that these people have a connection to our SQL server
(SQL-A) defined in MMC. But we are not sure what action they perform which
causes this to happen.
As far as actions go, users perform simple tasks like opening tables,
performing simple queires.
We even have one user who is not connected to the SQL-A server (although he
has the server registered under mmc), but he is connected to a different SQL
server through MMC, and at the same time, we have failure audits for that
person in the event log.
Looking at his MMC, I can see that he is connected to his local SQL server-
at the same time, there is a round circle with no green arrow inside for the
SQL-A server. So looks like MMC is attempting to poll SQL-A to see if it is
active but it is failing.
Looking at the event log, we have one entry every 10-15 seconds per person.
We would like for a way to stop these entries from showing up in the
security event log.
Thanks!
"William Wang[MSFT]" wrote:

> Based on my experience, this error usually occurs when a user
> (DOMAIN\KNOWN_USER_NAME) makes a connection via a MMC and they do not have
> the permissions to perform this action.
> Can you identify what actions were performing at that time this error was
> logged? In addition, is there any business impact casued by this error? Do
> the domain users have any difficulty doing their job?
> Sincerely,
> William Wang
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> --
> what
>|||This issue does not seem to be related to SQL server itself. I've seen a
similar issue before which occurs on a machine with multiple NICs
installed. If you have multiple NICs, I suggest that you temporarily
disable the unused ones for testing purpose.
If the issue persists, please check if the issue occurs with a user with
local admin right.
Because the issue occurs when users are getting Object Access Failure when
trying to access a server, you may want to use filemon/regmon (which can be
downloaded from www.sysinternals.com) to monitor the "access denied" error.
Third-Party Link Disclaimer
===========
This response contains a reference to a third-party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/defaul...rnational.aspx.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Failure Audit log
>thread-index: AcVX0ejCUeEAKnwdQfyIE+x61JsD+g==
>X-WBNR-Posting-Host: 128.194.92.153
>From: "examnotes" <stech@.nospam.nospam>
>References: <DA088796-FBED-4CCB-B9FC-2A2370CEACF0@.microsoft.com>
<xqiJe3rVFHA.460@.TK2MSFTNGXA01.phx.gbl>
>Subject: RE: Failure Audit log
>Date: Fri, 13 May 2005 08:39:11 -0700
>Lines: 118
>Message-ID: <F85CF50F-70C9-401E-92BF-F161EF680A2D@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.security
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTFEED02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA
03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.security:4995
>X-Tomcat-NG: microsoft.public.sqlserver.security
>Wang,
>You are right in that these people have a connection to our SQL server
>(SQL-A) defined in MMC. But we are not sure what action they perform which
>causes this to happen.
>As far as actions go, users perform simple tasks like opening tables,
>performing simple queires.
>We even have one user who is not connected to the SQL-A server (although
he
>has the server registered under mmc), but he is connected to a different
SQL
>server through MMC, and at the same time, we have failure audits for that
>person in the event log.
>Looking at his MMC, I can see that he is connected to his local SQL
server-
>at the same time, there is a round circle with no green arrow inside for
the
>SQL-A server. So looks like MMC is attempting to poll SQL-A to see if it
is
>active but it is failing.
>Looking at the event log, we have one entry every 10-15 seconds per
person.
>We would like for a way to stop these entries from showing up in the
>security event log.
>Thanks!
>
>"William Wang[MSFT]" wrote:
>
have[vbcol=seagreen]
was[vbcol=seagreen]
Do[vbcol=seagreen]
rights.[vbcol=seagreen]
we[vbcol=seagreen]
>

Failure Audit for SQL Server

I am getting the below Failure Audit in the SQL Server event log for 3 users.
All the users have access to a database in SQL Server with their domain
account. Below message keeps poping every second. How can I trouble shoot
this ? What is causing it ?
Thanks.
Source: Security
Type: Failure
Event ID: 560
Object Open:
Object Server:SC Manager
Object Type:SERVICE OBJECT
Object Name:MSSQLSERVER
New Handle ID:-
Operation ID:{0,1170910191}
Process ID:316
Primary User Name:DEVSERV1$
Primary Domain:CMR_PO
Primary Logon ID:(0x0,0x3E7)
Client User Name:aclint
Client Domain:CMR_PO
Client Logon ID:(0x0,0x3BAC59FE)
AccessesREAD_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges-
An event id 560 is just an open event. Check aclint's permission carefully.
Maybe ther is something he/she doesn't have access to like a particular proc
or table. Ask them if they see a message on their screen or if they are
experiencing any problems. see
http://www.microsoft.com/technet/arc...mspx?mfr=true
for more info on security event logs
"DXC" wrote:

> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server:SC Manager
> Object Type:SERVICE OBJECT
> Object Name:MSSQLSERVER
> New Handle ID:-
> Operation ID:{0,1170910191}
> Process ID:316
> Primary User Name:DEVSERV1$
> Primary Domain:CMR_PO
> Primary Logon ID:(0x0,0x3E7)
> Client User Name:aclint
> Client Domain:CMR_PO
> Client Logon ID:(0x0,0x3BAC59FE)
> AccessesREAD_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges-
>
|||My guess is that this is either EM or Service Manager which tries to see whether the service is
running.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...[vbcol=seagreen]
> An event id 560 is just an open event. Check aclint's permission carefully.
> Maybe ther is something he/she doesn't have access to like a particular proc
> or table. Ask them if they see a message on their screen or if they are
> experiencing any problems. see
> http://www.microsoft.com/technet/arc...mspx?mfr=true
> for more info on security event logs
> "DXC" wrote:
|||Thanks for the replies but I will not pursue this any longer since I can not
get any info from our developers who are having this problem in terms of what
they are trying to run/access. It seems like there is no way to find out what
they are doing from my end. I don't see anything under "Current Activity"
window either.
Windows 2000, SQL Server 2000 SE-SP4
Thanks again.
"Tibor Karaszi" wrote:

> My guess is that this is either EM or Service Manager which tries to see whether the service is
> running.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
>
|||Again, it is probably EM checking whether the server is running. You can check this, by asking one
of the users to stop EM, see if these events stop, and start EM again.
Also, you can uncheck the option "Display server state in console" for the server registration in EM
and see if these events disappear.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:2C1753AF-910D-4F62-A781-5870EE0C702E@.microsoft.com...[vbcol=seagreen]
> Thanks for the replies but I will not pursue this any longer since I can not
> get any info from our developers who are having this problem in terms of what
> they are trying to run/access. It seems like there is no way to find out what
> they are doing from my end. I don't see anything under "Current Activity"
> window either.
> Windows 2000, SQL Server 2000 SE-SP4
> Thanks again.
> "Tibor Karaszi" wrote:
|||In reference to SQL2000 at this site:
You may want to check if users are signed on to SQL Enterprise using
SQL logins and have 'Poll Server' checked
<Tools><Options>[Panel]General.
If this is checked, it will generate audit failures trying to
poll/acquire data using their domain account(s).
DXC wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server:SC Manager
> Object Type:SERVICE OBJECT
> Object Name:MSSQLSERVER
> New Handle ID:-
> Operation ID:{0,1170910191}
> Process ID:316
> Primary User Name:DEVSERV1$
> Primary Domain:CMR_PO
> Primary Logon ID:(0x0,0x3E7)
> Client User Name:aclint
> Client Domain:CMR_PO
> Client Logon ID:(0x0,0x3BAC59FE)
> AccessesREAD_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges-

Failure Audit for SQL Server

I am getting the below Failure Audit in the SQL Server event log for 3 users
.
All the users have access to a database in SQL Server with their domain
account. Below message keeps poping every second. How can I trouble shoot
this ? What is causing it ?
Thanks.
----
Source: Security
Type: Failure
Event ID: 560
----
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSQLSERVER
New Handle ID: -
Operation ID: {0,1170910191}
Process ID: 316
Primary User Name: DEVSERV1$
Primary Domain: CMR_PO
Primary Logon ID: (0x0,0x3E7)
Client User Name: aclint
Client Domain: CMR_PO
Client Logon ID: (0x0,0x3BAC59FE)
Accesses READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges -An event id 560 is just an open event. Check aclint's permission carefully.
Maybe ther is something he/she doesn't have access to like a particular proc
or table. Ask them if they see a message on their screen or if they are
experiencing any problems. see
[url]http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true[/u
rl]
for more info on security event logs
"DXC" wrote:

> I am getting the below Failure Audit in the SQL Server event log for 3 use
rs.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -
>|||My guess is that this is either EM or Service Manager which tries to see whe
ther the service is
running.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...[vbcol=seagreen]
> An event id 560 is just an open event. Check aclint's permission carefull
y.
> Maybe ther is something he/she doesn't have access to like a particular pr
oc
> or table. Ask them if they see a message on their screen or if they are
> experiencing any problems. see
> [url]http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true[
/url]
> for more info on security event logs
> "DXC" wrote:
>|||Thanks for the replies but I will not pursue this any longer since I can not
get any info from our developers who are having this problem in terms of wha
t
they are trying to run/access. It seems like there is no way to find out wha
t
they are doing from my end. I don't see anything under "Current Activity"
window either.
Windows 2000, SQL Server 2000 SE-SP4
Thanks again.
"Tibor Karaszi" wrote:

> My guess is that this is either EM or Service Manager which tries to see w
hether the service is
> running.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
>|||Again, it is probably EM checking whether the server is running. You can che
ck this, by asking one
of the users to stop EM, see if these events stop, and start EM again.
Also, you can uncheck the option "Display server state in console" for the s
erver registration in EM
and see if these events disappear.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:2C1753AF-910D-4F62-A781-5870EE0C702E@.microsoft.com...[vbcol=seagreen]
> Thanks for the replies but I will not pursue this any longer since I can n
ot
> get any info from our developers who are having this problem in terms of w
hat
> they are trying to run/access. It seems like there is no way to find out w
hat
> they are doing from my end. I don't see anything under "Current Activity"
> window either.
> Windows 2000, SQL Server 2000 SE-SP4
> Thanks again.
> "Tibor Karaszi" wrote:
>|||In reference to SQL2000 at this site:
You may want to check if users are signed on to SQL Enterprise using
SQL logins and have 'Poll Server' checked
<Tools><Options>[Panel]General.
If this is checked, it will generate audit failures trying to
poll/acquire data using their domain account(s).
DXC wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 use
rs.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -

Failure Audit for SQL Server

I am getting the below Failure Audit in the SQL Server event log for 3 users.
All the users have access to a database in SQL Server with their domain
account. Below message keeps poping every second. How can I trouble shoot
this ? What is causing it ?
Thanks.
----
Source: Security
Type: Failure
Event ID: 560
----
Object Open:
Object Server: SC Manager
Object Type: SERVICE OBJECT
Object Name: MSSQLSERVER
New Handle ID: -
Operation ID: {0,1170910191}
Process ID: 316
Primary User Name: DEVSERV1$
Primary Domain: CMR_PO
Primary Logon ID: (0x0,0x3E7)
Client User Name: aclint
Client Domain: CMR_PO
Client Logon ID: (0x0,0x3BAC59FE)
Accesses READ_CONTROL
Query service configuration information
Query status of service
Enumerate dependencies of service
Query information from service
Privileges -An event id 560 is just an open event. Check aclint's permission carefully.
Maybe ther is something he/she doesn't have access to like a particular proc
or table. Ask them if they see a message on their screen or if they are
experiencing any problems. see
http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
for more info on security event logs
"DXC" wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -
>|||My guess is that this is either EM or Service Manager which tries to see whether the service is
running.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Francis" <Francis@.discussions.microsoft.com> wrote in message
news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
> An event id 560 is just an open event. Check aclint's permission carefully.
> Maybe ther is something he/she doesn't have access to like a particular proc
> or table. Ask them if they see a message on their screen or if they are
> experiencing any problems. see
> http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
> for more info on security event logs
> "DXC" wrote:
>> I am getting the below Failure Audit in the SQL Server event log for 3 users.
>> All the users have access to a database in SQL Server with their domain
>> account. Below message keeps poping every second. How can I trouble shoot
>> this ? What is causing it ?
>> Thanks.
>> ----
>> Source: Security
>> Type: Failure
>> Event ID: 560
>> ----
>>
>> Object Open:
>> Object Server: SC Manager
>> Object Type: SERVICE OBJECT
>> Object Name: MSSQLSERVER
>> New Handle ID: -
>> Operation ID: {0,1170910191}
>> Process ID: 316
>> Primary User Name: DEVSERV1$
>> Primary Domain: CMR_PO
>> Primary Logon ID: (0x0,0x3E7)
>> Client User Name: aclint
>> Client Domain: CMR_PO
>> Client Logon ID: (0x0,0x3BAC59FE)
>> Accesses READ_CONTROL
>> Query service configuration information
>> Query status of service
>> Enumerate dependencies of service
>> Query information from service
>> Privileges -|||Thanks for the replies but I will not pursue this any longer since I can not
get any info from our developers who are having this problem in terms of what
they are trying to run/access. It seems like there is no way to find out what
they are doing from my end. I don't see anything under "Current Activity"
window either.
Windows 2000, SQL Server 2000 SE-SP4
Thanks again.
"Tibor Karaszi" wrote:
> My guess is that this is either EM or Service Manager which tries to see whether the service is
> running.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Francis" <Francis@.discussions.microsoft.com> wrote in message
> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
> > An event id 560 is just an open event. Check aclint's permission carefully.
> > Maybe ther is something he/she doesn't have access to like a particular proc
> > or table. Ask them if they see a message on their screen or if they are
> > experiencing any problems. see
> > http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
> > for more info on security event logs
> >
> > "DXC" wrote:
> >
> >> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> >> All the users have access to a database in SQL Server with their domain
> >> account. Below message keeps poping every second. How can I trouble shoot
> >> this ? What is causing it ?
> >>
> >> Thanks.
> >> ----
> >> Source: Security
> >> Type: Failure
> >> Event ID: 560
> >> ----
> >>
> >>
> >> Object Open:
> >> Object Server: SC Manager
> >> Object Type: SERVICE OBJECT
> >> Object Name: MSSQLSERVER
> >> New Handle ID: -
> >> Operation ID: {0,1170910191}
> >> Process ID: 316
> >> Primary User Name: DEVSERV1$
> >> Primary Domain: CMR_PO
> >> Primary Logon ID: (0x0,0x3E7)
> >> Client User Name: aclint
> >> Client Domain: CMR_PO
> >> Client Logon ID: (0x0,0x3BAC59FE)
> >> Accesses READ_CONTROL
> >> Query service configuration information
> >> Query status of service
> >> Enumerate dependencies of service
> >> Query information from service
> >>
> >> Privileges -
> >>
>|||Again, it is probably EM checking whether the server is running. You can check this, by asking one
of the users to stop EM, see if these events stop, and start EM again.
Also, you can uncheck the option "Display server state in console" for the server registration in EM
and see if these events disappear.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:2C1753AF-910D-4F62-A781-5870EE0C702E@.microsoft.com...
> Thanks for the replies but I will not pursue this any longer since I can not
> get any info from our developers who are having this problem in terms of what
> they are trying to run/access. It seems like there is no way to find out what
> they are doing from my end. I don't see anything under "Current Activity"
> window either.
> Windows 2000, SQL Server 2000 SE-SP4
> Thanks again.
> "Tibor Karaszi" wrote:
>> My guess is that this is either EM or Service Manager which tries to see whether the service is
>> running.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Francis" <Francis@.discussions.microsoft.com> wrote in message
>> news:5844A73A-7208-480C-BDC8-8DDAADA4C86B@.microsoft.com...
>> > An event id 560 is just an open event. Check aclint's permission carefully.
>> > Maybe ther is something he/she doesn't have access to like a particular proc
>> > or table. Ask them if they see a message on their screen or if they are
>> > experiencing any problems. see
>> > http://www.microsoft.com/technet/archive/winntas/support/usesecur.mspx?mfr=true
>> > for more info on security event logs
>> >
>> > "DXC" wrote:
>> >
>> >> I am getting the below Failure Audit in the SQL Server event log for 3 users.
>> >> All the users have access to a database in SQL Server with their domain
>> >> account. Below message keeps poping every second. How can I trouble shoot
>> >> this ? What is causing it ?
>> >>
>> >> Thanks.
>> >> ----
>> >> Source: Security
>> >> Type: Failure
>> >> Event ID: 560
>> >> ----
>> >>
>> >>
>> >> Object Open:
>> >> Object Server: SC Manager
>> >> Object Type: SERVICE OBJECT
>> >> Object Name: MSSQLSERVER
>> >> New Handle ID: -
>> >> Operation ID: {0,1170910191}
>> >> Process ID: 316
>> >> Primary User Name: DEVSERV1$
>> >> Primary Domain: CMR_PO
>> >> Primary Logon ID: (0x0,0x3E7)
>> >> Client User Name: aclint
>> >> Client Domain: CMR_PO
>> >> Client Logon ID: (0x0,0x3BAC59FE)
>> >> Accesses READ_CONTROL
>> >> Query service configuration information
>> >> Query status of service
>> >> Enumerate dependencies of service
>> >> Query information from service
>> >>
>> >> Privileges -
>> >>
>>|||In reference to SQL2000 at this site:
You may want to check if users are signed on to SQL Enterprise using
SQL logins and have 'Poll Server' checked
<Tools><Options>[Panel]General.
If this is checked, it will generate audit failures trying to
poll/acquire data using their domain account(s).
DXC wrote:
> I am getting the below Failure Audit in the SQL Server event log for 3 users.
> All the users have access to a database in SQL Server with their domain
> account. Below message keeps poping every second. How can I trouble shoot
> this ? What is causing it ?
> Thanks.
> ----
> Source: Security
> Type: Failure
> Event ID: 560
> ----
>
> Object Open:
> Object Server: SC Manager
> Object Type: SERVICE OBJECT
> Object Name: MSSQLSERVER
> New Handle ID: -
> Operation ID: {0,1170910191}
> Process ID: 316
> Primary User Name: DEVSERV1$
> Primary Domain: CMR_PO
> Primary Logon ID: (0x0,0x3E7)
> Client User Name: aclint
> Client Domain: CMR_PO
> Client Logon ID: (0x0,0x3BAC59FE)
> Accesses READ_CONTROL
> Query service configuration information
> Query status of service
> Enumerate dependencies of service
> Query information from service
> Privileges -