Search results for query: *

Hi all, I have a database with 20GB transaction log file. The recovery model of the database is Full. I need to move the T. log file to a new location with the minimal downtime. I know I can do this by detaching the DB, copying the T. Log and attaching it at the new location. This will take...

There is a local user who's been granted the following database roles: - public - db_datareader - db_datawriter I need to grant the user permission to create and alter non system stored procedures. How can I do that? I've read that you can define the user as db_owner, or db_ddladmin. But if I...

Hi all, perharps you can help with this.. My PC is on the organization's domain. I have MSSQL 2000 8.00.760. I have successfully registered a few remote SQL server instances, but quite often when I'm trying to select "New SQL server Registration" I get the following error and Enterprise Manager...

Let me have your feedback on this please.. I have created a job to delete some records from a table, using a SQL statement. Now, I want to execute this job by running a .bat file and capture its exit satus. So, I have created a SQL script of the job (attached below). How should my .bat script...

Hi all, we have two Win2003 machines in a Microsoft clustered environment. Each machine is running different SQL Server 2000 instances. Let's say we have machines sql1 and sql2. If sql2 goes down, sql1 automatically takes over the SQL Server instances that were running on the m/c that went down...

I wanted to schedule profiler to run at a specific time and produce a trace file. I have scripted the Profiler and use osql to do that from command line using windows scheduler. My problem is that every day, I want to give a different name to my trace file. Here's the line in concern in the .sql...

When running the following SQL statements, I get the same results. Though I need to count only -30 days. Both statements below also consider the time of the day as well, which is not desired DELETE FROM MNT_R WHERE MNT_R.TIMESTAMP < GETDATE()- 30 DELETE FROM MNT_R WHERE MNT_R.TIMESTAMP <...

Hi all, we are importing some FX rates into an Excel2K workbook (consisting of 20 worksheets). Some cells update to #N/A and we manually have to look for them w/s by w/s. Is there a macro or VB code we can use to identify which w/s and which cells contain the #N/A easily? thanx

Hi there, this really puzzles me. I formatted a cell into TEXT, then typed 1'234 When Edit->Replace ' with , it will not work. The result is 1234. I tried that with "#%&/()= instead of ' and still the same. Can anyone tell why and what the solution is please? Thank you all.

Hi all. I need a command to enable root to prevent specific users from logging into the AIX system (i.e. lock their account) and then a command to enable them back. I don't want to use smit. Is there any way? Thank you so much

Hi all, I'm using Excel (Office XP). I have inserted comments for some cells in my sheet. Through page setup I defined to print comments at the end of the sheet. If I select (from page setup) to print in a portrait page orientation, then everything (sheet data and comments) is printed this way...

Hi all, I'm using Office XP. I have inserted comments for some cells in my sheet. Through page setup I defined to print comments at the end of the sheet. If I select (from page setup) to print in a portrait page orientation, then everything (sheet data and comments) is printed this way. The...

I have downloaded MSN Messenger v5 in my WinXP Pro and it now co-exists with v4.7 that came with XinXP. Since the first time I looged into MSN Messenger v5, every time I open it, it signs me in automatically. I can't remember what I chose the first time I logged in to allow it to sign me in like...

I have some floppies which say that they are Windows/DOS formatted Double Sided High Density 1.44MB. When I put it in my floppy drive and access it with Windows Explorer of my Win2K, it says that it's 1.38MB. Why is that? I definately need to fit a 1.4MB file into one diskette (I don't want to...

I have recently installed Win2000 prof. on my PC. The only user on the system was the Administrator. Administrator did not have a password, so I decided to create one. The password I typed, was by mistake in Greek characters. Before shutting down the PC I removed Greek input language, as I...

Hi there, please help with the following so that I avoid writing multiple queries... I use &quot;Get External Data&quot; to get data from Oracle DB table. Let's say I have the query: SELECT * FROM TABLE1 WHERE COLUMN1='STR1'; Can I put value STR1 into a cell of my worksheet, so that the query...

Hi, I came accross a very unusual problem. when I open either MS-Word or MS-Excel, they both crash and disappear from my screen only 2-4 seconds after I open them. I tried opening them by executing the program itself or by double-clicking on an existin Word or Excel file; the result is the same...

Hi, I'm running Excel's &quot;Data&quot;-> &quot;Get external data&quot; to connect via ODBC to OracleDB. The Query returns a number to one cell, lets say A1. I need to run a different query to cell A2, but it doesn't let me; instead it thinks that cell is assigned to the first query and it only...

Hi, I'm running &quot;Data&quot;-> &quot;Get external data&quot; to connect via ODBC to OracleDB. The Query returns a number to one cell, lets say A1. I need to run a different query to cell A2, but it doesn't let me; instead it thinks that cell is assigned to the first query and it only gives...

Is there a way to list only the (sub)directories using the ls command? thanx