Friday, March 30, 2012
Launching a Report From an Application
that the applciation gives the user a link that it dynamically builds,
populating all of the parameters for the user.
Currently the link launches the report, but we wanted two things to happen.
We did not want to show the parameters to the user from within the report and
we also wanted to kkep the tool bar, the green spirally thing when loadign
and the drop downs for exporting.
But it seems like you can either have all that studd on the toolbar and be
able to see the parameters or don't see the parameters and don't see the
toolb bar of green spirally thing.
Any suggestions here? I want to see the toolbar, but I do not want to see
the parameters.Have you tried using
&rc:Toolbar=true&rc:Parameters=false
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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
"Cooper" <Cooper@.discussions.microsoft.com> wrote in message
news:393DA10F-2182-4CA0-B5FD-C617C870384E@.microsoft.com...
> We are trying to launch a report from an application. All that happens is
> that the applciation gives the user a link that it dynamically builds,
> populating all of the parameters for the user.
> Currently the link launches the report, but we wanted two things to
> happen.
> We did not want to show the parameters to the user from within the report
> and
> we also wanted to kkep the tool bar, the green spirally thing when loadign
> and the drop downs for exporting.
> But it seems like you can either have all that studd on the toolbar and be
> able to see the parameters or don't see the parameters and don't see the
> toolb bar of green spirally thing.
> Any suggestions here? I want to see the toolbar, but I do not want to see
> the parameters.
Wednesday, March 28, 2012
Latin to Cyrillic
I have to select a loto of cyrillic records saved on a table that has
Latin collation
How can i see them in Cyrillic?
i just tried to make another table with a column with Cyrillic
collation but it won't work
Thank you
FedericoFederico,
I guess the newsgroups on www.sql.ru is the best place to ask this
question.
Monday, March 26, 2012
Latency Issues
data doesn't get persisted to the database for up to 30 minutes. What the
devil could be causing this? These are all new machines running the latest
service packs.
TIA
Tina
Hi
The application is not committing the data until very late. In a bad case,
where the connection to the server gets lost, SQL Server will rollback the
transaction as it is not committed. You can loose a lot of data though this.
In effect, there is a BEGIN TRANSACTION and somewhere further down the line,
maybe by chance (due to developer luck), there is a COMMIT TRANSACTION,
resulting in the data being committed.
Ask the developer to look at his application.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Tina Smith" <tb.smith@.earthlink.net> wrote in message
news:uGNS5ZdFFHA.2676@.TK2MSFTNGP12.phx.gbl...
> I'm seeing latency issues with a single user on MSDE. It appears that
> data doesn't get persisted to the database for up to 30 minutes. What
the
> devil could be causing this? These are all new machines running the
latest
> service packs.
> TIA
> Tina
>
sql
Friday, March 23, 2012
last update of database
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIA
No, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>
last update of database
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIANo, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>
last update of database
OS - W2K or NT
Is there a sp or any way to check when a database is last accessed by or
updated by user ?
TIANo, SQL Server doesn't track this information, unless you want to use a
third party tool to review the transaction logs. You can put code into your
own procedures, or triggers on tables if you for some reason allow direct
access to tables, to track whatever components of the transaction you like.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"pohkeat" <pohkeat@.hotmail.com> wrote in message
news:e7DI$JeNEHA.556@.tk2msftngp13.phx.gbl...
> DB - SQL2000 or SQL7
> OS - W2K or NT
>
> Is there a sp or any way to check when a database is last accessed by or
> updated by user ?
> TIA
>
>
Last time table was used
I have been assigned to research a database. I am trying to find out whether
the database is currently being used by some process/user. Is there a way to
find when a particular table/ object was last used/updated/inserted? This
would help me in finding out what tables are not being used at all. Thanks in
advance.
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:5AB6D4A8-177F-4B1E-8B7A-2CA212F5302B@.microsoft.com...
> Hi,
> I have been assigned to research a database. I am trying to find out
> whether
> the database is currently being used by some process/user. Is there a way
> to
> find when a particular table/ object was last used/updated/inserted? This
> would help me in finding out what tables are not being used at all. Thanks
> in
> advance.
Not by default.
Generally you need to setup a profiler to watch that object.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com
|||Hi "sharman"!
try to look at sys.dm_db_index_usage_stats dynamic view:
each row of that view refers to an index or an heap table (Index_id = 0 is
for heaps, 1 for clustered index and 2-249 for non-clustered indexes). thera
are interesting columns for you: look at the Books on-line for details!
Gilberto
"sharman" wrote:
> Hi,
> I have been assigned to research a database. I am trying to find out whether
> the database is currently being used by some process/user. Is there a way to
> find when a particular table/ object was last used/updated/inserted? This
> would help me in finding out what tables are not being used at all. Thanks in
> advance.
Last time table was used
I have been assigned to research a database. I am trying to find out whether
the database is currently being used by some process/user. Is there a way to
find when a particular table/ object was last used/updated/inserted? This
would help me in finding out what tables are not being used at all. Thanks i
n
advance."sharman" <sharman@.discussions.microsoft.com> wrote in message
news:5AB6D4A8-177F-4B1E-8B7A-2CA212F5302B@.microsoft.com...
> Hi,
> I have been assigned to research a database. I am trying to find out
> whether
> the database is currently being used by some process/user. Is there a way
> to
> find when a particular table/ object was last used/updated/inserted? This
> would help me in finding out what tables are not being used at all. Thanks
> in
> advance.
Not by default.
Generally you need to setup a profiler to watch that object.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||Hi "sharman"!
try to look at sys.dm_db_index_usage_stats dynamic view:
each row of that view refers to an index or an heap table (Index_id = 0 is
for heaps, 1 for clustered index and 2-249 for non-clustered indexes). thera
are interesting columns for you: look at the Books on-line for details!
Gilberto
"sharman" wrote:
> Hi,
> I have been assigned to research a database. I am trying to find out wheth
er
> the database is currently being used by some process/user. Is there a way
to
> find when a particular table/ object was last used/updated/inserted? This
> would help me in finding out what tables are not being used at all. Thanks
in
> advance.
Last time table was used
I have been assigned to research a database. I am trying to find out whether
the database is currently being used by some process/user. Is there a way to
find when a particular table/ object was last used/updated/inserted? This
would help me in finding out what tables are not being used at all. Thanks in
advance."sharman" <sharman@.discussions.microsoft.com> wrote in message
news:5AB6D4A8-177F-4B1E-8B7A-2CA212F5302B@.microsoft.com...
> Hi,
> I have been assigned to research a database. I am trying to find out
> whether
> the database is currently being used by some process/user. Is there a way
> to
> find when a particular table/ object was last used/updated/inserted? This
> would help me in finding out what tables are not being used at all. Thanks
> in
> advance.
Not by default.
Generally you need to setup a profiler to watch that object.
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com|||Hi "sharman"!
try to look at sys.dm_db_index_usage_stats dynamic view:
each row of that view refers to an index or an heap table (Index_id = 0 is
for heaps, 1 for clustered index and 2-249 for non-clustered indexes). thera
are interesting columns for you: look at the Books on-line for details!
Gilberto
"sharman" wrote:
> Hi,
> I have been assigned to research a database. I am trying to find out whether
> the database is currently being used by some process/user. Is there a way to
> find when a particular table/ object was last used/updated/inserted? This
> would help me in finding out what tables are not being used at all. Thanks in
> advance.sql
Wednesday, March 21, 2012
Last synchronisation date for a (merge)-publication
Is there any table where I can find the last updated (last synced) date
and time for a subscription?
I am trying to warn a user if his/her subscription did not synchronise
since an xxx number of days but I can't locate the date/time for the
last successfull synchronisation.
Thx,
Ferry
you can query the history tables in the distribution database.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ferry" <ferryswi A@.T ferryswi D.O.T tmfweb D.O.T nl> wrote in message
news:mn.a56e7d63bfca7a9f.23024@.TferryswiD.O.Ttmfwe bD.O.Tnl...
> Hi!
> Is there any table where I can find the last updated (last synced) date
> and time for a subscription?
> I am trying to warn a user if his/her subscription did not synchronise
> since an xxx number of days but I can't locate the date/time for the last
> successfull synchronisation.
> Thx,
> Ferry
>
Last Select Statement
Regards,
Bala
With the SQL Server Profiler tool, you can monitor querying activity, including who's running the query. But you only get that information when it's running... I don't know of a general activity log SQL Server keeps that you could study.
-Ryan / Kardax
|||You could try using Lumigent's Log Explorer or Red-Gate's Log Rescue, however these will not help with tracking SELECT statements but will help track modifications to the database's data or structure:
http://www.lumigent.com/products/le_sql.html
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm
Note that the ability to obtain such information from a database's log file is dependent on both the database's recovery model and when the last log backup was taken (if appropriate).
Chris
Last repost: linked server local SQL login romote Windows login
If you mean local as in local NT User (non domain) then no.
If you mean a domain user id then yes, but you will need
to set up the remote computer.
J
>--Original Message--
>I have posted this twice, no response. Anyone from the
MS SQL Server team
>or anyone else could give me an answer? Thanks.
>Win2K, SQL Server2K.
>Hi group,
>can someone confirm me that this is not possible, or tell
me how to do it?
>For a local sql server login, the connectivity is to be
established with the
>remote login being a Windows login.
>Thanks.
>Quentin
>
>.
>Thanks.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:2275701c45d2a$9c543370$a501280a@.phx
.gbl...[vbcol=seagreen]
> If you mean local as in a non NT Authorisation then no.
> If you mean local as in local NT User (non domain) then no.
> If you mean a domain user id then yes, but you will need
> to set up the remote computer.
> J
>
> MS SQL Server team
> me how to do it?
> established with thesql
Last repost: linked server local SQL login romote Windows login
If you mean local as in local NT User (non domain) then no.
If you mean a domain user id then yes, but you will need
to set up the remote computer.
J
>--Original Message--
>I have posted this twice, no response. Anyone from the
MS SQL Server team
>or anyone else could give me an answer? Thanks.
>Win2K, SQL Server2K.
>Hi group,
>can someone confirm me that this is not possible, or tell
me how to do it?
>For a local sql server login, the connectivity is to be
established with the
>remote login being a Windows login.
>Thanks.
>Quentin
>
>.
>
Thanks.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:2275701c45d2a$9c543370$a501280a@.phx.gbl...[vbcol=seagreen]
> If you mean local as in a non NT Authorisation then no.
> If you mean local as in local NT User (non domain) then no.
> If you mean a domain user id then yes, but you will need
> to set up the remote computer.
> J
>
> MS SQL Server team
> me how to do it?
> established with the
|||Thanks.
"Julie" <anonymous@.discussions.microsoft.com> wrote in message
news:2275701c45d2a$9c543370$a501280a@.phx.gbl...[vbcol=seagreen]
> If you mean local as in a non NT Authorisation then no.
> If you mean local as in local NT User (non domain) then no.
> If you mean a domain user id then yes, but you will need
> to set up the remote computer.
> J
>
> MS SQL Server team
> me how to do it?
> established with the
Last period as initial value but still have period as parameter?
Hi all,
I'm using an olap cube in a report (dash board).
The last "actual" period should be viewed when the user opens the report. I'm using the MDX tail function for that.
Once the report is opened the users want to select another period. Then I want to put period as a parameter.
But that is not possible since the parameter check box is no longer available when using a MDX filter expression.
Is there any solution to this problem?
Any help will be appreciated.
If you know MDX, then don't use the query designer and just write your own queries. You'll need to have 2 maybe 3 datasets:
Main query dataset
Monday, March 19, 2012
Last login in sql server
Is there any way to tell when a user last logged into sql server/system
without auditing set? Are there any system tables or sp that will give me
that information? Thanks.
--
New SQL Server DBANewbie,
For current processes:
SELECT LOGINAME,LOGIN_TIME FROM MASTER..SYSPROCESSES
For logins in the past...not that I'm aware of without using built-in
auditing, a custom auditing solution or third-party auditing software. A
shot in the dark, you might be able to determine this by evaulating the
t-log backups in the past with a third-party log viewer tool.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:7692EDE5-82DC-4538-91A0-0E380D41862F@.microsoft.com...
> Hello,
> Is there any way to tell when a user last logged into sql server/system
> without auditing set? Are there any system tables or sp that will give me
> that information? Thanks.
> --
> New SQL Server DBA
Last login in sql server
Is there any way to tell when a user last logged into sql server/system
without auditing set? Are there any system tables or sp that will give me
that information? Thanks.
--
New SQL Server DBANewbie,
For current processes:
SELECT LOGINAME,LOGIN_TIME FROM MASTER..SYSPROCESSES
For logins in the past...not that I'm aware of without using built-in
auditing, a custom auditing solution or third-party auditing software. A
shot in the dark, you might be able to determine this by evaulating the
t-log backups in the past with a third-party log viewer tool.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:7692EDE5-82DC-4538-91A0-0E380D41862F@.microsoft.com...
> Hello,
> Is there any way to tell when a user last logged into sql server/system
> without auditing set? Are there any system tables or sp that will give me
> that information? Thanks.
> --
> New SQL Server DBA
Last login in sql server
Is there any way to tell when a user last logged into sql server/system
without auditing set? Are there any system tables or sp that will give me
that information? Thanks.
New SQL Server DBA
Newbie,
For current processes:
SELECT LOGINAME,LOGIN_TIME FROM MASTER..SYSPROCESSES
For logins in the past...not that I'm aware of without using built-in
auditing, a custom auditing solution or third-party auditing software. A
shot in the dark, you might be able to determine this by evaulating the
t-log backups in the past with a third-party log viewer tool.
HTH
Jerry
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:7692EDE5-82DC-4538-91A0-0E380D41862F@.microsoft.com...
> Hello,
> Is there any way to tell when a user last logged into sql server/system
> without auditing set? Are there any system tables or sp that will give me
> that information? Thanks.
> --
> New SQL Server DBA
Monday, March 12, 2012
Last Executed SP (Log file)
I want to know what is the last stored procedure executed in the server and
by which user. Is it possible to find. (I think there is some log for this)
anybody can help me.
Advanced Thanks
B. SundarNo, there isn't any log for it. You probably need to run Profiler to get
that kind of information.
"Sundar Bramanayagam" wrote:
> Hi
> I want to know what is the last stored procedure executed in the server an
d
> by which user. Is it possible to find. (I think there is some log for this
)
> anybody can help me.
> Advanced Thanks
> B. Sundar
Last Executed SP (Log file)
I want to know what is the last stored procedure executed in the server and
by which user. Is it possible to find. (I think there is some log for this)
anybody can help me.
Advanced Thanks
B. SundarNo, there isn't any log for it. You probably need to run Profiler to get
that kind of information.
"Sundar Bramanayagam" wrote:
> Hi
> I want to know what is the last stored procedure executed in the server and
> by which user. Is it possible to find. (I think there is some log for this)
> anybody can help me.
> Advanced Thanks
> B. Sundar
Last Executed SP (Log file)
I want to know what is the last stored procedure executed in the server and
by which user. Is it possible to find. (I think there is some log for this)
anybody can help me.
Advanced Thanks
B. Sundar
No, there isn't any log for it. You probably need to run Profiler to get
that kind of information.
"Sundar Bramanayagam" wrote:
> Hi
> I want to know what is the last stored procedure executed in the server and
> by which user. Is it possible to find. (I think there is some log for this)
> anybody can help me.
> Advanced Thanks
> B. Sundar