Viewing 15 posts - 1,351 through 1,365 (of 2,496 total)
Google should find you a few scripts that can do this.
Also, SQL Server FineBuild on Codeplex has scripts to help you transfer logins and roles from SQL 2000 to SQL...
May 11, 2009 at 2:25 am
For DTS Packages, msdb database will be transfer to 2008 database, is that right? What about master db? Do I need to transfer that as well.
Don't even think of restoring...
May 8, 2009 at 3:14 am
I would also consider talking to my manager to say I do not want the DBA responsibilities I have been offered.
This is obviously a very personal thing -...
May 8, 2009 at 3:03 am
It looks like you need to live within the constraints of what a VERY poor vendor is putting on you.
IMHO you should raise these issues with your management, as it...
May 8, 2009 at 2:39 am
You need to take a hard look at the business requirements and design your system accordingly.
There is a very big difference between designing a system to cope with a peak...
May 8, 2009 at 2:30 am
What are the business requirements. It is hard to advise unless we know what the application needs to do.
You have posted about the transaction table. Is this table...
May 7, 2009 at 4:05 am
Yet another update...
I have heard from Microsoft that all the currently available editions of SQL Server 2008 will not be supported by Microsoft on Windows 2008 R2 Core.
Apparently...
May 7, 2009 at 4:02 am
You need to set up proxy accounts for each user.
The SQL Server FineBuild Reference document has a detailed description on how to do this, the access rights given, and the...
May 7, 2009 at 3:15 am
Wow what a lot of posts!
Being a former mainframe DB2 DBA and IDUG speaker, and now having some knowledge of SQL Server, I thought I would add my 2p...
There factors...
May 5, 2009 at 3:25 am
This question is now also added as Community Content to BOL see http://msdn.microsoft.com/en-us/library/ms143506.aspx
SQL Server FineBuild now supports installing SQL Server 2008 on Windows 2008 R2 Core.
May 5, 2009 at 3:06 am
To me, it seems like some kind of programming constraints of mainframes
The strange thing you see is due to the application design, not to the platform it is running on....
May 5, 2009 at 3:01 am
VBScript can help you automate repetitive processes, especially where they need a mix of SQL Server tasks and Windows tasks.
SQL Server FineBuild is written using VBScript and some CMD scripts....
May 1, 2009 at 6:21 am
It is not just Windows SBS that cannot see more than 4 GB RAM. All 32-bit editions of Windows are not able to address more than 4 GB RAM,...
April 28, 2009 at 3:13 am
This is not the only problem that has been in SQL 2008 iFTS. We are heavy users of FTS in SQL 2005, but found that SQL 2008 iFTS performance...
April 28, 2009 at 2:52 am
I think you need to get some clarity from your vendor on what you are allowed to do. The vendor may well be concerned if you want to change...
April 23, 2009 at 3:02 am
Viewing 15 posts - 1,351 through 1,365 (of 2,496 total)