Another work around. declare @foreignkey sysname declare @referencingtable sysname declare @cmd sysname DECLARE fkey_cursor CURSOR FOR SELECT object_name(constid), object_name(fkeyid) from sysreferences OPEN fkey_cursor FETCH NEXT FROM fkey_cursor INTO @foreignkey, @referencingtable WHILE @@FETCH_STATUS = 0 BEGIN select @cmd = 'alter table ' + @referencingtable + ' drop constraint ' + @foreignkey print @cmd exec (@cmd) FETCH […]
2003-05-05
When you give access to READ|WRITE permissions mean FIXED DB ROLES, by default the user has access to the views you create.
2003-05-05
I got a copy and found it to be highly usefull. My only concerns are what is the compression threshold before loseless becomes lossy potential in data. But so far I have no issues. Have seen it take a bit long than I expected to get data restored. And there is an article on the […]
2003-05-05
Another problem with autoshrink is simplf that it moves data. You might work very hard to make sure your tables, indexes, etc., get built contiguously only to have autoshrink make mincemeat of all your hard work. Like the author says: no thanks. One possible exception: a sandbox / desktop server where space really *might* matter […]
2003-05-05
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-05
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-05
Database size = MDF files size + LDF files size. Reserved = data + index_size + unused MDF files size = reserved + unallocated space
2003-05-05
Aha - there's your problem. The NOT FOR REPLICATION option only prevents the trigger from firing when a replication agent is performing the action (insert, update or delete). The trigger still fires during the original action by the user. The idea behind NOT FOR REPLICATION is that you don't want the trigger to repeat the […]
2003-05-05
2 reads
I would most likely suspect just that. You might try setting the locking to page level specifically or use NOLOCK in your Report query to see if affects. However, the only way to know for sure is stop the process that handles the reporting. If you are going to run in this method you should […]
2003-05-05
Not all dll's require registration. Which files are you installing to support DMO operations? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-03
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers