Search results for query: *

Hi I have never used VB before, and before I go about trying to learn it I would like to know whether it will solve my problem. I have a batch of 5 images, the main image is in a separate directory from the other four. I need all images to be resized and renamed in the following format: The...

I have two backup servers, the old one has been converted to run a SQL database. The new one hasn't (yet). I am going to run setupSQL.exe on the new server and point it to the old server so that the database for each resides on the same box. After searching the forum I believe that in doing...

So am I right in assuming that I can run the sqlsetup executable and create the SQL database for this new installation and it will automatically create a second instance of asdb on the SQL Server?

I have two installations of ArcServe on separate servers, and would like them to store their individual SQL databases on the same server. How do I change the default name from asdb to something different for the second installation? Is this possible?

Hi I am an MS SQL Server 2000 Enterprise Manager newbie and was wondering if it is possible to restrict a users access to different packages on our SQL server. Currently we have our administrator logon and one user logon. I would like to hide or forbid the execution of several (but not all)...

Using MS Query to extract data from our SQL database into Excel. Here is an excerpt from a piece of my SQL code: ... WHERE (WODRAW.MENUOPTION='11') OR (WODRAW.MENUOPTION='02') ... I have a primary key of WONUM. The code above will obviously bring out any lines where MENUOPTION is 11 or 02...

That's what I was hoping. Thanks for the advice.

So can you inform me what I have to be careful of? How can I write bad WHERE clauses? I cannot understand how, if I am writing WHERE x=1 AND y Not In ("Hello","GoodBye") this can cause a problem.

Is there an alternative to using the WHERE clause in SQL? I am a complete beginner - I am basically using SELECT * FROM * WHERE <criteria> and that is about it. I have been told that the WHERE clause could potentially kill the server but the person telling me this cannot tell me why/how. What...

Thanks for both the replies. With: select * from wo where tasknum not like '*' & wotype & '*'; I get 'Invalid operator for data type. Operator equals boolean AND, type equals varchar. Statements could not be prepared'. For: Select * From tbl Where Instr(1,TASKNUM,WOTYPE) = 0 I get...

I am not sure if you can help me here, but I cannot find anywhere else that can help me. (If anyone knows of a forum more suited to this question I would appreciate it!) I need to create the following in SQL so that a query I am running will pull the right data into Excel for me. I need to...