Hmm ... little bit missunderstanding here, I know the rule that you can work with DB in SQL 2005 and setting the compatibility level 80 for SQL Server 2000 then...

Or you can try to change the compatibility level 80

try with this code then try to restore in SQL 2k!

USE [master]

GO

ALTER DATABASE [YourDatabaseName] SET COMPATIBILITY_LEVEL = 80

GO

Compatility Level 80 means...

anjan.ashok (10/9/2008)

---

Hi dugi,

If i grant create table and alter permission, then the user can drop the table i have crosschecked, but if deny createtable and alter table then the...

anjan.ashok (10/8/2008)

---

hi Dugi,

Thanks buddy

i added to datawriter role and now drop permission is denied.

One more question?

When i tried to create table ,i am getting following error

Msg 2760, Level 16, State...

Gila what will you do if you have the table with over 2 million records and after DBCC shrinking rebuilding...

Ok good question couz you no need to change them for execution...are you doing such thing just to see the code more pedantic...

sanjeev_krs2004 (10/8/2008)

---

Hi,

I have never deleted/archived anything from DB but when I ran DBCC shrinkfile command, size of DB has gone down from 80 GB to 45 GB. Could you please...

very easy ...CTRL+H then you have the options Find What = select ...Replace with: SELECT! then Find Next and you will find all them and if you want replace...

Maybe you didn't run the script in correct and...

jcrawf02 (10/7/2008)

---

An article would be fun, I've already seen several uses I haven't tried yet.

Karthik, you were first to suggest it (within this thread anyway). You going to write...

Jeff Moden (10/7/2008)

---

I've used it for "cleaning" data... you know... remove all numbers, remove everything but the numbers, remove special characters, remove adjacent multiple spaces (although there are better ways...

English only no other language plz!

:w00t::w00t::w00t::w00t::w00t::w00t:

...I forgot for the type of user... the first post it was for SQL Server user so if you have domain users you should write like this for the user...

hmmm...did you try to drop any object after the script above ...ok make a test go create TEST db then create 3-4 table then apply again the script that I...

Till now we have 7 + fuzzy dedupe from Chris Morris ...ooops it seems 8!

1) Splitting delimited values

2) Finding Palindrome

3) Date/Months generation

4) Displaying pyramid format output

5) Identifying the duplicate letters...