Viewing 15 posts - 3,271 through 3,285 (of 7,168 total)
GilaMonster (8/31/2012)
There's also the case where autogrow takes too...
August 31, 2012 at 12:06 pm
GilaMonster (8/31/2012)
The DB has reached the max size it's allowed and won't autogrow any more
The autogrow's too slow, probably because the growth increments are...
August 31, 2012 at 11:50 am
A couple options:
Using the Konesans File Watcher Task in SSIS to Process Data Files[/url]
Using the WMI Event Watcher Task in SSIS to Process Data Files[/url]
August 31, 2012 at 11:47 am
WMI (Windows Management Instrumentation) is for querying various properties of Windows state and watching for Windows events. In order to 'watch' a table in SQL Server you do not want...
August 31, 2012 at 11:38 am
n00bDBA (8/30/2012)
Have a done something quite silly and other things needed to be changed for this to work properly.. Or have i found a much simpler solution!
I don't know? Did...
August 31, 2012 at 11:23 am
Pretty much. From http://www.brianmadden.com/blogs/guestbloggers/archive/2007/05/07/how-to-automate-the-backup-of-a-sql-server-2005-express-data-store.aspx. Just chage the path to point to the proper location of sqlcmd that belongs to your local install. Do not skip the part about getting a...
August 31, 2012 at 11:15 am
I have implemented most of the policies offered up by Microsoft as Best Practices...
Monitoring Best Practices by Using Policy-Based Management
...plus I roll a few of my own tailored to the...
August 31, 2012 at 11:08 am
Autogrow may be setup and the max size might be UNLIMITED but the error can still occur if the disk the tempdb data file is stored on has filled up.
August 31, 2012 at 11:06 am
I rarely recommend it, but in this case I would try rebooting too.
This thread has a lot of the same symptoms: http://www.sqlservercentral.com/Forums/Topic1328455-1550-1.aspx
August 31, 2012 at 10:53 am
craigbroadman (8/31/2012)
I am after a bit of advice.... I am considering the design for some tables in my database and wondered if anyone has any experience/ideas about the following structures.
Background...
August 31, 2012 at 10:48 am
Mostly I see one service account used on all instances for all SQL Server services. This is typically not an issue, even for auditors as long as you can list...
August 31, 2012 at 10:12 am
durai nagarajan (8/31/2012)
opc you mis-understood this is not @rarara.i asked my doubt related to that.
I know you're not @rarara. I was answering your question and explaining the line of thinking....
August 31, 2012 at 9:38 am
That's why I asked about the account the partners are running under. In some configs logins go over automatically, in others they do not.
August 31, 2012 at 9:11 am
Joe, I found all the links you posted to be broken except this one:
http://www.simple-talk.com/opinion/opinion-pieces/bad-carma/%5B/url%5D
It was worth enduring all the bad ones to get to it though, so thanks.
August 31, 2012 at 9:09 am
durai nagarajan (8/31/2012)
as the user specified select * from sys.sql_logins datas are matching on both the servers.is it matching due to master DB mirroring?
The same except for the two columns...
August 31, 2012 at 8:22 am
Viewing 15 posts - 3,271 through 3,285 (of 7,168 total)