Search results for query: *

Hi, I am trying to update a sid field of a database I moved from another server. using update sys.syslogins set sid=0x1E05CBC760218744B42F05FD36E6E333 where name = 'WORKSITEMP' I am getting this error: Msg 259, Level 16, State 1, Line 1 Ad hoc updates to system catalogs are not allowed. what...

Hello, When in INFOVIEW, looking at a report instance. under the schedule link, there are additional scheduling options. Database logon, filters, format, print settings, server groups, events, parameters how do I remove these...

Hello, I want to modify the error message that come up on the logon page in red when a user attempts to logon and has no user name in the enterprise system. What csp page do I modify? I have been looking everywhere. Help!!!!! Thanks in advance.

Hello all, How could the sort order in Instance manager be changed. Sort by date instead of by name. Thanks mbfloyd

Hello all, I am trying to limit the options available to the users in the Customizing options drop down list. It seems that if I allow the users to schedule or run a report, they also have access to the database logon, destinations, printer options, format, parameters. I would like...

Hi, I am trying to display a max record from multiple tables. example: select a.cust_name, a.cust_address, a.cust_num, b.cust_amt, c.cust_cat from a, b, c where a.cust_num = b.cust_num GROUP BY b.cust_amt order by a.cust_name asc I am getting all records, but I need the max cust_amt record for...

Hello, I am trying to use a field that contains {lastname, firstname middle} to create a report. I want to create a last name search parameter. But how do I do it if what I'm searching on is the left part of a field. I hope I explained this clearly. I am using crystal 8.5. thanks in advance.

Hello, is it possible to make a connection from crystal 8.5 to SAP r/3 logical databases for reporting. if so, please help and explain. Thanks in Advance

Hello, I am trying to create a batch file that retrives a text file (comma delimited)thats created daily and runs an update stored procedure that updates and inserts new records. Such as new employees or updates employees data. Key is employee number and/or table id number. Please help Thanks...

Whenever I restart sql server my users lose access to the tempdb database. foxdev explained that I'm using this database as a default database. How do I not use this database as a default and continue to let my users have access to the database. Please help!!!

I need some help with the tempdb database. Everytime I restart sql server my user logins become invalid. I get a message that server user is not a valid user of database tempdb. Then I have to go an give each user tempdb access for them to use the application. I know I'm doing something...

Does anyone know of a free internet service that supports linux connections with internet/linux software.

Hello...I am trying to build a reservation web site that needs a confirmation number showing on the page and posting into a access database with the assoicated record.  Please help....M