Viewing 15 posts - 481 through 495 (of 1,524 total)
I have found this... have your AD person grant this right to the service ID write ServicePrincipalName
March 26, 2014 at 7:39 am
I found this myself on a couple of sqlservers.....
to clean up the issue I backed up the trans log, shrunk the transaction log down to bare minimum then resized it...
March 26, 2014 at 7:33 am
This is going to become more and more of an issue as more and more things are stored on servers with different types of software all intertangled together. At...
March 26, 2014 at 7:27 am
Not too surprising.... we shall see how good the Dodgers are this season....
Opening Day next week for everyone.... The weather here in Ohio is supposed to start being...
March 26, 2014 at 6:46 am
Says he should be ready to pitch by mid May last I saw.
March 20, 2014 at 12:14 pm
Yes, that is a greate SP.
One additional question though... in SQL2008 how does one script out above the database level rights (Server ROles)... like... SA, dbcreator, bulkadmin, etc
That is the...
March 20, 2014 at 5:59 am
This is what I have....
create a database called TOOLS or whatever you want.
Create the below SP in this database. Then execute it. It will build...
March 14, 2014 at 10:20 am
I just read an article that stated they do NOT recommend TEMPDB be on SSD. Reason being is you can only write so many times to them before their...
March 6, 2014 at 11:28 am
AH... yes, you can have an RTM instance and install SQL Server again for an instance and apply SP1 to just it. Yes, it will work that way.
March 6, 2014 at 10:40 am
It is possible to upgrade SP1 to a specific instance. When you fire up the GUI it will determine all of the instances that can be patched and will...
March 6, 2014 at 8:31 am
At minimum get 6 gig of memory and let SQL Server use its max for 32 bit version of 2 gig. Alternatively you can look into the AWE and...
March 6, 2014 at 4:36 am
You cannot limit log growth without figuring out what process is causing the log growth. Log growth in FULL or SIMPLE will be the same. Reason is that...
March 5, 2014 at 8:00 am
These can be the biggest problem to pin down the problem. If you have a SAN you need to get the SAN Admin involved. I have fought this...
March 5, 2014 at 7:57 am
Are you doing an inplace upgrade or getting a new server for SQL2008 and migrating the dbs to it? If your SQL2000 server is old and the new one...
March 5, 2014 at 7:55 am
Viewing 15 posts - 481 through 495 (of 1,524 total)