Please do not cross post. See/leave responses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=12703&FORUM_ID=9&CAT_ID=1&Topic_Title=Lost+the+MDF%2C+have+the+LDF&Forum_Title=General

quote:

---

How can you compare SQL to SCUBA because

SCUBA = Scuba where

SQL <> Sequel

so what do you call BMW cars

and 9 a.m....

That had not occurred to me, thanks for pointing out.

quote:

---

I know this is an older thread but had to revive it just to put in my two cents. I personally...

What are you trying to accomplish?

This should help.

select 

SO.[name] as TableName,

SI.[name] IndexName,

SC.[name] ColName,

ST.[name] TypeVal,

CASE WHEN (SI.status & 16)<>0 THEN 'Yes' ELSE 'No' END as ClusteredIndex

from 

sysobjects SO

INNER JOIN

sysindexes SI

INNER JOIN

sysindexkeys...

This is one of those situations where a variable cannot be used this way. You can however build a Dynamic SQL string to do this.

CREATE procedure GetAuth (@dbname sysname)

as

EXEC ('select...

Look at CONVERT in SQL BOL there are several format options you can use. For your needs it would be

CONVERT(char,column,103)

There are a comple of shirnk methods such and truncate free space and such but none do any index rebuilds and as Cengizu notes do your rebuilds befor shirnk as...

Shouldn't be that but to test if it can read the folder at least do

xp_cmdshell 'dir c:\profiledumps'

If it cannot access it it will tell you why.

Also, when you say you...

The only way is to dig thru the index using the DBCC PAGE command. However, they are not neccessarily in order and can in fact be in reverse order at...

quote:

---

What is a datatype of BYTE? Did you mean a BIT datatype, or something like a CHAR(1)?

I disagree with having indexes...

quote:

---

Antares686 how do you structure your code with spaces or tabs.

My formatting always seems to get lost!

---

From BOL

quote:

---

Function Determinism and Side Effects

Functions are either deterministic or nondeterministic. They are deterministic when they always return the same result any...

What are you needing to change about it? Is it the rule that is bound to it or the underlying datatype itself. If the rulle bound then create a new...