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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.