Can you post what you have? You may have to create a function depending on the query.

When you install sql 2005 you go in the advanced section and select that you want to install it. You can go to add/remove programs and select change to...

I generally see this in the tempdb. I think it is because the database is growing.

Try this...

CREATE TABLE #TmpSpaceUsed

(DBName varchar(50),

FileNme varchar(50),

SpaceUsed float)

INSERT INTO #TmpSpaceUsed

EXEC('sp_msforeachdb''use ?; Select ''''?'''' DBName, Name FileNme, fileproperty(Name,''''SpaceUsed'''') SpaceUsed from sysfiles''')

SELECT

A.name...

You have to have every log file since your last full backup unless you do a differential. Then you have to have every log file since your last differential....

select * from test

where charindex('%',val) > 0

That should work as long as the databases did not get corrupted.

This is a generic error and is usually due to a bug or some sort of hardware issue.

I just realized you said taskpad. Here is the 2000 version.

CREATE TABLE #TmpFixedDrives

(Drive char(1),

MBFree int)

INSERT INTO #TmpFixedDrives

EXEC xp_fixeddrives

CREATE TABLE #TmpSpaceUsed

(DBName varchar(50),

FileNme varchar(50),

SpaceUsed float)

INSERT INTO #TmpSpaceUsed

EXEC('sp_msforeachdb''use ?; Select ''''?''''...

Try this and see if that is what you are looking for.

http://www.mssqltips.com/tip.asp?tip=1510

SELECT @List = COALESCE(@List + ',', '') + '''' + Cast(somedata As varchar(5)) + ''''

SELECT DATABASEPROPERTYEX(N'DatabaseName', N'RECOVERY')

Here is the script I use to view table sizes. You can replace the temp table with a permenant table and add the date and snapshot on a regular...

Do you need real time data? If not, you can set a delay on log shipping to only sync after business hours. That way the database will be...

Replace the end of the query with this...

and

ISNULL(INDEX_COL(tbl.[name], idx.indid, 1),'''') = isnull(I2.col1,'''')

AND

isnull(INDEX_COL( tbl.[name], idx.indid, 2 ),'''') = isnull(I2.col2,'''')

AND

isnull(INDEX_COL( tbl.[name], idx.indid, 3 ),'''') = isnull(I2.col3,'''')

and

isnull(INDEX_COL( tbl.[name], idx.indid, 4 ),'''') = isnull(I2.col4,'''')

and

isnull(INDEX_COL(...