Clearing LOG Files: written

Showing posts with label written. Show all posts

Thursday, March 8, 2012

CLR Procedure not beeing seen by Reporting Services

I have written a CLR stored procedure and loaded it up into SQL... I
can run from there but when I reference it from Reporting Services, I
get an error saying that the stored procedure does not exist. IT
DOES!!!
There was a post in this group where the answer was to have the Command
Type set to Text and use EXEC... The challenge with that solution is
passing parameters doesn't seem to work this way.
I have seen where people have written a T-SQL "wrapper" for the
procedure but that yeilds the same results for me.
Any help would be appreciated.Make sure the login username and password as defined in your reporting
services datasource does have rights on the stored procedure.
Simply right click the stored procedure in enterprise manager, click
permissions and grant 'exec' rights to the user being used in the
datasource.|||I am not sure why I would need to that since we are running under
integrated security. I did try to give myself explicit permissions on
the proc as you suggested and still no luck. Does the assembly need to
be strong named?
nickismyname wrote:
> Make sure the login username and password as defined in your reporting
> services datasource does have rights on the stored procedure.
> Simply right click the stored procedure in enterprise manager, click
> permissions and grant 'exec' rights to the user being used in the
> datasource.|||Before continuing, make sure that CLR Integration is enabled on the SQL
server. To do this, simply execute the system stored procedure
sp_configure on the SQL Server with advanced options enabled:
EXEC sp_configure @.configname = 'Show Advanced Options', @.configvalue =1
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure
Look for a record where the name is clr enabled and check its run_value
- it should be 1. If it's not, you'll need to set it to 1 in order to
to enable CLR Integration in SQL Server 2005. To do this, execute the
following T-SQL code:
EXEC sp_configure @.configname = 'clr enabled', @.configvalue = 1
RECONFIGURE WITH OVERRIDE
GO
There are three ways you can execute the above code against the SQL
Server:
SQL Server 2000 Query Analyzer
SQL Server 2005 SQLCMD Console Utility
SQL Server 2005 Management Studio|||It is... That was one of the first things that I did... The whole MS
"off-by-default" thing on their new baby servers can be frustrating.
Plus the proc wouldn't run from Sql Management Studio if it was off...
I did get a T-Sql "wrapper" proc to work (not sure why it wasn't
before) but I don't think this is the best solution. If you have any
other thoughts, I would love to hear them...
Thanks again
nickismyname wrote:
> Before continuing, make sure that CLR Integration is enabled on the SQL
> server. To do this, simply execute the system stored procedure
> sp_configure on the SQL Server with advanced options enabled:
> EXEC sp_configure @.configname = 'Show Advanced Options', @.configvalue => 1
> RECONFIGURE WITH OVERRIDE
> GO
> EXEC sp_configure
> Look for a record where the name is clr enabled and check its run_value
> - it should be 1. If it's not, you'll need to set it to 1 in order to
> to enable CLR Integration in SQL Server 2005. To do this, execute the
> following T-SQL code:
> EXEC sp_configure @.configname = 'clr enabled', @.configvalue = 1
> RECONFIGURE WITH OVERRIDE
> GO
> There are three ways you can execute the above code against the SQL
> Server:
> SQL Server 2000 Query Analyzer
> SQL Server 2005 SQLCMD Console Utility
> SQL Server 2005 Management Studio

Friday, February 24, 2012

client/server performance problems

