Express Does have a 4 GB db size limit as well, however I'd be more looking at limitations involved around no SSIS, no Sql Agent job Service, and limited backup...

Magy (3/4/2008)

---

The problem is, is that due to security issues and network policy(which I cant change), the ONLY port that is open between the machine with Managment Studio and the...

Brandie,

Any chance something like this would work for you?

If Day(GetDate()) > 26 and Day(GetDate()) <= 31

Set @LastMonthEnd =

(Select Max(EndDate)

from tblAccountingPeriods

where BeginDate...

ruben ruvalcaba (2/29/2008)

---

Hi,

First of all thank you, it's a good point to be considered. In fact, I use functions on the WHERE clause very often, specially when filtering dates...

Yup, there's usually more than one way to to accomplish a given goal. It all depends on what works best in your environment.

-Luke.

additionally, you can check out the following article. I think it may have just what you are looking for...

http://www.sqlservercentral.com/articles/Monitoring/61373/

First off, Nice Article. Very well articulated intro to issues with using functions in the Where clause.

In reference to Peter Tirrell's question. Yes the Or should provide much...

One more here asking for SP3 and SP5. And while you're at it where's SP3 for WinXP that MS has been talking about for the past couple of years...

FROM BOL Databases (Database Engine) > Designing Databases > Designing Files and Filegroups >

Recommendations

"When you create a database, make the data files as large as possible, based on...

Yes you are absolutely correct, I was more poking fun at the phrasing of the question...

What happens when You do something, could be very different from what happens when someone...

What the above poster said combined with the file needs to exit!.

"If you run "sqlwb mysql.sql" from the command line, what happens?"

When I execute that command I get a File...

So does anyone else think it's strange that this was listed directly beside the last post I read on the SSC Jobs ad?

Database Administrator

Charlottesville, VA (possibly Boston, Mass.)

SNL Financial, LC

Perhaps...

My Resolution at work are to get the rewrite of the application I'm currently in charge of completed and get the organization to a better place so that I might...

Are you looking for...

07122430006 300001

07122430006 300006

Or

07122430006 300001,300006

Or something else entirely?

It would appear that you've already runt he reconfigure statement.

--This statement caused the message you received...

exec sp_configure 'affinity mask', 0x0000FFFF

GO

--This is the RECONFIGURE statement that the system wanted...

reconfigure

GO

Looks like...