Viewing 15 posts - 11,746 through 11,760 (of 49,562 total)
Benki Chendu (9/9/2013)
GilaMonster (8/26/2013)
Do you know how much data...
September 9, 2013 at 4:25 am
If you print the command rather than exec, what prints out?
September 9, 2013 at 4:24 am
All of them should. There's no windows OS feature requirements for log shipping.
September 8, 2013 at 11:53 am
Jan Van der Eecken (9/8/2013)
Now why TF would they do that? Paul is one of the very few guys I totally respect.
Anonymous. Need for attention. Fun (for them). Who knows.
September 8, 2013 at 11:02 am
INSERT INTO @TableVariable
EXEC StoredProcedure
September 8, 2013 at 12:23 am
L' Eomot Inversé (9/7/2013)
The connect item has now disappeared.I think someone at MS doesn't like being told they screwed up.
It was removed at Jen's request because a small number of...
September 8, 2013 at 12:19 am
Jan Van der Eecken (9/7/2013)
And, as to be expected, Gail's presentation on "Do's and Don'ts of Database Corruption" was top of the cream. Thanks, Gail!
You're welcome.
And now, as a reward,...
September 7, 2013 at 12:39 pm
SQLisAwE5OmE (9/7/2013)
However, if your mirror is in high performance mode and if principal goes down, then definitely there will be some data loss.
Not definitely. There may be some data loss....
September 7, 2013 at 10:43 am
Don't use sa. Use specific accounts for specific users with minimal permissions. Strong passwords or preferably windows authentication.
September 7, 2013 at 5:58 am
Minimum permissions on logins, don't give everyone sa.
September 7, 2013 at 5:19 am
There's no way to password protect a database, passwords are used on logins to SQL Server, if someone has a valid login, they can then see any databases they've been...
September 7, 2013 at 4:39 am
It's a low-level certification that tests basic database design concepts.
September 7, 2013 at 1:57 am
Jon.Morisi (9/6/2013)
Does it cause a performance issue to have a lot of unused space.
No.
September 7, 2013 at 12:03 am
Grant Fritchey (9/6/2013)
Steven.Howes (9/6/2013)
September 6, 2013 at 2:25 pm
That procedure isn't in a user database. It's in the system resource database and, because it's a system procedure, can be called from anywhere.
September 6, 2013 at 1:08 pm
Viewing 15 posts - 11,746 through 11,760 (of 49,562 total)