We have 1000 users on a client/server CRM application that we've written in
house. Recently we started experiencing performance problems at the top of
each hour, it lasts for about 30 seconds. I have run several traces using
these events:
lock: acquired,
lock: deadlock,
rpc: completed,
sql: stmtcompleted
Each trace runs from 10 till the hour until 10 after the hour. I've dumped
them out to tables so I could query them for the top 200 records by cpu,
duration, reads and writes. I then query them by each minute of starttime to
find the worst queries. I have fixed a lot of bad queries over the past
couple of weeks but still users are complaining. We are runnings Sql Server
2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for the
server but our I'm told it has a lot of cpu and at I think 8GB of memory. I
am not a dba, I am a developer but I cant understand why I'm not solving the
problem. The queries that I've fixed are running much faster, but still the
problem persists.
Am I not using the right events in SQL Profiler? Is it possible that we're
really having some sort of network issue at that time? I would use Perfmon
but that doesnt tell me much.
Any help is appreciated,
Doug
My guess is you have a scheduled job that runs on the hour each hour. It
could also be related to checkpoints but they rarely follow such an exact
cycle. You can see these with the SQL counter CHeckpoin Pages per second.
You should monitor for CPU, Disks etc as well. See if these help:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Doug Stiers" <doug@.nospam.com> wrote in message
news:%23t7lrXYCFHA.3120@.TK2MSFTNGP12.phx.gbl...
> We have 1000 users on a client/server CRM application that we've written
> in
> house. Recently we started experiencing performance problems at the top of
> each hour, it lasts for about 30 seconds. I have run several traces using
> these events:
> lock: acquired,
> lock: deadlock,
> rpc: completed,
> sql: stmtcompleted
> Each trace runs from 10 till the hour until 10 after the hour. I've dumped
> them out to tables so I could query them for the top 200 records by cpu,
> duration, reads and writes. I then query them by each minute of starttime
> to
> find the worst queries. I have fixed a lot of bad queries over the past
> couple of weeks but still users are complaining. We are runnings Sql
> Server
> 2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for
> the
> server but our I'm told it has a lot of cpu and at I think 8GB of memory.
> I
> am not a dba, I am a developer but I cant understand why I'm not solving
> the
> problem. The queries that I've fixed are running much faster, but still
> the
> problem persists.
> Am I not using the right events in SQL Profiler? Is it possible that we're
> really having some sort of network issue at that time? I would use Perfmon
> but that doesnt tell me much.
> Any help is appreciated,
> Doug
>

client/server performance problems

We have 1000 users on a client/server CRM application that we've written in
house. Recently we started experiencing performance problems at the top of
each hour, it lasts for about 30 seconds. I have run several traces using
these events:
lock: acquired,
lock: deadlock,
rpc: completed,
sql: stmtcompleted
Each trace runs from 10 till the hour until 10 after the hour. I've dumped
them out to tables so I could query them for the top 200 records by cpu,
duration, reads and writes. I then query them by each minute of starttime to
find the worst queries. I have fixed a lot of bad queries over the past
couple of weeks but still users are complaining. We are runnings Sql Server
2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for the
server but our I'm told it has a lot of cpu and at I think 8GB of memory. I
am not a dba, I am a developer but I cant understand why I'm not solving the
problem. The queries that I've fixed are running much faster, but still the
problem persists.
Am I not using the right events in SQL Profiler? Is it possible that we're
really having some sort of network issue at that time? I would use Perfmon
but that doesnt tell me much.
Any help is appreciated,
DougMy guess is you have a scheduled job that runs on the hour each hour. It
could also be related to checkpoints but they rarely follow such an exact
cycle. You can see these with the SQL counter CHeckpoin Pages per second.
You should monitor for CPU, Disks etc as well. See if these help:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Doug Stiers" <doug@.nospam.com> wrote in message
news:%23t7lrXYCFHA.3120@.TK2MSFTNGP12.phx.gbl...
> We have 1000 users on a client/server CRM application that we've written
> in
> house. Recently we started experiencing performance problems at the top of
> each hour, it lasts for about 30 seconds. I have run several traces using
> these events:
> lock: acquired,
> lock: deadlock,
> rpc: completed,
> sql: stmtcompleted
> Each trace runs from 10 till the hour until 10 after the hour. I've dumped
> them out to tables so I could query them for the top 200 records by cpu,
> duration, reads and writes. I then query them by each minute of starttime
> to
> find the worst queries. I have fixed a lot of bad queries over the past
> couple of weeks but still users are complaining. We are runnings Sql
> Server
> 2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for
> the
> server but our I'm told it has a lot of cpu and at I think 8GB of memory.
> I
> am not a dba, I am a developer but I cant understand why I'm not solving
> the
> problem. The queries that I've fixed are running much faster, but still
> the
> problem persists.
> Am I not using the right events in SQL Profiler? Is it possible that we're
> really having some sort of network issue at that time? I would use Perfmon
> but that doesnt tell me much.
> Any help is appreciated,
> Doug
>

