Viewing 15 posts - 6,886 through 6,900 (of 7,191 total)
Gary
I think you should be able to get away with doing all eight upgrades and then rebooting all the nodes at then end. If you are careful about ensuring the...
August 9, 2006 at 9:11 am
Richard
Try setting the database recovery model to Simple before you do the update. Make sure you change it back to Full afterwards and take a full backup immediately.
John
August 9, 2006 at 9:02 am
Norm
This is how you set up the job to back up the log automatically:
(1) In Enterprise Manager, expand Management, SQL Server Agent, right-click on Jobs and choose New Job
(2) Give...
August 9, 2006 at 6:58 am
It doesn't look pretty, but the query below should work. It eliminates the need for an IF statement by using an expression that comes to 4 if the day is a...
August 9, 2006 at 4:48 am
Chris
Just to add to what Wesley said:
If you can afford the disk space, a 10GB log is not going to impair performance. If you can't, then change to simple or...
August 9, 2006 at 3:45 am
Norman
I don't really agree with what Andrés suggests. Basically what he's saying is that you should run the first script to free space and shrink the log, then after any...
August 9, 2006 at 3:11 am
Harsh
Try the script below (not tested). Somebody else may be able to come up with something that doesn't involve a temp table...
John
CREATE TABLE #Table (TableID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED, Event VARCHAR(50), MyTimestamp datetime)
INSERT INTO August 9, 2006 at 2:16 am
Joseph
More information needed, please. What type of replication are you using, and in what topology? What database are you trying to restore (publication, disribution, subscription)? Are you restoring from a...
August 9, 2006 at 1:38 am
Glenn
Not the version, the edition. You can get this by right-clicking on the server name in Enterprise Manager and choosing Properties. There are also functions in T-SQL you can use. ...
August 8, 2006 at 9:50 am
John
For tables with a clustered index, drop the clustered index and recreate it on the new filegroup. For tables without a clustered index, create one on the new filegroup. Then...
August 8, 2006 at 9:42 am
Have a look at SET DATEFIRST in Books Online. Then you can use CASE and the DATEPART function to subtract the correct number of days from the date.
John
August 8, 2006 at 9:36 am
Glenn
Also, you don't say whether you're using SQL Server 2000 Standard or Enterprise Edition. If it's Standard, you're stuck with 2GB whatever you do.
John
August 8, 2006 at 9:31 am
To add a column to your table:
ALTER TABLE MyTable ADD Cash_WTD_Min INT
To populate the column:
UPDATE MyTable SET Cash_WTD_Min = (SELECT MIN(Cash_WTD) FROM MyTable)
You would need a trigger to keep all of this current. However, I wouldn't recommend that...
August 8, 2006 at 9:28 am
Fredrik
Something like the script below will generate some SQL that you can inspect and then run against your database.
John
SET nocount ON
SELECT 'DROP TABLE ' + TABLE_SCHEMA + '.[' + TABLE_NAME + ']'
FROM information_schema.tables
WHERE TABLE_SCHEMA =
August 8, 2006 at 9:16 am
Martin
That's strange. I think you're right - the next thing you need to look at is the regional settings of the computer on which you're running the import. I think...
August 8, 2006 at 4:14 am
Viewing 15 posts - 6,886 through 6,900 (of 7,191 total)