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...

GilaMonster (3/1/2010)

---

SELECT <column list> FROM...

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. ...

Nice script ... worked fine on SQL server 2005 !

Thanks for sharing ..

\\K

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...

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...

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...

Thanks Michael .... for sharing your good stuff to SQL server community !

Works Great ... 🙂

\\K

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...

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...

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....

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 ...

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...

Check this out: http://www.replicationanswers.com/FTI2005.asp

Hope this helps,

\\K

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...