Viewing 15 posts - 1 through 15 (of 144 total)
Interesting. That worked perfectly. I know the last time I did this I changed something in the registry. But, I guess this is better.
Thank you
March 28, 2012 at 1:53 pm
No, there was something that you could do in the registry to stop it completely. And that is what I want to do. I have all of my...
March 28, 2012 at 9:12 am
He is having difficulty doing what he is doing now. I serious doubt that he knows what a star schema is or how to implement it as either a...
October 16, 2009 at 6:40 am
You really need to break the information down into a better design. Import it into a staging table. then run SSIS packages that move it into more normalized tables.
For...
October 15, 2009 at 7:06 am
No matter how you put it, 400+ columns in a table is flat out bad design.
There is also no reason for it to take that long to import the data.
Why...
October 12, 2009 at 1:41 pm
Put down the cursor and step away from it. There is never a reason to use any kind of cursor in this situation.
Prileep Mathan (9/14/2009)
nitin.iec (9/14/2009)
September 22, 2009 at 8:04 am
I am taking a week off after July 4 after working with the current company for 21 months. Got married last year and did not take any time off because...
June 13, 2008 at 7:37 am
If you are going to use it with Accss, you need to add a timestamp column on each table. The problem you are finding is not a bug. More than...
March 25, 2008 at 8:02 am
Or a Win 2003 and SQL 2005 configuration. With 2008 coming out shortly, I wonder how much longer MS will be supporting 2000.
January 18, 2008 at 6:32 am
James,
I have a stored procedure that I wrote that creates a "generic" CRUD stored procedure for the table that is passed in as the parameter for it. It works great....
August 23, 2007 at 6:35 am
We have 6 instances running on a single server.
SQL 2005 x64 Standard. Win 2003 Standard.
8 gig ram. 170 gig raid 5 HD array
This is an upgrade from SQL 2000 x32...
May 8, 2007 at 9:22 am
You are probably going to have to setup the Access database as a linked server in SQL Server.
March 29, 2007 at 1:24 pm
MS Access does not support BigInt data type. That and the 0/1 logic for bit data type are the two most important things to remember about SQL Server and Access. ...
March 16, 2007 at 4:11 pm
Steve,
Thanks, this is exactly the kind of help I was looking for.
March 7, 2007 at 9:06 am
No, servers are not the same either in physical design or data.
We have decided not to touch the production system since we will be moving to 64-bit SQL 2005 in...
March 7, 2007 at 6:58 am
Viewing 15 posts - 1 through 15 (of 144 total)