Viewing 15 posts - 61 through 75 (of 307 total)
halifaxdal (8/6/2008)
I checked the sysprocesses (SQL2000), it gives me only four days records, is there any option I should set to make the log longer?Thanks.
but you can always make another...
"-=Still Learning=-"
Lester Policarpio
August 6, 2008 at 7:46 pm
Can you post some data?
refer to this link
http://www.sqlservercentral.com/articles/Best+Practices/61537/
"-=Still Learning=-"
Lester Policarpio
August 5, 2008 at 7:55 pm
You can use the data in master..sysprocesses, make a stored procedure schedule it to run lets say every 3-5 min then sends you a report or alerts you via email...
"-=Still Learning=-"
Lester Policarpio
August 5, 2008 at 7:38 pm
bard (8/5/2008)
CREATE PROCEDURE [so_name]
@imgcount int,@Photo varchar(55),@Col Varchar(10),@ExpID int
AS
Declare @sql varchar(500)
set @sql=''
select @sql='UPDATE Experience SET [' + @Col + ']=['+@Photo+']'
select @sql=@SQL + ' WHERE ID='
select @sql=@SQL + @ExpID
Execute(@SQL)
Your variable @sql...
"-=Still Learning=-"
Lester Policarpio
August 5, 2008 at 6:16 pm
I think you can use sp_who2 or values in the master..sysprocesses table You can view the host pc, program name, db name accessed by the hostname etc.
"-=Still Learning=-"
Lester Policarpio
August 5, 2008 at 5:59 pm
Did you try BCP out to a text file then BULK INSERT to a table?
"-=Still Learning=-"
Lester Policarpio
August 4, 2008 at 7:23 pm
Sobrang tuwa ahhh 😀
"-=Still Learning=-"
Lester Policarpio
August 4, 2008 at 3:18 am
if the conditions below apply i think you can use the script even if the backup is .dmp extension
1. MSSQL 2000
2. Backup Process is a "Native SQL Backup"
- Just change...
"-=Still Learning=-"
Lester Policarpio
August 3, 2008 at 8:08 pm
avipenina (7/31/2008)
Lester Policarpio (7/31/2008)
"-=Still Learning=-"
Lester Policarpio
August 3, 2008 at 7:54 pm
vambati (7/30/2008)
"-=Still Learning=-"
Lester Policarpio
July 31, 2008 at 10:23 am
Sorry for the late reply 'm so busy in my work. Maybe i can do something to modify the script. What do you want? different location for mdf and ldf...
"-=Still Learning=-"
Lester Policarpio
July 31, 2008 at 10:19 am
How about using the BULK INSERT command (can be viewed in BOL)?
"-=Still Learning=-"
Lester Policarpio
July 31, 2008 at 3:59 am
Is this what you want??
DECLARE @dbname varchar(255),@query varchar(255)
DECLARE dbname CURSOR FOR
select name from master..sysdatabases where dbid > 6
OPEN dbname
FETCH NEXT FROM dbname INTO @dbname
WHILE(@@FETCH_STATUS = 0)
BEGIN
SET @query = 'SELECT '+@dbname+',...
"-=Still Learning=-"
Lester Policarpio
July 31, 2008 at 3:52 am
Did you try using OPENROWSET?
I also have a setting of generating automated reports (daily). What i used is OPENROWSET to load the data from mssql to excel. As for the...
"-=Still Learning=-"
Lester Policarpio
July 30, 2008 at 7:35 pm
This is what I used for monitoring the servers
1. Data and Logs
DBCC SQLPERF(logspace) - For Logs
DBCC SHOWFILESTATS - For Data
2. Database Backups
You can use the data in msdb database, backupset...
"-=Still Learning=-"
Lester Policarpio
July 24, 2008 at 7:49 pm
Viewing 15 posts - 61 through 75 (of 307 total)