Select the choice for INSTALL DATABASE COMPONENTS. Then you should get one of two options:

1. You can select to install the Server and client tools, client tools only, Server only....

Yes, you must install them on both nodes.

-SQLBill

ARGHHHH! Veritas Backup Exec!!!! First, do you have the Agent for SQL Server installed? If not, then it won't backup SQL Server. If so, check the Backup Exec...

Wow, what a question. This depends on what the column is used for.

I use a default of 0 when my column is of a number data type (Integer,...

Somewhere I have seen that the best setup is:

System databases (except TEMPDB) on one drive

TempDB on it's own RAID 1 (two drives)

UserDBs on Raid5 with Log files on RAID1

Reasoning: TEMPDB...

Just looked over my backup information and those dates are the dates the database was created.

-SQLBill

To answer your question......yes you can reinstall it. Just run your install disk and choose the option for CLIENT TOOLS ONLY. Then you get a window where you can...

This was in Oracle not SQL Server, but....

I was hired as an Oracle Programmer to review a vendor's work on setting up a database for us. They set up...

I'm pretty sure it's from the server, since my backup date/times match my server date/times.

-SQLBill

DATEDIFF(datepart, startdate, enddate)

Example: SELECT DATEDIFF(d, '2005-10-01', GETDATE())

Refer to the BOL for more information.

-SQLBill

Jurushia,

Yes that is what I meant.

-SQLBill

True story alert....

Back up a few years....I'm a pretty new DBA. My Project Manager (PM) requests that I give the Technical Manager (TM) access to remotely run profiling/baselining scripts....

Are you using Linked Servers (Sybase to Microsoft SQL Server)?

If not, then you shouldn't be using a Sybase driver with Microsoft SQL Server. (And if you aren't using SQL Server,...

Here's what I do....

EXEC SP_CYCLE_ERRORLOG

GO

Then I go to the folder where the error logs are stored and open the one I need in notepad.

-SQLBill

Type up a letter to your boss/management:

Dear ,

I have been asked to allow users to create their own stored procedures in the database. This would require giving them admin...