Quarks?

You can use the DOS compatible names in your path to eliminate the spaces. The DIR command with the /x options gives you the DOS compatible names. In the...

All that shows in the title is:

Can somebody smarter than I am tell me why...

When you are posting a question, it helps to include the question.

It is completely normal for SQL Server to consume all the memory on the box.

More than likely, the reason for the freeze is the other application running on the box....

A slightly cynical point of view with a lot of truth and insight about human nature.

"...Upon this a question arises: whether it be better to be loved than feared or...

A complete list of servers would be handy.

Make sure you have sysadmin access to all the servers.

A list of the databases on each server, what they are used for, and...

Why can't you run a full backup?

Hans Munkwitz (2/25/2008)

---

...My opinion of the cause for this 'discrepancy' is that Microsoft just did not do a full and thorough test of its software (as is the case with...

If they are currently working, why not just continue to run the DTS packages under SQL 2005?

DTS 2000 runtime is included with SQL Server 2005 to run DTS 2000 packages...

"Table-valued parameters are a new parameter type in SQL Server 2008. Table-valued parameters are declared by using user-defined table types. You can use table-valued parameters to send multiple rows of...

Of course, there is probably a check or FK constraint on the column already to make sure it is a valid year, but it doesn't hurt to verify that. 🙂

You may want something like this to make sure the number is a valid SQL Server year.

select case when XYX between 1753 and 9999 then dateadd(yy,XYX-1900,0) else null end

You can't change the maint plan file name.

It's fairly easy to have your restore procedure do a directory comand from xp_cmdshell to find the latest file name to use.

This is a better way to do the WHERE clause to select data for the current year because:

1. It does not have to apply a function to each row of...

You might try creating the index I suggested as non-unique to cover the query. It lets SQL Server treat the index like a table without a bookmark lookup.

As an...