I believe that in order to do the dir command on a folder you only need to have Read permissions. I could be wrong but that is my recollection;

SQL_Easy_btn? (1/14/2009)

---

Have you tried...

PASSWORD = { password | @password_variable }

instead of

MEDIAPASSWORD = { mediapassword | @mediapassword_variable }

It may be a long shot but I am sure it wouldnt...

JMO, but I would say this depends on how the non-clustereds you are creating are being used (meaning are they covering indexes or do you have to end up doing...

I just did a simple test with the following on my own machine and it worked fine.

Backup Database test

to disk='c:\Backups\test.bak'

with Password = 'pwd1'

Restore database test1

from disk='c:\Backups\test.bak'

With Password = 'pwd1',

move 'test'...

There can only be one owner (creator of the database), and I actually was not aware that you could change it through SSMS (though I assume there is a backend...

You could create a global temp table (##) that had the same format as the output of a single query. Within your sp_msforeachdb you would do an insert...

I have frequently seen situations where linked servers within joins (as you have here) do not perform the way that they "should". The optimizer (especially in SQL 2000) has...

Something like

select convert(varchar(10), yourdate, 101), count(*)

from #tbl1

group by convert(varchar(10), yourdate, 101)

should get you what you need. Not the most efficient code but it should work to get data...

Kimberly Tripp has a good whitepaper on 2005 Partitioning

http://msdn.microsoft.com/en-us/library/ms345146.aspx

It does not specifically go into what you should do for OLTP partitioning (not in a top 10 things kind of way),...

I had always used

select cast(convert(char(10), getdate(), 101) as datetime)

but this way is...

DBA (1/8/2009)

---

right now i have the data files from my new DB in the same physical drive as the one i had before, if i move them to a different...

Micheal Young (1/8/2009)

---

In my opinion, adding more space will not increase performance, but you might want to consider it for future expansion of your database storage. Your processor may be...

If you do a Full Backup of a SQL 2008 database that has FileStreams enabled, it does backup that file stream data for you as part of the native SQL...

You certainly could create triggers for...

CrazyDBA (1/8/2009)

---

Host name will not work as it will give me a name of machine where application is installed.

well changing code is another problem as it is handle by...