Ninja's_RGR'us (5/4/2011)

---

Then it's the "parental" culture. The bottom line is that he feels offended and that you don't want to offend him. Just learn to get along.

No sense...

lol

I don't really care one way or the other. I was just hoping someone would have some super inside knowledge of the English language and would be able to give...

Index reorganization is always fully logged, no matter the recovery model. And yes, it could potentially make your log grow substantially.

It does transfer the keys and indexes as well. I think it converts Access "queries" to views. The conversions can be a little screwy sometimes because some data types just...

You're right. I should revise my post to say "an easy way...".

The difference is a gui that could handle converstions if necessary.

The benefit would be that it is easy and...

easiest way without having to learn SSIS is to just use SQL Server Migration Assistant for Access v4.2. This has a wizard to walk you through migrating your access tables...

yeah, always some junk on the local drive.

As Geoff said, plan for growth of the C: drive due to patches for the OS, SQL Shared features, and even other things...

lol...love it. You just...

Richard Warr (4/27/2011)

---

Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then in...

If you could post your select statement, we could see what might be wrong.

In Microsoft's own words

"A supported cumulative update package is now available from Microsoft. it is intended to correct only the problems that are described in this article. Apply it only...

The error is on the From line. You can't use a variable to declare an object name like that. It will need to be done using dynamic SQL.

declare

@dbname varchar(25),

replace 'GO' with ';'

and remove CHAR(13) + CHAR(10) +

The error is saying that the database you are trying to restore is larger than the 4gb limit SQL Express enforces.

Job details would be very helpful in determining why the log is growing.

Does it use a cursor and create individual insert statements for each record or does it insert a...