SQLQuest29

Forum Replies Created

Viewing 15 posts - 166 through 180 (of 286 total)

RE: Database Corruption problems

Malcolm Daughtree (3/3/2010)
Hey Paul, If you won't beat your own drum I will
GO HERE !!!!
http://www.microsoft.com/emea/teched2008/itpro/tv/default.aspx?vid=78.
LEARN
Enjoy!
I did and have discovered the Power of DBCC page and Checkdb, and...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 4, 2010 at 12:48 pm

#1128724
RE: Reading the .LDF File in Sql server 2005

GilaMonster (3/1/2010)
GSquared (3/1/2010)
It's "DBCC Log()". The parameters that I know of are the database name and a numeric "style" that determines the columns you get back.
SELECT <column list> FROM...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 2, 2010 at 2:24 pm

#1127423
RE: SQL Agent job SSIS permission denied on sp_send_dbmail

Sailor (7/28/2008)
I did some searching on sqlservercentral.com and came across various links that point to MS KBs as well as forum messages saying just change it to sa account. ...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 1, 2010 at 8:11 am

#1126468
RE: Script to get Server Info

Nice script ... worked fine on SQL server 2005 !
Thanks for sharing ..
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 12, 2010 at 8:11 am

#1118061
RE: Report Server Diagnostic Reports

Cris E (2/8/2010)
It occurs on reports where there are no data sources used (like a REPORTS ARE UNAVAILABLE report we put up) and the ChARINDEX functions both return 0.
To...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 8, 2010 at 1:24 pm

#1115781
RE: Report Server Diagnostic Reports

michael_davis2 (2/8/2010)
My guess is that one of the reports on the server getting the error has a query that is causing the problem. This is something I would like...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 8, 2010 at 11:26 am

#1115689
RE: Report Server Diagnostic Reports

Hello all,
when I try to run report: ReportQueries, I am getting below error:
Msg 9420, Level 16, State 1, Line 1
XML parsing: line 90, character 10, illegal xml character
Any ideas...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 8, 2010 at 11:04 am

#1115679
RE: Report Server Diagnostic Reports

Thanks Michael .... for sharing your good stuff to SQL server community !
Works Great ... 🙂
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 6, 2010 at 6:44 pm

#1115118
RE: Help with Database Mail sp

SQLbee (2/3/2010)
Hey guys,
I hope someone can hep me out here, regarding DB mail in sql server 2005.
I am facing a problem where I am not able to send a custom...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 5, 2010 at 9:48 am

#1114575
RE: Log file size issue in Log shipping in SQL Server 2005

I agree with beargle ...
why do you want to rebuild all the indexes ? Its smart to rebuild if there is more fragmentation (I normally do it above 30%) otherwise...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 29, 2010 at 4:11 pm

#1111062
RE: Server Migration

We are also doing a Physical migration from one data center to another which we call " Lift and Shift".
As others mentioned
1. Application connection string changes in config files
2....
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 29, 2010 at 3:58 pm

#1111059
RE: Monitoring databases!!

Hello,
This is what you are looking for :
USE MASTER
GO
CREATE TABLE #TMPFIXEDDRIVES (
DRIVE CHAR(1),
MBFREE INT)
INSERT INTO #TMPFIXEDDRIVES
EXEC xp_FIXEDDRIVES
CREATE TABLE #TMPSPACEUSED (
DBNAME ...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 28, 2010 at 5:31 pm

#1110401
RE: Log file bigger than data file

michael vessey (1/26/2010)
one thing everyone forgets
make sure your database is checkpointing - the log data is not truncated if no checkpoint has occured
try the following
use mydb
go
checkpoint
go
backup log mydb to...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 26, 2010 at 12:56 pm

#1108896
RE: Replication and Full-Text Search

Check this out: http://www.replicationanswers.com/FTI2005.asp
Hope this helps,
\\K
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 21, 2010 at 12:53 pm

#1106923
RE: Need to create meaning ful Job names and not the default- Replication 2005

Vinay Thakur-585143 (1/19/2010)
Sorry for confusion,
follow this
declare @JobID uniqueidentifier
select @JobID=job_id from distribution.dbo.MSdistribution_agents a,master.sys.servers s
where a.publisher_db=['PublisherDB'] and
a.subscriber_db=['Destination_DB'] and
a.subscriber_id=s.srvid and
s.srvname=['SubsriberServer']
--this will give jobid for the replication we have created, just use that...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 21, 2010 at 12:43 pm

#1106914

Viewing 15 posts - 166 through 180 (of 286 total)