Viewing 15 posts - 1,141 through 1,155 (of 1,252 total)
hi
i have a box where both 2000 & 2005 run, but 2000 was installed first. i would like to know if there are any problems with 2005 being installed first...
July 22, 2007 at 11:48 pm
Hi
have'nt understood ur requirements clearly. can u give a better clear picture regarding this.
just a point though - For hierarchial data i use CTE's (Common Tabe Expressions).
check them out...
July 20, 2007 at 4:52 am
Hi
there are some DMV's (dynamic management views) which show the processes running against the database and give blocking information. one example would be sys.sysprocesses. you can search BOL for more...
July 18, 2007 at 12:10 am
Hi
U can use database level triggers for this or C2 auditing.
July 12, 2007 at 3:17 am
hi
can u give more details regarding the
recovery model, type of backup and how much data insertion/modification goes on in your db.
are you taking log backups? have you done...
July 6, 2007 at 4:01 am
Hi
take a look at this. i copied the same from another site.
xp_delete_file
0, -- delete files
N'\\server02\dbbackup\sql2005', -- full path to the main directory
N'trn', -- file extension...
July 6, 2007 at 3:52 am
Hi
declare @var varchar(100)
set @var = ''
select @var = @var + cast(col1 as varchar(3)) + ',' from table
-- to remove the trailing comma
set @var = left(@var ,(len(@var )-1))
select...
July 5, 2007 at 3:04 am
hi
sql 2005 has dedicated administrator connections (DAC). try that to connect to your sql instance. refer BOL on how to do this.
July 3, 2007 at 6:25 am
Hi
in sql 2005 there dynamic management view which give info about state of a index. you cud use them in ur script and check whthr index(es) require defragging or reindexing....
July 3, 2007 at 6:17 am
Hi
You can use ROW_NUMBER() function for this.
ex:- say you have a employee table select Fullname,ROW_NUMBER()
over (order by EmployeeID) From Employees.
July 3, 2007 at 5:28 am
Hi
Other than implementing a loop i cant think of another solution to this now.
Anybody having better ideas.....
July 2, 2007 at 11:15 pm
Viewing 15 posts - 1,141 through 1,155 (of 1,252 total)