Viewing 15 posts - 16 through 30 (of 32 total)
You should try what follows:
Create manually the object named "mssqldtc"of type "computer" in your AD Domain through Active Directory Users & Computers. Disable it and then try again to bring...
November 6, 2011 at 6:42 am
OK, OK, I surrender!
I think I should stop believing MSDN statements like "Clustered indexes sort and store the data rows in the table based on their key values. There can...
October 10, 2011 at 5:33 am
Pablo: Yes. Best practice is that non-DBA users don't do that kind of stuff.
I agree. If it is just a Development server where they can play you might grant them...
October 10, 2011 at 5:24 am
Management likes the word consolidation... A few questions:
Is it SharePoint 2007 or 2010?
How many SP users do you plan to have within three years from now?
How many WFE, Search servers,...
October 10, 2011 at 5:16 am
Not sure? I wonder why... MS says it is:
http://msdn.microsoft.com/en-us/library/ms177443.aspx
A primary key can be a nonclustered index, so the Primary key is no guarantee that rows are sorted after it unless...
October 10, 2011 at 5:08 am
Yes, sure Clustered indexes store data rows in a sorted way based on the key values, this is their main characteristic.
The consequence is that there can only be one clustered...
October 10, 2011 at 5:07 am
How will you manage the move without downtime? Won't the data be obsolete by the time you have backed-up, moved around and restored the 1TB Backup to the new server?...
September 29, 2011 at 4:11 am
As I do not have Visual FoxPro I can't help you much in this but I suppose you did create a linked server and did configure it under the advanced...
September 25, 2011 at 10:24 am
Chris last option "export to SharePoint" is wonderful, instead! Why didn't I think about that one?:-D Users can setup an alert and get an email with the link to the...
September 22, 2011 at 9:41 am
Then you can export directly into an Excel file using whether OPENDATASOURCE (http://msdn.microsoft.com/en-us/library/ms179856.aspx) or creating a linked server to an Excel file with a SELECT INTO from the nice query...
September 22, 2011 at 5:24 am
There is a nice Powershell example from which you could build your own solution (this one creates an XL sheet as a report and sends it daily):
http://hassanszone.wordpress.com/2011/03/21/powershell-script-for-backup-monitor-for-all-the-sqlservers-in-network/%5B/url%5D
September 21, 2011 at 9:19 am
Are you sure that setup finished normally? Didi you see the final window confirming that setup was successful?
I have had the SQL2008R2 Setup.exe crashing a few times: it would...
September 21, 2011 at 9:08 am
Starting from SQL 2005 there are new limitations on instances names:
SQL2005: must start with a letter or an underscore
SQL2008 and R2: must start with a letter
So, the answer...
September 21, 2011 at 7:15 am
Of course it depends on lots of things. In a production environment changes can be made during working hours if the risk of impacting business activity is really low and...
September 20, 2011 at 9:18 am
Hello Marvin,
the setup crash could be a WMI corruption (see MSDN Forums here)
Kind regards
September 20, 2011 at 6:23 am
Viewing 15 posts - 16 through 30 (of 32 total)