client/server performance problems

We have 1000 users on a client/server CRM application that we've written in
house. Recently we started experiencing performance problems at the top of
each hour, it lasts for about 30 seconds. I have run several traces using
these events:
lock: acquired,
lock: deadlock,
rpc: completed,
sql: stmtcompleted
Each trace runs from 10 till the hour until 10 after the hour. I've dumped
them out to tables so I could query them for the top 200 records by cpu,
duration, reads and writes. I then query them by each minute of starttime to
find the worst queries. I have fixed a lot of bad queries over the past
couple of weeks but still users are complaining. We are runnings Sql Server
2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for the
server but our I'm told it has a lot of cpu and at I think 8GB of memory. I
am not a dba, I am a developer but I cant understand why I'm not solving the
problem. The queries that I've fixed are running much faster, but still the
problem persists.
Am I not using the right events in SQL Profiler? Is it possible that we're
really having some sort of network issue at that time? I would use Perfmon
but that doesnt tell me much.
Any help is appreciated,
DougMy guess is you have a scheduled job that runs on the hour each hour. It
could also be related to checkpoints but they rarely follow such an exact
cycle. You can see these with the SQL counter CHeckpoin Pages per second.
You should monitor for CPU, Disks etc as well. See if these help:
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"Doug Stiers" <doug@.nospam.com> wrote in message
news:%23t7lrXYCFHA.3120@.TK2MSFTNGP12.phx.gbl...
> We have 1000 users on a client/server CRM application that we've written
> in
> house. Recently we started experiencing performance problems at the top of
> each hour, it lasts for about 30 seconds. I have run several traces using
> these events:
> lock: acquired,
> lock: deadlock,
> rpc: completed,
> sql: stmtcompleted
> Each trace runs from 10 till the hour until 10 after the hour. I've dumped
> them out to tables so I could query them for the top 200 records by cpu,
> duration, reads and writes. I then query them by each minute of starttime
> to
> find the worst queries. I have fixed a lot of bad queries over the past
> couple of weeks but still users are complaining. We are runnings Sql
> Server
> 2000 sp3a on a clustered Win2k SP4. I dont know the hardware config for
> the
> server but our I'm told it has a lot of cpu and at I think 8GB of memory.
> I
> am not a dba, I am a developer but I cant understand why I'm not solving
> the
> problem. The queries that I've fixed are running much faster, but still
> the
> problem persists.
> Am I not using the right events in SQL Profiler? Is it possible that we're
> really having some sort of network issue at that time? I would use Perfmon
> but that doesnt tell me much.
> Any help is appreciated,
> Doug
>

Sunday, February 19, 2012

Client side printing

