Viewing 15 posts - 361 through 375 (of 463 total)
The specific id doesn't matter in as much as it either has rights to do the backups or it doesn't. The backups themselves run under the main SQL service...
February 15, 2008 at 2:21 pm
No, you are a little confused. Greg meant :
1) take the last full backup and restore it as a new database with norecovery
2) apply all the log backups from...
February 15, 2008 at 2:11 pm
Try going to control panel -> regional and language options -> languages tab and checking the options in supplemental language support (you might need the OS disks).
February 15, 2008 at 1:43 pm
Jeff Moden (2/15/2008)Heh... it's deja-vue all over again... and a bit ironic... that's exactly what I used to recommend... (Matt, PLEASE take no offense... I'm NOT picking on you......
February 15, 2008 at 9:17 am
Thanks for that information; we have a mix of 2000 and 2003 servers and this means I can lock some of them down tightly and use the local policies to...
February 15, 2008 at 7:59 am
I would say use whatever datatype is appropriate - if the potential range of stored values falls within smallmoney then go for it. Decimal is useful in situations where...
February 14, 2008 at 11:31 pm
In Windows 2003, it's not. If this is what you are running, your network co-workers need to go look up the Remote Desktop Users local group. Now, if they have...
February 14, 2008 at 10:32 pm
Before you say it's not feasible to use mirroring, you may want to test it. I think Microsoft recommend 10 as a max, but if the load is light...
February 14, 2008 at 3:56 pm
1.) I thought that the info in this DMV's got reset when SQL server services are started BUT books online describes the USECOUNTS column as "the number of times...
February 12, 2008 at 3:50 pm
Varchar(max) works fine ... from BOL for replicate:
If character_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 bytes. To return values greater than 8,000...
February 8, 2008 at 3:12 pm
My point about SAS70 is that your customers want to know their data is safe with you and that you aren't adding people to roles like sysadmin without great care....
February 8, 2008 at 7:57 am
In my experience, developers will create something that works (for a while) - but they aren't aware of best practises, optimisation techniques, different techniques of accomplishing something and the pros/cons...
February 7, 2008 at 11:01 pm
Thanks for posting this Brandie, I didn't check my email for the reminder until after it finished.
Is the information you provided pretty much everything, or is it still worth listening...
February 6, 2008 at 10:28 pm
Thanks for the information, plenty to investigate now.
February 5, 2008 at 10:30 pm
Viewing 15 posts - 361 through 375 (of 463 total)