I'm currently testing SS2005 (the free version, Express I believe) for
work and I am trying to use the default schemas to mimic the
search_path ability of Postgres but it doesn't seem to be working.
For example:

I'm trying to BCP out a temporary table (this is actually occuring in an
application and with the connection still open that "owns" the temporary
table, the application launches BCP.EXE to move the data to the file system).
The command line is of the form:

Is someone able to tell me if there is a good reason why 'not' to use windows
NTBackup to backup and restore databases in a disaster recovery scenario?
I was testing some restore methods on a SQL 2005 server, to which i found
that a SQL restore (to my suprise) failed 2 / 5 times, ...

I'm quite new in database field as a Database Aministrator.  Appreicate if
anyone able to help me on this.
We receive several trouble ticket regarding Log Shipping job failure issues.
When i check the database status in MS SQL, the database status show as

I know I am having TEMPDB performance issues.  Currently TEMPDB has
only 1 data file and one log file.  Both reside on the same SAN
drive.  I have been tasked with improving the performance, but I
cannot make changes in production without proof that my suggestions

Is there a way to delete backup files older than a month.
Every day SQL maintenance plan makes a file like this:
database_backup_200806161420.bak
But now i have manually delete files after a month ... because backups older

Anyone an idea why my maintenance plan doesn't send me a report by mail?
I created an agent and tested with succes ... and configured the maintenance
plan to send the report by mail to this agent. The report is written to the
given folder but he doesn't send me an email report.

Hi. Am using MSSQL 2005 Express, Management Studion Express.
I've created a number of sql script files that create SPs, Functions,
View etc.  How can get the following metrics by going thru all the
script files (located under a certain directory).

My boss read a white-paper on 2005 table partitioning and wants to implement
the idea to ease performance issues we are having.
What is the general consensus on table partitioning?  I am trying to
implement the traditional File Group/Disk Partition model.  I think it is a

I have a lot of database on clustering server and when some database run
report or import data to database, another database perform very slow. How to
verify which database is the cause? and I would like to seperate some
database to new clustering to solve the problem but I want ...

Have a database whose owner is named MyDbOwner. Need to give select
access to msdb.dbo.sysmai_account and execute permissions on the send
mail sp.
use MyDb

Does SQL DBA needs to access sql server, I mean remote desktop conntection
for some dba duties at server.
Thanks

I'm trying to set up a maintenance plan that backs up the transaction logs
THEN the databases, as I have successfully done with SQL 2000.  I get the
following error:
NEW COMPONENT OUTPUT

Good morning,
I do not have much experience in SQL, which is why I need your help.
What steps should I continue to make a running SQL server and DBS?.
You can defragment the DBS with some software?. I bought the PerfectDisk 8, but I dare not pass it.

I have a key value KEY: 6:72057385990435552 (e02060869ca0)
I can see that it is in database 6 and can get the index name from
72057385990435552.
But how can I find out which record (e02060869ca0) is?