What you need is software similar to Bit Torrent or RapidShare without the file share being publically available for just anyone.

Cory,

Who told you that you could be logical about the questions answered on the forum???

@=)

Honestly, that possibility didn't occur to me. Retaining old data but forcing new data to be...

Then the answer is "Yes, he should be able to see the view" with a caveat. He MUST be granted SELECT permissions on the View itself. Otherwise, it will fail.

I...

Litespeed has adjustable compression. It can go pretty small.

Third party tools such as Litespeed can do it for SQL 2005.

manoj2001 (7/9/2009)

---

But if i am not wrong we could add instances in SQL Server 2000, by right clicking

enterprise manager and create and register new instance by giving name of the...

One of our corporate teams monitors that sort of thing for us (Server is offsite) and notified us of these problems. Some alerts are auto, some are manual.

Our cluster service...

Wow. I need to add an example like this into my SQL Saturday JOINS class.

Good catch, Jason.

I have to whole-heartedly agree with this sentiment. Create a Dev server setup and test...

Better choice indeed. SQL 2k8 gives you so many more options that 2k. But you will have a LOT of code & stuff to upgrade, so get ready to work...

Maybe this is the old way of doing it... I'd never heard of sys.master_files before.

Use MyDB;

GO

Select * from sysfiles;

(Yes, I know using * is bad, but it's a tiny table).

Ditto to what Grant said.

I'm curious. What answer did you give in the interview?

It definitely sounds like she's using two different permission sets or that the client tools on her workstation were installed wrong.

What perms does she have? Does she log into the...

Mani-584606 (4/29/2010)

---

I'm NOT sure whether we can shrink the log file size for TempDB or not? I believe it's NOT a good...

When you retrieve this data, are you only pulling it from one database? Are you connected to that database?

Are you pulling from multiple DBs? Are you using a Linked Server?