Viewing 15 posts - 601 through 615 (of 687 total)
Ninja's_RGR'us (5/4/2011)
No sense...
May 4, 2011 at 12:34 pm
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...
May 4, 2011 at 11:04 am
Index reorganization is always fully logged, no matter the recovery model. And yes, it could potentially make your log grow substantially.
May 4, 2011 at 6:19 am
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...
May 3, 2011 at 8:31 am
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...
May 3, 2011 at 7:51 am
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...
May 3, 2011 at 7:39 am
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...
April 29, 2011 at 8:43 am
ColdCoffee (4/28/2011)
toddasd (4/28/2011)
@WayneS
: You write some great code.I totally concur 🙂 he is awesome, like how The Miz in WWE says, Wayne is awesome 🙂
lol...love it. You just worked WWE...
April 28, 2011 at 2:07 pm
Richard Warr (4/27/2011)
April 27, 2011 at 5:54 am
If you could post your select statement, we could see what might be wrong.
April 25, 2011 at 12:08 pm
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...
April 13, 2011 at 6:06 am
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),
@sql...
April 12, 2011 at 7:08 am
The error is saying that the database you are trying to restore is larger than the 4gb limit SQL Express enforces.
April 7, 2011 at 12:19 pm
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...
April 5, 2011 at 10:00 am
Viewing 15 posts - 601 through 615 (of 687 total)