Search results for query: *

I think this is for SQL Admin forum...... I am trying to write a script to grant EXEC permissions on all non-system stored procedures on all DB's to a specific user 'QATest' The below code will do this successfully but I need a way of writing it so it will run on ALL databases. Avoiding...

I am trying to write a script to grant EXEC permissions on all non-system stored procedures on all DB's to a specific user 'QATest' The below code will do this successfully but I need a way of writing it so it will run on ALL databases. Avoiding writing the same code for all db's on the...

I have a user QATest and I want to build a script to add said users to have db_datareader access. Is there a way to write it to give it access to all db's as a reader without writing it out 15 times? use test if exists (select * from sysusers where name = 'QATest' and issqluser = 1) begin...

I have NEVER been able to make subscriptions work, I updated the RSReportServer.config file since I did not have it set up during original install. I can set up subscription but they never work any ideas. -Matt

I would like to designate the name of a cell as “column_name,” and then enter the letter equivalent of a variable column in the column_name cell. In a “Report Cell,” I would like to use excel to identify the value the variable column_name in combination with an absolute row number to have the...

I have backup logs in created by NT Backup I want to import into a canned report for Crystal 8.5, I also am using Back up Exec by Veritas with I believe use to be a Seagate product. Is there anything out that would give me daily reports in Crystal Rather than studying all these Backup Logs in...

I am not able to get into my system clock through the control panel or system tray. Message says "you do not have proper privilege level to change the system time", I can get to it using the LAN admin login and I am an administrator on the machine. Seems weird to me any suggestions?

I have a client workstation that authenticates against the server more than five times by less than 10. The only way I can keep the client form locking out is to increase the threshold to 10 tries to login. All other clients can log into that machine just fine, so I think it is something with...

All- I am having a problem with file names not refreshing after I change them. For example I change the name of a file but it does not appear to be changed unless I refresh the screen by f5 or close and open. I don't think it is a setting thing sdoes anyone know? Thanks for your help

When I change a file name on my machine the name does not change till I actually do a F5(refresh). Any ideas why?

Is there a way to display a social security number stored in a single field and format it? Stored : 522219635 Display: 522-21-9635 In Crystal Reports I can use: Left ({UPR00100.SOCSCNUM},3)+'-'+Mid ({UPR00100.SOCSCNUM},4 ,2 )+'-'+Right ({UPR00100.SOCSCNUM},4 ) But I don't beliew SQL allows...

I have created users....ITMail@domain.com and APMail@domain.com. But I do not wish to display them in the company contacts. How can I remove them so they do not show up on the global address list in outlook? Any thoughts? Matt

I have a problem with IE6, I have downloaded and installed IE6.0 SP1 but this did not help. I want to download the entire IE6 and then uninstall my old one. Thus giving me a fresh install. I believe since I will not have a browser I will need to pre-download the entire IE6...Correct? Am I...

Can you connect a Zipdrive via USB to any on the ipaq's?

I am trying to set up users so they can install programs on there own machines, in other work give they administrator rights on only there own computers. On a recent install of XP it was one of the questions when setting up the network connection, and it worked great but wha can I do for...

I have a user who needs install right only on his labtop, he is set up on the WIN2K network as a power user without install rights. I think I could have him only log onto his machine under Local Admin. but is there any other way? Matt

I am trying to log onto the data source w/ my ID and password, I keep getting a "Connection failed: SQL State: 28000 SQL Server Error '18456' It is a SQL database, I have the user setup with permissions, but it stll will not connect, any thoughts. Matt

Crystal Report 8.5 I am having problem with a rounding figures. Depending on the hours worked the Rate is showing up sometimes off by one cent. Sometimes you get $48.68 (48.676) and sometimes $48.67 (48.671) depending on the rounding. I think the answer would be to bring the decimal out to...

I am working with Crystal Reports 8.5 doing some invoices that have a record with negative amounts that I do not want showing up on the report. That is easy to suppress the negative amounts.....but I want to also remove the corresponding record that has the same amount and date associated with...