Viewing 15 posts - 33,796 through 33,810 (of 49,552 total)
It doesn't appear to. I just tried it out, switching my server to french and running the reports. Still in English.
February 26, 2010 at 7:22 am
What reports?
Changing the language will not translate data stored in the database, nor will it translate anything that's explicitly put on to a report, if we're talking about reporting services...
February 26, 2010 at 6:59 am
river1 (2/26/2010)
Don't understand what is this "Run the RECONFIGURE statement to install."
It's referring to the RECONFIGURE statement, the one in the script you posted. Any change to sp_configure will produce...
February 26, 2010 at 6:25 am
river1 (2/26/2010)
No, i see this button in the SQL Server Management Studio (relational databases).
Where? What menu? What window? What dialog? etc
February 26, 2010 at 6:20 am
You said there's a button that's greyed out. Where is it?
February 26, 2010 at 5:14 am
Where is said button?
February 26, 2010 at 4:43 am
winslet (2/26/2010)
On production server is this a good practise to change the recovery mode to simple , ReBuild indexes and switch back to FULL.? Please confirm.
No. Terrible practice. Switching to...
February 26, 2010 at 2:08 am
miss.delinda (2/26/2010)
I understood each table must have a Identity Field called trnxid (transaction id)
There are no such requirements in SQL. There's no requirement that a table MUST have an identity...
February 26, 2010 at 12:34 am
mohammed moinudheen (2/25/2010)
Do you recommend this on a production environment. Just wanted to confirm with you as I face space issues sometimes on the log drive during maintenance operations.
Yes, providing...
February 26, 2010 at 12:26 am
Actually, there's one more if this is a once-off update.
Run the update in master and use 3-part naming to reference the DB in question. Compat mode is controlled by the...
February 25, 2010 at 2:52 pm
You could switch to bulk-logged for the duration of the index rebuilds. Otherwise, leave it alone, maybe increase the frequency of the log backups (the shipped ones) during the index...
February 25, 2010 at 1:02 pm
zukko (2/25/2010)
UPDATE Departments
SET DeptSeq = cte.deptSeq
FROM (
SELECT Department, ROW_NUMBER() OVER (Partition By Department Order By...
February 25, 2010 at 1:01 pm
You can, but you really shouldn't be considering shrinking the database at all.
Shrinking causes massive fragmentation and will just result in the data file growing again next time data gets...
February 25, 2010 at 12:25 pm
B. Hill (2/25/2010)
second, I want to update the DeptSeq column to the incremented value. Does this query do this?
No. I wrote a select for you. A select returns data,...
February 25, 2010 at 12:20 pm
Viewing 15 posts - 33,796 through 33,810 (of 49,552 total)