Viewing 15 posts - 5,281 through 5,295 (of 49,571 total)
Ack, I just read your first post again. Change the locks value back to 0. That's not the number of locks on an object which triggers an escalation (which is...
July 16, 2015 at 10:51 am
Not asking about SQL's version. Asking about Management Studio.
Tried restarting SSMS?
July 16, 2015 at 10:35 am
What version of Management Studio are you using? (Help->About)
What does this return?
select name, is_query_store_on from sys.databases
July 16, 2015 at 10:27 am
Does the SQL Server service account have access to the path you specified?
July 16, 2015 at 10:23 am
It's not logging related to replication.
When you have transactional replication, the space in the database's transaction log cannot be marked reusable until the log records have been replicated. Hence if...
July 16, 2015 at 10:21 am
Try using openquery instead of the 4-part naming. That way you can be sure that the query is executed on the remote server and the results sent across, not the...
July 16, 2015 at 10:00 am
They're global temp tables, they aren't dropped until the connection using them closes and no one else is using them.
Even if they were normal temp tables, they wouldn't get dropped...
July 16, 2015 at 9:49 am
SELECT @COLUMNS = @COLUMNS + c.name + ','
from tempdb..syscolumns c
join tempdb..sysobjects t
on c.id = t.id
where t.name like '##OutputTable
order by colid
Unclosed quotation mark after the character string '##OutputTable
July 16, 2015 at 9:42 am
Possibly because there are other locks on the table. Escalation isn't guaranteed, if there are any incompatible locks on the table, the escalation will fail and the original locks will...
July 16, 2015 at 9:21 am
Yes.
Index rebuild creates a new index and then drops the old one.
July 16, 2015 at 9:17 am
No. I didn't say destroy your database by deleting the log file. I said add a new log file.
July 16, 2015 at 9:14 am
You'll need to remove the replication before you can do anything with the log. While the database is published, the log can't be made reusable until the log records are...
July 16, 2015 at 8:04 am
Blackdog (7/16/2015)
I've heard exam writing is outsourced to somewhere in India and then proof read before they go live. I'm not sure about army's of exam beta testers.
Nope. The...
July 16, 2015 at 7:54 am
Blackdog (7/16/2015)
Personally I like them they give you a real insight into what's coming up in the exam.
Blackdog (7/16/2015)
July 16, 2015 at 3:47 am
Viewing 15 posts - 5,281 through 5,295 (of 49,571 total)