Viewing 15 posts - 4,441 through 4,455 (of 6,679 total)
fred2002 (10/23/2009)
noi explained it wrong.
first we restricted the size to 300MB
But now due to the errors we allw it to 1.2GB.
MS advise to fix a max size for transaction log
Do...
October 23, 2009 at 1:11 pm
There is no upgrade path from 32bit to 64bit. What you would have to do is install a new x64 instance and migrate the databases.
October 23, 2009 at 12:19 pm
frovello (10/23/2009)
October 23, 2009 at 9:28 am
free_mascot (10/22/2009)
The only reason what I am looking is that you have already purchage 32bit sql licence and having the new 64bit hardware.
There is no such thing as a 32bit...
October 23, 2009 at 7:51 am
fizzleme (10/22/2009)
Licensing and availability issue. I agree it is best to use 64 bit for both products.I'll see what we can do about this.
Not sure what you are referring...
October 22, 2009 at 7:31 pm
No concerns - other than why would you want to do that? There are only a very few specific reasons for running 32 bit SQL Server on x64. ...
October 22, 2009 at 2:37 pm
Download and install SQL Compare from Redgate (fully functional trial version). Then, create a new blank database in production and perform a comparison between the database in development and...
October 22, 2009 at 1:50 pm
Yes you can - but the real question is why do you think you need to? There are very few reasons that you would need to do that.
October 22, 2009 at 1:48 pm
Dugi (10/22/2009)
I know this fact but...
October 22, 2009 at 1:46 pm
I am going to say that it is not going to be possible - at least with the information you have posted so far. Please review the article I...
October 22, 2009 at 1:38 pm
When I run into these kinds of issues, I write it out using psuedo-code then convert it to the function:
If invoice date is greater than 75 days from today, then...
October 21, 2009 at 3:23 pm
The best option is another server - that will offload the processing completely and remove any contention between the production system and reporting.
Be aware that creating a new database, even...
October 21, 2009 at 1:53 pm
PiMané (10/21/2009)
that's weird... was that an upgrade from an instance of a previous sql server version?Pedro
That would definitely cause the problem you were seeing. Each schema would have had...
October 21, 2009 at 11:28 am
repent_kog_is_near (10/20/2009)
Thanks for your input on the RO DBs. yes, RO has it's downfall, but some of the good features that would work for us are RO featured...
October 20, 2009 at 4:33 pm
Now you can validate whether or not instant initialization has been set up. If SQL Server is running under a domain service account that is not a part of...
October 20, 2009 at 4:11 pm
Viewing 15 posts - 4,441 through 4,455 (of 6,679 total)