Forums disruption

Sorry if the forums have been disrupted this week, we are moving servers and the forum software hasn't been playing very nice with the new hosting environment (Win Server 2008/SQL Server 2008 vs the old Win Server 2003/SQL Server 2000). When under full load the forums have been a bit more memory hungry than I'd thought. Most of the issues will hopefully be resolved by the end of today, but apologies for any down time or slow loads.

Yes, apologies for this, I had to recover to a backup a few hours old when the site went down in the morning US Eastern time. I've been running backups 5 times a day during this period. Seems a few hours got lost. Many apologies.

I can't enter a post under a user's name - I could put it in my name and enter "recovered" underneath - but it might look a bit confusing...

I found a couple of threads missing (As per the mails). Is there anyway we can re-create them?
knowing a new server
By farrokhp in SQL Server 2005 General DBA Questions
How can I say what servie accounts is for a sql server 2k or 2005 in windows xp or 2003 or vista?
How can I find out what is the local sever name and what if there is any named sever?
How can I know what people has admin acess to this server?
What are the 5 or 10 first things you do when you inherit a new sql server?
Thanks Folks
T-log puzzling
By farrokhp in SQL Server 2005 General DBA Questions
Hi, I am not too expert but there is a T-log I have, No OpenTran, Size 17gb, Used only 200mb, Tried several things to shrink it but it does not shrink...why?? very strange to me. I tried 1- backup tlog with no_log, 2- dbcc shrinkfile (tlog ...) 3- From SSMS and EM
Have same problem sometimes in sql2k

Please advise the correct fully steps

Stored Procedure Help
By letmeupdate in SQL Server 2005 General Developer Questions
Hi,
I have written a stored procedure which gets results from DB. When I run this stored procedure from Query Analyzer it works great. But when I use this same in .net application it doesnt return results. I guess it has issue with dynamic query. Can anyone help me on this do I need to make any changes to below sproc.CREATE PROCEDURE [dbo].[My_SProc]
@P_I_FIRSTNAME NVARCHAR(250),
@P_I_LASTNAME NVARCHAR(250),
@P_I_PageSize INT,
@P_I_StartRowIndex INT,
@P_I_OrderBy NVARCHAR(100),
@P_I_SortDirection NVARCHAR(100)
AS BEGIN
DECLARE @SQL NVARCHAR(MAX)
DECLARE @SelectClause NVARCHAR(MAX)
DECLARE @WhereCondition NVARCHAR(MAX)
DECLARE @OrderBy NVARCHAR(MAX)
DECLARE @SortDirection NVARCHAR(MAX)
DECLARE @StartRowIndex INT
DECLARE @FirstRecNum NVARCHAR(MAX)
DECLARE @LastRecNum NVARCHAR(MAX)
SET @WhereCondition = ''
IF @P_I_StartRowIndex = ''SET @StartRowIndex = 1
ELSESET @StartRowIndex = @P_I_StartRowIndex
IF @P_I_OrderBy is null
SET @OrderBy = 'First_Name'
ELSESET @OrderBy = @P_I_OrderBy
IF @P_I_SortDirection IS NULL
SET @SortDirection = 'ASC'
ELSESET @SortDirection = @P_I_SortDirection SET @FirstRecNum = @StartRowIndexSET @LastRecNum = @P_I_PageSize + @FirstRecNum
SET @SelectClause = 'SELECT * FROM tblUsers'
IF @P_I_FIRSTNAME IS NOT NULL
BEGIN
IF @WhereCondition = ''
SET @WhereCondition = ' WHERE First_Name LIKE ''' + @P_I_FIRSTNAME + '%'''
ELSE
SET @WhereCondition = @WhereCondition + 'AND First_Name LIKE ''' + @P_I_FIRSTNAME + '%'''
END
IF @P_I_LASTNAME IS NOT NULL
BEGIN
IF @WhereCondition = ''
SET @WhereCondition = ' WHERE Last_Name LIKE ''' + @P_I_LASTNAME + '%'''
ELSE
SET @WhereCondition = @WhereCondition + 'AND Last_Name LIKE ''' + @P_I_LASTNAME + '%'''
END
SET @SQL = N'SELECT *'SET @SQL = @SQL + N' FROM (SELECT ROW_NUMBER() OVER (ORDER BY ' + @OrderBy + ' ' + @SortDirection + ') AS Row, * FROM tblUsers' + @WhereCondition + ' )' SET @SQL = @SQL + N' AS UsersWithRowNumbers WHERE Row >= ' + @FirstRecNum + ' AND Row <= ' + @LastRecNum
--Print @SQL
EXECUTE sp_executesql @SQL END