Search results for query: *

My dataset has two tables: Skills and Employee_Skills. Skills has a complete list of SkillName. Employee_Skills has a list of SkillName that an employee has obtained. They are from different databases, and the two tables are filled using dataAdapter with separate DB connections. Now I want to...

I have a company-wide authentication standard page written in classic asp (sign_on.asp). In my classic ASP applications, I just include "sign_on.asp" in the first line of every page and the authentication is taken care of. Now I have a ASP.net (2.0) with C# Web application. I cannot include the...

I tried to connect CR to my IIS Log. When I clicked "Web/IIS Log Files", it prompted me to select a directory. I selected the mapped drive I created that links to my IIS server. The directory's name is like "//testserver/C$/Systems32/W3C.../". The connection is done, but there are no items...

I am using Autodesk Map 2005 and I opened a dwg file and attached an Access database (C:\temp\abc.mdb) through the menu Map->Data Source -> Configure. Now I want to retrieve the data source (C:\temp\abc.mdb) via VBA code, but I don't know how. I have looked at Database object and ModelSpace...

I am using autodesk Map 3D 2005. I need to create a macro inside the autodesk Map. This vba macro will make connection to database as appears in "data source", extract the data in the database, and save the data into a xml file sequencially (read data and always append to the end of the file)...

I have a problem with backing up 300G DB. It is SQL Server 2000, the MDF(50MBs) is in C drive, one NDF(33,000MBs) and one LDF (21G) are in F drive. The index files are in F drive too. The backup mode is "Full". When I tried to back it up in Enterprise Manager, after 10 minutes of running, I got...

My XML structure: --------------------------- <INVOICE> <TASKS> <TASK ID=1000 NUMBER=&quot;01.A001&quot;> <TASK ID=2000 NUMBER=&quot;01.A002&quot;> <TASK ID=3000 NUMBER=&quot;01.B001&quot;> <TASK ID=4000 NUMBER=&quot;01.B005&quot;> </TASKS> <LINE>...

How do I stop execution inside a stored procedure immediately after a certain line, just like EXIT does in a loop? What I need is: ------------------- procedure my_procedure() is begin ... IF my_cursor%NOTFOUND THEN -- exit; end if; ... end; ---------------------- Thanks.

An example: ---------------------- TYPE task_rec_type IS RECORD (id NUMBER, name VARCHAR2(25)) TYPE task_tbl_type IS TABLE OF task_rec_type INDEX BY BINARY_INTEGER; --------------------- Question: Can I have the function: FUNCTION load_table(p_task_id IN NUMBER) RETURN task_tbl_type IS ...

Check the following: ---------------------- TYPE task_rec_type IS RECORD (id NUMBER, name VARCHAR2(25)) TYPE task_tbl_type IS TABLE OF task_rec_type INDEX BY BINARY_INTEGER; --------------------- I have a table (tasks) in database with two columns(id, name). Now I want to select records from...

I restored a database from a backup file on the other server. Then I ran sp_auto_fix_login to fix the logins on the new server. I need to run tens of stored procedures (with a single call) developed by our vendor and all the procedures and other referrenced objects have [dbo] as...

I forgot to type &quot;Subject&quot; in my previous post. Here I post it again. I have a table (&quot;title&quot;) that stores tree-structure info: -------------------------------------- id name parent_id has_child 0 CEO -1 1 1 VP-Finance 0...

I have a table (&quot;title&quot;) that stores tree-structure info: -------------------------------------- id name parent_id has_child 0 CEO -1 1 1 VP-Finance 0 1 2 VP-CIO 0 1 11 Controller 1...

Can anyone tell me whether it is possible to schedule a job to run an asp page? I would like to run an asp on my Web server (different from DB server and may be outside of the firewall) every night. That page does file synchronization, email notifications, etc. If yes, how; if not, any better...

I have read some posts here but I have not found an answer to my problem. My task is to find a window, if it exists, set focus to it; if it doesn't exists, open a new window. The problem of the following code is, if the window object has never been created and I tried to find it, I got an error...

I created a database with initial 10MBs and incremental is 10MB for SQL7 databse LOG file. Then the log file grows to 490MB. I just truncated the log file and now the space available for database is more than 350MB. What I want to do is to keep the log file within 150MB. My questions are: (1)...

In Access, I can run the query like: SELECT username, EXISTS(SELECT * FROM member WHERE username='abc') AS has_record FROM table1 I am trying to do the same in SQL7 database: SELECT username, &quot;has_record&quot; = EXISTS(SELECT * FROM member WHERE username='abc') FROM table1 But this...

I have already installed SQL Server 7 on my NT Server machine. The SQL Server was configured to fit into my application's requirements. Now I have another totally different appication to be run on SQL Server 7 on the same NT server. It requires a different configuration (page size, character...

I run &quot;kill 22&quot; in SQL Query analyzer. (My current spid is 17). But when I exec sp_lock and sp_who, I still see the process 22? The reason I want to kill the process is that I would like to delete a corrupted database. Any idea? Thanks.

I have a Web-based application with SQL Server 7 as the backend. The SQL7 Server machine is a powerful Win NT4 server, with more than 20gb hardware storage and 1.4 gb Ram. The Web is running on a separate IIS server. Each time a customer asks for this application, I create a database with it...