LIKE!

Rumors of SQL Servers' demise are greatly exaggerated...

After working in IT for over 26 years, and seeing technologies come, go, come back, or just hang around for interminably longer...

as2higpark (7/1/2011)

---

Hello everyone,

I have an issue that I have been pounding my head against a wall for days on.

We have a large client DB(400 GB) that we recently...

GSquared (6/29/2011)

---

repicurus (6/29/2011)

---

Robert L. Jones-330863 (6/29/2011)

---

I do believe that Craig is right. In the file License_EXPR_ENU.txt from 2005 Express it states:

4. SCOPE OF LICENSE. The software is...

Robert L. Jones-330863 (6/29/2011)

---

I do believe that Craig is right. In the file License_EXPR_ENU.txt from 2005 Express it states:

4. SCOPE OF LICENSE. The software is licensed, not...

TheSQLGuru (6/28/2011)

---

Seems you are new here - so welcome! But please always check the dates on threads you are going to post to. Makes no sense to...

Cem Uney (6/27/2011)

---

Hi

How can i find the Windows login name connected to the system?

Environment: Users are connecting the Terminal Server with their Windows logins (remote logins)

and opens a program with...

paul.knibbs (6/28/2011)

---

I have a 64-bit R2 Express install on my PC here. Just checked it out, and found the following files:

License_SqlBrowser.txt

license_SQLCMD.txt

License_SQLNCLI_ENU.txt (one of these in both Program Files (x86) and...

Welsh Corgi (6/27/2011)

---

repicurus (6/27/2011)

---

I've had extensive experience using this development model: ACCESS 2003 front-end --> SQL 2005 back-end.

It actually performs very well if both sides are done properly.

Unless you did...

Craig Farrell (6/27/2011)

---

repicurus (6/27/2011)

---

From MSDN:

The 4 GB database size limit applies only to data files and not to log files. However, there are no limits to the number of...

Craig Farrell (6/27/2011)

---

Be aware:

repicurus (6/27/2011)

---

1) Archive data from some of the larger tables, placing them into "archive" databases.

You will have to alter any SPROCS, VIEWS, UDF's, etc., used in reporting,...

Also, kindly point to the text in the license that forbids what I suggested (in good faith, NOT to get around limitations or law).

Thanks, again.

Craig:

I'm sorry but are you saying that you can ONLY create ONE database in the EXPRESS editions of SQL?

Because I thought the limit was on EACH database, and all I...

I've had extensive experience using this development model: ACCESS 2003 front-end --> SQL 2005 back-end.

It actually performs very well if both sides are done properly.

Unless you did something really REALLY...

Yes, as others have pointed out, your column in your table is not a datetime data-type.

However, once you get past that hurdle, and if you want to return a character...