Search results for query: *

OK I GOT IT EXEC sp_MSforeachdb @command1 = 'IF ''?'' NOT IN(''master'', ''model'',''tempdb'',''msdb'') begin declare @u sysname set @u = QUOTENAME(''QATest'') declare @sql nvarchar(4000) set @sql =''select ''''grant exec on '''' + QUOTENAME(ROUTINE_SCHEMA) + ''''.'''' +...

OK I GOT IT.... EXEC sp_MSforeachdb @command1 = 'IF ''?'' NOT IN(''master'', ''model'',''tempdb'',''msdb'') begin declare @u sysname set @u = QUOTENAME(''QATest'') declare @sql nvarchar(4000) set @sql =''select ''''grant exec on '''' + QUOTENAME(ROUTINE_SCHEMA) + ''''.'''' +...

OK I still can not get this to run and its driving me crazy, can I have two EXEC statments in the script and still have it work?

OK what about something like this??? it is not working so it might not be possible?? Mr.Denny any help?? EXEC sp_MSforeachdb @command1 = 'IF ''?'' NOT IN(''master'', ''model'',''tempdb'',''msdb'') IF EXISTS (select * from ?..sysusers where name = ''QATest'' and issqluser = 1) begin...

OK Tried this but no luck as of yet is it possible? EXEC sp_MSforeachdb @command1 = 'IF ''?'' NOT IN(''master'', ''model'',''tempdb'',''msdb'') IF EXISTS (select * from ?..sysusers where name = ''QATest'' and issqluser = 1) begin print ''Granting EXEC Permissions to QATest user in ?''...

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...

That’s great!!! I have played with this all morning and I am unable to find a way to avoid running the script on the Sys databases master, model, msdb...etc. Any ideas? I was able to isolate the databases I need by running the below script but how do I incorporate this into the above script...

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...

Catadmin- Using w/ service pack 2. No messages it simply does not email, also no execution log file either. any ideas.

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 took a look but was only able to find "exchange features" and "exchange general" for the tab choices. Am I in the right area. If not I might need for detail I am very new at this. Thanks

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