SQL Server does not really know/care whether a drive is a SAN drive or SCSI or IDE etc - and this is regardless of the edition. It really only...

I assume that the message reads like the following:

Warning: SQL cache memory usage: %d (pages). If this condition persists, see the Error Log Messages topic in Troubleshooting.

Books on line has...

I seen this problem too often. The easiest workaround is to right-click on the database (in the left hand screen), goto the view option and select a view that...

SQL Server ONLY operates under Windows. Depending on the Edition of SQL Server, different versions of Windows is supported.

This limits your choices of platforms for Oracle and...

I think it was poorly worded because the snapshot agent does not apply the snapshot. It creates it. The distribution agent applies the snapshot.

The wording the question implies...

Trick question ? Well, I thought that it was a poorly worded question. As Cindy said, the snapshot agent does not apply snapshots (the distribution agent is responsible...

I think the correct answer really is NONE OF THE ABOVE. Your first step really should be to determine what the security requirements are. Otherwise, you will simply...

Have a look in the SQL Server Log for each instance.  Near the start of it you will see a line that looks like

Server Process ID is 1234

In task manager,...

Check whether the replication cleanup job is running - it is responsible for deleting data from the replication tables once the transactions have been sent to the subscribers.  10GB does...

Are you a member of the SQL Server "System Administrators" role ?

The command you specify must be a "real file" (i.e. you must be able to see the command you are running as a file and it must be an executable...

The name "FRET05\JAN" is a name instance of SQL Server.  You cannot change this without re-installing.

However, you might be able to create an alias for this using the "Client Network...

Select datename (dw, Entrydate) as 'Day of week' , count(OrderNo) as Number

From [order-header]

Where (SUBSTRING(source, 1, 8) = '223WHOLE')

and EntryDate bewtween  '20040101' AND '20041231' 

GROUP BYdatename (dw, Entrydate)

Yes

Add an activeX task that runs at the start of your package.  In the task, use an inputbox to prompt for the start number. 

I assume that you want to...