Search results for query: *

No no.. it's on a different drive. Just assume I can't do it this way, since I can't afford that much downtime which approx. 15 minutes.

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...

...(local) BEGIN TRANSACTION DECLARE @JobID BINARY(16) DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1 EXECUTE msdb.dbo.sp_add_category @name = N'[Uncategorized (Local)]'...

Hi all thanks for the replies. Jamfool the sp is working great. Now I'm just trying to get just the net name of the machine in a text file. I used osql: osql -E -S servert\test -d DATABASE1 -n -i getnname.sql -o c:\tmp\nname.txt This is the output: ------------------------------ SERVERT-SQL1...

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...

Well I'm not a real expert, so I didn't find anything to help me with what I'm looking for. If I run my SQL statement on Nov 11th 14:00pm, and want to delete all rows created 30 days ago, then I want it to capture all records inserted previous to that day (which is 30 days before Nov 11th), not...

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 <...

What if the two databases are on twp different servers? Do I have to export the data into a flat file first and then import it into the second database? Is there any alternative way? Which is the fastest? thanx

DPlank, the ranges in each of my sheets is B5 to M40. The #N/A can appear anywhere within this range, in any of the 20 sheets in the same workbook. What would be preferable is not to have a formula for each cell that could possibly have a #N/A, but a convenient way to identify the #N/As. For...

Hi again, DPlank if I include a range in ISNA then it won't return 0 unless all cells in range are #NA dhulbert Edit->Replace in Excel2K does not give the option to look in entire workbook. It onle searches active worksheet. thanx

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 all, thanks for the replies. This is what I try to accomplish. We are using a third party application, from where we copy some values and paste them into Excel. Since we don't want to change our regional settings, the numbers pasted are not recognized as numbers. Therefore we use a macro...

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...

thanks everybody... problem is sorted out And linney I have already awarded you with a star to your other post regarding the same issue... thaks again