I know this is old thread but anyone looking newly for answer this may be useful.

GDR (General Distribution Release), it applies to much broader base of operating systems not to...

I know this is a old thread but for conclusion... how many IP addresses are required?

Hi all,

I am using idea of script you mentioned to verify the backup status of backup files location in different location. Same like RESTORE VERIFYONLY.

The 'C:\Temp\Paths.txt' is having backup file...

As per normal situation 20GB is not such huge file to worry but here in this case the drive itself has total space of 20GB and this one is eating...

hi all,

i have tried all the options(except server reboot) mentioned in this thread but still my tempdb size didn't reduce. we are maintaing tempdb in separate drive and it...

check this if it helps

http://www.bigresource.com/Tracker/Track-ms_sql-NB562Xcu/

this helped me.. thanks

EdVassie (9/26/2011)

---

My advice: Put Master back to its original location and leave it there.

There are no data integrity or performance advantages in moving master or modfel DBs. All you...

GilaMonster (5/24/2009)

---

Jeffrey Williams (5/24/2009)

---

So, of course - they changed that whole thing in 2008 and you can't have this database anywhere other than in the same directory as the master...

the final link is gud

Suggest any good books for MCITP DBA SQL Server 2008. I cleared MCTS SQL Server 2005 already.

Thanks in Advance

yes i mean identity

you also can use option called "SEQUENCE" for that column so that it generates number automatically when u insert a new row

hi,

why don't you try to attach the DB only using the data file ".mdf" while trying this it asks for creation of new logfile you can select YES and automatically...

hi try these.....

- when i drop the FK A and go and see it in the SSMS it is not there

try to truncate table it says cannot drop because it...