Search results for query: *

I want to create a scheduled task that calls a batch file to login to Windows. How would I create this batch file to do this? I basically have to have an automated login at a certain time each day so I thought I could create a scheduled task and write a batch file that the scheduled task cold...

i have a webserver that is running windows 2003 server web edition. When someone goes to the website, it takes 37 seconds for the page to pull up and it ends up timing out. The page is trying to query a database, and I have re-indexed the database and it still does the same thing. Also, the...

i have a webserver that is running windows 2003 server web edition. When someone goes to the website, it takes 37 seconds for the page to pull up and it ends up timing out. The page is trying to query a database, and I have re-indexed the database and it still does the same thing. Also, the...

When I do properties on the field, there is no default value listed. There is a property called default binding and default shema. I am using SQL 2008. Thanks.

I need to modify a field in one of my tables to always be 0 instead of NULL. Basically, when a record is created in our application, it populates a table called Credit. There is a field in the Credit table called PortType. It always populates this field with NULL and I want it to always put a...

I have a batch file that is not working when I run it. For some reason, I don't know where the error is in my script that would cause the file to not produce what I am wanting. I am trying to run a schedule task to add the date and time to a file and then copy that file to a different...

I am trying to login to a server that I am "Supose" to have access to. Sometimes I can login, and other times it tells me that I have to be a member of the remote desktop group in order to login to the server. I am not physically able to get to the server to logon it locally, so I have to use...

Running SQL 2000, can you change the DB Owner from dbo to whatever you want through Enterprise Manager, or do you HAVE to run a script? If you can do it through Enterprise Manager, please tell me how, because I can't find it anywhere what-so-ever! Thanks in advance. -J

When adding a personal contact in outlook, when I add the phone number as 18008882555 why does outlook not format the number as 1-800-888-2555? Is there a mask that I can choose or settings I can change to make the format with dashes? -Jason

I am writing a statment to autogenerate a number. The number is 5 digits, but the number that the auto generate is on is only 3. what is happening is that when the number generates, it should show 00545 but instead it is showing 545. What syntax should be used to make the leading zeros show...

I am trying to make a txt box all uppercase. So if someone puts in lowercase, it will convert it to uppercase and if uppercase is put it, it will just take it. I am not real familliar with writing vb script, so that is why I am asking.

I am just starting out at learning how to write VB Script. I have no idea what is what, so my question is, does anyone know of a good beginners book to learning how to write vb script? thanks.

Does anyone know of a good book I can get to learn VB Scripting? I have no knowledge of programming and want to get a book to learn how to start writing VB Script. If anyone can recommend a book for starters on writing vb script, I would be appreciative.

Ok, this will probably be easy for you guys, but this is my first time to do a DTS package. I setup my package and now when I go to set it up to run on a schedule, I get the following error. Package Error Microsoft SQL-DMO(ODBC SQLState: 42000) [Microsoft][ODBC SQL Server Driver][SQL...

I am trying to create a formula to chop up a date into seperate columns. I am using the LEFT (field name,2) and it is asking me for a string. What am I doing wrong? Also, what I am trying to do is pull the the first two digits from a date and then I want to create a formual to pull the middle...

I have a database that I want to move data out of and into another database. The deal is, both databases are the same however one has more data than the other. What I want to do is move the data from the one that has more to the new database. I have about 5 months worth of data from last...

I am trying to run an update statement that will add one day to a specific date field. Here is my update statement. update employee set empenddate = empbegindate +1 where empbegindate = empenddate I don't know how to add an extra day to the empbegindate field. What I am trying to do is...

The query is working. I need to add an IF THEN statement to it. Base is a record type within the ecomp table as well as Bencomp3. what is happening is when the query runs, it is pulling a bencomp3 and base record. what I need it to do is only pull the record that does not have an emannual...

Here is my actual statment. What I need to do is figure out under the 'WHERE' clause. I need to pull the record for a particualr person that has a record that matches BENCOMP3 and EmAnnual is >0 otherwise I need to get the BASE record and EmAnnual amount for the employee. QUERY: SELECT...

How would I go about putting an IF THEN statement in a select query. Example: SELECT Name, Age, SSN, Pay, PayType FROM Base, Payroll WHERE BaseID = PayrollID AND IF paytype = '0' then bencomp3 ELSE BASE I am confused as to how I would put that into my select statement. Any help would be...