Hi
I am trying to print Query Result directly to the printer from Client
machine. I managed to do this on Server machine. Where I had written SP which
accepts SQL as parameter and using osql and xp_cmdShell command I am
outputting CSV file to printer. I want to do same from client machine but I
want print out should get printed on client printer not on Server.
Any ideas or suggestions'
Many thanks in advance.
Regards,
Santoshxp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
the server machine, but the destination is specified as the client?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Santosh" <Santosh@.discussions.microsoft.com> wrote in message
news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> Hi
> I am trying to print Query Result directly to the printer from Client
> machine. I managed to do this on Server machine. Where I had written SP which
> accepts SQL as parameter and using osql and xp_cmdShell command I am
> outputting CSV file to printer. I want to do same from client machine but I
> want print out should get printed on client printer not on Server.
> Any ideas or suggestions'
> Many thanks in advance.
> Regards,
> Santosh
>|||Thanks Tibor, yes what you are suggesting, makes sense.
But I feel it will be better if I drop this idea and look for some different
option. Because if we want to specify UNC naming for printer. I need to make
printer as shared and need to give permissions so it can be accessible from
server by other users. Since printers are getting cheaper and cheaper, almost
everyone at client-side got there own printers, so I doubt if client admin
will accept this solution.
"Tibor Karaszi" wrote:
> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
> the server machine, but the destination is specified as the client?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> > Hi
> >
> > I am trying to print Query Result directly to the printer from Client
> > machine. I managed to do this on Server machine. Where I had written SP which
> > accepts SQL as parameter and using osql and xp_cmdShell command I am
> > outputting CSV file to printer. I want to do same from client machine but I
> > want print out should get printed on client printer not on Server.
> >
> > Any ideas or suggestions'
> >
> > Many thanks in advance.
> >
> > Regards,
> > Santosh
> >
>
>|||I agree with your assessment. Can you do the printing from the client app (which I assume is running
on the client machine already)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...
> Thanks Tibor, yes what you are suggesting, makes sense.
> But I feel it will be better if I drop this idea and look for some different
> option. Because if we want to specify UNC naming for printer. I need to make
> printer as shared and need to give permissions so it can be accessible from
> server by other users. Since printers are getting cheaper and cheaper, almost
> everyone at client-side got there own printers, so I doubt if client admin
> will accept this solution.
>
>
> "Tibor Karaszi" wrote:
>> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
>> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done
>> on
>> the server machine, but the destination is specified as the client?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
>> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
>> > Hi
>> >
>> > I am trying to print Query Result directly to the printer from Client
>> > machine. I managed to do this on Server machine. Where I had written SP which
>> > accepts SQL as parameter and using osql and xp_cmdShell command I am
>> > outputting CSV file to printer. I want to do same from client machine but I
>> > want print out should get printed on client printer not on Server.
>> >
>> > Any ideas or suggestions'
>> >
>> > Many thanks in advance.
>> >
>> > Regards,
>> > Santosh
>> >
>>|||Yup I can Print Crystal reports on local client printer through client app.
Now I have written small code in Vb.net which accepts SQL from client PC and
prints result in CSV format on local client printer.
"Tibor Karaszi" wrote:
> I agree with your assessment. Can you do the printing from the client app (which I assume is running
> on the client machine already)?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "sansaw80" <sansaw80@.discussions.microsoft.com> wrote in message
> news:E7FB20CE-CDA7-4334-BA6F-AEAEDA694852@.microsoft.com...
> > Thanks Tibor, yes what you are suggesting, makes sense.
> >
> > But I feel it will be better if I drop this idea and look for some different
> > option. Because if we want to specify UNC naming for printer. I need to make
> > printer as shared and need to give permissions so it can be accessible from
> > server by other users. Since printers are getting cheaper and cheaper, almost
> > everyone at client-side got there own printers, so I doubt if client admin
> > will accept this solution.
> >
> >
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
> >> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done
> >> on
> >> the server machine, but the destination is specified as the client?
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> http://www.sqlug.se/
> >>
> >>
> >> "Santosh" <Santosh@.discussions.microsoft.com> wrote in message
> >> news:A37189CF-9AFE-403A-97FC-2586C96C275B@.microsoft.com...
> >> > Hi
> >> >
> >> > I am trying to print Query Result directly to the printer from Client
> >> > machine. I managed to do this on Server machine. Where I had written SP which
> >> > accepts SQL as parameter and using osql and xp_cmdShell command I am
> >> > outputting CSV file to printer. I want to do same from client machine but I
> >> > want print out should get printed on client printer not on Server.
> >> >
> >> > Any ideas or suggestions'
> >> >
> >> > Many thanks in advance.
> >> >
> >> > Regards,
> >> > Santosh
> >> >
> >>
> >>
> >>
>
>

Thursday, March 8, 2012

CLR Procedure not beeing seen by Reporting Services

Friday, February 24, 2012

client/server performance problems

client/server performance problems

client/server performance problems

Sunday, February 19, 2012

Client side printing

Client side printing

Client side printing

Clearing LOG Files

Blog Archive

About Me